Discover Classes. Earn 10% Rewards.

Excel PivotTables: Data Summarization and Analysis is unfortunately unavailable

Thankfully we have 3 other All Software Classes for you to choose from. Check our top choices below or see all classes for more options.

Digital Video Editing with Adobe Premiere Pro (Level 2)

Los Angeles City College See all classes by this school @ 855 N Vermont Ave, Los Angeles, CA

Push your video editing skills further with this intermediate Adobe Premiere Pro course. Step into advanced tools and techniques, including timeline pancaking, media browsing, and working with different resolutions. Build color correction, adjustment layers, and exporting settings for YouTube and Vimeo. The course is built for those already familiar with basic editing and project setup in Premiere Pro.

(935) Intermediate 18 and older
$199

3 sessions

Attend
+1990 pts
Gift it!

Adobe Photoshop: Training for Everyone

Los Angeles City College See all classes by this school @ 855 N Vermont Ave, Los Angeles, CA

Pick up essential concepts and advanced features of Adobe Photoshop in this thorough training course. Develop your graphic design, photo manipulation, and image restoration abilities, and create striking movie posters and pop art pieces. Stand apart from the crowd with strong design and imaging skills.

(935) Beginner 18 and older
$99

2 sessions

Attend
+990 pts
Gift it!

Adobe Illustrator: Training for Everyone

Los Angeles City College See all classes by this school @ 855 N Vermont Ave, Los Angeles, CA

Build your skills in vector graphics and distinctive illustration design using Adobe Illustrator. Get hands-on with painterly brushes, shape-building utilities, path controls, transparency, and gradients across mediums while shaping personalized logos and business cards at Los Angeles City College's hands-on lab.

(935) Beginner 18 and older
$99

2 sessions

Attend
+990 pts
Gift it!
See all All Software classes Los Angeles

Excel PivotTables: Data Summarization and Analysis

  • Intermediate
  • 16 and older
  • Earn 10% Rewards
  • Price Lock

    Secure your booking now and we'll match any price drop within 48 hours across all booking platforms, ensuring you never miss out on savings!

  • 200 Pine Ave, Long Beach, CA
  • 3 hours

Start Dates (0) $179/person

No upcoming dates are currently available.

Book a Private Group Event

Booking this class for a group? Find great private group events

Or see all Excel Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

Class Description

Description

A PivotTable is Excel's most powerful data summarization tool. In this three-hour session for Windows and Mac users, you will learn what kinds of data works best for PivotTables and how to prepare your data. You will create PivotTables based on various data sources, summarize data by multiple categories using sum, average and count, format the PivotTable, rearrange columns and rows, apply filters, slicers and grouping (both manual and automatic). You will apply built-in calculations like Show as % of Grand Total, as well as create custom calculated fields. You will also create PivotCharts and refresh a PivotTable if its source data changes.

Prerequisites

This class is suited for people who have taken our Excel Beginning or Intermediate Excel classes or have been using Excel (any version) for a year or more and want to learn how to use PivotTables.

Class Outline

Preparing Data and Creating PivotTables

  • prepare data
  • create a PivotTable from a local data source
  • create a PivotTable from an external data source
Analyzing data using PivotTables
  • summarize PivotTable data
  • organize PivotTable data
  • filter PivotTable data
  • format a PivotTable
  • refresh a PivotTable if its data is changed
Working with PivotTable options
  • PivotTable report layout options
  • setting PivotTable options
  • grouping and calculating
  • creating calculated fields and items
Creating PivotCharts
  • create a PivotChart
  • manipulate PivotChart data
  • format a PivotChart


Refund Policy

  • You may cancel or reschedule a class registration at least 8 business days prior to the class without incurring any penalty.
  • After 8 business days, we may charge a penalty of up to 100% of the registration cost.
In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.

In the event that an instructor or the school needs to cancel at the last minute, students will receive a refund less a 5% non-refundable registration fee.

Reviews of Classes at Accelerate Computer Training (33)

(4.9-star rating across 33 reviews)

This class: 5.0 out of 5 from 5 reviews

  • Excel PivotTables: Data Summarization and Analysis

    Peter is great. Peter can make excel simple to learn. Hands down, his class was very useful.
  • Excel PivotTables: Data Summarization and Analysis

  • Excel PivotTables: Data Summarization and Analysis

    Sue was terrific! She was very informative, helpful and a pleasure to learn from. I would recommend this class to anyone wanting to brush up or learn more about Excel Pivot tables. They care about your needs and really do a great job.
  • Excel PivotTables: Data Summarization and Analysis

    Sue was a pleasant, patient and informative instructor. Would take another class with her!
  • Excel PivotTables: Data Summarization and Analysis

See reviews for other classes at Accelerate Computer Training
loading...
Hide Reviews

Benefits of Booking Through CourseHorse

  • Booking is safe. When you book with us your details are protected by a secure connection.
  • Lowest price guaranteed. Classes on CourseHorse are never marked up.
  • This class will earn you 1790 points. Earn 10% back in reward points!

Accelerate Computer Training

Accelerate Computer Training offers hands-on computer training classes in Long Beach, California. Their experienced trainers provide personalized instruction in a variety of software applications, allowing students to improve their skills and enhance their work efficiency.

View school profile
Accelerate Computer Training
Vetted by CourseHorse

A verified Los Angeles educator.

Loading...