Excel: What would we do without it!

Johnny Bradley @JohnnyBrad1ey

When I started on my Performance Analyst journey back in 2005, the landscape was different. YouTube had just been founded, Microsoft launched Windows XP, the highest capacity hard drive you could buy was 500 GB (which weighed a tonne BTW and cost a fortune). We have come such a long way. The job tasks that took 3 hours in 2005 now take just a matter of minutes.

One element that has remained constant in my workflow has been Excel.

Excel is the ‘good old reliable’. It is not expensive, and it’s still the backbone of my day to day work as an analyst. I use it to collect, analyse and visualise data. I know it is not perfect. I have a love/hate relationship with it. There have been times when we have had our arguments, and we haven’t talked for weeks. But you always come back! When it works, and you achieve what you want to achieve, there is no better feeling.

Given the fact that we have created this online community, I wanted to share some of the formulas that I have used over the years. I believe these will help you make better use of your time, create better workflows and ultimately deliver a better message. Instead of trying to explain through text I thought I would be innovative and create a video.

So, if you can’t understand my Northern Ireland accent I apologise, just email me, and I will send you a transcript.

Enjoy,

JB

Excel File:  Simple Dashboard

Author: Johnny Bradley

Johnny is a highly experienced performance analyst who has worked with elite athletes from a wide range of sports at numerous major championships. Johnny was Performance Analyst at the Sports Institute Northern Ireland for 10 years before moving to work as a lecturer in Sports Performance Analysis at Institute of Technology in Carlow. He has provided support to elite athletes from a wide range of sports including hockey, triathlon, rugby union, gaelic football, hurling, netball and swimming.