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!
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
Version 1 - Healthcare Dashboard
Version 2 - Healthcare Dashboard (you may find this one to be a bit easier to follow my work)
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.
Rollover B8 OV1
Edit Button, Please
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.
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.
Turn an Excel Spreadsheet into a Bitmap Image
Bitmap To Excel