This 1-day instructor-led course teaches you to use PowerPivot in Microsoft Excel 365 to analyze and report on large, complex data sets. You learn how PowerPivot is structured and how it works, how to navigate its interface, how to manipulate data using key PowerPivot techniques, how to build reports, how to write and structure DAX functions, and how to distribute your PowerPivot output to others.
Through hands-on exercises, you develop the skills to perform data analysis that goes beyond what standard Excel pivot tables allow. Experience with Excel PivotTables is recommended before taking this course.
