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
Using multiple Excel worksheets
Linking worksheets by using 3-D
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
Workgroup collaboration

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

Course Overview
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

"The training was well planned and specific to the needs of our department. I would highly recommend."

Financial Director - HotelREZ

My new found knowledge will help me in my current job. I got more out of the course more than I thought possible!

Instructor - Dixons Carphone