1 - Organize Worksheet and Table Data
Create a TableSort and Filter a TableCreate Calculated Columns in a TableCreate a Total Row in a TableFormat a Table
2 - Analyzing Data Using PivotTables, Slicers, and PivotTables
Create a PivotTableFilter Data with SlicersAnalyze Data Using PivotCharts
3 - Apply Conditional Formatting
Data Bars, Icon Sets, Color Scales, Top/Bottom Values, Duplicate Values
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
This course is intended for individuals who want to gain knowledge of working on Excel using Tables, PivotTables and Conditional Formatting.