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:Fri 08 November 2019
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
- 546 references viewable online
- Free USB stick containing course files
- Genuine Wise Owl trainers only
- Unbelievably good courseware
Sample customer feedback
Nicola Leah (Shell International Trading and Shipping Company Ltd.)
Christine Lee (British Council)
Dami Matte (HMI Probation)
Daniel Gates (ICE Futures Europe)
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 |
|---|---|---|---|---|
| Friday 08 November 2019 | 1 | Manchester | £295 | Book places |
| Date(s) | Venue |
|---|---|
| 08/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 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