Microsoft Excel - Advanced
|Presentation Style:||Tutor-led Classroom Training Course|
|Course Time:||09:30 - 16:30hrs|
|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.
Nested IF statements, combining IF statements with 'And' / 'Or', IFERROR
Pivot tables, types of validation, setup rules, display help and error messages
OLE objects and paste special
Create, edit and delete templates
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.
- 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
Free PDF Download
Sign-up to get a free Sneak Peek of our 'Excel Introduction' Training Course Manual