Learn to master Power Pivot for Excel from your chair with our high quality video course.
This video course is divided in three parts: the first one (Beginner) introduces Power Pivot to any user who knows Excel and want to create reports with more complex and large data structures than a single table made by few thousand rows. The Beginner section is completely available in the free trial, you are just one click away to start.
The second part of the course (Intermediate) improves your skills on Power Pivot for Excel, introducing you to the DAX language and important features such as CALCULATE and Time Intelligence functions.
The last part (Advanced) enables you to master Power Pivot for Excel. You will understand DAX in depth, which is required for writing complex calculations. You will also learn how to create complex reports and data models by leveraging advanced features of both Excel and Power Pivot.
Power Pivot is available in both Excel 2010 and Excel 2013, and it is the center of Power BI, the Microsoft offer for self-service analytics. You do not need any previous experience in Power Pivot to take this course.
The course includes almost 10 hours of video in 73 lectures.
This was a well-outlined class. I look forward to finishing the definitive guide. I love Marco's teaching style and I look forward to more interaction. Worth the money and time
Kenneth Barber(Dec 4, 2019)
This course has aged surprisingly well. However, some parts of this course are no longer relevant. SQLBI's Mastering DAX course largely supersedes this course, and I would recommend that most people take Mastering DAX instead.
Marshall Joubert(Jun 17, 2019)
Despite covering a previous version of Excel, the material was still relevant.