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



By the end of this course delegates will be able to use Microsoft Office Excel’s advanced features to create complex spreadsheets.
  • 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
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.

In-House Training and Coaching

We can come to you!

Print this page

In-Company Training

From £975.00 + VAT

INCLUDES: Expert Trainer – Tailored One Day Course for up to 6 people