Easy-To-Follow Excel Pivot Tables

When

10/10/22 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.

Recording Only

Our Price: $219.00

Per Attendee

Event Description

Pivot tables are among the most useful yet misunderstood tools in Microsoft Excel.

With just a few clicks of the mouse (and no complicated formulas.) you can quickly and easily build reports, dashboards and charts that help you summarize, analyze, interpret and understand your data.

It's a great way to spot trends and answer important questions on which you base your key business decisions.

Pivot tables have a reputation for being complicated but by attending this training, you'll be pleasantly surprised at how easy it is to create and use them.

This interactive, hands-on webinar will demonstrate and provide examples using Excel worksheets and templates that you can download and use for your own practice. Your trainer accepts questions and provides examples on-the-fly throughout the 90-minute session, giving you an opportunity to gain understanding that you might never achieve on your own.

Who Should Attend:

You should attend this training if you need to use Excel to quickly build reports and summaries or if you simply want to learn how to create pivot tables to improve your knowledge of Excel. You don't have to be proficient in Excel to benefit. If you can create basic worksheets and can copy and paste and apply basic formatting to cells, you'll be able to follow along. The training will be delivered using the latest version of Excel for Windows although much of the functionality is available in earlier versions of Excel for both Windows and Mac.

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

Objectives:

Use pivot tables to turn raw data into meaningful and insightful reports
Structure your raw data in the right way
Design and format your pivot table reports so that they are easy to read and understand
Summarize your data in different ways including totals, counts and percentages
Use pivot tables to create monthly summary reports
Display a pivot table as a chart

Topics Covered:

Use cases: Why and when you should use a pivot table
Your raw data - do's and don'ts
Create a simple pivot table with a few mouse clicks
Different ways to summarize your data - total, count and percent
Apply formatting to a pivot table to make it easy to read and understand
Display pivot table data in alphabetical or numerical order
Represent the pivot table data as a chart/graph
How to update a pivot table when the source data changes

Bring Your Team – Group Package Pricing 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