Excel for Financial Management

 

Course overview

Financial literacy alongside relevant digital technological expertise have become a must have for most financial professionals. Thus, Excel is a program that most professionals pick up as they go along, the result being a basic level of competence that is sufficient for “getting by”. However, organisations are increasingly expecting more. Excel for Financial Management is a course that provides practical, hands-on training on Excel’s features and functions, which will enhance your efficiency in the workplace and your value to the organisation. This course also assumes familiarity with the basic techniques covered in the Microsoft Excel for Beginners’ course:

Who should attend the course?

This course is primarily designed for the following target group in mind

  • This program is ideal for people working in accounts teams, finance-related roles as well as people with investment banking roles, looking to extend their knowledge of excel in a financially driven context.

Course objectives

At the end of this course, Participants will be able:

  • Gain best practice techniques in pulling financial information into Excel, common pitfalls to avoid when using key financial functions and some useful presentation tips.
  • Award the opportunity to use example financial statements such as cash-flows and look at common size statements.

The Learning Model

The trainer uses up-to-date training techniques and a variety of training methods, to give all participants the
best opportunities for learning including:

  • Class session
  • Group discussions
  • Simulations exercises
  • Case studies and problem solving exercises
  • Individual assignments
  • Templates and tools

Course Contents

  • Introduction to Excel course
  • Setting up a Financial Worksheet
  • Conditional formatting to analyse data
  • Working with data
  • Cash flow spreadsheets
  • Financial Functions
  • Reviewing Financial Statements
  • Spreadsheet Debugging Skills
  • Analysing the Output

2019
Course Calendar
Dates

21 – 22 Mar

25 – 26 Apr

23 – 24 May

20 – 21 Jun

25 – 26 July

22 – 23 Aug

26 – 29 Sept

24 – 25 Oct

28 – 29 Nov

Share this course

 

Cost: R 5 000

 

Interested in a custom programme?
Beginning with the content of our existing offerings, we’ll work with you
to create a program tailored to address the challenges of your organization.

Looking for more?

Let us follow up about more details about this program.