The role of managers in companies today is expanding. The program MS-Excel is used by many departments, but most users only “scratch the surface” of the many ways Excel can be used to perform analysis.

This intensive 2-day course has been developed to introduce managers to the many ways that Excel can be used as a support tool for management decisions. The course is filled with practical exercises that allow delegates to find out how to get the most out of Excel with the least additional effort.

Course Outline

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.

Learning Outcomes

Set up Excel databases and pivot tables to effectively use the same data for different purposes

Utilise Macros and advanced functions to save time when manipulating data and setting up reports

Develop projection and trend analysis spreadsheets to assist with management decision making

Understand how to import data directly from other applications to make a wider range of information available for analysis

Conduct profit and cost variation, sensitivity and margin analysis to help highlight problems before they occur

Manage risk by checking the effect that external factors (such as inflation) may have on costs, profits and results