Fun Downloads

Below is a collection of stuff I've made in Excel.  Email if you have questions.  Also, if you like what you see -- or, if you have have suggestions, feedback, comments, etc. -- leave a comment and let me know!  

Periodic Table of Elements

Read more and downloadt here.

Healthcare Dashboard

This is a fully-loaded dashboard loosely based on the World Health Organization's (WHO) study comparing healthcare systems from across the world.  The data are not real, however.  What it borrows from the actual WHO study are the five health-care metrics and weighting scheme.  

This dashboard demonstrates many important functionalities including:

- One Way Sensitivity Analyses (my "Easy Sensitivity Analysis" no VBA version) 

- Creating a scrollable table with the MSFORMS scrollbar control

- Interactivity and automatic updating

- Drilling down content into smaller charts

Downloads

Version 1 - Healthcare Dashboard

Version 2 - Healthcare Dashboard (you may find this one to be a bit easier to follow my work)

Tornado Dashboard

Another great dashboard.  Inside you'll see the ability to highlight different years to find out more information for that year.  Additionally, I demonstrate the use of in cell bar charts.  

Download: 
Tornado Dashboard

Snakey 

Snakey is a fun take on the rollover technique described on this blog.

See Also:
Rollover B8 OV1
Edit Button, Please

Download

Snakey

Sketchpad

Sketchpad is a silly program that will take pictures drawn in Excel and turn them into Bitmaps.  It's good for drawing icons but for not much else.   

See Also:

Turn an Excel Spreadsheet into a Bitmap Image

Download

Sketchpad

Bitmap to Excel

Bitmap To Excel allows you to use your spreadsheet as a canvas for a bitmap image.  It's good for wasting time at work but for not much else.  

See Also:
Turn an Excel Spreadsheet into a Bitmap Image







Download
Bitmap To Excel