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

Course Length
Course Length 1 or 2 day workshops available
Location Nationwide - call for details
Number of Delegates 6/8 delegates
Enquire about this course

Need more information?

Call one of our specialist training consults for additional information about our Onsite Courses or to book this course.

What our clients say

Watching 100 videos on YouTube wouldn’t be able to come close to the knowledge that I have received today."

Administration Assistant - NHS (Nottingham University Hospitals)

“The trainer was a nice guy and attentive to my needs. An intuitive training technique concentrating on my needs rather than a set agenda or list."

Executive Assistant - Raphael Healthcare