Curriculum
Course:
Excel Power Query and PowerPivot
Login
Curriculum
Excel Power Query and PowerPivot
Introduction (Fundamentals of Pivot Tables in Excel)
0/6
Normal Pivot Table Formulas
10 mins
Preview
Sorting and Filtering the Pivot Table
1 min
Calculated Items
3 mins
Calculated Fields
3 mins
Conditional Formatting in the Pivot Table
2 mins
Consolidated Pivot Tables
4 mins
Body (Power Query – Data Import, Cleaning & Transformation)
0/12
Importing data from Excel into Power Query – normal data
9 mins
Importing data from Excel into Power Query – formatted tables
4 mins
Importing data from Access, SQL Server, and text files into Power Query
6 mins
Importing data from a website into the Power Query
4 mins
Splitting and Merging Columns in Power Query
5 mins
Calculate age in Power Query
3 mins
Adding Custom Calculations in Power Query
5 mins
More Calculations including a conditional column in Power Query
9 mins
Append Queries
2 mins
Group By Queries
4 mins
Merge Queries
4 mins
Refreshing the data in Power Query
2 mins
Conclusion (Power Pivot – Data Modeling, Relationships & Advanced Analytics)
0/8
Activating PowerPivot
3 mins
Exploring the PowerPivot menus
4 mins
Starting the Pivot Table from PowerPivot
5 mins
Managing Table Relationships
9 mins
Slicers and Timelines in PowerPivot
5 mins
Using Sets in PowerPivot
4 mins
Importing Data directly into PowerPivot
4 mins
Measures and KPIs in PowerPivot
10 mins
Video lesson
Normal Pivot Table Formulas
Sign In
The password must have a minimum of 8 characters of numbers and letters, contain at least 1 capital letter
Remember me
Sign In
Sign Up
Restore password
Send reset link
Password reset link sent
to your email
Close
No account?
Sign Up
Sign In
Lost Password?
Scroll to Top