Add ins

Excel Add-ins Step by Step Tutorial

Microsoft Excel is one of the most-used software applications in the world for data storage and analysis. So, being proficient in Excel is an important skill and can help you gain a lot of time when dealing with long sheets.

In Excel, there are many extra functionalities that can help you become more productive and make things easier for you. These extra tools are called Excel Add-ins.

Are Excel Add-ins a type of Excel Macros?

Simply No, but defenity they use the VBA codes.
Excel add-ins are small programs that extend the functionality of Excel, allowing you to do more with the software than ever before. There are a wide variety of add-ins available, each with its own unique set of features and capabilities.

5 reasons to start using Excel add-ins today

Why should you start using Excel add-ins today? Here are five good reasons:

    1. Add-ins can save you time by automating repetitive tasks.
    2. Add-ins can help you work more efficiently by providing shortcuts and tools to help you get your work done faster.
    3. Add-ins can improve your accuracy by reducing the chances of errors in your work.
    4. Add-ins can make working with complex data sets easier by providing features and tools specifically designed for dealing with large amounts of data.
    5. Add-ins can help you create better looking and more professional looking documents by providing access to a wide range of templates and graphics.

Different types of Excel Add-ins

In Excel there are Add-ins developed by Microsoft, such as the PowerPivot add-in, PowerQuery or the Solver add-in, and there are also some Excel add-ins developed by independent vendors, such as the Table add-in or the F9 add-in. In the newer version of Excel like 2013 version, you also have access to a form of add-in, which Microsoft has named the Apps for Office. Even if they don’t have the same name, they act in a similar way, i.e. they provide additional functionalities, not available in the basic Excel version. They can be consulted via an “App Store”.
Apps for Office

Learn how to load Add-ins in Excel

In this exemple we are going to use The “XLP Function Pack” is a free add-in for Excel that includes 92 new useful functions.

Download The “XLP Function Pack”

    • Excel 2000 to 2003 (XLA Extension):
      1. Look in the downloaded zip file for the additional macro called “XLP-function-pack.xla“.

        install-excel-add-ins

      2. Then create the folder C:/Excel and copy the file “XLP-function-pack.xlam” into this folder:
      3. Activate the Add-In, go to “File” > “Options” > “Add-ins”  then click on “go” in the bottom of window
      4. A new window will appear click “Browser”and select the file in “C:\Excel”.Then check “XLP function pack” and validate:

        Import Excel Add-ins 2007-2019

      Here it is installed, the functions will now be usable with all your Excel files!

      In case of problem, go to “Tools” > “Macros” > “Security” and check in the second tab if “Trust all installed templates and add-ons” is checked.

    • Excel 2007 to 2019(XLAM Extension):
      1. Look in the downloaded zip file for the additional macro called “XLP-function-pack.xlam“.

        install-excel-add-ins

      2. Then create the folder C:/Excel and copy the file “XLP-function-pack.xla” into this folder.
      3. Activate the Add-In, go to “File” > “Options” > “Add-ins” then click on “Go”

        Excel Add-ins 2007-2019

      4. A new window will appear click “Browser” and select the file in “C:\Excel”.Then check “XLP function pack” and validate.

        Import Excel Add-ins 2007-2019

      Here it is installed, the functions will now be usable with all your Excel files!

      IN CASE OF PROBLEMS
      If it doesn’t work, uncheck the add-in, close Excel and delete the file from the C:\Excel folder. Then start the installation again from the beginning, this time dropping the file in the XLSTART folder:
      “C:\Program Files (x86)\Microsoft Office\root\Office16\XLSTART”
      Note that the path to the XLSTART folder may vary depending on your installation of Excel (for example it may be in the Program Files or Programs folder instead of Program Files (x86)).

Check out also:

Add Developer Tab in Excel : https://www.macrosinexcel.com/add-developer-tab-in-excel/

Macros in Excel with Examples : https://www.macrosinexcel.com/macros-in-excel-with-examples/

Leave a Comment