Excel 2016 - Tables, PivotTables, and Conditional Formatting
In this course, students will create, edit, and enhance Tables, PivotTables and Conditional Formatting using Microsoft Office Excel 2016.
Who Should Attend
This course is intended for individuals who want to gain knowledge of working on Excel using Tables, PivotTables and Conditional Formatting.
Upon successful completion of this course, students will be able to create a spreadsheet using Tables, PivotTables and Conditional Formatting by using Microsoft Office Excel 2016.
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
This is a half-day class
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.
contact us for available
dates and times.