The course consists of 10 modules and includes media demonstrations, hands-on activities, and knowledge check questions. At the end of the course, you will complete a consolidation exercise, which will help you review what you have learned and assess your understanding.
The course also contains quizzes at the end of each module and a Validation Test at the end of the course. With successful completion of the course, you will receive a Pitman Training certificate to verify your achievement.
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 Inspector; Import Data from a Text / CSV File