Here is a comprehensive walkthrough guide for the August Fantasy Football Challenge provided by two of our faculty fellows, David Brown and Diarmuid Early. The case is available in your ExPrep account. Try it yourself, and if you get stuck, look for the solution in the videos.

WALKTHROUGH VIDEO PROVIDED BY DAVID BROWN
We are getting everyone ready for fall with a Fantasy Football themed challenge. Don’t worry if you’re more into “data huddles” than football huddles – the August challenge is tailor-made for everyone. We’re passing you a dataset that needs a little cleanup before you can lead it to victory in your analysis. You don’t need to be a football aficionado or even a rookie to make some MVP-level data decisions!
WALKTHROUGH VIDEO PROVIDED BY DIARMUID EARLY
Cleaning fantasy football data, using dynamic arrays in Excel.
MEWC
TAC
EEO