Microsoft Excel - Advanced
Presentation Style: | Tutor-led Classroom Training Course |
Duration: | 1 Day |
Course Time: | 09:30 - 16:30hrs |
Course Location: | Northampton |
Cost: | Public Courses: £175 + VAT per delegate, £150 each + VAT for two delegates on the same day (call for group discounts) Closed Courses: please enquire |
What will you learn on this Microsoft Excel Advanced Training Course?
By the end of this Excel course delegates will have gained skills in how to use the advanced tools and time-saving features, how to automate Excel using macros and have an introduction to Visual Basic within Excel.
Course Content
Module One
Nested IF statements, combining IF statements with 'And' / 'Or', IFERROR
Module Two
Module Three
Pivot tables, types of validation, setup rules, display help and error messages
Module Four
OLE objects and paste special
Module Five
Create, edit and delete templates
Module Six
Overview of macros, record and run a macro, relative and absolute cell positioning, assign macros to buttons
*This course does not cover VBA
Who should take this course?
This course is designed for delegates with Knowledge of Microsoft Excel to a level equivalent to having completed the Microsoft Excel Intermediate course and who wish to gain the skills necessary to create macros, collaborate with others, audit and analyse worksheet data, create pivot tables and pivot charts and incorporate multiple data sources.
Additional Information
- Buffet lunch included and free parking (only for courses held at Paradise Training Centre, Northampton)
- Joining instructions will be sent prior to attending the course
Course Dates
Excel Introduction | 01/05/2018 |
Excel Intermediate | 08/05/2018 |
PowerPoint 2013 Introduction | 14/05/2018 |
Excel Advanced | 16/05/2018 |
Excel 2010 VBA | 21/05/2018 |
Excel Introduction | 29/05/2018 |
Excel Intermediate | 04/06/2018 |
Excel Advanced | 11/06/2018 |
Excel 2010 VBA | 12/06/2018 |
WordPress | 20/06/2018 |
Free PDF Download
Sign-up to get a free Sneak Peek of our 'Excel Introduction' Training Course Manual