Professional Training
5.0 (75 Reviews)

Excel Birmingham | Excel Intermediate

Keys Training, In Birmingham
1 day
1 day
Leave your details so the provider can get in touch

Course description

Excel Birmingham | Instructor-led Training

Excel Intermediate | 1 Day Excel Courses | Classroom or In House

Microsoft Excel Courses

Microsoft Excel is the world’s most popular spreadsheet program, learning how to use the software with Keys Training® shows that you’ve taken one of the best Excel training courses available. Comprehensive instructor-led excel courses available across Birmingham:

  • By the end of the course delegates will be able to use to full advantage a greater range of available Excel functions in order to produce more effective spreadsheets.
  • This Excel introduction course is a great course for a group of individuals that are confident using the fundamentals of excel but would benefit from learning more advanced features to work more effectively.

Suitability - Who should attend?

Basic IT skills required

We can provide pre-course evaluation forms to asses each person’s level.

Outcome / Qualification etc.

Excel Intermediate - Course Objectives:

  • Use advanced formulas and functions
  • Define names for individual cells and ranges
  • Use the database tools in Excel
  • Work effectively with large spreadsheets

Certificate of Attendance for Training Records.

All attendees will take their Excel skills and knowledge to the next level.

All skills will be ready to apply in the workplace.

Training Course Content

Excel Intermediate

This one-day instructor led course is designed to develop the practical skills of Excel users. By the end of the course delegates will be able to use to full advantage a greater range of available Excel functions in order to produce more effective spreadsheets.


  • IF functions
  • Function to combine data from multiple cells
  • Data functions
  • Nested functions


  • Naming cells and ranges
  • Protecting cells
  • Linking workbooks
  • Linking applications (Excel with Word or PowerPoint)

Database tools

  • Sorting data – ascending, descending, left to right
  • Sorting data in custom sequences
  • Filtering data with AutoFilter
  • Creating customised and advanced filters
  • Using data forms to enter, delete and search for data
  • Using subtotals to calculate sub sets of data


  • Hiding columns, rows and formulas
  • Grouping columns and rows
  • Applying conditional number formatting

Course delivery details

Two Types of Training

  • Excel Introduction Public Courses
  • Group In House Excel Training (up to 8 attendees)

Why choose Keys Training

Over 25 years’ experience of delivering quality Microsoft & Business Skills training.

All Trainers are Microsoft Certified or equivalent.

Scheduled Public and Tailored In-house training throughout the UK.


Average rating 5

Based on 75 reviews.
Write a review!
01 Feb 2024

Trainer was outstanding. Both friendly and professional 😊

25 Jan 2024

Really helpful.

25 Jan 2024


Please get in touch by filling out the form or call to find out the course fees.

Public Course – Excel Intermediate: £225.00 plus VAT per Person (quantity discounts apply)

In House Excel Intermediate: £625.00 plus VAT (for up to 8 attendees)

As these are all inhouse courses, we can tailor the course content to meet the skill levels and requirements of the delegates.

Get Inspired! Watch the Video

Request info

Contact course provider

Fill out your details to find out more about Excel Birmingham | Excel Intermediate.

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.
Keys Training
1 Croston House Lancashire Business Park, Leyland
PR26 6TU Preston Lancashire

Keys Training

Keys Training® provides a Business Skills Training Service throughout the UK. We specialise in delivering one-day instructor-led courses that cover Microsoft Office and Personal Development Skills. Our training courses can be delivered on your site, at one of our venues...

Read more and show all courses with this provider