Home • Training • Databases • Contact Us • Site map

Onsite Microsoft Excel Training - Intermediate

Microsoft Excel is a spreadsheet application that features calculation, graphing tools, pivot tables and a macro programming language called VBA. It is used by a large proportion of the workforce for a variety of different purposes from storing lists through to complicated analysis. Microsoft Excel is an extremely powerful and easy to use application.

Our training Allows you to capitalise on this extremely useful resource. Our standard Intermediate course is outlined below but we can discuss bespoke courses and also collaborative development of any spreadsheet you wish to create.

Microsoft Excel Intermediate Training Course

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

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

Customizing Excel
Using the Options dialog box
Customizing 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 templates
Built-in templates
Creating and managing templates