Advanced Microsoft Excel 2003

Overview

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

Who Should Attend?

Attendees need a good working knowledge of 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.

Benefits To You & Your Organisation

• 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

We will provide a trainer who is certified by Microsoft and a member of the IITT.

Upto six laptops are provided for each in-house training course to ensure your staff have an interactive and hands on IT training experience.

 

To proceed simply email us at info@ripleytraining.co.uk or call us on 01423 861122 to agree your preferred date(s).