Bridgeway International

Excel – Pivot Tables and Conditional Formatting

Course Information

Need Group Training

Course Description

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

Course Outline

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