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
Next course:Mon 13 January 2020
Time:09.30-16.30
Course Contents
The content 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 (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 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
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 6 people per class- Proper restaurant lunch included
- 509 references viewable online
- Free USB stick containing course files
- Genuine Wise Owl trainers only
- Unbelievably good courseware
Sample customer feedback
Cameron Copeland (ICE Futures Europe)
Nicola Leah (Shell International Trading and Shipping Company Ltd.)
Dami Matte (HMI Probation)
Christine Lee (British Council)
Jamie Smith (HMI Probation)
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 Excel Intermediate courses we have scheduled for the next 3 months:
| Dates | Days | Venue | Price | Booking |
|---|---|---|---|---|
| Monday 13 January 2020 | 1 | Manchester | £295 | Book places |
| Monday 02 March 2020 | 1 | Manchester | £295 | Book places |
| Friday 08 May 2020 | 1 | Manchester | £295 | Book places |
| Thursday 02 July 2020 | 1 | Manchester | £295 | Book places |
| Thursday 03 September 2020 | 1 | Manchester | £295 | Book places |
| Tuesday 03 November 2020 | 1 | Manchester | £295 | Book places |
| Friday 04 December 2020 | 1 | Manchester | £295 | Book places |
| Date(s) | Venue |
|---|---|
| 13/01 | Manchester |
| 02/03 | Manchester |
| 08/05 | Manchester |
| 02/07 | Manchester |
| 03/09 | Manchester |
| 03/11 | Manchester |
| 04/12 | 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 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