Course Summary
Our Microsoft Excel Advanced course is a highly practical and interactive tutor-led session delivered by highly experienced Microsoft Certified Trainers. Delegate numbers are kept low to ensure individual support can be given to each participant. Courses can be delivered on your premises on dates that suit you or you can complete the course at one of our public courses in London or Bristol.
Course format
Classroom based learning delivered by highly experienced Microsoft Certified Trainers. Very interactive session with plenty of hands on, applying new learnt skills throughout the day with exercises.
Manual provided and unlimited support after the training, backed up with a Certified Certificate at the end of the session.
Private course:
- On your premises – anywhere throughout the UK or Europe
- Dates to suit you
- Maximum number of delegates 8 to ensure dedicated individual attention when required
Public Course Dates (Bristol & London):
- Tuesday 2nd April
- Wednesday 3rd July
- Thursday 7th November
- Thursday 19th December
Laptops can be provided, or you can bring your own, refreshments provided throughout the day and a lunch.
Course content – overview
- Short overview of intermediate topics
- Named Ranges
- Lookup Functions – VLOOKUP, MATCH, INDEX, INDIRECT
- Advanced Functions – OFFSET
- Date and Text
- Data Validation
- File Linking
- Protection
- Consolidation
- Macros
- Goal Seek, Using Solver and Goal See
Outcomes
On successful completion of the course, delegates will be able to create and apply names ranges, understand Lookups, solve problems by using Goal Seek, record macros and assign to buttons and link objects between different applications.
What our delegates have to say
"Very Informative." - Owen
"Kam was friendly, really helpful and informative." - Denise
"Well done to Caroline, brilliant course, learnt loads." - Angus
"Great course - informative and engaging." - James
"Very good and useful. Refreshed my knowledge on excel and gained new skills."
How to book your space
Interested in booking a space on one of our Microsoft Excel Advanced courses or want to find out more details? Fill out our “Register Interest” form we’ll get back to you as soon as we can with further information. Or call us today on 01454 203 355.
