Excel 2016 Expert
$199.00Price
Module One: Manage Workbook Options and Settings
- Manage Workbooks
- Manage Workbook Review
Module Two: Apply Custom Data Formats and Layouts
- Apply Custom Data Formats and Validation
- Apply Advanced Conditional Formatting and Filtering
- Create and Modify Custom Workbook Elements
- Prepare a Workbook for Internationalization
Module Three: Create Advanced Formulas
- Apply Functions in Formulas
- Look up data using Functions
- Apply Advanced Date and Time Functions
- Perform Data Analysis and Business Intelligence
- Troubleshoot Formulas
- Define Named Ranges and Objects
Module Four: Create Advanced Charts and Tables
- Create Advanced Charts
- Create and Manage Pivot Tables
- Create and Manage PivotCharts