0

Power Pivot - The New Way to Build Pivot Tables

Power Pivot - The New Way to Build Pivot Tables
Power Pivot - The New Way to Build Pivot Tables

When

8/6/21 1:00 pm EDT
Our Customer Assurance Pledge
Power Pivot - The New Way to Build Pivot Tables

If this webinar fails to meet your needs, we will refund 100% of your tuition – no hassles, no questions asked.

     Sign up for Business Watch Network's Training Pass to get access to our entire training library!

Event Description

Power Pivot is a feature of Excel that puts the "power" into Pivot Tables (hence the name).

Power Pivot removes many of the limitations and frustrations that users find with creating Pivot Tables. For example, using Power Pivot you can...

  • Create Pivot Tables from multiple Excel-based lists without the need to combine them into a single list first (no more VLOOKUP)
  • Create Pivot Tables from large datasets without worrying about file size, performance or needing more rows that an Excel worksheet contains
  • Create Pivot Tables from multiple data sources (Excel, database, text file etc)
  • Create powerful calculations on the data in your Pivot Tables
  • And more...

In this training, you will learn, using practical examples, how Power Pivot provides Business Intelligence and reporting functionality within the familiar environment of Excel to provide you with better business insights and enable you to make more informed business decisions.

Why you should attend

Your data is only as good as the information you can derive from it. Power Pivot enables you to gain better business insights and make more informed business decisions.

If you want to take your reporting capabilities to the next level by learning how to leverage the functionality of Power Pivot, this is a must-attend training session.

Who Should Attend:

This training is aimed at users of Excel (2010 and above for Windows) who wish to learn about Power Pivot.  Attendees should have at least intermediate knowledge of Excel and be familiar with formulas and creating Pivot tables.

Important Note: Power Pivot may not be available for your version of Excel. If you are unsure whether this training is relevant for your version of Excel, please check with your IT department or see this link: https://www.support.microsoft.com/en-us/office/where-is-power-pivot-aa64e217-4b6e-410b-8337-20b87e1c2a4b

Customer Reviews Back To Top

 
 

Speaker Back To Top

Mike ThomasMike Thomas has over 25 years experience designing and delivering face-to-face and virtual training courses. He has authored nearly 200 written and video-based Excel tutorials. He also develops Microsoft Office solutions to automate key business tasks and processes.

Topics Back To Top

Topics Covered:

  • Importing data into Power Pivot - the why and how
  • The importance of understanding The Data Model
  • Creating a Pivot Table from related Excel tables
  • Creating a Pivot Table from related data sources (including external sources)
  • An introduction DAX: Calculated Columns and Measures

Bring Your Team – Group Package Pricing Back To Top

5 or More Attendees? Please view our group pricing registration page

View Price Per Attendee

 

 

Have more than 30 attendees? Issues during checkout? Or want to register your team directly with the help of a BusinessWatch Network Customer Representative? Please Reach Out To: support@bizwatchnetwork.com

Companies Who Trust Us Back To Top

Trusted Customer Logo

Back To Top