Creating a table of all combinations in Excel [Video]

Power Query solution

Let’s assume you have three state codes and four department codes and you want to create a table of all the possible 12 combinations (3 x 4). How do you do it so that it is flexible? i.e. if you add a new state or department it must be easy to update the combination table.

How to get CREATIVE! by John Cleese

Brilliant talk!

No slides needed, this was way back in 1991!

This is especially relevant these days because we get so little “think” and “alone” time.

 

 

Where it all began

A great talk by Dan Bricklin the co-developer of Visicalc – the first desktop spreadsheet.

He talks about how game changing spreadsheets were for the desktop computer.

Discover where he was when the idea came to him and how he visualised it.

Decisions he made back then are still with us today.

Horizontal bullet chart in Excel

Excel Yourself article

Check out my follow up article and VIDEO on the ITBDigital website on how to convert a vertical bullet chart into a horizontal one.

Click here for full article and video.

For the original bullet chart post click here

These techniques are based on ones in the great book
Excel 2007 Dashboards and Reports For Dummies by Michael Alexander

Excel Bullet Charts [Video]

Excel Yourself Article

Check out my July 2014 article on Bullet charts on the CPA Australia ITBDigital website – click here to see the article. The video is below.

Bullet charts were developed by Stephen Few – see his pdf on bullet charts click here.

The technique is based on one used by Michael Alexander in his great book Excel 2007 Dashboards and Reports for Dummies by Wiley.

Make your own list – like the months in the year [VIDEO]

A Custom List Can Stop Entries Being Missed

Make Your Own Lists like January, February etc

When you drag a cell with January in it with the fill handle (the small cross at the bottom right corner of the cell), Excel creates a series with February and March etc. This is quick and useful. It also works for days of the week. Eg drag a cell with Monday in it to get Tuesday, etc. This is an example of a custom list.