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.
Virtual training available.
-
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-company, Virtual Training and Coaching
Preferential rates!
In-Company Training
From £975.00 + VAT
INCLUDES: Expert Trainer – Tailored One Day Course for up to 6 people