|
|
01 - Challenge setup.mp4
|
MP4
|
4.5 MB
|
|
|
01 - Challenge setup.srt
|
SRT
|
1.3 KB
|
|
|
01 - Data types explained.mp4
|
MP4
|
17.9 MB
|
|
|
01 - Data types explained.srt
|
SRT
|
8.5 KB
|
|
|
01 - Drill down to create a variable in Power Query.mp4
|
MP4
|
18.8 MB
|
|
|
01 - Drill down to create a variable in Power Query.srt
|
SRT
|
8.4 KB
|
|
|
01 - Fill up and fill down.mp4
|
MP4
|
11.1 MB
|
|
|
01 - Fill up and fill down.srt
|
SRT
|
5.4 KB
|
|
|
01 - Fuzzy matching by percentage.mp4
|
MP4
|
24.5 MB
|
|
|
01 - Fuzzy matching by percentage.srt
|
SRT
|
9.5 KB
|
|
|
01 - Group By feature.mp4
|
MP4
|
14.4 MB
|
|
|
01 - Group By feature.srt
|
SRT
|
6.2 KB
|
|
|
01 - Make your data useful with Power Query.mp4
|
MP4
|
3.4 MB
|
|
|
01 - Make your data useful with Power Query.srt
|
SRT
|
1 KB
|
|
|
01 - Midterm challenge Get a count of all colors.mp4
|
MP4
|
19 MB
|
|
|
01 - Midterm challenge Get a count of all colors.srt
|
SRT
|
8.5 KB
|
|
|
01 - Next steps.mp4
|
MP4
|
4.1 MB
|
|
|
01 - Next steps.srt
|
SRT
|
1.3 KB
|
|
|
01 - Overview of joins in Power Query.mp4
|
MP4
|
9.5 MB
|
|
|
01 - Overview of joins in Power Query.srt
|
SRT
|
7.5 KB
|
|
|
01 - Pivot data in Power Query.mp4
|
MP4
|
7.2 MB
|
|
|
01 - Pivot data in Power Query.srt
|
SRT
|
3.3 KB
|
|
|
01 - Power Query example.mp4
|
MP4
|
24.9 MB
|
|
|
01 - Power Query example.srt
|
SRT
|
12.3 KB
|
|
|
01 - Two data sets.mp4
|
MP4
|
7.9 MB
|
|
|
01 - Two data sets.srt
|
SRT
|
3.6 KB
|
|
|
01 - Use IF formulas.mp4
|
MP4
|
7.1 MB
|
|
|
01 - Use IF formulas.srt
|
SRT
|
3.6 KB
|
|
|
01_02_Excel vs Power Query.xlsx
|
XLSX
|
13.9 KB
|
|
|
02 - Differences between Excel and Power Query.mp4
|
MP4
|
23.6 MB
|
|
|
02 - Differences between Excel and Power Query.srt
|
SRT
|
11.1 KB
|
|
|
02 - Merging inconsistent data with a transformation table.mp4
|
MP4
|
16.5 MB
|
|
|
02 - Merging inconsistent data with a transformation table.srt
|
SRT
|
7.6 KB
|
|
|
02 - Multiple tables.mp4
|
MP4
|
17.6 MB
|
|
|
02 - Multiple tables.srt
|
SRT
|
7.8 KB
|
|
|
02 - Nest IF and AND.mp4
|
MP4
|
8.7 MB
|
|
|
02 - Nest IF and AND.srt
|
SRT
|
4.1 KB
|
|
|
02 - Pivot and append data.mp4
|
MP4
|
11.6 MB
|
|
|
02 - Pivot and append data.srt
|
SRT
|
5.6 KB
|
|
|
02 - Query data from a table or range.mp4
|
MP4
|
9.3 MB
|
|
|
02 - Query data from a table or range.srt
|
SRT
|
4.7 KB
|
|
|
02 - Real-world challenge 1 Projects.mp4
|
MP4
|
15.3 MB
|
|
|
02 - Real-world challenge 1 Projects.srt
|
SRT
|
7.2 KB
|
|
|
02 - Split column by delimiter.mp4
|
MP4
|
16.2 MB
|
|
|
02 - Split column by delimiter.srt
|
SRT
|
7 KB
|
|
|
02 - Walk through all six joins.mp4
|
MP4
|
35.9 MB
|
|
|
02 - Walk through all six joins.srt
|
SRT
|
15.8 KB
|
|
|
02_01_Data Types.xlsx
|
XLSX
|
15 KB
|
|
|
02_02_Query from a Table or Range.xlsx
|
XLSX
|
12.5 KB
|
|
|
02_04_Connection Only.xlsx
|
XLSX
|
10.3 KB
|
|
|
03 - AddDays to determine the deadline.mp4
|
MP4
|
9.5 MB
|
|
|
03 - AddDays to determine the deadline.srt
|
SRT
|
4.3 KB
|
|
|
03 - Joins Left or right.mp4
|
MP4
|
6.8 MB
|
|
|
03 - Joins Left or right.srt
|
SRT
|
2.7 KB
|
|
|
03 - Pivot and don't aggregate.mp4
|
MP4
|
8.4 MB
|
|
|
03 - Pivot and don't aggregate.srt
|
SRT
|
4.2 KB
|
|
|
03 - Query data from a folder and import multiple files.mp4
|
MP4
|
21 MB
|
|
|
03 - Query data from a folder and import multiple files.srt
|
SRT
|
11.1 KB
|
|
|
03 - Query data from another Excel file.mp4
|
MP4
|
7.9 MB
|
|
|
03 - Query data from another Excel file.srt
|
SRT
|
4.2 KB
|
|
|
03 - Real-world challenge 2 Donors.mp4
|
MP4
|
16.7 MB
|
|
|
03 - Real-world challenge 2 Donors.srt
|
SRT
|
7.5 KB
|
|
|
03 - Split into rows.mp4
|
MP4
|
11.9 MB
|
|
|
03 - Split into rows.srt
|
SRT
|
5.5 KB
|
|
|
03_01_Fill Up Fill Down.xlsx
|
XLSX
|
14.1 KB
|
|
|
03_02_Import Survey Data.xlsx
|
XLSX
|
11.6 KB
|
|
|
03_02_Split by Delimiter.xlsx
|
XLSX
|
13.3 KB
|
|
|
03_03_Split into Rows.xlsx
|
XLSX
|
14.2 KB
|
|
|
03_04_Conditional and Custom Columns.xlsx
|
XLSX
|
12.8 KB
|
|
|
03_05_Column by Example.xlsx
|
XLSX
|
12.7 KB
|
|
|
03_06_Merging Columns.xlsx
|
XLSX
|
14.3 KB
|
|
|
03_07_Sort and Filter.xlsx
|
XLSX
|
13.7 KB
|
|
|
04 - Add conditional and custom columns.mp4
|
MP4
|
13.4 MB
|
|
|
04 - Add conditional and custom columns.srt
|
SRT
|
6.2 KB
|
|
|
04 - Append multiple sheets.mp4
|
MP4
|
14 MB
|
|
|
04 - Append multiple sheets.srt
|
SRT
|
5.9 KB
|
|
|
04 - Load data only as a connection.mp4
|
MP4
|
10.7 MB
|
|
|
04 - Load data only as a connection.srt
|
SRT
|
5.7 KB
|
|
|
04 - Outer join versus XLOOKUP.mp4
|
MP4
|
6.5 MB
|
|
|
04 - Outer join versus XLOOKUP.srt
|
SRT
|
3.4 KB
|
|
|
04 - Real-world challenge 3 Soccer team.mp4
|
MP4
|
19.2 MB
|
|
|
04 - Real-world challenge 3 Soccer team.srt
|
SRT
|
7.6 KB
|
|
|
04 - Unpivot data in Power Query.mp4
|
MP4
|
16.5 MB
|
|
|
04 - Unpivot data in Power Query.srt
|
SRT
|
7.3 KB
|
|
|
04_01_IF Formula.xlsx
|
XLSX
|
13.8 KB
|
|
|
04_02_Nested IF AND.xlsx
|
XLSX
|
13.8 KB
|
|
|
04_03_AddDays Function.xlsx
|
XLSX
|
13.6 KB
|
|
|
05 - Add column by example.mp4
|
MP4
|
24.9 MB
|
|
|
05 - Add column by example.srt
|
SRT
|
11.7 KB
|
|
|
05 - Merge with multiple fields.mp4
|
MP4
|
9.6 MB
|
|
|
05 - Merge with multiple fields.srt
|
SRT
|
4.5 KB
|
|
|
05 - Unpivot warnings.mp4
|
MP4
|
7.4 MB
|
|
|
05 - Unpivot warnings.srt
|
SRT
|
3.7 KB
|
|
|
05_01_Pivot.xlsx
|
XLSX
|
15.2 KB
|
|
|
05_02_Pivot and Append.xlsx
|
XLSX
|
19.8 KB
|
|
|
05_03_Pivot - Dont Aggregate.xlsx
|
XLSX
|
12.4 KB
|
|
|
05_04_Unpivot.xlsx
|
XLSX
|
16.5 KB
|
|
|
05_05_Unpivot - Warning.xlsx
|
XLSX
|
13.4 KB
|
|
|
06 - Approximate match equivalent of VLOOKUP Binning.mp4
|
MP4
|
14.6 MB
|
|
|
06 - Approximate match equivalent of VLOOKUP Binning.srt
|
SRT
|
6.1 KB
|
|
|
06 - Merge columns.mp4
|
MP4
|
8.8 MB
|
|
|
06 - Merge columns.srt
|
SRT
|
5.1 KB
|
|
|
06_01_Grouping.xlsx
|
XLSX
|
14.2 KB
|
|
|
07 - Approximate match equivalent of VLOOKUP Conditional column.mp4
|
MP4
|
7.2 MB
|
|
|
07 - Approximate match equivalent of VLOOKUP Conditional column.srt
|
SRT
|
3.7 KB
|
|
|
07 - Sort and filter data in Power Query.mp4
|
MP4
|
12.3 MB
|
|
|
07 - Sort and filter data in Power Query.srt
|
SRT
|
5.7 KB
|
|
|
07_01_Append.xlsx
|
XLSX
|
19.6 KB
|
|
|
07_02_Append Multiple Datasets.xlsx
|
XLSX
|
19.6 KB
|
|
|
07_04_Append Multiple Sheets.xlsx
|
XLSX
|
16 KB
|
|
|
08 - Cross Join.mp4
|
MP4
|
8.6 MB
|
|
|
08 - Cross Join.srt
|
SRT
|
4.2 KB
|
|
|
08_01_MidTerm Challenge.xlsx
|
XLSX
|
21.3 KB
|
|
|
09_02_Joins.xlsx
|
XLSX
|
12.6 KB
|
|
|
09_03_Joins - Left Right.xlsx
|
XLSX
|
16.2 KB
|
|
|
09_04_OuterJoin XLOOKUP.xlsx
|
XLSX
|
16.6 KB
|
|
|
09_05_Merge Multiple Fields.xlsx
|
XLSX
|
45.2 KB
|
|
|
09_06_Approximate Match by Binning.xlsx
|
XLSX
|
14.3 KB
|
|
|
09_07_Approximate Match by Conditional Formatting.xlsx
|
XLSX
|
14.3 KB
|
|
|
09_08_Cross Join.xlsx
|
XLSX
|
19.2 KB
|
|
|
10_01_Drill Down.xlsx
|
XLSX
|
28.4 KB
|
|
|
11_01_Fuzzy Matching.xlsx
|
XLSX
|
29.3 KB
|
|
|
11_02_Transformation Table.xlsx
|
XLSX
|
18.9 KB
|
|
|
12_02_PQ Challenge - Projects - Solution.xlsx
|
XLSX
|
34.8 KB
|
|
|
12_02_PQ Challenge - Projects.xlsx
|
XLSX
|
17.3 KB
|
|
|
12_03_PQ Challenge - Donors - Solution.xlsx
|
XLSX
|
35.2 KB
|
|
|
12_03_PQ Challenge - Donors.xlsx
|
XLSX
|
12.6 KB
|
|
|
12_04_PQ Challenge Soccer Team - Solution.xlsx
|
XLSX
|
125.9 KB
|
|
|
12_04_PQ Challenge Soccer Team.xlsx
|
XLSX
|
102 KB
|
|
|
Bonus Resources.txt
|
TXT
|
409.6 B
|
|
|
Get Bonus Downloads Here.url
|
URL
|
204.8 B
|
|
|
Levitation.xlsx
|
XLSX
|
9 KB
|
|
|
Magic as a Business.xlsx
|
XLSX
|
9.1 KB
|
|
|
Mentalism.xlsx
|
XLSX
|
9.8 KB
|
|
|
Street Magic.xlsx
|
XLSX
|
9 KB
|
|
|
Working in Las Vegas.xlsx
|
XLSX
|
9 KB
|
