All classes are taught LIVE by seasoned instructors. * 9.6 of 10 (over 22 k student survey results - 2023)

Find A Class in Your City:


Microsoft Power Pivot training class

Email this page | Print this page
 

Microsoft Power Pivot

 

To View Class Dates: Please use the pull-down options on the upper left of this page to select your course and city. You can then navigate to other classes in that same city, view class descriptions and register for the class or you call us and register now, 877-760-0078.

 


All instructor-led classes on our public schedule will be LIVE ONLINE.  Same trainers, same outlines and small classes (5 or less).

Want an in-person class? We can have one of our trainers come to your office for 1on1 or group training. For a quote, call 877 760 0078, email us at info@sonictraining.com or request a quote.

Popular Collaborative Software Training Classes



 

To View Class Dates: Please use the pull down options on the upper left of this page to select your course and city. You can then navigate to other classes in that same city, view class descriptions and register for the class or you call us and register now, 877-760-0078.

  • Want Power Pivot training at your company site? (group or 1on1) -- click here.
  • We have taught thousands of business professionals throughout the years. Read what our students say
  • Free repeats! You are allowed to repeat your class for free within 6 months for any reason whatsoever! Classes are 9am to 4pm and come with courseware  to practice afterward.
  • Are you signing up for more MS Office classes? See our package discounts page
  •  

Excel Training

 


 

 

Data Analysis with Power Pivot

 

Course Description

 

Overview:

We are now living in the age of big data. Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyze large amounts of data quickly. Fortunately, Microsoft® Excel® provides Power Pivot to help you organize, manipulate, and report on your data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analyzing data.

 

Course Objectives:

Upon successful completion of this course, you will be able to use Power Pivot along with Excel to analyze data from a variety of sources.

You will:

  • Get started with Power Pivot.
  • Visualize Power Pivot data.
  • Work with advanced functionality in Power Pivot.

Target Student:

Students taking this course are experienced Excel users who are seeking to advance their data-analysis capabilities by using Power Pivot.

Prerequisites:

To ensure your success in this course, you should have experience working with Excel and PivotTables. You should already understand spreadsheet concepts and be comfortable creating and analyzing basic PivotTables.

 

Course Content

 

Lesson 1: Getting Started with Power Pivot

Topic A: Enable and Navigate Power Pivot

Topic B: Manage Data Relationships

 

Lesson 2: Visualizing Power Pivot Data

Topic A: Create a Power Pivot Report

Topic B: Create Calculations in Power Pivot

 

Lesson 3: Working with Advanced Functionality in Power Pivot

Topic A: Create a KPI

Topic B: Work with Dates and Time in Power Pivot

 

Appendix A: Commonly Used DAX Functions