Back To Home Page

Highline Busn 218: Advanced Excel (Spreadshseet Construction) ExcelPowerBI

Syllabus (click to view pdf, right-click to download file)
Introductory Video (click to view video)

 

Videos, Written Handouts, Homework and Homework Solutions:

Week 1:

Video/Class Project Excel Basics 1:
Video to watch:
  Excel Basics 1: Introduction To Excel 1: Formatting, Formulas, Cell References, Page Setup    ( 01:02:54 min)
Start file for Video/Class Project to download: None
Finished file for Video/Class Project to download (example of how file looks after video is over): EB01-Gradebook-Finished.xlsx
Handout to download (pdf notes): Office2016Class13-ExcelBasics01-IntroductionToExcel01.pdf
Homework to practice: None

Video/Class Project Excel Basics 2:
Video to watch:
  Excel Basics 2: Introduction to Excel 2: Excel's Golden Rule for Formulas, Formula Inputs, & Charts    ( 37:49 min)
Start file for Video/Class Project to download: None
Finished file for Video/Class Project to download (example of how file looks after video is over): EB02-NetIncomeProjections.xlsx
Handout to download (pdf notes): Office2016Class14-ExcelBasics02-IntroductionToExcel02.pdf
Homework to practice: None

Video/Class Project Excel Basics 3:
Video to watch:
  Excel Basics 3: Count & Add with COUNT, COUNTA, SUM, COUNTIFS, SUMIFS Functions (Intro Excel #3)     ( 21:06 min)
Start file for Video/Class Project to download:  EB03-CountingAddingWithCriteria.xlsx
Finished file for Video/Class Project to download (example of how file looks after video is over):  EB03-CountingAddingWithCriteriaFinished.xlsx
Handout to download (pdf notes): Office2016Class15-ExcelBasics03-IntroductionToExcel03.pdf
Homework to practice: HW # 1 - 3 at the end of the Excel workbook for this video.

Video/Class Project Excel Basics 4:
Video to watch:
  Excel Basics 4: PivotTables & SUMIFS Function to Create Summary Reports (Intro Excel #4)  ( 33:25 min)
Start & Finished file for Video/Class Project to download:  EB04-SUMIFSandPivotTables.xlsx
Handout to download (pdf notes): Office2016Class16-ExcelBasics04-IntroductionToExcel04.pdf
Homework to practice: HW # 1 - 3 at the end of the Excel workbook for this video.

Video/Class Project Excel Basics 5:
Video to watch:
  Excel Basics 5: Power of PivotTables to Create Reports with Various Calculations & Layouts  ( 20:19 min)
Start & Finished file for Video/Class Project to download: EB05-PivotTableCalculationsLayout.xlsx
Handout to download (pdf notes): Office2016Class17-ExcelBasics05PivotTableCalculationsLayout.pdf
Homework to practice: HW # 1 - 3 at the end of the Excel workbook for this video.

Important Video 01 - 05 Concept Summary: Office2016Class17s-ExcelBasics01-05-KeyConcepts.pdf

 

Week 2:

Video/Class Project Excel Basics 6 - 8:
** There are three videos here with one Excel file and one handout:
Video to watch:
  Excel Basics 6: Customize Quick Access Toolbar (QAT) and Show New Ribbon Tabs  ( 10:17 min)
Video to watch:  Excel Basics 7: Keyboard Shortcuts Are Fast!  ( 08:15 min)
Video to watch:  Excel Basics 8: Default Data Alignment In Excel & How it Can Help  ( 09:25 min)
Start & Finished file for Video/Class Project to download: EB06-08QATKeyboardsDefaultAlign.xlsx
Handout to download (pdf notes): Office2016Class18-20-ExcelBasics06-08QATKeyboardDefaultAlign.pdf
Homework to practice: HW # 1 - 3 at the end of the Excel workbook for this video.

Video/Class Project Excel Basics 9:
Video to watch:
  Excel Basics 9: Number Formatting as Façade & the ROUND Function   ( 28:49 min)
Start & Finished file for Video/Class Project to download: EB09-NumberFormattingAndROUND.xlsm
Handout to download (pdf notes): Office2016Class21-ExcelBasics09-NumberFormattingAndROUND.pdf
Homework to practice: HW # 1 - 2 at the end of the Excel workbook for this video.

Video/Class Project Excel Basics 10:
Video to watch:
  Excel Basics 10: Date & Time Number Formatting, Formulas, Functions & Calculations   ( 39:53 min)
Start & Finished file for Video/Class Project to download: EB10DateTimeNumberFormattingAndCalculations.xlsm
Handout to download (pdf notes): Office2016Class22-ExcelBasics10-DateTimeNumberFormatAndCalculations.pdf
Homework to practice: HW # 1 - 4 at the end of the Excel workbook for this video.

Video/Class Project Excel Basics 11:
Video to watch:
   Excel Basics 11: Search for Excel Functions & get help with Function Arguments  ( 17:04 min)
Start & Finished file for Video/Class Project to download: EB11SearchForFunctions.xlsm
Handout to download (pdf notes): Office2016Class23-ExcelBasics11-SearchForFunctions.pdf
Homework to practice: None.

Video/Class Project Excel Basics 12:
Video to watch:
   Excel Basics 12: Complete Formula Lesson of Formula Types & Formula Elements 12 Examples   ( 42:25 min)
Start & Finished file for Video/Class Project to download: EB12-FormulaElements.xlsm
Handout to download (pdf notes): Office2016Class24-ExcelBasics12-FormulaElements.pdf
Homework to practice: HW # 1 - 5 at the end of the Excel workbook for this video.

Video/Class Project Excel Basics 13:
Video to watch:
   Excel Basics 13: IF Function Made Easy! IS Functions Too! 14 Epic Examples!!    ( 54:07 min)
Start & Finished file for Video/Class Project to download:  EB13-IF-FunctionAnd-IS-Functions.xlsm   
Handout to download (pdf notes): Office2016Class25-ExcelBasics13-IF-FunctionAndIs-Function.pdf
Homework to practice: HW # 1 - 4 at the end of the Excel workbook for this video.

Video/Class Project Excel Basics 14:
Video to watch:
  Excel Basics 14: Excel VLOOKUP Function Made Easy! 9 Examples to Make Your Job Easier!   ( 40:07 min)
Start & Finished file for Video/Class Project to download:  EB14-VLOOKUPFunction.xlsm   
Handout to download (pdf notes):  Office2016Class26-ExcelBasics14-VLOOKUPFunction.pdf 
Homework to practice: HW # 1 - 3 at the end of the Excel workbook for this video.

Video/Class Project 27: Excel Basics 15:
Video to watch:
  Excel Basics 15: Excel Table Feature & Dynamic Ranges for VLOOKUP, PivotTables, & more!    ( 36:46 min)
Start & Finished file for Video/Class Project to download:  EB15-ExcelTableFeature.xlsm   
Handout to download (pdf notes):  Office2016Class27-ExcelBasics15-VExcelTableFeature.pdf 
Homework to practice: HW # 1 - 2 at the end of the Excel workbook for this video.

Video/Class Project Excel Basics 16:
Video to watch:
  Excel Basics 16: Mixed Cell References #1 Trick to Creating Formulas Quickly!!!    ( 45:07 min)
Start & Finished file for Video/Class Project to download:  EB16MixedCellReferences.xlsm   
Handout to download (pdf notes):  Office2016Class28-ExcelBasics16-MixedCellReferences.pdf 
Homework to practice: HW # 1 - 4 at the end of the Excel workbook for this video.

 

Week 3:

Video/Class Project Excel Basics 17:
Video to watch:
  Excel Basics 17: Style Formatting: By Hand, Cell, Table & Conditional Formatting    ( 18:02 min)
Start & Finished file for Video/Class Project to download:  EB17StyleFormatting.xlsm   
Handout to download (pdf notes): Office2016Class29-ExcelBasics17-StyleFormatting.pdf 
Homework to practice: HW # 1 - 2 at the end of the Excel workbook for this video.

Video/Class Project Excel Basics 18:
Video to watch:
  Excel Basics 18: Defined Names in Excel Formulas & Functions & For Jump Go To!   ( 10:44 min)
Start file for Video/Class Project to download:   EB18-DefinedNamesStartFile.xlsm  
Finished file for Video/Class Project to download (example of how file looks after video is over):
 EB18-DefinedNamesFinishedFile.xlsm 
Handout to download (pdf notes):  Office2016Class30-ExcelBasics18-DefinedNames.pdf 
Homework to practice: None.

Video/Class Project Excel Basics 19:
Video to watch:
  Excel Basics 19: SUMIFS, COUNTIFS, AVERAGEIFS, functions calculations w 1 or more Criteria   ( 35:15 min)
Start & Finished file for Video/Class Project to download:  EB19-SUMIFSandSimilarFunctions.xlsm   
Handout to download (pdf notes):   Office2016Class31-ExcelBasics19-SUMIFSandSimilarFunctions.pdf
Homework to practice: HW # 1 - 3 at the end of the Excel workbook for this video.

Video/Class Project Excel Basics 20:
Video to watch:
   Excel Basics 20: PivotTable Power: 14 Amazing PivotTable Reporting Tricks: Slicers to Show Values As   ( 39:49 min)
Start file for Video/Class Project to download:  EB20-PivotTablesStart.xlsm   
Finished file for Video/Class Project to download (example of how file looks after video is over):  EB20-PivotTablesFinished.xlsm    
Handout to download (pdf notes):  Office2016Class32-ExcelBasics20PivotTables.pdf 
Homework to practice: HW # 1 - 3 at the end of the Excel workbook for this video.

Video/Class Project Excel Basics 21:
Video to watch:
  Excel Basics 21: Relationships Rather than VLOOKUP for PivotTable Reports (Excel 2016 Data Model)   ( 21:34 min)
Start file for Video/Class Project to download:  EB21-PivotTablesRelationshipsStart.xlsm   
Finished file for Video/Class Project to download (example of how file looks after video is over):  EB21-PivotTablesRelationshipsFinished.xlsm   and  EB21-PivotTablesVLOOKUPFinished.xlsm    
Handout to download (pdf notes):  Office2016Class33-ExcelBasics21PivotTablesRelationships.pdf 
Homework to practice: HW # 1 at the end of the Excel workbook for this video.

Video/Class Project Excel Basics 22:
Video to watch:
  Excel Basics 22: Set Default PivotTable Layout & Options in Excel 2016 Office 365 or Later   ( 04:25 min)
Start & Finished file for Video/Class Project to download:   EB22-DefaultPivotTableLayoutExcel2016.xlsx   
Handout to download (pdf notes):  Office2016Class34-ExcelBasics22DefaultPivotTableLayoutExcel2016.pdf 
Homework to practice: None.

Video/Class Project Excel Basics 23:
Video to watch:
  Excel Basics 23: Data Analysis Features: Sort, Filter, Flash Fill to Organize & Clean Data   ( 30:07 min)
Start file for Video/Class Project to download:   EB23-SortFilterFlashFillStart.xlsx   
Finished file for Video/Class Project to download (example of how file looks after video is over):  EB23-SortFilterFlashFillFinished.xlsx 
Handout to download (pdf notes): Office2016Class35-ExcelBasics23SortFilterFlashFill.pdf 
Homework to practice: HW # 1 - 4 at the end of the Excel workbook for this video.

Video/Class Project Excel Basics 24:
Video to watch:
  Excel Basics 24: Excel Charts & Graphs to Visualize Quantitative Data. No Chart Junk!!!    ( 34:33 min)
Start & Finished file for Video/Class Project to download:      EB24Charts.xlsm
Handout to download (pdf notes):  Office2016Class36-ExcelBasics24Charts.pdf 
Homework to practice: HW # 1 - 5 at the end of the Excel workbook for this video.

Video/Class Project Excel Basics 25:
Video to watch:
  Excel Basics 25: Power Query (Get & Transform) to Clean & Transform Data into Proper Data Set  ( 30:53 min)
Start file for Video/Class Project to download:  EB25GetAndTransformPowerQueryStart.xlsm   
Finished file for Video/Class Project to download (example of how file looks after video is over):  EB25GetAndTransformPowerQueryFinished.xlsm    
Zipped Folder with Text Files used for importing into Excel:  EB25FileDownloads.zip 
Handout to download (pdf notes):  Office2016Class37-ExcelBasics25-PowerQueryGetAndTransform.pdf 
Homework to practice: HW # 1 at the end of the Excel workbook for this video.

Important Video 01 - 25 Concept Summary: ExcelBasics01-25-KeyConcepts.pdf

 

Week 4:

Video/Class Project E-DAB 01:
Video to watch:
   E-DAB 01: Excel Data Analysis & BI Basics Class 01: What is Data Analysis & Business Intelligence?   ( 12:41 min)
PowerPoint Video Notes:  E-DAB-01-IntroductionToClass.pptx   
No Homework for this video

Video/Class Project E-DAB 02:
Video to watch:
   E-DAB 02: Excel Data Analysis & BI Basics: Data, Proper Data Sets, Excel Tables, Logical Tests, More   ( 35:26 min)
Start file for Video/Class Project to download: E-DAB-02-Start-DataTablesFilterLogicTest.xlsx    
Finished file for Video/Class Project to download:  E-DAB-02-Finished-DataTablesFilterLogicTest.xlsx     
Handout to download (pdf notes): E-DAB-02-DataTablesFilterLogicTest.pdf   
Homework to practice:
 In the above Excel Download file named "E-DAB-02-Start-DataTablesFilterLogicTest.xlsx", at the end of the worksheets are 3 problmes for you to complete. The problems are on the blue sheets and the answers are on the red sheets.

Video/Class Project E-DAB 03:
Video to watch:
   E-DAB 03: Excel Data Analysis & BI Basics: Excel Spreadsheet Formulas Old School? Or Dynamic Arrays?   ( 29:52 min)
Start file for Video/Class Project to download:  E-DAB-03-FormulasStart.xlsx   
Finished file for Video/Class Project to download:  E-DAB-03-FormulasFinished.xlsx     
Handout to download (pdf notes):  E-DAB-03-Formulas.pdf  
Homework to practice:
 In the above Excel Download file named "E-DAB-03-FormulasStart.xlsx ", at the end of the worksheets are 2 problmes for you to complete. The problems are on the blue sheets and the answers are on the red sheets.   

Video/Class Project E-DAB 04:
Video to watch:
   E-DAB 04: Excel Data Analysis & BI Basics: PivotTables & Slicers to Create Dashboards & Summary Reports  ( 29 min)
Start file for Video/Class Project to download:  E-DAB-04-PivotTablesStart.xlsx    
Finished file for Video/Class Project to download:  E-DAB-04-PivotTablesFinished.xlsx     
Handout to download (pdf notes):   E-DAB-04-PivotTables.pdf  
Homework to practice:
 In the above Excel Download file named "E-DAB-04-PivotTablesStart.xlsx  ", at the end of the worksheets are 4 problmes for you to complete. The problems are on the blue sheets and the answers are on the red sheets.   

Video/Class Project E-DAB 05:
Video to watch:
    E-DAB 05: Excel Data Analysis & BI Basic: Visualizing Data w Tables, Charts, Formatting & Dashboards ( 54:40 min)
Start file for Video/Class Project to download: E-DAB-05-Visualizations-Start.xlsx 
Finished file for Video/Class Project to download:  E-DAB-05-Visualizations-Finished.xlsx   
Handout to download (pdf notes):   E-DAB-05-Visualizations.pdf 
Homework to practice:
In the above Excel Download file named "E-DAB-05-Visualizations-Start.xlsx ", at the end of the worksheets are
5 problmes for you to complete. The problems are on the blue sheets and the answers are on the red sheets.   

 

Week 5 - 6:

Video/Class Project E-DAB 06:
Video to watch:
    E-DAB 06: Excel Data Analysis & BI Basics: The Magic of Power Query to Import, Transform & Load Data  ( 26:39 min)
All files needed to follow along with video and do homework are in this zipped folder you can download: DownloadFilesForEDAB06.zip
If you want, you can donwload files individually:
    Excel Start File: E-DAB-06-PowerQuery-Start.xlsx
    Excel Finished File: E-DAB-06-PowerQuery-Finished.xlsx
    Text files for video example #1: Ex01March2019.txt , Ex01April2019.txt
    Text Files for Example #2: EB25FileDownloads.zip
Handout to download (pdf notes):  E-DAB-06-PowerQuery.pdf

Homework to practice:
Homework #2 Text File  HW02CarDealerSurveyData.txt
In the above Excel Download file named "E-DAB-06-PowerQuery-Start.xlsx " at the end of the worksheets are 2 problmes for you to complete. The problems are on the blue sheets and the answers are on the red sheets.  Text file for Homewprk #2 is above and is named "HW02CarDealerSurveyData.txt ".     

Video/Class Project E-DAB 07:
Video to watch:
   E-DAB 07: Excel Data Analysis & BI Basics: Data Modeling: Excel Formulas, Power Query, Power Pivot?   ( 45:20 min)
All files needed to follow along with video and do homework are in this zipped folder you can download: DownloadFilesForEDAB07.zip 
If you want, you can donwload files individually:
    Excel Start File: E-DAB-07-DataModeling-Start.xlsx 
    Access Data Source File: E-DAB07-AccessData.accdb 
    Excel Finished File:  E-DAB-07-DataModeling-Finished.xlsx 
Handout to download (pdf notes):  E-DAB-07-DataModeling.pdf  
Homework to practice:    Homework instructions and problem are in this Excel Workbook file: E-DAB-07-HomeworkStart.xlsx  solution to homework is here: E-DAB-07-HomeworkFinished.xlsx

Video/Class Project E-DAB 08:
Video to watch:
    E-DAB 08: Excel Data Analysis & BI Basics: Power Pivot: Big Data, Data Modeling, DAX & Dashboard   ( 44:41 min)
All files needed to follow along with video and do homework are in this zipped folder you can download: DownloadFilesForEDAB08.zip 
If you want, you can donwload files individually:
    Excel Start File:  E-DAB-08-SQLBigDataDAXFormualsStart.xlsx
    Excel Finished File:  E-DAB-08-SQLBigDataDAXFormualsFinished.xlsx 
Handout to download (pdf notes):  E-DAB-08-SQLBigDataDAXFormuals.pdf     
Homework to practice:    Homework instructions and problem are in this Excel Workbook file: E-DAB-08-HomeworkStart.xlsx  solution to homework is here: E-DAB-08-HomeworkFinished.xlsx

Video/Class Project E-DAB 09:
NOTE: Power BI Desktop Ribbon tab has changed. Read this BEFORE watching video:
E-DAB-09-Busn218-PowerBI-RibbonHasChanged.pdf

Video to watch:  E-DAB 09: Power BI Desktop: Data Modeling & Interactive Visualizations (Data Analysis & BI Basics)   ( 37:36 min) 
All files needed to follow along with video and do homework are in this zipped folder you can download: DownloadFilesForEDAB09.zip 
If you want, you can donwload files individually:
    Excel Start File: E-DAB-09-PowerBISourceTables.xlsm 
    Zipped Folder with Files: E-DAB-09-PowerBISourceZippedExcelTables.zip
    Power BI Desktop Finished File:  E-DAB-09-PowerBIReportFinished.pbix 
Handout to download (pdf notes): E-DAB-09-PowerBIDesktop.pdf     
Homework to practice:    Homework instructions and problem are in this Word file: E-DAB-09-HomeworkProblem-PowerBI.docx  solution to homework is here: E-DAB-09-HomeworkFinished.pbix

Video/Class Project E-DAB 10:
Video to watch:  E-DAB-10: Excel & Power BI Together! Import, Publish and Share (Excel Data Analysis & BI Basics)  
 ( 14:36 min) 
All files needed to follow along with video and do homework are in this zipped folder you can download: DownloadFilesForEDAB10.zip 
If you want, you can donwload files individually:
    Excel Start Source Table File: E-DAB-10-ExcelFileSourceTables.xlsx 
    Excel Start Source Data Model File: E-DAB-10-ExcelFileWithDataAndReports.xlsx 
    Power BI Desktop Start File:  E-DAB-10-PowerBIDesktop-Start.pbix 
        Important Notes: Hints about Importing Excel Data Model into Power BI Desktop File.docx
                                    (
Steps for Importing Excel Data Model into Power BI File with the new User Interface in 2020 Power BI Desktop).
    Power BI Desktop Finished File:  E-DAB-10-PowerBIDesktop-Finished.pbix 
Handout to download (pdf notes): E-DAB-10-ExcelAndPowerBIShare.pdf     
Homework to practice:  Homework instructions and problem are in this zipped fodler:  E-DAB-10-HomeworkFiles.zip  

Week 7:

Video/Class Project Advanced Excel 04:
Video to watch:   Highline Excel 2016 Class 04: References: Relative, Absolute, Mixed, Sheet, Workbook, 3-D, Table and more (24 Examples) (1 hour 43 min)
Excel File: Busn218-Video04Start.xlsm and Busn218-Video04Finished.xlsm (for Video and Homework)
Excel File for Workbook Reference: May Net Income.xlsx
Handout to download (pdf notes): Highline Excel 2016 Class 04 Cell References Defined Names Table Formula Nomenclature.pdf (click to view pdf, right-click to download file)
Homework to practice: Sheets at end of downloaded Excel Workbook: HW #1 to #13

Video/Class Project Advanced Excel 05:

Video to wtach:  Highline Excel 2016 Class 05: Excel Array Formulas: Comprehensive Lessons: 12 Examples  (52 min)
Excel File: Busn218-Video05.xlsm (for Video and Homework)
Handout: Highline Excel 2016 Class 05 Introduction To Array Formulas.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/Class Project Advanced Excel 06:
Video to watch: 
 
Highline Excel 2016 Class 06: Conditional Calculations with Excel Formulas: Comprehensive Lessons   (1 hour 23 min)
Excel File: Busn218-Video06Start.xlsx   and   Busn218-Video06Finished.xlsx  (for Video and Homework)
Handout to download (pdf notes): Highline Excel 2016 Class 06 Conditional Calculations with Excel Formulas AND & OR Criteria.pdf (click to view pdf, right-click to download file)
Homework to practice: Sheets at end of downloaded Excel Workbook: HW #1 to 9

Week 8 - 10:

 

Video/Class Project Advanced Excel 08:
Video to watch: 
Highline Excel 2016 Class 08: Text Formulas and Text Functions to Join and Extract Data    (30 min)
Excel File: Busn218-Video08.xlsx (for Video and Homework)
Handout to download (pdf notes): Highline Excel 2016 Class 08 Text Functions.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/Class Project Advanced Excel 09:
Video to watch: 
 
Highline Excel 2016 Class 09: Date Formulas and Date Functions, including Fiscal Quarter & Year    (22 min)
Excel File: Busn218-Video09.xlsx (for Video and Homework)
Handout to download (pdf notes): Highline Excel 2016 Class 09 Date Functions.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/Class Project Advanced Excel 10:
Video to watch: 
 
Highline Excel 2016 Class 10: Excel Data Validation (List, Custom & More), Comprehensive Lesson   (24 min)
Excel File: Busn218-Video10.xlsx (for Video and Homework)
Handout to download (pdf notes): Highline Excel 2016 Class 10 Data Validation.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/Class Project Advanced Excel 11:
Video to watch: 
Highline Excel 2016 Class 11: Lookup Functions & Formulas, Comprehensive Lessons, 20 Examples    (1 hour 18 mins)
Excel File: Busn218-Video11.xlsx (for Video and Homework)
Handout to download (pdf notes): Highline Excel 2016 Class 11 Lookup Functions.pdf (click to view pdf, right-click to download file)
Homework to practice: Sheets at end of downloaded Excel Workbook: HW #1 to 10

Video/Class Project Advanced Excel 16:
Video to watch:  Highline Excel 2016 Class 16: Conditional Formatting to Visualize Data: Built-in & Logical Formulas   (44 mins)
Excel File: Busn218-Video16.xlsx (for Video and Homework)
Handout: Highline Excel 2016 Class 16 Conditional Formatting to Visualize Data - Copy.pdf (click to view pdf, right-click to download file)
Homework to practice: Sheets at end of downloaded Excel Workbook: HW #1 to 13

Video/Class Project Advanced Excel 24:
Video to watch: 
 
 Highline Excel 2016 Class 24: Financial Functions: PMT, RATE, NPER and FV 12 Examples     (41 mins)
Excel File: Busn218-Video24-OldFileName-Busn214-Week10.xlsm
Handout to download (pdf notes): Highline Excel 2016 Class 24 Finance Functions in Excel.pdf
Homework to practice: Sheets at end of downloaded Excel Workbook: HW #1 to 4
  

Video/Class Project Advanced Excel 26:
Video to watch: 
 
Highline Excel 2016 Class 26: Macro Recorder Basics & Copying VBA Code From Internet       (40 mins)
Excel File: Busn218-Video26Start.xlsm and Busn218-Video26Finished.xlsm (Video)
Handout to download (pdf notes): Highline Excel 2016 Class 26 Recorded Macros.pdf
Homework: None
    

 

End Of Class Videos

 

 

 

 

 

 

 

 

 

Old Class