What do you want to learn today?

PowerPivot Fundamentals

ENDED
Training by  NYIM Training
Inquire Now
On-Site / Training

Details

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.

Outline

1). Why PowerPivot?
2). Benefits of PowerPivot
3). Installing PowerPivot
4). Overview of PowerPivot Ribbon
5). Working with different data sources
6). Importing Data
7). Creating Relationships
8). Linking Tables
9). Calculated Columns

10). Difference between Excel's Compact Pivot Tables and Power Pivot's Flat File Tables
11). Using Slicers
12). Creating 4 or more related pivot tables
13). Available functions and their power
14). Advanced Filtering
15). Asymmetrical Reports
16). Other PowerPivot capabilities

Reviews
Be the first to write a review about this course.
Write a Review

We have been training the college professors and IT department heads at all the State University of New York City Colleges and Institutions, along with corporations and individuals, for many years. Call or email us to experience what good computer training in New York City is all about. We have hundreds of satisfied clients who are willing to provide referrals. We would like to make you one of those clients.

We offer both customized Corporate Training and Group Classes. Since 1998, we have trained thousands in the New York Metro area, along with hundreds of international clients. We are serious about delivering the most practical, focused computer training around New York and beyond.

Why is NYIM the Highest Rated Excel Training in NYC?

  • The most practical and hands-on training
  • State-of-the-art curriculum refined by industry experts
  • Interactive lessons taught by world-class instructors
  • Personalized attention in small classroom sizes
  • Revolutionary video suite with premium content (selected courses)
  • Custom in-depth manuals and shortcut sheets

For more information about individual or corporate training, please contact us at (212) 658-1918 or [email protected].
Sending Message
Please wait...
× × Speedycourse.com uses cookies to deliver our services. By continuing to use the site, you are agreeing to our use of cookies, Privacy Policy, and our Terms & Conditions.