Course Content
Module 1: Using Charts
Creating Charts; Types of Charts; Editing Charts; Using Graphics to Enhance Charts; Linking Chart Titles; Creating Sparklines
Module 2: Working with Names
Creating Range Names; Managing Names; Using Names in Formulas
Module 3: Sorting and Filtering Data
Removing Duplicate Rows; Sorting Data; Filtering Data; Using Advanced Filters
Module 4: Outlining and Subtotaling Data
Creating an Outline; Adding Subtotals
Module 5: Working with Views
Arranging Files; New Window Feature; Custom Views
Module 6: Linking Files
Creating Formulas Between Files; Working with Links; Consolidating Data
Module 7: Advanced Formula Creation
Using IF Statements; Using Functions to Look Up Data; Working with Data Validation; Formula Auditing; Using the Watch Window
Module 8: Overview of PivotTables and PivotCharts
PivotTables; PivotCharts; Slicers
Module 9: Customizing Excel
Excel Options; Customizing the Ribbon; Modifying Workbook Properties
Module 10: Additional Excel Features
Text to Columns; Conditional Formatting; Hyperlinks; the Spell Checker and Translate Features; Quick Analysis Tool; the Document