Microsoft Excel - MasterClass
|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
|Click a date to book:||No upcoming courses|
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.
Module One - Financial Functions
Fv, Pv, Npv, Rate, Pmt.
Module Two - Input 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.
- 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