X

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

OLL Online LIVE

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.

Cart When Time   Where How
10/10/2019 1:30PM - 5:00PM GTR Online LIVE OLL
12/02/2019 1:30PM - 5:00PM GTR Online LIVE OLL

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