Course Aims

For participants to use advanced techniques to analyse financial data for business purposes for planning and forecasting.

The skills participants will develop will be to

Build complex worksheets using excel functions

Analyse business data

The course is for

Administrative, finance and support staff, business owners and managers who would benefit from quick and effective financial data reports to enable them to make business decisions.

Topics covered

Using excel functions (SUM, Average, MIN, MAX, VLOOKUP etc)

Use pivot tables

Use Goal Seek to forecast

Using Solver for financial problem solving

Create scenarios using scenario manager to test 'What if' hypotheses

Using Macros in worksheets

The benefits

Participants will be able to create and use worksheets that will provide financial analysis at any time not just year end, and far more extensively than previously, to aid in management decisions.

Stand Alone module - duration 1 day