Guaranteed to be Good
All training experiences include a 7-day 100% money-back guarantee.
Excel Pivot Table Training: Accelerate Analytics & Decision Making
Summary
So, you found the data you need for your analysis, now what? How do you sort and sift through it to mine key intel, plus make the right decisions? Microsoft Excel holds the key. Pivot Tables is one of Excel’s most powerful tools and is designed to help you quickly summarize mountains of data.
Join us and gain a solid understanding of how to identify key trends, generate meaningful reports, plus “pivot” spreadsheets for specific users and needs.
In this 90-minute, highly interactive workshop, you’ll discover the following:
- Multiple methods to set up a Pivot Table
- Efficient ways to clean, filter, sort & structure your data
- How to navigate the options menu for complete control & customization
- Essential tips, tricks & shortcuts to save time while enhancing outcomes
- Techniques to target production delays, efficiency gains, scrap rates, key demographics & much more
Program Highlights
Getting Started: Wrangle your Database and Prepare it for Pivoting
- How to create a Pivot Table from an Excel table & range
- Selection techniques & layouts: Clean your datasets for flawless pivoting
- Manage Pivot Table fields: Build the perfect Table for yours & others’ needs
Basic Pivot Table Techniques to Save time, Boost Calculations & Customize Your Work
- Methods to format your Pivot Table efficiently so it’s easy to understand
- How to drill into on your data: Explore & focus on what matters most
- Techniques to chart your Pivot Table results & visualize your data
Pivot Table Tools & Features Every Excel User Must Know
- Get the most out of your analysis: Filter your report with Excel’s Slicer tool
- Create flexible data queries that refresh when the data does: Automate & analyze
- Learn how the gurus in your organization analyze their data so quickly - become one too!
About The Speaker
Miles Hutchinson, CGMA, President, Learn Continuously, LLC. Miles Hutchinson is a CGMA and experienced businessman.
- He has been an auditor with PriceWaterhouseCoopers and the Chief Financial Officer of a $1 billion real estate development company.
- Miles is a professional speaker and consultant who has presented over 2,500 seminars and training sessions on a myriad of business and financial topics, like financial analysis and modeling, accounting, strategic planning, and compliance with the Sarbanes-Oxley Act.
- He is recognized as an expert in payroll and sales & use tax as well as financial modeling & analysis, business strategy and communications.
- His clients include, Abbott Labs, Bank of America, Boston Scientific, Citicorp, Corning, the FBI, the FDA, the Federal Reserve, GE, Pfizer, Siemens, US Marine Corps, and the US Army. Please visit his web sites to see how you can further benefit from his expertise.
Program Benefits
Stop staring at that database. Dive in, explore it with Pivot Tables and save time while doing it!
This 90-minute program will guide you to identify the key trends in your data and be confident you’ve reached the right conclusions to support your recommendations.
Purchase this On-Demand Workshop
Excel Pivot Table Training: Accelerate Analytics & Decision Making
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.
