COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
Classroom training -  Excel Intermediate

Classroom Training

Intermediate Excel

Classroom training course - online version also available

£295 + VAT for most venues (£395 + VAT for London)

1 day

Once you've got the basics of Excel, it's time to learn a little more about what you can do.  This one-day intermediate course will show you how to use range names, sort and filter lists, create decision (IF) functions and much more!

Course details

  • Locations for Excel Intermediate coursesPossible locations:London, Manchester, Online
  • Next Excel Intermediate course locationNext classroom course:Mon 30 November 2020
  • Excel Intermediate course timesTime:10.00-16.30

Course Contents

The contents of this course are as follows:

Absolute references

  • Absolute cell references
  • Using the $ sign

Range names

  • Creating range names
  • Editing/deleting range names

Conditional formulae

  • Creating a single =IF formula
  • Using =SUMIFS and =COUNTIFS
  • Combining conditions

Conditional formatting

  • Creating cell rules
  • Managing cell rules
  • Viewing conditional formats
  • Data bars and icon sets

Basic tables

  • Using a spreadsheet as a table
  • Sorting table data
  • Filtering table data
  • Table styles (a warning!)

Advanced printing

  • Layout versus Preview tab
  • Print areas and print titles
  • Setting/removing page breaks
  • Headers, footers and page numbering

Formatting numbers and dates

  • Standard number formats
  • Hiding cell contents
  • Date formats

Working with dates

  • Using series fill
  • Using dates in formulae
  • TODAY and NOW

Covered if time allows If time

Data validation

  • Setting validation rules
  • Input and error messages
  • Highlighting validated cells
  • Circling invalid data

Covered if time allows If time

Protection

  • How protection works
  • Unlocking cells
  • Turning protection on for a worksheet
  • Protecting the whole workbook

You shouldn't attend this course unless you're already familiar with creating formulae in Excel.

Why Choose Us?

Sample customer feedback

Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).

"Was the only one on the course, so fab 1:1 training. Reviews are very good."

Christine Lee (British Council)

"Very enjoyable, informative, fun and educational. Maintained an excellent level of teaching and professionalism throughout."

Cameron Copeland (ICE Futures Europe)

"It was great."

Dami Matte (HMI Probation)

"Useful content & well delivered. Already had staff attend course, good feedback from them."

Jamie Smith (HMI Probation)

"Good content delivered in an easy-to-understand manner, without over-complicating. Been on previous courses & good experience, so natural progression."

Daniel Gates (ICE Futures Europe)

There are lots more where these came from (or just refresh this page to change the quotes shown).

Scheduled Excel Intermediate training dates

Here are the classroom Excel Intermediate courses we have scheduled for the next 3 months:

Dates Days Venue Price Booking
Monday 30 November 2020 1 £295 Book places
Wednesday 20 January 2021 1 £295 Book places
Tuesday 02 March 2021 1 £295 Book places
Friday 30 April 2021 1 £295 Book places
Friday 11 June 2021 1 £295 Book places
Tuesday 27 July 2021 1 £295 Book places
Date(s) Venue
30/11
20/01
02/03
30/04
11/06
27/07

All prices exclude VAT. If you can't see the dates you want, ask us about running onsite Excel training at your offices (we'll even provide and set up the computers).

Other Microsoft Excel training resources

Excel exercises

Excel exercises

To help you determine if this is the right course for you, we've published all of our Excel exercises online.

View Excel, Excel VBA or PowerPivot exercises

Excel videos

Excel videos

In addition to providing classroom training, we've also created a series of online training videos on Excel.

View Excel tips, Excel VBA - Basics, Microsoft Excel or PowerPivot videos

Excel skills assessment

Excel skills assessment

You can test how well you know Excel by taking one of our skills assessment tests.

View Test your current Excel skills or Test your VBA knowledge skills assessment tests

Excel blogs

Excel blogs

We've published lots of blogs on various aspects of Excel, which make for good reading for when you have a few spare moments.

View Excel, Power BI - Excel or VBA macros blogs

This page has 0 threads Add post