Course Objective:

To equip participants with certain vital skills and tools for building a system in Excel for effective Trend Monitoring, Forecasting and Budgetary Control

Course Outline:

• Applying the Applied-Excel® Core Courses to Design and Develop a Trend Analysis System

• Extraction of Monthly and Quarterly Trend of all items and Charting

• Extraction of Monthly and Quarterly Trend on item by item basis and Charting

• Incorporation of Budgetary Control System and Variance Analysis

• Automatic Alertness of the potential occurrence of Unfavourable Variances using

               Conditional Formatting

• Expansion and Troubleshooting