Microsoft Excel 2019 – Part 2

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