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 V Pivot Tables

Scheduled Dates

Course NameDateTimeOpen Seats In-PersonOpen Seats OnlinePrice
Excel V Pivot Tables2/22/2023 (Wed)9AM - 12PM44$95.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 300A
Upland, CA 91786
Phone: 909.981.6331 Hours: Monday – Friday: 9:00 AM – 4:00 PM (PST)

Contact Us

View Cart (0)