Are you sick of waiting for the IT department to extract data from your systems?
Do you spend too much time flattening your data tables into one with VLOOKUP just so you can use it in a Pivot Table report?
Are you frustrated that Excel can’t handle more data?
Power Pivot for Excel fixes all that.
Power Pivot transforms Excel from a day to day spreadsheet to a commanding BI tool able to consume an All You Can Eat Data Buffet right from the comfort of your desk. No donut bribery for the IT department required to rush through your report or data request 🙂
It’s exciting, it’s ground breaking and you’ll never look back.
In my Power Pivot for Excel course I’ll teach you how you can use the free Power Pivot Excel add-in to perform powerful data analysis right from within Excel 2010 onward, bringing self-service business intelligence to your desktop.
Don't know Pivot Tables?
Get up to speed with my PivotTable Quick Start course (as an optional extra), so you can master Pivot Tables too.
Big Data on your Desktop
Leveraging “big data” in your business might be crunching sales patterns to plan inventory levels, cutting staff expenses by analysing employee overtime and rearranging work schedules or using social media data to gauge what customers think about your business and competitors.
Power Pivot for Excel enables you to transform enormous quantities of data with incredible speed into meaningful information to get the answers you need in seconds, all with the comfort of familiar Excel tools and features.
- Import millions of rows of data from virtually any source including relational databases, data feeds, Reporting Services, text files, multidimensional sources, cloud services, data feeds, Excel files, and data from the Web into a single Excel workbook,
- Create relationships between the different sources just like Access.
- Build interactive reports with PivotTables, PivotCharts and Slicers, and then further analyze the data so that you can make timely business decisions.
- Power Pivot calculations and analysis are extremely fast. You can process millions of rows in about the same time as thousands.
- Data Analysis Expressions (DAX) is a new formula language that extends the data manipulation capabilities of Excel to enable more sophisticated and complex grouping, calculation, and analysis like never before.
- The DAX formula language is very similar to that of Excel formulas.
All without requiring IT assistance.
Note: even if IT guard the data like their life depends on it, once they hand over the 'data goods' you can load it into Power Pivot and it's yours forever. Each month/week/day you just need to get the new data and import it to your Power Pivot model where you can analyse it to your heart's desire. Shhh, don't tell IT you're secretly harvesting their data for your own use... that's just between you, me and Power Pivot 😉
Sneak Peek of Power Pivot
For best viewing quality: press play then 1. click the cog and select 720p HD, and 2. click the icon on the bottom right of the video to view in full screen. | ![]() |
What you get in the Power Pivot for Excel Course
- Hands on Project Based Learning – We build a Power Pivot model together from start to finish. The course follows a progressive path with each video teaching a technique or step which you then perform using the data provided in the course. So, at every stage you are practicing what you learn which helps retain knowledge and build confidence.
- Download the completed Excel Power Pivot files created during filming and use them as a reference tool that you can go back to later on to refresh your memory.
- The training is delivered online and tutorials are available to watch 24/7 at your own pace. Pause, rewind, replay as many times as you like.
- 5.5 hours of video tutorials covering everything from installing Power Pivot, importing data, DAX formulas, PivotTables and more.
- Accessibility Features: The course includes English subtitles and a fully searchable transcript, making it easier to follow along and quickly find specific topics or instructions.
- Compatible with Excel 2016, 2019, 2021, 2024 and Microsoft 365 - so no matter what version of Excel you have, you can follow along.
- The pace is pretty fast because I hate courses that waffle on. I like to get straight to the point so you’re up to speed fast, and I’ve designed it so that if you need to re-watch anything you can rewind and replay the videos as many times as you like.
- The average video length is 4 ½ minutes! Fit it in during a coffee break, on the train or bus to work, at the airport, or anywhere you have a spare 5 minutes and an internet connection.
- 12 months access to the video tutorials and file downloads. There’s even a download option where you can download all videos in the course and keep them on your own PC forever.
- When you’ve finished I’ll send you a ‘Certificate of Completion’ saying you’ve completed the course which you can add to your resume/CV arsenal.
- BONUS e-Book: Learn to Write DAX by Matt Allington. This book extends your hands-on practice. Inside you will find explanation of concepts, sample exercises and then practice questions and answers to maximize learning retention and experience. The e-book is delivered via email 31 days after joining the course.
Prerequisites:
- Have access to Excel 2010 or Excel 2013/2016 Office Professional Plus, Office 2016 Professional, any version of Excel 2019, 2021 or Office 365, or the standalone edition of Excel 2013/2016. Click here for the full list.
- Pivot Table and Pivot Chart knowledge is helpful, but expertise is not necessary to take this course.
If you think you need to brush up on your PivotTable skills first you can add my PivotTable Quick Start course to your bundle. Click here to find out more about my PivotTable Quick Start course.
- Mac users: Power Pivot won’t run on a Mac, sorry 🙁 You can install Windows on Mac using Parallels, Boot Camp or VMWare Fusion and then install Power Pivot on a PC version of Excel (see first point above) running under a VM.
- Sharing Power Pivot Excel files: Office 365 users can share Excel files under 10MB via Excel Online with others. Excel Online supports Slicers and modifying Power Pivot PivotTables, but not the creation of Power Pivot PivotTables. Excel Online is a great option for users who wish to view Power Pivot reports but don't have a version of the Excel Desktop App that contains Power Pivot.
Learn with Support from a Recognized Expert
Your instructor, Mynda Treacy, has been a Microsoft MVP for over 10 years, and is Co-founder of My Online Training Hub. With more than 25 years of experience, she’s helped thousands of professionals transform their Excel & Power BI skills.
When you enroll in her Power Pivot and DAX Course, you’re not just getting high-quality tutorials - you’re also gaining access to Mynda Treacy’s personalized support and mentorship.
As a seasoned Excel trainer, Mynda is passionate about helping students succeed. Throughout the course, you’ll have opportunities to:
- Ask Questions: Get answers to your Excel challenges directly from Mynda.
- Receive Expert Feedback: Gain insights and tips to refine your skills and problem-solving approach.
- Be Part of a Learning Community: Join like-minded professionals and learn through shared experiences and discussions.
This isn’t just a course — it’s a learning journey with a trusted mentor by your side. Mynda’s guidance ensures you’re never stuck or unsure of how to move forward.
And with her streamlined teaching methods, you’ll gain advanced Excel skills faster than you ever thought possible.
Choose Your Course
Tip: The courses below (Power Pivot and DAX and the Power Query course) complement each other. Automate data gathering and cleaning with Power Query and load to Power Pivot. Get them both and get 20% off*. *Not available with any other offers.
- Online Only : 12 months online access to the course(s)
- Online + Download : 12 months online access to the course(s) + download the course videos to keep
- GST : Prices are shown exclusive of GST for Australian customers.
Power Pivot and DAX : Online
Original price was: USD $169.USD $135Current price is: USD $135.Add to cart
Original price was: USD $169.USD $135Current price is: USD $135.Add to cart
12 Months Online
Online Only Access To Course
Power Pivot and DAX Videos
5hrs 23min
One Payment for 12 Months Access
Unlimited 24/7 access
Pause, rewind, replay
Download Workbooks and Practice Data
30 Day Money Back Guarantee
Power Pivot and DAX : Download
Original price was: USD $339.USD $271Current price is: USD $271.Add to cart
Original price was: USD $339.USD $271Current price is: USD $271.Add to cart
12 Months Online + Download
Online Access + Download & Keep Course Videos
Power Pivot and DAX Videos
5hrs 23min
One Payment for 12 Months Access
Unlimited 24/7 access
Pause, rewind, replay
Download Workbooks and Practice Data
30 Day Money Back Guarantee
Power Query : Online
Original price was: USD $149.USD $119Current price is: USD $119.Add to cart
Original price was: USD $149.USD $119Current price is: USD $119.Add to cart
12 Months Online
Online Only Access To Course
Power Query Videos
5hrs 30min
One Payment for 12 Months Access
Unlimited 24/7 access
Pause, rewind, replay
Download Workbooks and Practice Data
30 Day Money Back Guarantee
Power Query : Download
Original price was: USD $298.USD $238Current price is: USD $238.Add to cart
Original price was: USD $298.USD $238Current price is: USD $238.Add to cart
12 Months Online + Download
Online Access + Download & Keep Course Videos
Power Query Videos
5hrs 30min
One Payment for 12 Months Access
Unlimited 24/7 access
Pause, rewind, replay
Download Workbooks and Practice Data
30 Day Money Back Guarantee
Notes
- Videos will be available for download after the 30 day Money Back Guarantee period ends. You can watch the videos online in the meantime.
- Membership and access to the training materials is for one person only. Logons are not to be used by multiple people.
- Downloaded videos are to be used only by the registered member, they are not to be transferred/shared amongst other people.
- You can request a refund provided that no more than 30% of the course videos have been watched.
Added to Cart