Sales Excel Dashboard

An Excel sales dashboard which focuses on quarter and YTD data. It has a slicer and spins on a monthly combo box.

Read More

Excel Timesheet Example

Creating an excel timesheet is easier with a template to start with. This blog post provides the template and the instructions for using it.

Read More

Protect a Worksheet, Use the Autofilter

Protect an Excel worksheet and use the auto filter.  A how to guide.

Read More

Excel Copying Variable Columns with Array

My tassie friend Valario asked another interesting and engaging question.  The question came from the blog post ‘Read Individual Columns to An Array’.  The design of the code was a little bit static so Valerio’s question was as follows.

Another question just to ruin your night!

Read More

Scandinavian Infograpic in Excel

The above infographic is one of my favourites of the Nordic region. It is very simple and yet tells a story about 4 countries in Scandinavia. The Excel infographic has the top 5 companies for each country (Iceland is excluded due to its small size - sorry). It has data on career and staffing data. There is some population metrics, GDP and GDP Growth which is low all around the world as a result of the global downturn after 2008. Let's hope that ends soon.

Read More

Excel Merge Sheets to Master

This article draws on the post from the site which is dedicated to merging worksheets in a workbook into a single master sheet Consolidate Sheets.  This technique can be significantly simplified with a VBA macro.   I have posted this type of reply on forums dozens of times.  Howeve this reply differs just slightly.  The following will consolidate data so the data tables appear side by side in the consolidaiton tab.  So if Sheet 1 appears:

Read More

Starting a Blog

I have been toying with the idea of a blog for some time now.  Fact is my website is too large and the menus have too many items so on most screens the material drops off the page.  I am limited as my choice of website builder does not offer scrolling drop down menus.  It might be for the best as having 50 or more items under one menu is less than ideal. 

Read More