Course Aims

For participants to create worksheets for the purpose of calculations for a variety of functions, accounts, price lists, measurements, order pricing etc.

The skills participants will develop will be to

Build and edit worksheets

Format worksheets according to requirements

Use formulae and functions to perform calculations

Create charts and link sheets

The course is for

Anyone who is required to produce financial documents of varying nature or use calculations as part of their role and are keen to use the speed and accuracy of a PC.

Topics covered

Loading excel using the features

Entering information in different formats

Inserting hyperlinks, saving and editing and formatting worksheets

Creating and customising charts

Linking worksheets and calculating across worksheets.

Protecting worksheets using security features

Using excel functions (SUM, Average, MIN, MAX, VLOOKUP etc and formulae

The benefits

Participants will be able to create and use powerful worksheets to manipulate mathematical or financial data for  improved management reporting and other business needs, quickly and accurately to produce effective business data.

Stand Alone module - duration 1 day