Open the Budget vs Forecast vs Actual v1 Step 3 file and do the following:
1. We now want to set up a report that automatically pulls through the latest month’s information as well as the year to Date numbers for the given month. Go to the Monthly Variance sheet
2. In H11 to H22, create a variance calculation comparing Actual to Budget for now. However, keep in mind the issue regarding negative numbers so the formula must be set up so that if expenses decrease it should show an improvement (positive percentage).
3. Using Conditional Formatting on H11 to H22, create arrows that indicate which costs have improved, worsened or stayed the same
To see the full course contents click here.