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

Price: $
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.

Credits

NASBA logo
Credit Hours:
Field of Study:
Program Level:
Basic Knowledge
Prerequisites:
None
Advance Prep:
Delivery Method:
Group Internet Based
Progressive Business Conferences is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.org

REGISTRATION

Excel Pivot Table Training: Accelerate Analytics & Decision Making

Live event begins Monday, July 8, 2019, 12PM (ET)

Live +
On-Demand $249
more info
You will receive access to the live event which includes a copy of the speaker's presentation, real-time training with our expert instructor, and an interactive question & answer period. 2-3 business days after the live webinar concludes you will also receive a link with unlimited access to the on-demand recording of the live session that you can revisit, review and share with colleagues.

If you can’t make it live, no worries!
You’ll receive the recording and materials after the event.

Register Now

A Note to Our Valued Attendees Impacted by COVID-19:

We understand that due to COVID-19, most people are working remotely and in multiple locations, so we're doing things a little different to accommodate such situations.

After registering, simply reply to your invite email with a list of all the folks who will need additional access links.. Please include their first name, last name, and email address.

REGISTRATION

Excel Pivot Table Training: Accelerate Analytics & Decision Making

Live event begins Monday, July 8, 2019, 12PM (ET)

Live + On-Demand $199
Register Now

REGISTER NOW

Live Event

Monday, July 8, 2019

at 12PM (ET)

Live + On-Demand $249

If you can’t make it live, no worries!
You’ll receive the recording and materials after the event.

Register Now

A Note to Our Valued Attendees Impacted by COVID-19:

We understand that due to COVID-19, most people are working remotely and in multiple locations, so we're doing things a little different to accommodate such situations.

After registering, simply reply to your invite email with a list of all the folks who will need additional access links.. Please include their first name, last name, and email address.

Live Event

Monday, July 8, 2019

at 12PM (ET)

Live + On-Demand $199
Register Now

Credits

NASBA logo
Credit Hours:
Field of Study:
Program Level:
Basic Knowledge
Prerequisites:
None
Advance Prep:
Delivery Method:
Group Internet Based
Progressive Business Conferences is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.nasbaregistry.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