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
Possible locations:London, Manchester, Online
Next classroom course:Tue 02 March 2021
Time: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
If time
Data validation
- Setting validation rules
- Input and error messages
- Highlighting validated cells
- Circling invalid data
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
- 535 references viewable online
- Free USB stick containing course files
- Genuine Wise Owl trainers only
- Unbelievably good courseware
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).
Nicola Leah (Shell International Trading and Shipping Company Ltd.)
Dami Matte (HMI Probation)
Amanda Wilding (ReAssure UK Services Limited)
Jamie Smith (HMI Probation)
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 |
|---|---|---|---|---|
| Tuesday 02 March 2021 | 1 | Manchester | £295 | Book places |
| Friday 30 April 2021 | 1 | Manchester | £295 | Book places |
| Friday 11 June 2021 | 1 | Manchester | £295 | Book places |
| Tuesday 27 July 2021 | 1 | Manchester | £295 | Book places |
| Date(s) | Venue |
|---|---|
| 02/03 | Manchester |
| 30/04 | Manchester |
| 11/06 | Manchester |
| 27/07 | 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, Power BI - Excel or VBA macros blogs