Charts - aren't they great?  Nothing tells the story of the data better than a beautiful visualisation in Excel.  But, they can be tricky to create.  In this video, I argue the key to easy chart creation is actually properly prepared data.  With this in mind, we learn a supremely powerful Excel formula (and one of my Excel 'secret weapons') to analyse the simulated dataset.  With this formula set up, chart creation is relatively easy.

It's a tough session so take your time, and don't forget to download the Excel files and try the technique out for yourself.  I'm absolutely sure you'll use these techniques in your data analysis in the future ...

DAY 2: Learning Outcomes