Microsoft Excel Intermediate - Online

Insight IT Training
Course summary
1 day
Corporate Training for Teams
Next available date: Choose a date and time to suit your staff. - Online courses
Course Dates
Choose a date and time to suit your staff.  (English)
United Kingdom
Choose a date and time to suit your staff.  (English)
Online courses
Choose a date and time to suit your staff.  (English)

Microsoft Excel Intermediate - Online

*We now offer Online IT training remotely to businesses in the UK and in Europe. This course is delivered remotely as a real time face-to-face communication with the trainer. You will be able to see the trainer and the trainer will be able to see you and your screen. All secure and private. No videos, animations or modules to complete online. This is proper hands-on instructor led training for your staff. Just like in a classroom, plus, all the benefits of private training.  A Remote solution for effective Virtual training, delivered using either Microsoft Teams or Zoom, which are both free to download. Online IT training can be 1-to-1 or for a group of up to 6 people, plus a Per Hour option.

A private course delivered exclusively for your staff, this Microsoft Excel Intermediate course enables your delegates to build on their Excel skills in a relaxed and highly interactive environment that will favour the development of both skill and confidence.

The 1-day programme is led by a highly skilled Microsoft Excel trainer with extensive knowledge of the product who will guide delegates through a range of intermediate Excel features and tools. Key topics covered include:

  • Using Formulas in Excel
  • Using Absolute and Relative references ($)
  • Creating charts and graphs
  • Controlling the screen and layout
  • Using Excel internet features
  • Using Excel databases

The course is 100% hands-on and full of exercises to help trainees practice the skills they are learning. Delegates are encouraged to bring their own data to the course in order to work with relevant examples. Organisations can also choose to further customise the training to meet a specific need or reach a well-defined outcome.

Insight IT Training can arrange for the training to cover any version of the Microsoft Excel software.

Suitability - Who should attend?

This course is suitable for those who already have a foundation of Excel knowledge and would like to build on their skills. Delegates should have attended Insight's;Introduction to Microsoft Excel course or have an equivalent level of knowledge.

Outcome / Qualification etc.

Each trainee will receive a Certificate of Attendance, signed by the trainer. You will also receive copies of the Evaluation Forms completed by the trainee(s) for your records.

Training Course Content

Standard course content includes:

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

Levels of Study

Insight IT Training delivers standard Excel courses at Introductory, Intermediate, Advanced and VBA levels. These courses can also be tailored - in content, format and duration - to meet your exact needs.


Our prices are all inclusive and the same for any;location in the UK. Prices options are available for training 1 or 2 people and a group of between 3 to 6 people.

Be Inspired! Watch the Video

Insight IT Training

Insight IT Training

Provider: Insight IT Training

Insight IT Training Logo

Insight IT Training - Customised IT and Business Skills Training, Tailored to Your Company

*We now offer Online IT training remotely to businesses in the UK and in Europe. This course is delivered remotely as a real time face-to-face communication with the trainer. You will be able to see the trainer and the trainer...

Read more and show all courses with this provider

Request information - obligation free

Fill out your details to find out more about Microsoft Excel Intermediate - Online.

  Contact the provider

  Get more information

  Register your interest

Contact information for Insight IT Training

Insight IT Training

Insight IT Training Limited
Hamilton House, Mabledon Place
WWC1H 9BB London London

 Show phone number

Reviews by course attendees

Average rating 5

Based on 1 reviews

Very useful, tutor was clear, friendly and spoke in language we could understand.
Request information

Find out more about this Microsoft Excel Intermediate - Online course - simply fill out your details:

U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!


Learn more

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here