An Excel dashboard about the UK general election 2015

Hello Excel-folks, today I want to share with you a nice informative Excel dashboard that I created for the UK general election on May 7th. I focused on the main 7 parties (those ones that appeared on the ITV debate). See how the dashboard looks like in a few screenshots:

The Excel dashboard about Real Madrid Tenth Champions League win 2013/14

Hello Excel fans. Today I would like to mix two of my passions. As you all know I love Excel, but I also love football and am a supporter of Real Madrid. Although it is best to have the full story so that everybody understands. My whole family are Atletico Madrid supporters, in fact I was born as an Atletico fan and I remember going to the Vicente Calderon when I was little, but when I was 5 years or so I changed my team and I became a fan of Real. Why? Because my favourite player was playing for Atletico and then he signed for Real, and I followed him.......   Who is he? The incredible Hugo Sanchez. I was so passionate about how he played and his somersaults as goal celebration, and besides, I also played football with the number 9. Anyway, so today I consider myself a fan of Real Madrid but I still have much appreciation to Atletico. So, back to Excel, I have decided to create a small tribute to Real Madrid for the achievement of the Champions League win last year: the Tenth European Cup, and everything will be done in Excel. So even if you are not Real Madrid supporter or do not even like football, check the dashboard and I am sure you will find it interesting.

First let's see how it looks:

Welcome to Malta - a dashboard in Excel about this beautiful island

Hello everyone. I guess most of you do not know that I live in Malta. I live in this beautiful island since September 2014. To celebrate my adventure and try to convince my friends to come and visit, I have created a dashboard in Excel about the island. The dashboard runs smoothly in Excel 2007, 2010 and 2013. Other versions have not been tested.

And what is a dashboard?

Drop-down lists in Excel

The drop-down list in Excel is a powerful tool that simplifies the process of choosing values ​​for the user. It is a technique widely used in which we can create lists that have the source data located on another sheet in Excel, which are hidden from the main sheet.

In this post we will look at two ways to create a drop-down list, first using data validation and then using the form control option.

1. Drop-down list with data validation