Microsoft Excel – Intermediate

Our Microsoft Excel Intermediate training course builds on your prior knowledge of Excel and incorporates this into producing more complex spreadsheets to enhance business capabilities. It is expected that you will have had a working experience and/or training within Microsoft Excel prior to this course.

Working with large worksheets
Viewing options
Hiding, displaying, and outlining data
Printing large worksheets

Using multiple worksheets and
workbooks
Using multiple Excel worksheets
Linking worksheets by using 3-D
formulas
Consolidating data
Linking workbooks
Managing workbooks

Customising Excel
Using the Options dialog box
Customising toolbars and menus

Advanced Formatting
Borders and shading
Using special number formats
Working with dates
Working with styles
Other advanced formatting

List management
Examining lists
Sorting and filtering lists
Advanced filtering

Advanced charting
Chart formatting options
Using combination charts
Using graphic elements

Documenting and auditing
Auditing features
Comments and text boxes
Protection
Workgroup collaboration

Using Excel templates
Built-in Excel templates
Creating and managing templates