Classroom Training

Intermediate Excel

Classroom training course - online version also available

£550 + VAT for most venues (£695 + 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

Possible locations:London, Manchester, Online
Next classroom course:Fri 17 June 2022
Time:09:30-16:30

SCHEDULED DATES Course Contents - PDF

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?

No more than 5 people per class
Proper restaurant lunch included
478 references viewable online
Free USB stick containing course files
Genuine Wise Owl trainers only
Unbelievably good courseware

View full list of benefits

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).

"I found everything relevant and useful. Some bits I already knew but it was good to get a refresher. Our trainer was extremely patient and had a way of explaining things that made sense to all on the course. I was always fearful of having to use excel but this course has made it much less scary. Thanks again."

Maxwell Brown (Greater Manchester Combined Authority (GMCA))

"I found the course very informative, really useful and overall excellent. I was looking for a course that covered the areas that I need to create charts etc and this was the best one for my ability at the moment. Once I get more confident using PBI I will be looking at the other courses."

Shirley Grayson (Salvation Army Housing Association)

"Really appreciate the accompanying manual for future reference."

Callum Walker (Cheshire East Council)

"Really engaging session with a brilliant trainer who helped throughout."

Kate Lawler (Greater Manchester Combined Authority (GMCA))

"The trainer taught the course well and I felt comfortable asking questions and he was always available to help - good teacher!"

Neil Barnes (e-foods)

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
Friday 17 June 2022	1	Manchester	£550	Book places
Tuesday 05 July 2022	1	Manchester	£550	Book places
Tuesday 13 September 2022	1	Manchester	£550	Book places
Monday 14 November 2022	1	Manchester	£550	Book places

Date(s)	Venue
17/06	Manchester
05/07	Manchester
13/09	Manchester
14/11	Manchester

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

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

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

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

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

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, PowerPivot or VBA macros blogs

This page has 0 threads Add post