This is a series of short presentations about using Excel to solve some interesting data challenges.  Each one comes with a working Excel file that shows some advanced techniques.  We hope this is of interest.  Tell us if there is an example you want to see covered.

Excel #1 – Voting

This example controls voting in an election.  The full spreadsheet can be downloaded from Voting Spreadsheet (it has had to be zipped because this web host won’t allow xlsm files).

Excel #2 – Selecting from a List

This second example extracts a short list of matching items from a long list.  The full spreadsheet can be downloaded from Picker.

Excel #3 – Exploring invoice data

This third example holds a set of invoices and lets the user explore how they relate to each other.  The example spreadsheet can be downloaded from projects (once again it has to zipped so the web site can accept it).

Excel #3a – The theory

This presentation provides a detailed look at the general pattern behind example #3.