Excel Training
Intermediate Excel Training Course
£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:Manchester, London
Next course:Thu 08 November 2018
Time:09.30-16.30
Course Contents
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 (AND, OR and NOT)
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 tiltes
- 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
Protection
- How protection works
- Unlocking cells
- Turning protection on for a worksheet
- Protecting the whole workbook
Why Choose Us?
No more than 6 people per class- Proper restaurant lunch included
- 492 references viewable online
- Free USB stick containing course files
- Genuine Wise Owl trainers only
- Unbelievably good courseware
Sample customer feedback
Quentin Harris (NHS North & East London CSU)
Lucy Onyango (PricewaterhouseCoopers Services Ltd.)
Philip Iddon (Sellafield Ltd)
Marcio Franco (Royal Borough of Kensington & Chelsea)
Matt Curley (NHS Digital)
There are lots more where these came from (or just refresh this page to change the quotes shown).
You shouldn't attend this course unless you're already familiar with creating formulae in Excel.
Scheduled Excel Intermediate training dates
Here are the Excel Intermediate courses we have scheduled for the next 3 months:
| Dates | Days | Venue | Price | Booking |
|---|---|---|---|---|
| Thursday 08 November 2018 | 1 | Manchester | £295 | Book places |
| Tuesday 11 December 2018 | 1 | Manchester | £295 | Book places |
| Friday 04 January 2019 | 1 | London | £395 | Book places |
| Wednesday 06 February 2019 | 1 | Manchester | £295 | Book places |
| Friday 29 March 2019 | 1 | Manchester | £295 | Book places |
| Date(s) | Venue |
|---|---|
| 08/11 | Manchester |
| 11/12 | Manchester |
| 04/01 | London |
| 06/02 | Manchester |
| 29/03 | 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, PowerPivot or Excel VBA - pivot tables/charts videos
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
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