Curriculum
3 Sections
17 Lessons
1 Hour
Expand all sections
Collapse all sections
Introduction
7
2.1
Introduction
1 Minute
2.2
Instructor’s Background
2 Minutes
2.3
Background – Data Transformation Challenges
2 Minutes
2.4
Power Query to the Help!
2 Minutes
2.5
Purpose of this course!
1 Minute
2.6
Quiz 1
10 Minutes
8 Questions
2.7
Quiz 2
10 Minutes
5 Questions
Power Query - from Basic to Advanced
9
3.1
Power Query – the first taste!
5 Minutes
3.2
Intermediate functions in Power Query – An Intro
1 Minute
3.3
Intermediate: 6 essential functions from Power Query (Part 1)
11 Minutes
3.4
Intermediate: 6 essential functions from Power Query (Part 2)
10 Minutes
3.5
Advanced functions in Power Query – An Intro
5 Minutes
3.6
Advanced – Stop dragging 12 month’s data 12 times!
5 Minutes
3.7
Advanced – VLOOKUP() no more!
5 Minutes
3.8
Advanced – Artificial Intelligence in Power Query!
5 Minutes
3.9
Advanced – Finally the Instant Consolidation in Excel!
8 Minutes
Conclusion
3
4.1
Takeaways
1 Minute
4.2
Segue to the next Course and Q&A
1 Minute
4.3
Course Reference Sheets
10 Minutes
Power Query – The Ultimate Data Transformation Program
Search
This content is protected, please
login
and enroll in the course to view this content!
Login with your site account
Lost your password?
Remember Me
Not a member yet?
Register now
Register a new account
Are you a member?
Login now
Modal title
Main Content