Microsoft Excel Tips and Tricks - Computergaga

Home / Archives for Dashboards

3 Awesome World Cup 2018 Trackers

With the FIFA World Cup 2018 starting tomorrow, excitement is reaching fever pitch. In this blog post, are three awesome World Cup 2018 trackers to choose from.


With these trackers you can easily follow the World Cup as the results come in, and improve your Excel skills at the same time.


I have an online course in how to create automated sports league tables. And these World Cup 2018 trackers utilize some of the skills I cover in that course.


So check them out, enjoy the football, and look under the hood of the spreadsheets to see how they work.

[Read more…] about 3 Awesome World Cup 2018 Trackers

Excel Doughnut Chart to Measure Progress to a Goal

An Excel Doughnut chart is a very popular way to measure progress towards a goal or target. They are simple to understand, appealing to the eye and familiar to users.

You see Doughnut charts being used to show progress in the news, in business reports and even when your computer is loading or refreshing.

Well the good news is that they are also extremely easy to create.

Watch the Video

[Read more…] about Excel Doughnut Chart to Measure Progress to a Goal

Create a Geographic Heat Map in Excel – FREE Add-in

In this blog post, we create a geographic heat map in Excel using a cool free Excel add-in. This add-in is extremely easy to use, meaning you can have an awesome looking geographic heat map on your Excel report in minutes.

The image below shows the data being used for this example. I have a list of countries and a number of online training subscribers.

This data has been plotted on an image of a world map using a red to green colour scheme.

Geographic heat map in Excel

Watch the Video

Keep reading for the step by step instructions or watch this video as it walks you through the process.

[Read more…] about Create a Geographic Heat Map in Excel – FREE Add-in

Create a Searchable Drop Down in Excel – Just Like Google Search

This blog post will take you through the steps to create a searchable drop down list in Excel – just like Google search.

This is a great Excel trick for working with large drop down lists.

In this tutorial we will use a list of 87 names that as we type into the drop down list, it searches the names, and the list shortens to show only those names containing that string of characters.

Completed searchable drop down list in Excel

There are a few formulas to write to get this searchable drop down list in Excel created. Everything is shown and provided in this tutorial. If you prefer a video. Check out the video tutorial below.

Watch the Video – Searchable Drop Down List in Excel

[Read more…] about Create a Searchable Drop Down in Excel – Just Like Google Search