Course Content:

Functions & Formulas
Multiple Operators
Inserting and Editing a Function
AutoCalculate and Manual Calculation
Using and Managing Defined Names
Displaying and Tracing Formulas
Understanding Formula Errors

Working with Data Ranges
Sorting by One or Multiple Columns
Sorting by Colors or Icons
Sorting by a Custom List
Filtering Data
Creating a Custom AutoFilter
Using an Advanced Filter

Working with Tables
Creating a Table
Working with Table Size
Working with the Total Row

Working with Table Data
Summarizing a Table with PivotTable
Using the Data Form
Using Table Styles and Style Options
Creating and Deleting Custom Table Stilves
Convert or Delete a Table

Working with PivotTables
Creating a PivotTable
Specifying PivotTable Data
Changing a PivotTable’s Calculation
Filtering and Sorting a PivotTable
Working with PivotTable Layout
Grouping PivotTable Items
Updating a PivotTable
Formatting a PivotTable
Creating a PivotChart

Analyzing and Organizing Data
Creating Scenarios
Creating a Scenario Report
Working with Data Tables
Using Goal Seek
Using Solver
Using Data Validation
Using Text to Columns
Removing Duplicates
Grouping and Outlining Data
Using Subtotals
Consolidating Data by Position or Category
Consolidating Data Using Formulas

Advanced Topics
Customizing the Quick Access Toolbar
Using and Customizing AutoCorrect
Changing Excel’s Default Options
Recovering Your Documents
Using Microsoft Office Diagnostics
Viewing Document Properties and Finding a File
Saving a Document as PDF or XPS
Adding a Digital Signature to a Workbook
Preparing Documents for Publishing and Distribution
Publishing a Workbook to a Document Workspace
Creating a Custom AutoFill List
Creating a Custom Number Format