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
Convert Formula to Relative or Absolute April 10, 2019
Convert Entire Excel Workbook to Values March 11, 2019
Evaluate with Excel to Extract Sequence March 6, 2019
Extract the First Item from a Horizontal List February 27, 2019
Create Number Sequence with VBA Custom Function January 15, 2019
Protect a Worksheet, Use the Autofilter October 18, 2018
Countifs Across Sheets October 10, 2018
Excel VBA to Select Sheets September 22, 2018
Power BI Desktop Dashboard August 20, 2018
New Excel Dashboard Tools August 1, 2018