Below are my list of the top five excel add-ins based on usefulness and just plain coolness. I use these add-ins often, they will improve productivity and provide a little enjoyment along the way.
1. Send Mail: At the touch of a button you can email parts or all of your worksheets and workbooks.
2. SQL Excel: Easily retrieve data from ODBC databases.
3. Comment Control: Comment Wizard that allows you to manipulate the font, background color and indicator color.
4. Google Search: Add a Google search bar to your workbooks!
5. Shrink and Value: When your workbook is ready to send to your clients or boss, this add-in will reduce the size of it by paste special=>valuing it, deleting unused cells and removing named ranges. Can reduce workbook size by 60%.
Resources:
How to Install an Excel Add-in
More Free Add-ins
Joseph Harris
ExcelYogi.com
No related posts.
I have a different list. Of the ones you’ve listed, I might only consider SQL Excel to be cool, but I haven’t used it yet so it’s not in my five.
Here are mine:
1. Chart Labeler by Rob Bovey: easily add labels from the worksheet to your charts.
2. Name Manager by Jan Karel Pieterse: manage defined names in your workbook.
3. AutoSafe also by Jan Karel Pieterse: save a copy of each open workbook at pre-specified intervals to a pre-specified directory.
4. XLG Favourites by Ken Puls: most recent files on steroids, allows you to permanently add files and folders to a custom list.
5. Find Links by Bill Manville: find external links anywhere in your workbook.
This doesn’t count some of my own utilities, which I also think are pretty cool. Mostly because I wrote them to address needs that otherwise were unmet.
Thanks John…Great list. I can vouch for chart labeler, I use it often.