MS Office Excel Advanced Training Course (1 Day In-Company)

Overview

By the end of this course delegates will be able to use Microsoft Office Excel’s advanced features to create complex spreadsheets.

Objectives

You will be able to correctly use the Validation feature to control the information that is entered into cells
You will be able to correctly use Templates to speed up your work
You will be able to correctly use the Scenario Manager to create “What If…” based scenarios
You will be able to correctly use Pivot Tables to easily display and summarise data
You will be able to correctly use the VLOOKUP and HLOOKUP functions to simplify your formulas
You will be able to correctly create formulas that contain Partial Absolute cell references to give you more flexibility when copying formula

Who should attend?

Attendees need a good working knowledge of Microsoft Office Excel ideally gained from attending a previous course or be a competent basic user. You must be comfortable with Absolute cell references and the IF function.

Testimonials

Enjoyed the programme and met some great people in the process
Birmingham, Oct 2017

Very thorough, very well conducted and detailed where required
– Edinburgh, July 2018

Brilliant programme, should be rolled out throughout the company

All the training programme was beneficial

Really enjoyed it, as well as getting other peoples opinions, it has given me a focus for moving forward – Thank you!

I’m looking forward to returning to the office with the fresh ideas and developing a stronger team

MS Office Excel Advanced Training Course (One Day In-Company)

In-House Training and Coaching

In-Company Training