909.981.6331
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 VI Pivot Tables

Scheduled Dates

Course NameDateTimeOpen Seats In-PersonOpen Seats OnlinePrice
Excel VI Pivot Tables10/16/2021 (Sat)1PM - 4PM44$80.00 Register
Excel VI Pivot Tables10/25/2021 (Mon)9AM - 12PM54$80.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 3290 East Guasti Road
Suite 110
Ontario, CA 91761
Phone: 909.981.6331 Hours: Monday – Friday: 9:00 AM – 4:00 PM (PST)

Contact Us

View Cart (0)