Back To Home Page <https://people.highline.edu/mgirvin>



*Highline College Excel 2016 Class: Busn 218, Spreadhseet Construction* 	

*Comprehensive Excel Class: Effective & Efficient Calculations & Data

Analysis*







Syllabus

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Busn218Syllabus.pdf>

(click to view pdf, right-click to download file)

Introductory Video <https://www.youtube.com/watch?v=i8SztR1y9LE> (click

to view video)



 



*Videos, Written Handouts, Homework and Homework Solutions:*



Week 1:



*Video 01:* Highline Excel 2016 Class 01: Excel Fundamentals:

Efficiency, Data, Data Sets, Formatting

<https://www.youtube.com/watch?v=miUTG38k2mA> (1 hour 21 min)

Excel File: Busn218-Week01.xlsm

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week01/Busn218-Week01.xlsm>

(for Video and Homework)

Handout: Highline Excel 2016 Class 01 Excel Fundamentals Efficiency,

Data, Data Sets, Formatting.pdf

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week01/Highline%20Excel%202016%20Class%2001%20Excel%20Fundamentals%20Efficiency,%20Data,%20Data%20Sets,%20Formatting.pdf>

(click to view pdf, right-click to download file)

Homework to practice: Sheets at end of downloaded Excel Workbook: HW #1

to #6



*Video 02:*  Highline Excel 2016 Class 02: Excel Fundamentals:

Comprehensive Formula Lesson (15 Examples)

<https://www.youtube.com/watch?v=8tQM4W3hv3A> (55 min)

Excel File: Busn218-Video02.xlsm

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week01/Busn218-Video02.xlsm>

(for Video and Homework)

Handout: Highline Excel 2016 Class 02 Excel Fundamentals Formulas,

Formula Types, Formula Elements, Functions & Excel's Golden Rule.pdf

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week01/Highline%20Excel%202016%20Class%2002%20Excel%20Fundamentals%20Formulas,%20Formula%20Types,%20Formula%20Elements,%20Functions%20&%20Excel's%20Golden%20Rule.pdf>

(click to view pdf, right-click to download file) Homework to practice:

Sheets at end of downloaded Excel Workbook: HW #1 to #11

Project to complete for points toward a grade: Busn218Project01.xlsm

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week01/Busn218Project01.xlsm>



 



Week 2:



*Video 03:*  Highline Excel 2016 Class 03: Data Analysis Fundamentals:

PivotTables, Power Query & Data Model (36 Examples)

<https://www.youtube.com/watch?v=Jzt-I4mt8sQ> (1 hour 43 min)

Excel File: Busn218-Video03-Start.xlsm

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week02/Busn218-Video03-Start.xlsm>

and Busn218-Video03-Finished.xlsm

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week02/Busn218-Video03-Finished.xlsm>

(for Video and Homework)

Zipped Files for Big Data Power Query / Power Pivot Data Model Example:

Video03TextFilesForImport.zip

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week02/Video03TextFilesForImport.zip>

Handout: Highline Excel 2016 Class 03 Excel Fundamentals Data Analysis

Sort, Filter, PivotTables, Power Query, Power Pivot.pdf

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week02/Highline%20Excel%202016%20Class%2003%20Excel%20Fundamentals%20Data%20Analysis%20Sort,%20Filter,%20PivotTables,%20Power%20Query,%20Power%20Pivot.pdf>

(click to view pdf, right-click to download file)

Homework to practice: Sheets at end of downloaded Excel Workbook: HW #1

to #7

Project to complete for points toward a grade: Busn218Project02.xlsm

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week02/Busn218Project02.xlsm>



 



Week 3:



*Video 04:*  Highline Excel 2016 Class 04: References: Relative,

Absolute, Mixed, Sheet, Workbook, 3-D, Table and more (24 Examples)

<https://www.youtube.com/watch?v=51JdnRuR4VY>(1 hour 43 min)

Excel File: Busn218-Video04Start.xlsm

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week03/Busn218-Video04Start.xlsm>

and Busn218-Video04Finished.xlsm

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week03/Busn218-Video04Finished.xlsm>

(for Video and Homework)

Excel File for Workbook Reference: May Net Income.xlsx

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week03/May%20Net%20Income.xlsx>

Handout: Highline Excel 2016 Class 04 Cell References Defined Names

Table Formula Nomenclature.pdf

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week03/Highline%20Excel%202016%20Class%2004%20Cell%20References%20Defined%20Names%20Table%20Formula%20Nomenclature.pdf>

(click to view pdf, right-click to download file)

Homework to practice: Sheets at end of downloaded Excel Workbook: HW #1

to #13

Project to complete for points toward a grade: Busn218Project03.xlsm

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week03/Busn218Project03.xlsm>   

Zipped Folder needed for Project 3: TextFiles.zip

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week03/TextFiles.zip>



 



Week 4:



*Video 05:*  Highline Excel 2016 Class 05: Excel Array Formulas:

Comprehensive Lessons: 12 Examples

<https://www.youtube.com/watch?v=RDP1uF7HafU>  (52 min)

Excel File: Busn218-Video05.xlsm

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week04/Busn218-Video05.xlsm>

(for Video and Homework)

Handout: Highline Excel 2016 Class 05 Introduction To Array Formulas.pdf

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week04/Highline%20Excel%202016%20Class%2005%20Introduction%20To%20Array%20Formulas.pdf>

(click to view pdf, right-click to download file)

Homework to practice: Sheets at end of downloaded Excel Workbook: HW #1

to #4

No Project This Week.



*Video 06:*  Highline Excel 2016 Class 06: Conditional Calculations with

Excel Formulas: Comprehensive Lessons

<https://www.youtube.com/watch?v=4XafeWt-pQI>   (1 hour 23 min)

Excel File: Busn218-Video06Start.xlsx

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week04/Busn218-Video06Start.xlsx>  

and   Busn218-Video06StartFinished.xlsx

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week04/Busn218-Video06Finished.xlsx> 

(for Video and Homework)

Handout: Highline Excel 2016 Class 06 Conditional Calculations with

Excel Formulas AND & OR Criteria.pdf

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week04/Highline%20Excel%202016%20Class%2006%20Conditional%20Calculations%20with%20Excel%20Formulas%20AND%20&%20OR%20Criteria.pdf>

(click to view pdf, right-click to download file)

Homework to practice: Sheets at end of downloaded Excel Workbook: HW #1 to 9

No Project This Week.



*Video #7 Not Required For Fall 2016 Class:

Video 07:*  Highline Excel 2016 Class 07 Excel 2016 MAXIFS, MINIFS & IFS

Functions for Conditional Calculations

<https://www.youtube.com/watch?v=y9nuq7ZHQPM>   (11 min)

Excel File: Busn218-Video07.xlsx

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week04/Busn218-Video07.xlsx>

(for Video)

Handout: Highline Excel 2016 Class 07 Excel 2016 MAXIFS, MINIFS & IFS

Functions for Conditional Calculations.pdf

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week04/Highline%20Excel%202016%20Class%2007%20Excel%202016%20MAXIFS,%20MINIFS%20&%20IFS%20Functions%20for%20Conditional%20Calculations.pdf>

(click to view pdf, right-click to download file)

Homework to practice: No Homework

No Project This Week.



 



Week 5:



*Video 08:*  Highline Excel 2016 Class 08: Text Formulas and Text

Functions to Join and Extract Data

<https://www.youtube.com/watch?v=rlGLP3qzNnw>    (30 min)

Excel File: Busn218-Video08.xlsx

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week05/Busn218-Video08.xlsx>

(for Video and Homework)

Handout: Highline Excel 2016 Class 08 Text Functions.pdf

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week05/Highline%20Excel%202016%20Class%2008%20Text%20Functions.pdf>

(click to view pdf, right-click to download file)

Homework to practice: Sheets at end of downloaded Excel Workbook: HW #1 to 2



*Video 09:*  Highline Excel 2016 Class 09: Date Formulas and Date

Functions, including Fiscal Quarter & Year

<https://www.youtube.com/watch?v=9JbHP4g_LEs>   (22 min)

Excel File: Busn218-Video09.xlsx

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week05/Busn218-Video09.xlsx>

(for Video and Homework)

Handout: Highline Excel 2016 Class 09 Date Functions.pdf

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week05/Highline%20Excel%202016%20Class%2009%20Date%20Functions.pdf>

(click to view pdf, right-click to download file)

Homework to practice: Sheets at end of downloaded Excel Workbook: HW #1 to 6



*Video 10:*  Highline Excel 2016 Class 10: Excel Data Validation (List,

Custom & More), Comprehensive Lesson

<https://www.youtube.com/watch?v=ws63XhhQi1o>   (24 min)

Excel File: Busn218-Video10.xlsx

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week05/Busn218-Video10.xlsx>

(for Video and Homework)

Handout: Highline Excel 2016 Class 10 Data Validation.pdf

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week05/Highline%20Excel%202016%20Class%2010%20Data%20Validation.pdf>

(click to view pdf, right-click to download file)

Homework to practice: Sheets at end of downloaded Excel Workbook: HW #1 to 2



*Video 11:*  Highline Excel 2016 Class 11: Lookup Functions & Formulas,

Comprehensive Lessons, 20 Examples

<https://www.youtube.com/watch?v=HqXEcu22EaY>    (1 hour 18 mins)

Excel File: Busn218-Video11.xlsx

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week05/Busn218-Video11.xlsx>

(for Video and Homework)

Handout: Highline Excel 2016 Class 11 Lookup Functions.pdf

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week05/Highline%20Excel%202016%20Class%2011%20Lookup%20Functions.pdf>

(click to view pdf, right-click to download file)

Homework to practice: Sheets at end of downloaded Excel Workbook: HW #1

to 10

Project to complete for points toward a grade: Project04.xlsx

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week05/Project04.xlsx>





 



Week 6:



*Video 12:* Highline Excel 2016 Class 12: Two Lookup Values in VLOOKUP?

Helper Column or Array Formula.

<https://www.youtube.com/watch?v=7cLGrwbmpqw>  (8 mins)

Excel File: Busn218-Video12-14Start.xlsx

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week05/Busn218-Video12-14Start.xlsx>

(for Video and Homework #12, 13 and 14)

Handout: Highline Excel 2016 Class 12 Two Lookup Values in VLOOKUP.pdf

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week05/Highline%20Excel%202016%20Class%2012%20Two%20Lookup%20Values%20in%20VLOOKUP.pdf>

(click to view pdf, right-click to download file)

Homework to practice: Sheets at end of downloaded Excel Workbook: HW #1



*Video 13:*  Highline Excel 2016 Class 13: One Lookup Value to Return

Multiple Items: INDEX & AGGREGATE

<https://www.youtube.com/watch?v=jVI2kXCBfTA> (9 mins)

Excel File: Busn218-Video12-14Start.xlsx

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week05/Busn218-Video12-14Start.xlsx>

(for Video and Homework #12, 13 and 14)

Handout: Highline Excel 2016 Class 13  One Lookup Value Return Multiple

Items.pdf

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week05/Highline%20Excel%202016%20Class%2013%20%20One%20Lookup%20Value%20Return%20Multiple%20Items.pdf>

(click to view pdf, right-click to download file)

Homework to practice: Sheets at end of downloaded Excel Workbook: HW #2



*Video 14:*  Highline Excel 2016 Class 14: VLOOKUP as Relationship in

Power Pivot Data Model & Vice Versa

<https://www.youtube.com/watch?v=nvP-4eQnrZg> (8 mins)

Excel File: Busn218-Video12-14Start.xlsx

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week05/Busn218-Video12-14Start.xlsx>

and Busn218-Video12-14Finished.xlsx

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week05/Busn218-Video12-14Finished.xlsx>

(for Video and Homework #12, 13 and 14)

Handout: Highline Excel 2016 Class 14 VLOOKUP as Relationship and Vice

Versa.pdf

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week05/Highline%20Excel%202016%20Class%2014%20VLOOKUP%20as%20Relationship%20and%20Vice%20Versa.pdf>

(click to view pdf, right-click to download file)

Homework to practice: None.



*Video 15:*  Highline Excel 2016 Class 15: Excel Charts to Visualize

Data: Comprehensive Lesson 11 Chart Examples

<https://www.youtube.com/watch?v=xLmtGk7Ymy8>  (52 mins)

Excel File: Busn218-Video15.xlsm

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week06/Busn218-Video15.xlsm>

(for Video and Homework)

Handout: Highline Excel 2016 Class 15 Excel Charts.pdf

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week06/Highline%20Excel%202016%20Class%2015%20Excel%20Charts.pdf>

(click to view pdf, right-click to download file)

PowerPoint: Busn218-Charts.pptx

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week06/Busn218-Charts.pptx>

Homework to practice: Sheets at end of downloaded Excel Workbook: HW #1 to 5



 



Week 7:



*Video 16:*  Highline Excel 2016 Class 16: Conditional Formatting to

Visualize Data: Built-in & Logical Formulas

<https://www.youtube.com/watch?v=45QYIUBVSMY>   (44 mins)

Excel File: Busn218-Video16.xlsx

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week06/Busn218-Video16.xlsx>

(for Video and Homework)

Handout: Highline Excel 2016 Class 16 Conditional Formatting to

Visualize Data - Copy.pdf

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week06/Highline%20Excel%202016%20Class%2016%20Conditional%20Formatting%20to%20Visualize%20Data%20-%20Copy.pdf>

(click to view pdf, right-click to download file)

Homework to practice: Sheets at end of downloaded Excel Workbook: HW #1

to 13

Project to complete for points toward a grade: Project05.xlsm

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week06/Project05.xlsm>



*Video 17:*  Highline Excel 2016 Class 17: How to Build Excel Dashboard

PivotTable, Chart, Conditional Formatting from Data Model, See First DAX

Formula <https://www.youtube.com/watch?v=hYPwX_CfYv4>    (36:15 mins)

Excel File: Busn218-Video17Start.xlsx

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week07/Busn218-Video17Start.xlsx>

and Busn218-Video17Finished.xlsx

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week07/Busn218-Video17Finished.xlsx>

(for Video)

Zipped Files for Power Query / Power Pivot Data Model

Example:Video17ImportTextFiles-05.zip

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week07/Video17ImportTextFiles-05.zip>

Handout: Highline Excel 2016 Class 17 Dashboards.pdf

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week07/Highline%20Excel%202016%20Class%2017%20Dashboards.pdf>

(click to view pdf, right-click to download file)

Homework to practice: No Homework

Project to complete for points toward a grade: Busn218Project06.xlsm

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week07/Busn218Project06.xlsm>



 



Week 8:



*Video 18:*  Highline Excel 2016 Class 18: Clean & Transform Data:

Replace, Flash Fill, Text To Columns, Formulas

<https://www.youtube.com/watch?v=g3nN1P-vxiE>    (24 mins)

Excel File: Busn218-Video18.xlsx

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week08/Busn218-Video18.xlsx>

(for Video and Homework)

Handout: Highline Excel 2016 Class 18 Clean Transform Data Replace Flash

Fill TTC Formulas.pdf

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week08/Highline%20Excel%202016%20Class%2018%20Clean%20Transform%20Data%20Replace%20Flash%20Fill%20TTC%20Formulas.pdf>

(click to view pdf, right-click to download file)

Homework to practice: Sheets at end of downloaded Excel Workbook: HW #1 to 4



*Video 19:*   Highline Excel 2016 Class 19: Transform Data Sets using

Advanced Filter (8 Examples)

<https://www.youtube.com/watch?v=yAbRJHkK4Mg>   (34 mins)

Excel File: Busn218-Video19Start.xlsx

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week08/Busn218-Video19Start.xlsx> 

and Busn218-Video19Finished.xlsx

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week08/Busn218-Video19Finished.xlsx> 

(for Video and Homework)

Handout: Highline Excel 2016 Class 19 Transform Data Sets Advanced

Filter.pdf

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week08/Highline%20Excel%202016%20Class%2019%20Transform%20Data%20Sets%20Advanced%20Filter.pdf>

(click to view pdf, right-click to download file)

Homework to practice: Sheets at end of downloaded Excel Workbook: HW #1 to 3

Project to complete for points toward a grade: Project 07.xlsm

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week08/Project%2007.xlsm>



*Video 20:*   Highline Excel 2016 Class 20: Power Query (Get & Transform

) Import Multiple Excel Files, 1 Sheet Each & PivotTable Show Values As

<https://www.youtube.com/watch?v=90QdbiUTq7k>   (24 mins)

Excel File: Busn218-Video20Start.xlsx

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week08/Busn218-Video20Start.xlsx> 

and Busn218-Video20Finished.xlsx

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week08/Busn218-Video20Finished.xlsx> 

(for Video)

Zipped Files for Power Query / Power Pivot Data Model Example:

Video20-3ExcelFilesImport.zip

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week08/Video20-3ExcelFilesImport.zip>

Handout: Highline Excel 2016 Class 20 Clean Transform & Import Excel

Workbook Data with Power Query.pdf

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week08/Highline%20Excel%202016%20Class%2020%20Clean%20Transform%20&%20Import%20Excel%20Workbook%20Data%20with%20Power%20Query.pdf>

(click to view pdf, right-click to download file)

Homework: None



*Video 21:*  Highline Excel 2016 Class 21: Power Query Import Multiple

Excel Workbooks with Multiple Sheets

<https://www.youtube.com/watch?v=f83kcI3HSXo>    (9 mins)

Excel File: Busn218-Video21Start.xlsx

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week08/Busn218-Video21Start.xlsx>

and Busn218-Video21Finished.xlsx

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week08/Busn218-Video21Finished.xlsx> 

(for Video)

Zipped Files for Power Query: Video21-3ExcelWorkbooks.zip

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week08/Video21-3ExcelWorkbooks.zip>

Handout: Highline Excel 2016 Class 21 PQ to Import Multiple Excel

Workbooks with Multiple Sheets.pdf

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week08/Highline%20Excel%202016%20Class%2021%20PQ%20to%20Import%20Multiple%20Excel%20Workbooks%20with%20Multiple%20Sheets.pdf>

(click to view pdf, right-click to download file)

Homework: None

Project to complete for points toward a grade: Project 08.xlsm

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week08/Project%2008.xlsm>

& Zipped Folder: 3ExcelFilesForProject08.zip

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week08/3ExcelFilesForProject08.zip> 



 



Week 9:





*Video 22:*  Highline Excel 2016 Class 22: How To Build Data Model & DAX

Formulas in Power Pivot <https://www.youtube.com/watch?v=e-CFYi52gpc>  

 (1 hour 5 mins)

Excel File: Busn218-Video22Start.xlsm

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week09/Busn218-Video22Start.xlsm>

and Busn218-Video22Finished.xlsm

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week09/Busn218-Video22Finished.xlsm> 

(for Video)

Zipped Files for Power Query: Video22-ImportExcelFiles.zip

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week09/Video22-ImportExcelFiles.zip>

Handout: Highline Excel 2016 Class 22 Data Modling & DAX Formulas.pdf

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week09/Highline%20Excel%202016%20Class%2022%20Data%20Modling%20&%20DAX%20Formulas.pdf>

(click to view pdf, right-click to download file)

Homework: None 



*Extra Video About Making Automatic Calendar Table

Video 22.5:*   Excel Magic Trick 1299: Automatic Calendar Table in Data

Model, New in Excel 2016 <https://www.youtube.com/watch?v=0-VGZ4VUPlg> 

 (3 mins)

Excel File: EMT1299Start.xlsx

<https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1299Start.xlsx> and

EMT1299Finished.xlsx

<https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT1299Finished.xlsx> 

(for Video)

Handout: None

Homework: None 



*Video 23:*  Highline Excel 2016 Class 23: Intro to Power BI Desktop to

Create Data Model & Visualization

<https://www.youtube.com/watch?v=yET750M1Kas>     (24 mins)

Excel File: Busn218-Video23.xlsm

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week09/Busn218-Video23.xlsm>

(for Video)

Finished Power BI Desktop File: Video22-Busn218-Finished.pbix

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week09/Video22-Busn218-Finished.pbix>

Zipped Files to use in import into Power BI Desktop:

Video23-Import5ExcelFiles.zip

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week09/Video23-Import5ExcelFiles.zip>

Handout: Highline Excel 2016 Class 23 Power BI Desktop.pdf

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week09/Highline%20Excel%202016%20Class%2023%20Power%20BI%20Desktop.pdf>

(click to view pdf, right-click to download file)

Homework: None

Project to complete for points toward a grade: Coming soon... & Zipped

Folder: Coming soon...



 



Week 10 & 11:



*Video 24:*  Highline Excel 2016 Class 24: Financial Functions: PMT,

RATE, NPER and FV 12 Examples

<https://www.youtube.com/watch?v=9_HMM9wqfYM>     (41 mins)

Excel File: Busn218-Video24-OldFileName-Busn214-Week10.xlsm

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week10/Busn218-Video24-OldFileName-Busn214-Week10.xlsm>



Handout: Highline Excel 2016 Class 24 Finance Functions in Excel.pdf

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week10/Highline%20Excel%202016%20Class%2024%20Finance%20Functions%20in%20Excel.pdf>

Homework to practice: Sheets at end of downloaded Excel Workbook: HW #1

to 4  



*Video 25:*  Highline Excel 2016 Class 25: Round Functions: ROUND,

MROUND, ROUNDUP, CEILING, more…

<https://www.youtube.com/watch?v=Yd8qfeZqsdM>      (9 mins)

Excel File: Busn218-Video25-OldFileName-Busn214-Week03.xlsx

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week10/Busn218-Video25-OldFileName-Busn214-Week03.xlsx>

Handout: None.

Homework: None   



*Video 26:* Highline Excel 2016 Class 26: Macro Recorder Basics &

Copying VBA Code From Internet

<https://www.youtube.com/watch?v=WKyN8e7XXjI>       (40 mins)

Excel File: Busn218-Video26Start.xlsm

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week10/Busn218-Video26Start.xlsm>

and Busn218-Video26Finished.xlsm

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week10/Busn218-Video26Finished.xlsm>

(Video)

Handout: Highline Excel 2016 Class 26 Recorded Macros.pdf

<https://people.highline.edu/mgirvin/AllClasses/218_2016/Content/Week10/Highline%20Excel%202016%20Class%2026%20Recorded%20Macros.pdf>

Homework: None    



Class over! That was fun!



 



 



 



 



 



 



 



 



 



 



 



 



 



 



 



 



Link to Old Excel 2013 Class

<https://people.highline.edu/mgirvin/AllClasses/214_2013/214/Busn214_2013.htm>