Excel – Pivot Tables And Conditional Formatting training course

Instructor‑Led: $140 | Duration: 0.5

In This Course, students will analyze Excel data, create PivotTables, Pivot Charts as well as Analyzing Pivot Tables.

Reserve your seat in an upcoming class date or select a Learning Method below:

Start Date End Date CLASS TIMES (EST) DELIVERY/LOCATION Status Price Enroll Now
6/17/2026 6/17/2026
9:00AM - 12:30PM
star GTR

Guaranteed-to-Run

$140.00
8/14/2026 8/14/2026
1:30PM - 5:00PM
star GTR

Guaranteed-to-Run

$140.00
10/13/2026 10/13/2026
1:30PM - 5:00PM
star GTR

Guaranteed-to-Run

$140.00
12/16/2026 12/16/2026
1:30PM - 5:00PM
star GTR

Guaranteed-to-Run

$140.00
START DATE : 6/17/2026
END DATE : 6/17/2026
CLASS TIMES (EST) : 9:00AM - 12:30PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run

PRICE : $140.00
START DATE : 8/14/2026
END DATE : 8/14/2026
CLASS TIMES (EST) : 1:30PM - 5:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run

PRICE : $140.00
START DATE : 10/13/2026
END DATE : 10/13/2026
CLASS TIMES (EST) : 1:30PM - 5:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run

PRICE : $140.00
START DATE : 12/16/2026
END DATE : 12/16/2026
CLASS TIMES (EST) : 1:30PM - 5:00PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run

PRICE : $140.00

Course Highlights

LEVEL: 
  • Intermediate
TOPICS & JOB ROLES: 
BRANDS/TECHNOLOGIES: 

Excel – Pivot Tables And Conditional Formatting Course Outline

In This Course, students will analyze Excel data, create PivotTables, Pivot Charts as well as Analyzing Pivot Tables.

PREREQUISITES

Excel — Part 1 or equivalent experience.

1 — ANALYZING DATA

  • Tables
  • Conditional Formatting

2 — CREATE A PIVOTTABLE

  • Pivot Tables
  • Pivot Charts

3 — PREPARING DATA AND CREATING PIVOTTABLES

  • Summarize PivotTable Data
  • Organize PivotTable Data
  • Filter PivotTable Data
  • Format a PivotTable
  • Refresh and Change a PivotTable

Related Job Roles

This course builds skills and demonstrates qualifications for the job roles and average base salaries below. 

Explore Related Training Courses with TechSherpas 365