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