This intensive, hands-on course demonstrates, through numerous practical examples, how utilising the features of MS Excel can increase the efficiency of Financial Managers in the Public Sector.

Delegates will learn how make use of MS Excel in ways that are particularly relevant to the Public Sector, such as: effectively controlling expenditure budgets, optimising budget usage, generating accurate and useful financial reports, monitoring over or under-spending as well as providing better information for investment decision making

During the intensive 3-days, delegates will learn to:

• Monitor expenditure budgets effectively by using Excel’s features to help recognise and correct misallocations
• Set up special reports that highlight over or under-spending in time to take remedial action, ensuring that your department remains within their budgets
• Avoid repeat work by setting up Excel Databases and Pivot Tables to effectively use the same data for different purposes
• Understand how to Import data directly from other applications to make a wider range of information available for analysis and manipulation
• Free up more time by learning how to effectively set up Financial Macros, use Function Wizards and take advantage of other advanced functions in MS Excel
• Automate the generation of reporting formats which will enable you to monitor whether delivery has actually taken place where money has been spent
• Develop financial projection and trend analysis spreadsheets to assist with management decision making and managing external factor risk
• Set up spreadsheets to reliably estimate ROI, Cash Flow and Payback time to assist in Investment decision making and Risk Management

The course has been developed and is delivered by an experienced Financial Manager and Consultant, and focuses purely on the practical applications of Excel that can be used in everyday work.

Each delegate will have the opportunity to set up advanced spreadsheets during the course, and experiment with conducting a wide range of financial analysis under controlled conditions.

Residential Course Information

You can also attend this course as a residential event. Our exclusive Guest House adjoins our dedicated Conference Centre, providing a seamless and easy solution to all our out of town delegates wishing to attend our training courses. You won’t have to worry about traffic, interruptions from the office or finding your way to and from the training venue. All you need to focus on is the course content – making sure you get maximum value for your training investment.

Our up market guest house – Glendower View Guesthouse – sports the most luxurious finishes – each en-suite room has its own work station, Wi-Fi and DSTV television. There is a sitting room for relaxed get-togethers with our delegates and a beautifully appointed dining room for meals.

Residential delegates will book into the guesthouse the night before the training starts, and leave for home on the last day of the course.

The residential course prices for this course, including all meals, accommodation and flights and transfers if applicable are as follows:

• Residential Course Package (Own Travel)
  Residential Course Price R9, 850 ex VAT
• Course Package including flights from Durban
  Residential Course Price incl Travel/Flight: R10, 950 ex VAT
• Course Package including flights from Cape Town
  Residential Course Price incl Travel/Flight: R11, 450 ex VAT