Learn Excel Now

Conquer the Fear of Excel

  • Home
  • Training
    • Excel
    • MS Office
    • Outlook
    • PowerPoint
    • Word
    • OneDrive
    • Google
  • All-Access
  • eLearning
    • Excel Foundations
    • Micro Courses
      • Simply Excel
  • Resources
  • Login

Excel Power Pivot Course: Online & Instructor-led with Labs

Price: $
Share

Summary

Using more than one data set, as well as massive data sets, in Pivot Tables is cumbersome and often limits your ability to read the data. Using more than one data set, as well as massive data sets, in Pivot Tables is cumbersome and often limits your ability to read the data.

Starting with version 2010, Excel introduced a solution to this issue - the PowerPivot Tool. This tool allows you to analyze more than one dataset at a time and scale your data. PowerPivot allows you to provide "query" based pivot tables for related datasets.

No VLookUps, no cutting and pasting - using PowerPivot allows you to do more in less time and massive datasets understandable. Add the power of PowerView and Get&Transorm and you can turn Excel into a powerhouse solution for big data.

In this online course with Excel demonstration, you will learn how to use PowerPivot effectively.


After attending, you will be able to:

  • Determine what datasets are appropriate for PowerPivot
  • Work with PowerPivot in Excel and in the PowerPivot window
  • Perform calculation using PowerPivot data
  • Understand the difference between appending data & relating data
  • Scale your reports based on PowerPivot data

Program Highlights

Excel PowerPivot: Essential Must-Know Concepts for Your Success

  • When you should use PowerPivot: Appropriate datasets
  • Know the PowerPivot terminology by the version of Excel you have
  • The difference between appending data and relating data
  • How to avoid upgrade issues when moving to a different version of Excel

Putting Excel PowerPivot to Use: Practical Guidance on What You Can Do

  • Demo on using PowerPivot in Excel & in the PowerPivot window
  • How you can perform calculations using PowerPivot
  • What measures are and how to create them
  • How reports based on PowerPivot data scale

About The Speaker

Melissa Esquibel is a technology consultant, coach, trainer and speaker.

  • She is a consultant, frequent speaker and Microsoft Certified Trainer
  • Since 1991, Ms. Esquibel has assisted a variety of companies and industries with Microsoft Office (Excel, Word, PowerPoint, Access, Outlook) all versions through 2016.
  • Melissa has 25+ years experience in information technology with a background in training, technical writing and business risk analysis

Program Benefits

This 90-minute, online training will give you the skills and knowledge necessary to effectively use Excel PowerPivot to do more with your data.

Credits

NASBA logo
Credit Hours:
Field of Study:
Program Level:
Basic Knowledge
Prerequisites:
None
Advance Prep:
Delivery Method:
Group Internet Based
Progressive Business Conferences is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org

Purchase This On-Demand Webinar

Excel Power Pivot Course: Online & Instructor-led with Labs

Format: On-Demand Webinar
Price: $199 + applicable taxes Buy Now

Purchase This On-Demand Webinar

Excel Power Pivot Course: Online & Instructor-led with Labs

Format: On-Demand Webinar
Price: $199 + applicable taxes
Buy Now

Credits

NASBA logo
Credit Hours:
Field of Study:
Program Level:
Basic Knowledge
Prerequisites:
None
Advance Prep:
Delivery Method:
Group Internet Based
Progressive Business Conferences is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org

Learn Excel Now helps you conquer the fear of Excel. By providing self-paced and instructor-led training and free strategies and guides, we leave no Excel mystery unsolved.

  • Home
  • Training
  • All-Access
  • Excel Foundations
  • Resources

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-484-259-7664 or 1-800-964-6033
660 American Ave
Suite 203
King of Prussia, PA 19406

Microsoft® Office Excel® is a registered trademark of the Microsoft Corporation in the United States and other countries. All rights reserved.

Copyright © 2023 ­Learn Excel Now

Terms of Service

Privacy Policy

Copyright © 2023 · News Pro Theme on Genesis Framework · WordPress · Log in

WELCOME BACK!

Enter your username and password below to log in

Forget Your Username or Password?

Reset Password

Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.

Log In