Social Media Dashboard in Excel

This is a social media dashboard created in Excel.  It is free to download and has all of the graphs and source formula in the file.

Read More

More Dashboard Updates

This is a post about updates to the Excel Dashboard section of the smallman site.

Read More

Excel Dashboards Essential Updates

This Excel dashboard displays revenue and expense metrics with some additional KPI data.  

Read More

Social Media Dashboard in Excel

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

Incident Tracking Dashboard

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

=REPT(A1,B1)

Read More

Excel Dashboard by Department and Region

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

Road Traffic Statistics in Excel

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