Levi, Ray & Shoup, Inc.
  • Courses
  • Site Content

APPWRPVT - Microsoft Excel 2010: PowerPivot

You will make use of the PowerPivot add-in to import data from various sources and create a dynamic report.

Click here to print this page »

Prerequisites


To ensure your success, we recommend you first take one of the following courses or have equivalent knowledge: Microsoft® Excel® 2010: Level 1, Microsoft® Excel® 2010: Level 2, and Microsoft® Excel® 2010: Level 3.

Detailed Class Syllabus


Lesson 1: Getting Started with PowerPivot


Topic 1A: Explore the PowerPivot Application
Topic 1B: Import Data from Various Data Sources
Topic 1C: Refresh Data from a Data Source
Topic 1D: Create Linked Tables

Lesson 2: Manipulating PowerPivot Data


Topic 2A: Organize and Format Tables
Topic 2B: Create Calculated Columns
Topic 2C: Sort and Filter PowerPivot Data
Topic 2D: Create and Manage Table Relationships

Lesson 3: Creating PowerPivot Reports


Topic 3A: Create a PivotTable
Topic 3B: Create PivotCharts
Topic 3C: Filter Data Using Slicers
Topic 3D: Present PivotTable Data Visually

Lesson 4: Using DAX Functions in PowerPivot


Topic 4A: Manipulate PowerPivot Data Using DAX Functions
Topic 4B: Extract Data from Tables Using Functions
Topic 4C: Work with Time Dependent Data

Lesson 5: Distributing PowerPivot Data


Topic 5A: Protect Reports
Topic 5B: Save Reports in Different File Formats