You are not logged in
This Month Specials

Special Promotion

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

PowerPivot Fundamentals $199 (Normally $299)

$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)


Current Sales Packages

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

PowerPivot Fundamentals


Feb 22: 10:00am–2:00pm$199FullMichael M.1 Union Square W, NYC
Apr 2: 10:00am–5:00pm$19910TBD185 Madison Avenue, NYC
May 11: 10:00am–5:00pm$19910TBD185 Madison Avenue, NYC
Jun 27: 10:00am–5:00pm$19910TBD185 Madison Avenue, NYC
Aug 3: 10:00am–5:00pm$19910TBD185 Madison Avenue, NYC

CALL 212.658.1918 OR EMAIL US

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

Class Perks

  • Practical and hands-on training classes
  • Proprietary curriculum refined by industry experts
  • Interactive courses taught by engaging instructors
  • Revolutionary video suite with premium content
  • Personalized attention in small class sizes


  • 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 2018

Client Testimonials