Learn Excel Now

Conquer the Fear of Excel

  • Home
    • Our Team
  • Training
    • Custom Training
      • Custom Virtual Group Training
      • Custom Onsite Group Training
      • Consulting Services
    • Excel
    • MS Office
    • Outlook
    • PowerPoint
    • Word
    • OneDrive
    • Google
  • All-Access
  • eLearning
    • Excel Foundations
    • Micro Courses
      • Simply Excel
      • Simply Excel Pt. II
  • Resources
    • Contact
    • FAQ
    • New User Onboarding
  • Login

Excel Pivot Table Training: Accelerate Analytics & Decision Making

Share

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
Learn how to pull the whole story from your data!

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.
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.
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.
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.
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.
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.
Add To Cart

Guaranteed to be Good

All training experiences include a 7-day 100% money-back guarantee.

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.

Purchase This On-Demand Webinar

Excel Pivot Table Training: Accelerate Analytics & Decision Making

On-Demand $199 + applicable taxes
3 Workshop Bundle $300 + applicable taxes
One-year subscription (All Access Membership) $699 + applicable taxes
Add To Cart

Guaranteed to be Good

All training experiences include a 7-day 100% money-back guarantee.

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.

HRCI Credits

HRCI logo

This program has been approved for 1 (HR (General)) recertification credit hour toward aPHRTM, aPHRiTM, PHR®, PHRca®, SPHR®, GPHR®, PHRiTM and SPHRiTM recertification through the HR Certification Institute. Learn more at hrci.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

All Access Subscription
Our 1-year all-access subscription provides step-by-step guidance for mastering Microsoft Office applications, with workshops, exercises and quick reference eGuides. It's perfect for anyone that needs to brush up on certain skills or even folks who need to learn the programs - from a beginner’s level.
Excel Foundations
Take the fear out of Excel with this 20 module self-paced training course. You will cover the most essential topics to develop a solid foundation of Excel or a lifetime of mastery.