Task 5: Calculate the Changes in Sales Performance 

In this task, you will calculate the changes in sales performance by comparing current and historical sales performance data using a macro and applying Excel formulaes with cell referencing. To achieve this, you will need to perform a series of Excel formulaes and functions using the Current Data and Last Year’s Data ranges as specified in the Project Brief. 

5.1 Analyse performance change using macros 

R 1. in the Template, implement Function 3 as per the Project Brief’s requirements: 

• test the macro button and all other functionalities for accuracy 

• output must conform to the Style Guide standards 

R 2. save and store the Template in accordance with organisational requirements. 

5.2 Highlight over performing and underperforming products 

R 1. in the Change Analysis range, implement Function 4 as per the Project Brief’s requirements: 

• test the results of conditional formatting for accuracy 

• output must conform to the Style Guide standards 

R 2. save and store the Template in accordance with organisational requirements 

R 3. request feedback from the Sales Manager (Assessor) on the draft Template 

R 4. after the receipt of this feedback, modify your draft template in light of the feedback received.

Appendix