• Useful Excel Add-ins

    I try all of the add-ins I recommend, and won't recommend them unless I believe they are worthwhile (particularly if there is a charge!) Each of those listed below are helpful tools that I have no problem recommending.

    General Purpose Add-ins (Free)
    • ASAP Utilities
      • ASAP utilities is a standard install procedure for many advanced Excel users. Another addin full of great stuff!

    • Name Manager
      • Jan Karel's name Manager is an essential add-in for working with names.

    VBA Add-ins and Tools (Free)
    • MZ Tools
      • If you do any VBA developing, you need this addin. It is loaded with useful tools such as a code reviewer and much more to speed up your development process.

    • Smart Indenter
      • An awesome little add-in that makes indenting all of your code very simple. I find it really helps to know if you have an issue in a Case or If block, among other things.

    • PDF Creator
      • A free PDF writer utility that supports VBA.

    General Purpose Add-ins (Nominal Cost)

    Random Data Generator is an add-in for Microsoft® Excel 2003-2010 that lets you easily create fake, randomly generated personal and demographic information in Microsoft® Excel. No VBA skills required!

    This data can be used in applications such as PivotTables, macros, charts, tutorials, web demos, databases — anywhere that fake test data is needed, without using actual personal information (which may be protected by Sarbanes-Oxley [SOX] and/or the Health Insurance Portability and Accountability Act [HIPAA]).


    I'm afraid that you must be logged in to comment or leave a testimonial. I wish it could be otherwise, but I'm trying to keep my site spam free for everyone's benefit. If you don't yet have an account it's completely free to sign up, and a very quick process. Simply click here to Register. Not only can you post a comment here, but it gives you full access to posts questions in our forum as well!


    If you already have an account, and just haven't logged in yet, what are you waiting for? Login Now!

  • Recent Knowledge Base Articles

    Ken Puls

    Making Pivot Table Hyperlinks Clickable

    If you’ve ever built a PivotTable that contains hyperlinks, you’ll notice that clicking the hyperlinks doesn’t do anything. This can be a bit frustrating as the reason you put that field on the Pivot in the first place is that it’s valuable information you want to use. When you click the hyperlink,... read more
    Ken Puls 2013-10-31, 01:58 AM
    Ken Puls

    Temperature Forecast Chart

    Some of the really cool charts that we can build in Excel involve the trick of combining multiple chart types together to make them happen. In this article, we’ll build one of those; a temperature chart that not only shows the forecasted high and low temperatures, but also the season highs and lows. The beauty of this chart is that it provides a lot of information, some of which essentially fades into the background until you really need it.
    ... read more
    Ken Puls 2013-03-21, 05:04 AM
    Ken Puls

    VLOOKUP for Pictures

    Something that can be very handy when you’re building a dashboard is to return a certain picture depending on a condition. We can use VLOOKUP to look up data in a table and return the corresponding value from a different column, but unfortunately we can’t do that with pictures... or can we?

    This example shows how to accomplish the equivlanet of a picture VLOOKUP, and is based on looking up a picture to display the appropriate... read more
    Ken Puls 2013-03-14, 05:47 AM
    Ken Puls

    Understanding How Conditional Formatting Rules Are Applied

    Conditional formatting in Excel is a powerful tool that allows you to dynamically format cells depending on the values of that or other cells’ data. In Excel 2007 the conditional formatting engine was re-written, opening things up to allow more than 3 conditional formats on any cell, as well as conditional formats that could overlap ranges. All in all, these were fantastic improvements that can lead to some very versatile and useful worksheets.

    Unfortunately, the user interface to control conditional formatting is not the most intuitive. The purpose of this article is to help you understand the way Excel applies rule precedence so that you can build powerful formatting rules of your own, without getting frustrated along the way.
    ... read more
    Ken Puls 2013-01-22, 06:30 AM
  • Recent Article Comments Widget


    A message to forum cross posters

    Thanks and regards. Go to last post

    kepler19 Today 10:18 AM
  • MVP Logo
  • Recent Forum Posts


    Formula Protection

    Thanks friend for your supports. You helped me. I understand about that cross-posting and did as was advised to me. ...

    kepler19 Today, 10:08 AM Go to last post

    Formula Protection

    @ Kepler

    please do not quote entire posts unnecessarily. They clutter the thread and make it ahrd to read.


    Pecoflyer Today, 10:02 AM Go to last post

    Formula Protection

    I understand. i provided LINK as you told.

    So at first i have to select that cells where i want to happen changes right?

    kepler19 Today, 10:01 AM Go to last post

    Formula Protection

    I do not think that you are trying to waste anybody's time. Cross-posting is not forbidden: you just need to remember to provide links, that's all. ...

    AliGW Today, 09:58 AM Go to last post

    Formula Protection

    am trying to post that LINK but unable yet. 404 error page.

    Do not think that i am time waster, i am not it. I appreciate your quick answers...

    kepler19 Today, 09:56 AM Go to last post