Using Excel for Financial Managers

"Most Financial Managers work with Excel, but few utilise the advanced functions that enable Spreadsheet Automation, Data Sharing and extended Financial Analysis."

This intensive 2-day CBM training course has been developed to introduce financial people to the many ways that Excel can be used as a support tool for the financial function. The course is filled with practical exercises that show delegates how to get the most out of Excel with the least additional effort.

Key areas that will be covered on this intensive 2-day course include:

• Using Excel to take control of financial data and put it into a format that can be used for effective decision making
• Taking advantage of Excel's many specialised features to produce management reports, quickly and easily
• Using Excel's advanced features to import data directly from other systems, sources and applications
• Methods for implementing profit/cost tracking to help identify possible problems before they occur
• Developing projections and trend analysis spreadsheets to assist with management decision making
• Automatic creation of graphs and charts to help illustrate key financial issues and trends
• Writing and using Excel Macro's and Formulae to save time by automatically doing repetitive work

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 advasnced spreadsheets during the course, and experiment with conducting a wide range of financial analysis under controlled conditions.

Please note that the prerequisites for attending this course are a basic knowledge of Excel and Windows, as well as a good understanding of the Financial Function