01 - Make your data useful with Power Query.mp4 (3.38 MB)
MP4
01 - Power Query example.mp4 (24.89 MB)
MP4
02 - Differences between Excel and Power Query.mp4 (23.55 MB)
MP4
01 - Data types explained.mp4 (17.93 MB)
MP4
02 - Query data from a table or range.mp4 (9.28 MB)
MP4
03 - Query data from another Excel file.mp4 (7.87 MB)
MP4
04 - Load data only as a connection.mp4 (10.75 MB)
MP4
01 - Fill up and fill down.mp4 (11.06 MB)
MP4
02 - Split column by delimiter.mp4 (16.17 MB)
MP4
03 - Split into rows.mp4 (11.87 MB)
MP4
04 - Add conditional and custom columns.mp4 (13.42 MB)
MP4
05 - Add column by example.mp4 (24.94 MB)
MP4
06 - Merge columns.mp4 (8.82 MB)
MP4
07 - Sort and filter data in Power Query.mp4 (12.35 MB)
MP4
01 - Use IF formulas.mp4 (7.06 MB)
MP4
02 - Nest IF and AND.mp4 (8.7 MB)
MP4
03 - AddDays to determine the deadline.mp4 (9.55 MB)
MP4
01 - Pivot data in Power Query.mp4 (7.16 MB)
MP4
02 - Pivot and append data.mp4 (11.57 MB)
MP4
03 - Pivot and don't aggregate.mp4 (8.36 MB)
MP4
04 - Unpivot data in Power Query.mp4 (16.46 MB)
MP4
05 - Unpivot warnings.mp4 (7.4 MB)
MP4
01 - Group By feature.mp4 (14.43 MB)
MP4
01 - Two data sets.mp4 (7.9 MB)
MP4
02 - Multiple tables.mp4 (17.58 MB)
MP4
03 - Query data from a folder and import multiple files.mp4 (21.01 MB)
MP4
04 - Append multiple sheets.mp4 (14.03 MB)
MP4
01 - Midterm challenge Get a count of all colors.mp4 (19 MB)
MP4
01 - Overview of joins in Power Query.mp4 (9.5 MB)
MP4
02 - Walk through all six joins.mp4 (35.86 MB)
MP4
03 - Joins Left or right.mp4 (6.77 MB)
MP4
04 - Outer join versus XLOOKUP.mp4 (6.46 MB)
MP4
05 - Merge with multiple fields.mp4 (9.58 MB)
MP4
06 - Approximate match equivalent of VLOOKUP Binning.mp4 (14.57 MB)
MP4
07 - Approximate match equivalent of VLOOKUP Conditional column.mp4 (7.23 MB)
MP4
08 - Cross Join.mp4 (8.57 MB)
MP4
01 - Drill down to create a variable in Power Query.mp4 (18.82 MB)
MP4
01 - Fuzzy matching by percentage.mp4 (24.48 MB)
MP4
02 - Merging inconsistent data with a transformation table.mp4 (16.46 MB)
MP4
01 - Challenge setup.mp4 (4.46 MB)
MP4
02 - Real-world challenge 1 Projects.mp4 (15.31 MB)
MP4
03 - Real-world challenge 2 Donors.mp4 (16.73 MB)
MP4
04 - Real-world challenge 3 Soccer team.mp4 (19.17 MB)
MP4
01 - Next steps.mp4 (4.14 MB)
MP4