Excel – Pivot Tables and Conditional Formatting

Instructor‑Led: $148 | Duration: 0.5

Upgrade your tech skills with this , training course from TechSherpas 365!

Select a Learning Method Below

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

Guaranteed-to-Run

$148
4/14/2026 4/14/2026
9:00AM - 12:30PM
star GTR

Guaranteed-to-Run

$148
6/17/2026 6/17/2026
9:00AM - 12:30PM
star GTR

Guaranteed-to-Run

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

Guaranteed-to-Run

PRICE : $148
START DATE : 4/14/2026
END DATE : 4/14/2026
CLASS TIMES (EST) : 9:00AM - 12:30PM
DELIVERY/LOCATION :
STATUS :
star GTR

Guaranteed-to-Run

PRICE : $148
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 : $148

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. 

No results found.

Explore Related Training Courses

What Our Students Are Saying

IT Certification Training Course Reviews