Excel 2013 - Tables, PivotTables, and Conditional Formatting

Course Overview

In this course, students will create, edit, and enhance Tables, PivotTables and Conditional Formatting using Microsoft Office Excel 2013.

Course Outline

1 - Organize Worksheet and Table Data

  • Create a Table
  • Sort and Filter a Table
  • Create Calculated Columns in a Table
  • Create a Total Row in a Table
  • Format a Table

2 - Analyzing Data Using PivotTables, Slicers, and PivotTables

  • Create a PivotTable
  • Filter Data with Slicers
  • Analyze Data Using PivotCharts

3 - Apply Conditional Formatting

  • Data Bars, Icon Sets, Color Scales, Top/Bottom Values, Duplicate Values

Enroll Today

This is a half-day class

Price: $195.00
Payment Options

ILT Instructor‑Led Training


GTR  Guaranteed to Run

Class times are listed Eastern time. This class is available for Private Group Training

To sort by location or date, click the ‘When’ and ‘Where’ column headings.

Class dates not listed.
Please contact us for available
dates and times.