Week 9-10:
Video 07
Video link:
Logical Tests: Excel Formulas, Conditional Formatting, PivotTables, Power Query,
& More- 365 MECS 07 (1
hour 48 mins)
Download Excel file:
07-M365ExcelClass.xlsx
Download pdf file:
07-M365ExcelClass.pdf
Download csv file for Power Query Video Example:
9112021-2022CallData.csv
Video 08
Video link:
All Important Excel Lookup Formulas: Excel Worksheet, Power Query & DAX
– 28 Examples! - 365 MECS 08 (1 hour 18 mins)
Download Excel file:
08-M365ExcelClass.xlsx
Download pdf file:
08-M365ExcelClass.pdf
When you are done studying the above material you can:
1) Take Canvas Quiz 8 in the Home area of Canvas.
2) Download Excel Test #7 file (4 test problems in file): Test07