HR

Financial Skills Courses

CBM Training provides a variety of financial skills courses ranging from beginner to advanced level, and courses for financial professionals as well as non-financial professionals.

Using Excel for Advanced Financial and Business Analysis

Using MS Excel for Financial Modelling and other Financial Analysis Functions

In business, every decision has an impact on the overall performance of the organisation. To ensure success it is vital that you are able to manipulate and analyse large amounts of data effectively and efficiently, and this requires you to be highly proficient in MS Excel. This highly practical and intensive course will demonstrate how MS Excel can be used effectively for Data Consolidation & Manipulation, Financial Modelling, Scenario Analysis as well as creating professional Reporting Dashboards containing vital business data, forecasts and projections.

The ever-changing business environment has made it more important than ever for business professionals to accurately forecast volatile economic inputs.  Being able to better analyse financial data, predict revenues and costs and assess risks to justify business decisions will give your organisation the best chance of success in today’s competitive environment.

This course is aimed at Financial Managers and other business professionals who need to develop their understanding of MS Excel to better analyse the financial drivers of their business, and understand the impact that business decisions can have on an organisation’s financial performance.

NOTE: At least 2 years’ experience working with Excel in a financial function is a pre-requisite for this course

Your comprehensive programme includes:

– Easily monitoring financial performance by implementing best practice for creating spreadsheets that track profit and cost variation, sensitivity and margin analysis.
– Understanding the most common uses of Financial Modelling, and how to develop models to enable you to make better business decisions
– Streamlining your data management, importing and analysis process by using advanced features such as DDE and OLE to link data from a variety of sources
– Learning to write Macros that will enable you to regularly perform complex multi-stepped tasks in a fraction of the time
– Introducing some of the advanced Excel Formulas that you will find you can’t live without
– Creating powerful Pivot Tables that will enable you to analyse data for trends and make more accurate forecasts
– Mitigating risk and making better business decisions by learning various approaches to “What-If” analysis that will enable you to play out a variety of financial scenarios
– Using “Regression Analysis” and “Smoothing Techniques” to create practical business forecasts and projections that will lead to better business decisions
– Creating easy-to-read reports using dashboards and charts that link back to the business analysis objectives

Do you have 8 or more delegates and want to run this course Onsite?

Click here to request a quote and get more information about our onsite training.


REGISTER

Dates

4-5 March 2019 (JHB), 7-8 March 2019 (DBN), 14-15 March 2019 (CPT)

Duration

2 Days

City

Johannesburg, Cape Town, Durban

Venue

The Riverside Hotel (Durban), Corporate Conference Centre (Dowerglen), The Peninsula Hotel (Cape Town)

Price R5,975.00 excl. 15% VAT

R5,975.00 excl. 15% VAT

PLEASE SELECT OPTIONS TO CONTINUE

Clear
Your Booking
Courses in your City
show blocks helper

Price

Product categories -

Product City

Onsite Enquiry Form:

Complete the form below and our onsite team will be in touch with you shortly.

Please prove you are human by selecting the Flag.

PDI Scholarship Application Form:

 


Personal Details:

Previously Disadvantaged Individual (PDI) Group: Black: AfricanBlack: ColouredBlack: IndianOther


Company Details:

Please prove you are human by selecting the Star.