Everyone! We've moved to WordPress.

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 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

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:





Download


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


Comments: 2

  1. Hello Jordan,

    I am very interested in your latest article "Details on Demand" of Aug. 27th. Please, how can I download the example file "Details on Demand Rollover.xlsm" that you mentioned there ?
    Thank your for your assistance.
    Kind regards,

    H.G. Lamy
    E-Mail: Enterplan@web.de

    ReplyDelete
    Replies
    1. If you go back to the Details on Demand blog post, http://optionexplicitvba.blogspot.com/2012/08/details-on-demand-bring-up-details-on.html, a link to the file should be at the bottom of the post.

      Delete