Guaranteed to be Good
All training experiences include a 7-day 100% money-back guarantee.
Microsoft Excel Power Pivot: Take Your Pivot Tables to the Next Level
Summary
If you’ve got Pivot Tables down and are looking to take the next step to advance in Microsoft Excel, this workshop is for you!
Power Pivot removes many of the limitations and frustrations that advanced users find with Pivot Tables...
No more VLOOKUPs to combine source data.
No more copy and pasting of data to combine it.
No more clunking around Excel with large datasets that slow you down.
In this 90-minute workshop session, you’ll learn how to take advantage of the Power Pivot feature, from importing the data to manipulating columns, rows, and calculations to making meaningful reports to share with stakeholders. Leave this training knowing how to:
- Create Pivot Tables from multiple Excel-based lists without the need to combine them
- Combine related data from multiple data sources (Excel, database, text file etc) into a single Pivot Table
- Create Pivot Tables from large datasets without worrying about file size or performance
- Automate powerful calculations on the data in your Pivot Tables
Program Highlights
Topics Covered:
- Importing data into Power Pivot
- How to navigate Power Pivot based on the version of Excel you have
- The importance of understanding The Data Model
- How to determine which datasets are appropriate for using Power Pivot
- 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
- PowerPivot allows for combining different data sources and making meaningful reports
You’ll get answers to your peers’ most pressing questions, including:
- When should you use PowerPivot?
- What’s the difference between appending data and relating data?
- Can you use PowerPivot without SQL knowledge?
About The Speaker
Mike Thomas has worked in the IT training business since 1989. He is a subject matter expert in a range of technologies including Microsoft Office and Apple Mac. Mike has produced nearly 200 written and video-based Excel tutorials, and hundreds of courses and webinars on a wide variety of technology-related topics.
Mike is a Fellow of The Learning and Performance Institute and has worked with and for a large number of global and UK-based companies and organizations across a diverse range of sectors.
Program Benefits
If you spend too much time in Pivot Tables, it may be time for you to take the next step in Excel: Power Pivot.
This feature will allow you to create data models that are more sophisticated than what you can build with Pivot Tables, accomplish more in less time, and make massive datasets understandable even for others to easily digest your reports. Don’t miss this workshop where you’ll learn how to use this feature from beginning to end.
If you'd like this program customized for your organization, call us at 1-800-964-6033.
We're certain we can fulfill your training needs, while making it fit in your budget!
Purchase this On-Demand Workshop
Microsoft Excel Power Pivot: Take Your Pivot Tables to the Next Level
On-Demand $199 +
applicable taxes
more info
For the live training(s) you've selected:
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
For the on-demand training(s) you've selected:
You'll receive a link to access the recording(s) in your order confirmation email. On-demand recordings also include a copy of the speaker's presentation and the ability to submit your questions to the expert, for up to 7 days after viewing.
You'll receive a link to access the recording(s) in your order confirmation email. On-demand recordings also include a copy of the speaker's presentation and the ability to submit your questions to the expert, for up to 7 days after viewing.
3 Workshop
Bundle $300 +
applicable taxes
more info
Take advantage of our three workshop bundle to enhance your learning beyond the training you initially selected. Our workshop bundle allows you to select three workshops (Live or On-Demand) at a discounted price.
For the live training(s) you've selected:
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
For the on-demand training(s) you've selected:
You'll receive a link to access the recording(s) in your order confirmation email. On-demand recordings also include a copy of the speaker's presentation and the ability to submit your questions to the expert, for up to 7 days after viewing.
You'll receive a link to access the recording(s) in your order confirmation email. On-demand recordings also include a copy of the speaker's presentation and the ability to submit your questions to the expert, for up to 7 days after viewing.
One-year subscription (All Access Membership) $699 +
applicable taxes
more info
With this subscription, you will receive 1 year of unlimited access to our full library of on-demand trainings as well as priority access to trainings that are upcoming.
For the live training(s):
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
You will receive access to the live event(s) which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. Two to three business days after each live training concludes, an email is sent to registrants which contains a link for unlimited access to the on-demand recording you can revisit & review.
For the on-demand training(s):
You'll receive access to our full library of on-demand trainings along with the speaker's presentation and handouts for each event.
You'll receive access to our full library of on-demand trainings along with the speaker's presentation and handouts for each event.
Full-Team Pass
Simply share the invite link with your team so you can learn and grow together!
Yours Forever
The event recording and materials are yours to rewatch and share as you choose.
