Excel and Advanced Excel Training

Excel and Advanced Excel Training Syllabus

Introduction

Using Excel lists

Creating a List

Sorting

To perform a Simple Sort

To Sort by Multiple Columns

Data Forms

Adding Data Using the Data Form

Finding Records Using Criteria

Filtering Data

AutoFilter

Advanced Filters

Special Features for Filtered Lists

Totals and Subtotals Total

Row

Subtotals

Manipulating data

Working with charts

Working with pivot table

'What if' analysis

Managing Windows

Multiple Windows

Splitting Windows

Freezing Panes

Linking Data

Macros

Printing Excel files

Managing Excel files

Grouping and outlining data

Shortcut keys and references

Analysis tool pack

Analysis by goal seek

Analysis by pivot tables