Excel Dashboard: Premier League Season 2014-15 Visualized

I was never into sports. I tried my hands at a number of sports, but I was always below average in most of it (you got to give me some credit for trying at least).

In 2010, my roommate got me addicted to watching football. We would keenly follow all the matches in English Premier League and La Liga.

I even played fantasy football with a couple of football junkies. I still follow these matches and I still suck at playing it. 🙂

But I am better at making dashboards, and in this tutorial, I will show you how to create an Excel Dashboard that analyses English Premier League games of the 2014-2015 season.

Here is how the final dashboard looks like:

Excel Dashboard - EPL

Excel Dashboard – EPL Season 2014-15 Visualized

How to use this Excel Dashboard:

  • Use Scroll bar to change the week number.
    • Note that as you change the week number, it shows the games played it that selected week and the ranking of the teams at the end of the week.EPL Excel Dashboard - Change Week Number with Scroll Bar
  • Double click on the game result cells to get the detail for the game.
    • As soon as you double click on the cells that have the game results, the match statistics update along with the logo of the clubs. It also shows the total win/loss numbers of both the teams for the entire season. For example, if I double-click on a game of Chelsea, it would show only 3 lost games for Chelsea (in red colour bar in the win/loss chart).EPL Excel Dashboard - Double click to show game details
  • Click on the help icon to show instructions. Click on it again to hide the instructions.EPL Excel Dashboard - Click to show help instructions

Download the Premiere League Excel DashboardDownload File Pic

Learn to Create World-Class Dashboards in Excel. Join the Excel Dashboard Course.

Where did the data come from?
What all goes into making this dashboard?

Are you a football fan too? Do you like it? Let me know your thoughts by leaving a comment.

Download the Premiere League Excel DashboardDownload File Pic

Other Excel Dashboard Tutorials:

Learn to create Killer Excel Dashboards

Dashboard Course banner in post

If you want to learn to create world-class Excel Dashboard, consider joining our Dashboard Course. Click here to know more about the course.