Video 09
Video link: Excel
Array Formulas & Functions: 50 Examples of How to Become an Array Expert! - 365
MECS 09 (1
hour 10 mins)
Download Excel file:
09-M365ExcelClass.xlsx
Download pdf file:
09-M365ExcelClass.pdf
Video 10
Video link:
Excel LAMBDA function – Every Single Things You Ever Wanted To Know -
365 MECS 10 (1
hour 45 mins)
Download Excel file:
10-M365ExcelClass.xlsx
Download pdf file:
10-M365ExcelClass.pdf
Video 11
Video link:
Visualizing Data and Building Dashboards in Excel & Power BI - 365 MECS 11 (1
hour 42 mins)
Download zipped folder with all files for this video:
11-M365ExcelClassVideoFiles.zip
Click to view pdf notes:
11-M365ExcelClass.pdf (pdf also in zipped folder)
Video 12
Video link: M
Code Class from Basic to Advanced: Power Query Excel & Power BI, Custom
Functions 365 MECS 12 (1
hour 42 mins)
Download zipped folder with all files for this video:
12-M365ExcelClassVideoFiles.zip
Click to view pdf notes:
12-M365ExcelClass.pdf
(pdf also in zipped folder)
Video 13
Video link: Power
Query and M Code to Import &Transform Data: 20 Epic Examples! 365 MECS 13 (1
hour 49 mins)
Download zipped folder with all files for this video: 13-M365ExcelClassVideoFiles.zip
Click to view pdf notes:
13-M365ExcelClass.pdf (pdf also in zipped folder)
Video 14
Video link: Power
Query UnPivot to Convert Cross Tabulated Table into Proper Data Set. 365 MECS
Class 14 (03:37 mins)
Download zipped folder with all files for this video: 14-M365ExcelClassVideoFiles.zip
Click to view pdf notes:
14-M365ExcelClass.pdf (pdf also in zipped folder)
Video 15
Video link: 7
Types of Joins in Power Query Merge. 9 Examples. 365 MECS Class 15 (22:01 mins)
Download zipped folder with all files for this video: 15-M365ExcelClassVideoFiles.zip
Click to view pdf notes:
15-M365ExcelClass.pdf (pdf also in zipped folder)
Video 16
Video link: Power
Query Group By: Complete Lesson. 10 Examples. 365 MECS Class 16 (33:48 mins)
Download zipped folder with all files for this video: 16-M365ExcelClassVideoFiles.zip
Click to view pdf notes:
16-M365ExcelClass.pdf (pdf also in zipped folder)
Video 17
Video link: Fundamentals
of DAX in Power BI & Power Pivot. 365 MECS Class 17 (2
hour 26 mins)
Download zipped folder with all files for this video: 17-M365ExcelClassVideoFiles.zip
Click to view pdf notes:
17-M365ExcelClassDAX.pdf (pdf also in zipped folder)
Video 18
Video link:
Solution for Two Fact Tables: Power Query or DAX formulas or Worksheet
Formulas? 365 MECS Class 18 (37:29 mins)
Download zipped folder with all files for this video: 18-M365ExcelClassVideoFiles.zip
Click to view pdf notes:
18-M365ExcelClass.pdf (pdf also in zipped folder)
Video 19
Video link:
Budget Vs. Actual Variance Analysis: Data Modeling, DAX, or Worksheet Formulas?
365 MECS Class 19 (14:55 mins)
Download zipped folder with all files for this video: 19-M365ExcelClassVideoFiles.zip
Click to view pdf notes:
19-M365ExcelClass.pdf (pdf also in zipped folder)
Video 20
Video link: What
Is My CD Worth? A Lesson in Finance & Worksheet Model Building. 365 MECS Class
20 (18:25 mins)
Download zipped folder with all files for this video: 20-M365ExcelClass.xlsx
Click to view pdf notes:
20-M365ExcelClass.pdf (pdf also in zipped folder)
Video 21
Video link: Build
Mortgage Home Loan Schedule. Traditional &Dynamic Spilled Array Formulas. 365
MECS Class 21 (15:48 mins)
Download zipped folder with all files for this video: 21-M365ExcelClass.xlsx
Click to view pdf notes:
21-M365ExcelClass.pdf (pdf also in zipped folder)
Video 22
Video link: Two
Date Columns in Fact Table? How To Create Report? DAX, Power Query, Excel? 365
MECS Class 22 (18:11 mins)
Download zipped folder with all files for this video: 22-M365ExcelClassVideoFiles.zip
Click to view pdf notes:
22-M365ExcelClass.pdf (pdf also in zipped folder)
When you are done studying the above material you can:
1) Take Canvas Quiz 9 in the Home area of Canvas.
2) Download Excel Test #8 file (????????? test problems in file): Test09