close
You are not logged in
close
This Month Specials
 

Special Promotion

$199 PowerPoint for Business Blowout! (Normally $299/ea)

PowerPivot Fundamentals Level 5a $199 (Normally $299)

15% off all Web Design Classes

$199 QuickBooks Level 1 or Level 2 for PC, Mac, or Online Classes (Normally $299/ea)

Now $545-Excel Power Programming with VBA (Normally $659)

Now $649-Photoshop Essentials 2 Day Course (Normally $749)

(book before 12/31/16)

GIFT CERTIFICATES AVAILABLE

Current Sales Packages

close
1 Union Square West, Suite 805, NY, NY 212.658.1918

PowerPivot Fundamentals

Excel 2010 Training Class Logo

This PowerPivot group class concentrates on how to create powerful pivot tables through multiple table relationships. By the end of the Excel PowerPivot training course, you will feel confident setting up relationships, creating and displaying complex PivotTables and using Calculated DAX columns. This class is perfect for those that have a fundamental understanding of Excel and using Excel Pivot tables and want to see more correlation between data. Those in the financial, real-estate or data analysis field will especially find this class enjoyable.

 

 

Call 212.658.1918 or Email us

 

 

Materials

  • Custom Printed Manual
  • Multiple XLS and XLT examples for in class and after class
  • Shortcut sheets
  • After class resources

Course Outline

Why PowerPivot?
Benefits of PowerPivot
Installing PowerPivot
Overview of PowerPivot Ribbon
Working with different data sources
Importing Data
Creating Relationships
Linking Tables
Calculated Columns

Difference between Excel's Compact Pivot Tables and Power Pivot's Flat File Tables
Using Slicers
Creating 4 or more related pivot tables
Available functions and their power
Advanced Filtering
Asymmetrical Reports
Other PowerPivot capabilities

 

© NYIM Training 2017

Client Testimonials