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 or Target Control System

Automatic Alertness of the potential occurrence of Unfavourable Variances using Conditional Formatting

Expansion and Troubleshooting