Excel

Excel

Word

Word

Access

Access

PowerPoint

PowerPoint

Outlook

Outlook

Publisher

Publisher

Quickbooks

Quickbooks

Windows & Computers

Windows & Computers

Internet & Cloud

Internet & Cloud

Specialty

Specialty

Excel Pivot Tables

Welcome to the Excel V Pivot Tables class!

In this course, we will dive into the powerful world of pivot tables in Microsoft Excel, empowering you to efficiently organize, analyze, and gain valuable insights from your data. Pivot tables offer a dynamic and flexible way to summarize and manipulate large amounts of information. We will explore the features of pivot tables, starting with sorting and grouping pivot table items, allowing you to organize your data in a meaningful way. You will learn how to customize pivot table layouts, enabling you to rearrange and structure your data to suit your analysis needs. Additionally, we will delve into the functionality of adding data fields that calculate, such as sums, averages, counts, and more, providing you with the ability to derive key metrics and perform in-depth analysis. By the end of this class, you will possess the skills to create and customize pivot tables that transform raw data into meaningful reports, enabling you to make informed decisions and uncover valuable insights. Get ready to harness the power of pivot tables and take your data analysis capabilities to new heights in Excel.

Scheduled Dates

Course NameDateTimeOpen Seats In-PersonOpen Seats OnlinePrice
Excel Pivot Tables11/2/2024 (Sat)1PM - 4PM54$125.00 Register

Need a Different Date?

Do the current classes not work for your schedule, or are no classes currently available? No problem! Visit our Schedule a Class page and choose an available day and time or call us at (909) 981-6331 for more information.



Topics Include:

Pivot Table Basics

  • Creating A Pivot Table
  • Laying out a New Pivot table On the Worksheet
  • Adding Sub-Details to an Item
  • Managing Pivot Tables
  • Grouping Pivot Table Items
  • Displaying Pivot Table Details
  • Creating a Slicer

Pivot Table Layouts

  • Adding/Deleting Subtotals
  • Grouping Text Fields
  • Inserting a Chart

Advanced Features

  • Adding a Calculated Percentage Field
  • Displaying the Top/Bottom Number of Items
  • Adding a Calculated Field
  • Adding a Data Field That Calculates the Difference Between Two Data Fields
  • Adding a Data Field That Calculates Percentages from One Item of the Row Field
  • Adding a Data Field That Calculates
  • Automatically separating data with pivot tables

California Computer Schools, Inc.

Location 123 East 9th Street
Suite 300
Upland, CA 91786
Phone: 909.981.6331 Hours: Monday – Friday: 9:00 AM – 4:00 PM (PST)

Contact Us

View Cart (0)