We use cookies to provide you with a better experience. Full functionality may not be available if cookies are denied.
Power Pivot - The New Way to Build Pivot Tables
When
8/6/21 1:00 pm EDT
Our Customer Assurance Pledge
If this webinar fails to meet your needs, we will refund 100% of your tuition – no hassles, no questions asked.
$209.00
Per Attendee
Missing Headline
$219.00
Per Attendee
Missing Headline
$279.00
Per Attendee
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 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 Back To Top
5 or More Attendees? Please view our group pricing registration page
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
