1 - Customizing the Excel Environment
Configure Excel Options Customize the Ribbon and the Quick Access Toolbar Enable Excel Add-Ins
2 - Creating Advanced Formulas
Use Range Names in FormulasUse Specialized Functions Use Array Formulas
3 - Analyzing Data with Functions and Conditional Formatting
Analyze Data by Using Text and Logical Functions Apply Advanced Conditional Formatting
4 - Organizing and Analyzing Datasets and Tables
Create and Modify TablesSort DataFilter DataUse SUBTOTAL and Database Functions
5 - Visualizing Data with Basic Charts
Create Charts Modify and Format Charts
6 - Analyzing Data with PivotTables, Slicers, and PivotCharts
Create a PivotTable Analyze PivotTable Data Present Data with PivotCharts Filter Data by Using Slicers
Actual course outline may vary depending on offering center. Contact your sales representative for more information.
Who is it For?
This course is designed for students who already have foundational knowledge and skills in Excel 2013 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.