30-days Money-Back Guarantee
This step-by-step online course will help you learn power pivot from beginning to Excel
Updated on Sep, 2026
Office Productivity, Microsoft, Pivot Tables Data Analysis
Training 5 or more people ?
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
This is PowerPivot with DAX Part 2 and it is in continuation to part 1. This course will make you superb in PowerPivot DAX Language.
This course will give you insight into the importance of DAX in PowerPivot and how it has no comparison with old traditional pivots.
You will learn HASONEVALUE Dax
You will learn IF statements - Basic to advance
How to use SWITCH Dax - Which one is better - IF or SWITCH
How to use IF as a calculated column and as a measure and which option is best or should you use when.
TOPN Dax for calculating the TOP entries from different date ranges
How to customize the pivot field calculations with grand totals and sub-totals
In section2 learn about Time Intelligence DAX functions from scratch.
Practical examples in day-to-day life also have been explained.
Learn what is DAX Studio
How to download it and how to launch it in power pivot
Do we really need DAX Studio and for what purposes it can be used.
Another amazing DAX - Summarize with practical examples.
What is implicit and Explicit measures
Which one is better and why - Implicit or Explicit
You should have seen this course Part1 as this is in continuation to the previous one.
You should be familiar with PowerPivot DAX language as this course is not intended for those who lacks knowledge of power pivot.
You should have Excel 2013 or afterwards versions which supports powerpivot.
Check out the detailed breakdown of what’s inside the course
I have been teaching online from 13 years now and teaching is my hobby and passion. I cannot think of anything better than teaching and shaping up students career. Enroll today and take your knowledge to the next level. My training content is my proud and you will not be disappointed. I teach advance Excel, Excel VBA, MS Access, Access VBA, PowerQuery, M code in Powerquery, PowerPivot,DAX Formulas,Power BI and WebScraping using html libraries in VBA.
Use your certificate to make a career change or to advance in your current career.
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Master prominent technologies at full length and become a valued certified professional.