Subscribe!

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

Related posts:

  1. How to Import XML Data into Excel This article is a quick primer on using XML data...

This entry was posted on Monday, November 3rd, 2008 at 12:27 pm and is filed under Miscellaneous. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

2 Responses to “Top Five Excel Add-ins”

  1. Jon Peltier on November 3rd, 2008 at 1:50 pm

    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.

  2. Joseph Harris on November 3rd, 2008 at 4:18 pm

    Thanks John…Great list. I can vouch for chart labeler, I use it often.

Leave a Reply

You must be logged in to post a comment.