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 Advanced Pivot Tables & Ifs

Scheduled Dates

This class is scheduled on an as-needed basis. Please choose an available day and time or call us at (909) 981-6331 for more information.

Topics Include:

  • Grouping Text Fields
  • Retrieving Data from a Pivot Table Report
  • 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
    IF Function
  • If Syntax
  • Phrasing An If ‘Question’
  • IFS Yes And No Answers
  • Using If For More Than 2 Results (Nested Ifs)
  • AND Function
  • OR Function
  • Using An If To Help Data Entry Errors
  • Use An If To Clean Up Report Errors

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)