• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Microsoft Excel Tips and Tricks - Computergaga

  • Home
  • Excel Online Courses
  • Excel Functions List
  • Free Downloads
  • Blog
  • Tutorials
  • About
Home / Dashboards / FIFA World Cup History – Excel Dashboard

FIFA World Cup History – Excel Dashboard

I have created a World Cup history dashboard full of fascinating statistics from the previous 20 world cups.

I find creating spreadsheets involving your passions a great way of developing and testing your Excel skills.

This dashboard incorporates a few different Excel dashboard techniques which are explained in this post.

The spreadsheet is completely unprotected so all the formulas and code can be explored.

Download the FIFA World Cup Excel Dashboard

Creating a Scrollable List

The dashboard uses a scrollable list to scroll through the 19 world cups viewing the host nation, winners and losing finalist.

By using a scrollable list, we ensure that the list does not take up too much space on the spreadsheet. Excel dashboard reports need to display the important information in a limited space.

Displaying Interactive Content

The scrollable list is clickable so that statistics such top goal scorer and average attendance can be viewed about each world cup.

This interactive content has been created using VBA code that is triggered by the worksheet change event.

The code also moves an arrow that is visible to the left of the scrollable list, and used to identify the world cup currently being viewed.

Not hot on Excel VBA. Check out our Excel VBA online course.

Using Data Bars for Top 5 Stats

Data bars have been used for a graphical representation of some top 5 stats. They are used to show the world cups with the most goals scored, highest average goals per game and highest average attendance.

How do I apply data bars?

Controlling a Chart with a Combo box

Two charts are used on the dashboard. One shows stats by country and the other by players. A combo box is supplied to interact with the charts and change the data being presented.

The CHOOSE function is used along with the combo box to serve the correct data to the chart dependent on user selection.

  • World Cup History website
  • FIFA World Cup records Wikipedia page

Related Posts:

  • Entering Fractions in Excel
    Entering Fractions in Excel
  • Import Multiple Excel Files with Multiple Sheets in Excel
    Import Multiple Excel Files with Multiple Sheets in Excel
  • Excel VLOOKUP Trick - No More Counting Columns
    Excel VLOOKUP Trick - No More Counting Columns
  • Excel FILTER Function – The Best Function in Excel
    Excel FILTER Function – The Best Function in Excel

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Popular Posts

  • Excel Fixtures and League Table Generator
  • 5 Reasons Why your Excel Formula is Not Calculating
  • Excel IF Function Contains Text – A Partial Match in a Cell
  • Excel Formula to Display the Sheet Name in a Cell
  • 4 Alternatives to Nested IF Formulas
  • How to Hyperlink to a Hidden Worksheet in Excel
  • How to Create a Reverse FIND Formula
  • Check if a Value is an Even Number
  • Conditional Formatting Multiple Columns – 3 Examples
  • IF Function in Power Query Including Nested IFS

Recent Posts

  • SEQUENCE Function in Excel
  • Sort by Drop Down List in Excel
  • Advanced SUM Function Examples – The Power of SUM
  • Display Negative Time in Excel
  • Lookup Multiple Values in Excel
Advanced Excel Success book

Footer

Contact

[email protected]

Useful Links

  • Home
  • Excel Online Courses
  • Tutorials
  • Sitemap
  • Privacy Policy
  • Jobs by Jooble

Course Topics

  • Charts
  • Courses
  • Dashboards
  • Downloads
  • Excel Tips
  • Formulas
  • Mail Merge
  • Office
  • PivotTables
  • Power BI
  • Power Pivot
  • Power Query
  • VBA

Join Our Mailing List

© Copyright 2020 Computergaga · All Rights Reserved ·