Week 7:
Video 04
Video link:
Excel & Power BI Data Analysis Complete Class in One Video - 365 MECS 04 (
3 hour 44 mins)
Download all files for video in zipped folder:
MECS04DownloadFiles.zip (This zipped folder has many more files
than are shown in video : ) )
Pdf notes (in zipped folder also):
04-M365ExcelClass.pdf
When you are done studying the minute marks 00:00 to 01:28:37 of the above video you can:
1) Take Canvas Quiz 4 in the Home area of Canvas by end of week 7
2) Download Excel Test #5 file: Test05. and zipped folder with csv files: Test05Problem04TextFiles.zip and compltete and upload to Home area of Canvas by end of week 7
Week 8:
3) Download Excel Test #6 file: Test06. and compltete and upload to Home area of Canvas by end of week 8
Week 9:
When you are done studying the minute marks 01:28:38 to 02:07:05 of the above video you can:
2) Take Canvas Quiz 5 in the Home area of Canvas by end of week 9
2) Download Excel Test #7 file: Test07. and the Excel file with data analysis source tables: Test07Problem01SourceTables.xlsx and then compltete and upload to Home area of Canvas by end of week 9
Week 10 to 12:
2) Download Excel Test #8 file: Test08. and the Excel file with data analysis source tables: Test08Problem01SourceTables.xlsx and then compltete and upload to Home area of Canvas by end of week 12