Close
You are not logged in
Close
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)

GIFT CERTIFICATES AVAILABLE

Current Sales Packages

Close
185 Madison Ave, 11th Floor, New York, NY 10016 212.658.1918

Pivot Tables & PowerPivot

$299

SessionPriceSeatsLocation
Jun 27: 10:00am–5:00pm$2998185 Madison Avenue, NYC
Aug 3: 10:00am–5:00pm$29910185 Madison Avenue, NYC

Call 212.658.1918 or email us

Pivot Tables & PowerPivot Classes New York City

The Premier Excel Course Focused on Pivot Tables & PowerPivot

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.

PowerPivot Course Outline

PowerPivot Course PDF 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