WA Auditor Excel Files:


Power Query 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
pdf notes:  E-DAB-06-PowerQuery.pdf

Homework #2 Text File  HW02CarDealerSurveyData.txt
Assigned Homework:   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 Homework #2 is above and is named "HW02CarDealerSurveyData.txt ".     

Relationships 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:  Office2016Class33-ExcelBasics21PivotTablesRelationships.pdf 
Assigned Homework: HW # 1 at the end of the Excel workbook for this video.

 

Playlist of Other Accounting Excel Videos from excelisfun: Playlist of Accounting Excel Topics