Using Excel for Financial Managers
MS Excel is used by many financial departments, but most people only use a fraction of the many ways Excel can be used to perform financial analysis.
This intensive course has been developed by an experienced Financial Manager and Consultant, to introduce financial people to advanced ways that Excel can be used as a support tool for the financial function.
The course focuses on the practical financial applications of MS Excel, and even the most advanced Excel user will be amazed at the extra functionality that they will get out of Excel with the least additional effort.
Key learning areas covered during this course include:
Setting up Excel databases and pivot tables to effectively use the same data for different purposes
Developing projection and trend analysis spreadsheets to assist with management decision making and managing external factor risk
Understanding how to import data directly from other applications to make a wider range of information available for analysis
Conducting profit and cost variation, sensitivity and margin analysis to help highlight problems before they occur
Setting up spreadsheets to reliably estimate ROI, cash flow and liquidity into the future, to assist in investment decision making
Utilising Macros and Functions to save time and automate tasks
Time: 09:00 - 17:00
Venue: Corporate Conference Centre, Johannesburg
Cost: R7,350 Excluding VAT
Date: 18 February 2014 to 19 February 2014
Time: 09:00 - 17:00
Venue: Belmont Square Conference Centre, Cape Town
Cost: R7,350 Excluding VAT
Date: 20 February 2014 to 21 February 2014
Time: 09:00 - 17:00
Venue: Sicas Guest House, Durban
Cost: R7,350 Excluding VAT
Date: 13 May 2014 to 14 May 2014
Time: 09:00 - 17:00
Venue: Corporate Conference Centre, Johannesburg
Cost: R7,350 Excluding VAT
Date: 12 June 2014 to 13 June 2014
Time: 09:00 - 17:00
Venue: Belmont Square Conference Centre, Cape Town
Cost: R7,350 Excluding VAT