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

Course NameDateTimeOpen Seats In-PersonOpen Seats OnlinePrice
Excel VI Advanced Pivot Tables & Ifs6/29/2021 (Tue)5PM - 8PM44$80.00 Register

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)