Power Pivot, Power Query & DAX in Excel

Analyze data at scale with these advanced Excel functions.

In this advanced Excel course, we look at three crucial advanced Excel features Power Pivot, Power Query, and DAX.

This suite of Excel functions allows you to manipulate, analyze, and evaluate millions of rows of data from Excel or other databases.

We first look at how to bring your data together, merge, and clean it using Power Query before moving onto creating relationships between our data tables and building out a data model. We then look at performing calculations on our data model using DAX, and finally, we look at displaying our analysis using PivotTables and PivotCharts.

If you’ve reached a point where you need Excel to work with data at scale, then these tools will unlock that capability.

This course also includes practice exercises and follow-along files so you can build your data models as we go.

In this course you will learn:

  • How to get started with Power Query
  • How to connect Excel to multiple workbooks
  • How to get data from the web and other sources
  • How to merge and append queries using Power Query
  • How the Power Pivot window works
  • How to set up and manage relationships in a data model
  • How to create a PivotTable to display your data from the Power Pivot data model
  • How to add calculated columns using DAX
  • How to use functions such as CALCULATE, DIVIDE, DATESYTD in DAX
  • All about creating Pivot Charts and PivotTables and using your data model
  • How to use slicers to adjust the data you display

Course Format

  • This is a video-led course. You can preview some videos below.
  • This course includes practice exercises.
  • This course is aimed at PC Excel users.

Course Certificate Included

This course includes an optional online quiz that will generate a course certificate upon completion.

30-Day Guarantee

We offer an unconditional, 30-day, full money-back guarantee, no questions asked. This is our way of ensuring you have complete confidence in your Stream Skill purchase. If you don’t learn, you don’t pay.

Why Trust Us?

Stream Skill is part of the Simon Sez IT family and has been in business 10+ years and taught over 500,000 students in that time. We’ve created over 100 software training courses, 5,000+ video tutorials, and we’ve helped thousands of people across the world learn how to use Microsoft Office. We’ve now created Microsoft Excel courses for the last five versions and continue to help people get to grips with this essential tool.


Your Instructor


Simon Sez IT
Simon Sez IT

The “IT" in Simon Sez IT stands for “Information Technology." We offer instruction to help learners win when it comes to computer and software technology. Learning software skills in an easy, self-paced way for an affordable price is what Simon Sez IT is all about.

The company was founded in 2008 by Chris “Simon" Calder, Director of IT operations for one of Los Angeles' most prestigious institutions. In this role, Simon saw the need for low-stress software training for hundreds of employees in his company who were facing technological upgrades at work. That's how the idea of Simon Sez IT was born.

Since then, Simon Sez IT has built a rapid and loyal following. At a time when many companies were struggling to survive, Simon Sez IT thrived—providing accessible, low-cost computer and software training to people of all ages, regardless of their computer experience. In our first four years alone, we serviced tens of thousands of satisfied customers in over 180 countries.


Course Curriculum



Frequently Asked Questions


What if I am unhappy with the course?
If you are unsatisfied with your purchase, contact us in the first 30 days and we will give you a prompt and full refund.
How long do I have access to the course?
After purchasing a course, you have unlimited access to this course for as long as you like - across any and all devices you own. Active memberships have access to all courses while they membership is active.
When does the course start and finish?
The course starts now and never ends! It is a completely self-paced online course - you decide when you start and when you finish.
Will your videos work with iPhone, iPads, and Android devices?
All of our courses are compatible with iPhones and iPads and most Android devices. If you are looking to confirm that it works for you, feel free to view the free preview videos offered for each course.
Will your videos work with Mac computers?
All of our courses are compatible with both Windows (PC) and Mac computers
What if I have questions or problems while I am watching my tutorial?
Should you have any problems using the system, we offer free technical support to customers. Just send an email to [email protected] and we will respond promptly.
Do you offer Certificates of Completion?
We offer 2 types of Certificate. The first applies to all courses and is awarded on completing 100% of the course. The second is for courses that include an online quiz (currently over 80% of our courses). The Certificates of Completion are offered as part of the online test/quiz, which accompanies the course. You will need a passing grade of 70% in order to receive a Certificate. The quizzes are based solely on course content.
Do you offer a subscription option?
Yes, we offer a monthly or annual membership. Any monthly or annual subscription includes unlimited access to all StreamSkill.com courses including new courses released while your subscription is active. Click here http://streamskill.com/course/streamskill-membership/ to get additional details about the Ultimate Training Library membership.
Do you provide any group discounts?
Yes, we offer group discounts or multiple users. Contact [email protected] for more information.
Do you offer discounts for non-profits or educational institutions?
Yes, we offer 20% off discounts to non-profit, educational, and government agencies. Contact [email protected] for more information.
Can I interact with others who are taking the same course?
Yes, you can interact with others by using the discussion section offered for each course.
How long have you been in business?
We started our company in 2008 with our first course for Excel 2007. Since that time, our company has published over 80 courses, with tens of thousands of satisfied customers in over 180 countries.

Get started now!