Back

About MrExcel
Consulting Services
Learn Excel Resources
Challenge of the Month
MrExcel Seminars

Message Board

MrExcel Store
Podcast
Search
Media
Contact
Home

 

Cool Spreadsheets to Download

Occassionally, I receive an e-mail from someone who has developed a cool spreadsheet and they would like to donate it, to allow anyone who can use it, to download it for free. I will occassionally update this page to include some of these spreadsheets. If you have a spreadsheet you would like to share, send it to bill at mrexcel.com.

Please note: There is no warranty with any of these spreadsheets. They are developed by people just like you and me. They may or may not be subject matter experts. Before you make any decisions based on these spreadsheets, do some testing to make sure the results make sense.

Also note: Before I started this page, there were a few other pages of themed spreadsheets which are free to download:

Bi-Weekly Mortgage Calculator submitted by Robert Phillips of Cleveland Ohio
Download: mortgage.zip
You can save a lot of interest by paying half of your mortgage payment every payday instead of once a month. In addition to getting the equivalent of 13 payments a year, you will save interest by making half the payment early. This application by Robert Phillips shows the actual savings. Enter a few cells about your mortgage and the chart will update to show how much you could save by starting to making bi-weekly payments. Cool side benefit: VBA programmers might want to check out Robert's code for adjusting the scale of the y-axis in response to the numbers entered in the spreadsheet.


Speedometer from a Pie Chart submitted by Richard Cantin of Toronto Canada
Download: piespeedo.zip
Speedometer charts are becoming popular on executive dashboards. If you don't want the full-featured Speedometer utility from Mala Singh, you can knock out a quick speedometer using a Pie Chart, as illustrated in Richard's workbook.


Monopoly Dice submitted by Brett Stewart of Brisbane Australia
Download: piespeedo.zip
Excel 2007 Only. Press the F9 key to roll a couple of dice to replace the missing dice in Monopoly. While it is easy to knock out a couple of =RANDBETWEEN(1,6) formulas to do this, Brett used some great formatting to bring the dice to life.


List Files submitted by Bill Jelen of Akron, USA
Download: listfiles.zip
Not compatible with Excel 2007!. Do you ever wish you could sort and filter a list of files? With this utility, enter a path name, click the button, and you will have a list of files, one file per row in Excel. The utility provides the file name, the path name, and last modified date/time. You can specify to include files found in subfolders.


Advanced Filter tip submitted by Brad Kennedy of Brisbane, Australia
Download: BradsFilterTip1.zip
Brad's comments: Excel will not let you record an advanced filter being copied to another worksheet. However, if you record the macro in the current worksheet then go and edit the destination in the macro it will work! A report example is included to demonstrate the usefulness of this technique.


Monthly Income & Expense Tracking submitted by Doug Wilson of Ontario, Canada
Download: Expense1.zip
Keep track of monthly income vs. expenditures.


Grocery Shopping List submitted by Doug Wilson of Ontario, Canada
Download: Grocery1.zip
An easy way to prepare a shopping list of regurlarly purchased items and the approximate costs.


Creat Jewel Case Insert/Cover submitted by Doug Wilson of Ontario, Canada
Download: JCInsertsver3.zip
Easy to use workbook to create jewel case insert/cover with lots of flexibility.


MrExcel.com Consulting can be hired to implement this concept, or many other cool applications, with your data.

MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.

 

Excel is a registered trademark of the Microsoft® Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.

All contents Copyright 1998-2008 by MrExcel Consulting.