30-days Money-Back Guarantee
What is a PowerPivot and how to install it, how to import data from different sources like Excel, CSV Files, Text files
Updated on Sep, 2026
Office Productivity, Microsoft,
Duration - 9.5 hours
Training 5 or more people ?
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
This course is educating students about PowerPivot & DAX - if you are working on Data and want to come out of data size barriers.
Students will be able to do any type of analysis on small, medium, or Big data using PowerPivot.
You will learn how to write Measures and Calculated Columns
You will learn the DAX formula as well. See the Curriculum to know what exactly we are covering.
You will understand the difference between Measure and Calculate Column - Which one better and Why?
Learn SUM, COUNT, COUNTA, COUNTBLANK, CALCULATE, ALL, ALL EXCEPT, ALL SELECTED
Every topic is discussed from the very beginning to advanced levels. Exercises are also discussed to see their practical use.
Basics of Excel with functions knowledge can be an added advantage.
You should know Old Excel Pivot.
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.