At your Convenience
We come to you or
you come to us
Wherever you are!

Build your own tailored course
Lots of options available

Good Value
Your company saves money
and your staff save time

What's New?
Remote Classroom Training...
...coming shortly!

It's Your Training!
When and Where
You want it

Welcome to Insight

Delivering private IT training from businesses,
public sector and voluntary organisations

Microsoft Excel Intermediate

< Back to Microsoft and Office Courses | Insight IT Training

Course Details


Course Duration - One Day

Benefits of Microsoft Excel Intermediate Course

This Intermediate course has been designed to improve the user’s knowledge of Microsoft Excel and develop the basic spreadsheet skills that trainees have already acquired. This course will benefit anyone wishing to develop their basic Excel knowledge. You will learn how to use Charts/Graphs, how to control the screen and use Excel internet features. So if you would like to be more proficient in using Excel, then check out our Intermediate course content for the full picture.

Our course is a one day, 100% hands-on led by highly skilled Microsoft Excel trainers who have a wealth of knowledge in the Microsoft product set. We give you practical exercises to practice the new skills as you learn them.

To get the best of out the Intermediate course, trainees should have attended the Introduction to Microsoft Excel course or have a basic knowledge of Microsoft Excel.

If you are interested in discussing bespoke training from Insight IT, please contact us to discuss this option further and we’ll get back to you with a recommended course outline customised to your needs.

Basic and Advanced courses are also available.

Course Content

Excel Functions

  • Using the SUM, MAX, MIN, COUNT and AVERAGE functions
  • Understanding Absolute and Relative cell references

Excel Charts/Graphs

  • Creating a Chart
  • Formatting a Chart

Controlling the Screen

  • Freezing column and row titles
  • Using the Zoom feature
  • Using the Split Screen feature


  • Use the Screenshot and Screen Clipping features (2010+)

Use Excel Internet Features

  • Viewing a worksheet in a browser
  • Creating a hyperlink to a web site or other document

Naming Ranges in a Worksheet

  • Naming Ranges
  • Move to a Named Range
  • Use Named Ranges in formulae
  • Print a Named Range

Excel Databases

  • Use an Excel list as a Database
  • Setting up a new Database
  • Sorting records in a Database
  • Filtering records in a Database


Trainees should have attended the Introduction to Excel course or have a basic knowledge of Microsoft Excel.

Contact Us

Interested in our service? Then get in touch today with Insight IT to see how we can tailor your training to suit your needs.

Call us on: 07889 216849. Alternatively contact us online here.