In the final video in the series (at least for now!) we look to complete the form analysis and to present it effectively.  We've successfully calculated the number of Ws, Ls, and Ds from the last 6 games for the home team; the next job: to do the same thing for the away team.

How to do that?  There is no need to create any new variables, or to change the code structure significantly.  In the video, I show you how to get this job done quickly using an existing variable, with only a minor change to the coding.  That's what happens when you design VBA routines with scalability in mind: you can quickly adapt them and scale them up.  We also introduce the code to give us the 'average points over the last 6 games' - a useful measure of recent form, in a single cell.  Awesome!

With the main job now complete, how can we improve the presentation of the analysis?  We use normal cell formats to create a 'professional look', and implement some cool conditional formatting too.  At the same time, we discuss the pros and cons of conditional formatting whilst learning how to use the conditional formatting rules manager to achieve control.

Tools And Techniques

'- .Cells referencing technique
- Scaling up a VBA routine
- Application.worksheetfunction
- VBA Round function
- VBA Format function
- Cell formats for a professional look
- Conditional formatting
- Conditional formatting rules manager