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 MasterClass 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 - Financial Functions

Fv, Pv, Npv, Rate, Pmt.

Module Two - Input Tables
One-Input Data Tables, Two-Input Data Tables.
Module Three - Date Functions

Day, Days, Network Days, Networkdays.Intl.

Module Four - Auditing

Tracing Precedent Cells, Tracing Dependent Cells, Cells with Missing Dependents.

Module Five - Date Options

Scenario Manager, Scenario Summary Reports, Consolidate, Advanced Filter.

Module Six - Macros

Macro to Change the Page Set-Up, Macro to Apply a Custom Number Format, Macro to Apply the Advanced Filter, Assigning a Macro to a Button on the Quick Access Toolbar, Assigning a button to a Form Control, Deleting Macros, Creating a simple function using Visual Basic.

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 Advanced course and who wish to gain the skills necessary to use financial functions, create macros, audit and analyse worksheet data 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