This is my latest Excel Dashboard. It outlines social media activity, visits to pages, likes, retweets. The dashboard focuses mainly on Pinterest, Facebook, Twitter and Google +.
The Excel spreadsheet spins on a slicer and is broken down by geographic region but has the detail by country. It has text boxes which dynamically update on the back of the slicer selection.
The social media Excel dashboard is attached to show workings.Read More
The dashboard tracks incidents by year and by cost. It is only a small dashboard but has stacks of functionality. The chart on the far left is achieved through a smart Excel formula called the REPT funcion. It will repeat formula a set amount of times.
If I was to write the word Car in A1 and 3 in B1, the following formula
I have been quiet on my blog of late. Been busy preparing courses and webinars for the year. This morning a put together a fresh dashboard for the site. The Excel dashboard has a consistent feel and I have used 3 years as an example. It spins on the option buttons in the top right. It is only a very small dataset but works nicely. The staffing by state chart works nicely.
I will attach the file to show how the Excel dashboard is put together.Read More
While going through some road traffic information on the Department of Transport's website it occurred to me that the data was perfect to create a dashboard. It was information rich and there were very little gaps in the data. I decided to use quite a few pictures in conjunction with the charts to try and spice them up. I have used actual data but had to ‘normalise’ some of the data as there were a few gaps.Read More
XLookup to the Party August 31, 2019
Populate a Userform with VBA August 14, 2019
New Dashboard Ideas August 9, 2019
Excel Custom Sort August 7, 2019
Excel VBA Remove Duplicates Multiple Columns August 6, 2019
The Tennis Chart July 17, 2019
Smallman Interview July 15, 2019
Excel Summit South 2019 July 12, 2019
Sales Excel Dashboard June 14, 2019
Using the Wildcard with SUMPRODUCT May 30, 2019