Excel Intermediate Course duration: 1 day

Working with Large Worksheets
View Tab
Hiding/displaying data.
Printing large worksheets.

Working with Multiple Worksheets and Workbooks
Using multiple worksheets.
Linking worksheets by using 3-D formulas.
Managing workbooks.
Using multiple workbooks.

Documenting and Auditing
Comments and Text Boxes.
Auditing features.
Protecting cells and sheets.
Allow Edit Ranges.

List Management
Creating lists.
Sorting and filtering.
Data Validation.
Flash Fill.
Subtotals.
Remove Duplicates.

Analysing
Data Validation.
Conditional formatting.
Charts.
Sparklines.

Customising Excel
Changing options.
Customising toolbars and menu.