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
Text to columns, Left(), Right(), Mid(), Len(), Upper(), Proper(), Lower(), Trim(), Concatenate cells
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