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 the red color 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 Premier 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 Premier 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.

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

15 thoughts on “Excel Dashboard: Premier League Season 2014-15 Visualized”

  1. Dear Sumit. Congratulations with this wonderful example of creating a visual beautiful dashboard. Could you tell how the displayed “Loss/Win chart” could be changed into “Win/Loss chart” (= just as title in dashboard specifies)? I believe somehow data isn´t displayed correctly. Thanks for claryfying.

    Reply
  2. Would love to download this but I’ve tried on a couple of PC’s and it takes me to a page of ‘code’

    Reply
  3. Hey i like your work its informative and very visual also i do love to learn as much as i can from you. but i have a couple of ideas and models i have been using in soccer prediction and if you don’t mind can we discuss that?

    Reply
    • Thanks for dropping by Ben.. Glad you like the dashboard. I used VBA for 2 things:

      1. Update game stats when you double click on the game (from the list on the left)
      2. Show/Hide help when you click on the orange icon on the top right

      Reply
  4. give a person a fish and he eats today, teach them to fish and they can feed themselves
    i thought it would take forever to discover your “magic”
    a little time and “like a blind man i picked up my hammer and saw”
    i will have to find time for your Dashboard course when i retire in at year-end
    the “magic” is simple and teachable

    Reply
    • Thanks for commenting Gary.. Glad you like the dashboard.. This skill is easy to acquire. All you need is the right set of nuts and bolts (or hammer and saw if you prefer that)

      Reply
  5. This makes my head hurt thinking of the possibilities.
    I have futbol die-hard friends and they are having kittens over this.

    Reply
  6. Amazing.. Very innovative. I really like the way it shows the instructions for help.. Would love to see player level data in this as well

    Reply

Leave a Comment

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free Excel Tips EBook Sumit Bansal

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster