Accountants and Financial Managers are today faced with an expanded range of responsibilities. Their function is becoming more strategic and as such, they cannot spend an inappropriate amount of time each month consolidating financial data during financial report and statement generation.

This highly practical and intensive course will demonstrate how the MS-Excel program can be used effectively for: Data Collection, Consolidation, Manipulation, Assimilation and Distribution. A good working knowledge of Excel is therefore a pre-requisite for this course!

By attending this two day course you will learn how to:

• Use Excel exclusively to generate all your monthly reports
• Develop dynamic reports that you can use to present to non-financial managers/directors that are easy to understand and navigate
• Develop a complex data warehouse that will store and manage all the data you require
• Prepare consolidated “ad hoc” reports quickly and easily in Excel using a wide choice of report criteria
• Add notes to your financial statements that provide explanation and assistance to the reader
• Easily create detailed graphic reports that support and enhance your financial data

This two day course, which incorporates many actual exercises and demonstrations, will ensure that you return to your office with practical know-how that will allow you to save a significant amount of time and effort each month.

PLEASE NOTE THAT A SOUND WORKING KNOWLEDGE OF EXCEL AND A GOOD UNDERSTANDING OF THE FINANCIAL FUNCTIONS ARE PREREQUISITES FOR THIS COURSE.

Who will benefit from attending this course?

• Financial Managers, Management Accountants
• Cost Accountants, Works Accountants, Project Accountants
• Account Assistants