Week 5 & 6 & 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.
2) Download Excel Test #3 file (5 test problems in file): Test03. and zipped folder with csv files: Test03Problem04TextFiles.zip
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.
2) Download Excel Test #4 file (1 test problems in file): Test04. and the Excel file with data analysis source tables: Test04Problem01SourceTables.xlsx
When you are done studying the minute marks 02:07:06 to 03:44:07 of the above video you can:
1) Take Canvas Quiz 6 in the Home area of Canvas.
2) Download Excel Test #5 file (2 test problems in file): Test05
Grade Web Site for example 1 in MECS #4: Grade Web Site