Name: Excel: Summarizing & Analyzing Excel Data with Pivot Tables
Best Seller
Overall Rating: 4.9 out of 5 (8 ratings)
Category: All Learners
Duration: 1.25 hour(s)
Individual Fee: $20.00

This informative training session, you’ll learn how to use PivotTables better to sort, filter and subtotal your data more efficiently .

PivotTables can help you sort and sift through large data sets to focus quickly on just the data elements that matter most to your specific needs. In addition, you’ll get tips on the easiest way to group your data. Most importantly, when you use the power of PivotTables, you’ll be saving time and making your job easier.

This Development Activity has not been scheduled.
College of Lake County
19351 West Washington Street
Building E, Suite E186
Grayslake, IL 60030
United States
Do and Show: Important tasks or skills you will be able to perform and demonstrate to others.

Use PivotTables to: 

  • Better sort, filter and subtotal your data more efficiently
  • Create multiple customized reports in a few easy steps
  • Gain a powerful new tool to help you make better business decisions

Topics

• Why PivotTables are the hidden gems of Excel

• How to analyze large data sets from different business perspectives

• Create a PivotTable to summarize data

• Make understanding the data easier for others

• Use PivotTables to answer questions about the data

• Analyze patterns in the data

• Customize the summary by grouping data

• Format PivotTables for easy viewing

• Use a chart to view the summary visually

SkillPrerequisiteExpected Outcome
Excel1 - BeginnerNot specified
Excel Advanced1 - BeginnerNot specified
Excel Intermediate1 - BeginnerNot specified
Excel Pivot Tables1 - BeginnerNot specified

Cathy Horwitz

Years of Experience: 44+ years

Area of Expertise: Microsoft Office

Class Costs
Class ValueNo Charge
Individual Fee$20.00
Private Class Fee$0.00
4.9 out of 5 (8 ratings)

Excellent Course Fri, May 19, 2023
This was an awesome and informative class with a great teacher to student ratio. All of my questions were answered fully in a timely manner. I was given multiple tips and tricks to make using Pivot tables much easier to use and understand. Thank You!!
Excel: Analyzing Data with Excel Pivot Tables Mon, Feb 13, 2023
good illustration
Useful Information for Creating Pivot Tables Tue, Feb 7, 2023
There is lots of useful, hands on information in this class. In particular I found the explanation about how to refresh a pivot table extremely useful. This is not something that is easily found online.
[See all User Reviews…]