For the waterfall chart I used Jon Peltier's Charting Utility. This is a very handy Excel Add-in, and one that every chart maker should have. This is a very handy Excel Add-in, and one that every chart maker should have.

What Are Add-ins? Add-ins for Excel are similar to the apps you can download and purchase for your smartphone. They are mini software applications that you install into Excel in order to provide integration, shortcuts, and tasks that are not available within the standalone Excel application. Add-ins are created mainly by third-party businesses or self-motivated users (like myself) to fill a void that seems to be missing within Excel's vast array of capabilities. Creating an add-in not only takes coding prowess in languages like VBA and XML, but it also requires an eye for a smooth intuitive user-interface to make the program 'feel' like it is a natural part of Excel. If you can find add-ins that possess both of these characteristics, you can do absolute magic within Microsoft Excel.

Where Do I Find Add-ins? The main purpose of this directory is to provide a one-stop list of high-quality and practical add-ins that you can use to increase your productivity and capabilities while using Microsoft Excel. Since there are so many Excel developers out there, it can be somewhat hard to find Excel add-ins, let alone decipher the good ones from the bad ones. This list is in no way a reflection of 'my favorites' or a 'guaranteed hit', as I have not used every single one of the add-ins within this list. Free voice to text software for mac.

This is simply a starting place to help get you in the right direction without having to scour all over the internet for days to determine your options. I do encourage you to leave reviews within the Comments Section at the bottom of this page describing add-ins you have had good/bad experiences with. Please feel free to recommend add-ins that may have been left off this list that you think people should know about. Overview Here is a listing of all the add-ins that are detailed within this article: • • • (Automate bulk chart creation) • (Shape object conditional formatting) • • (Ribbon XML Code Editor) • • (Excel To PowerPoint copy/paste automation) • (Custom Color Branding Tool) • (Build Your Own Ribbon Add-in) • (Remove VBA Project Passwords) • • (Extra Pivot Table Functionalities) • • (Spreadsheet auditing & Tick icons) • (VBA Project Protection) • • (File Clean up utility) • •. Productivity forms of Excel Add-ins do a specific task to help speed up what you are working or provide an easier solution than what is the norm within the Excel application. Here are some great solutions that will speed up specific tasks that might currently put a strain on your work day. PivotPal Add-in Supercharge your pivot tables with the PivotPal add-in.

This Excel add-in provides tons of great Pivot Table related features that will make it easier and faster to modify your pivots. You can learn more about this Excel add-in by visiting the. Trial Available? No Developer: Excel Campus. Peltier Tech Chart Utility 3.0 Add-in This add-in is probably the most popular in its category. The variety of extra chart types available with this add-in is truly phenomenal. You can create Box Plots, Histograms, Paretos, and many more with a few click within the add-in.

If you love using these advanced charting forms but hate the hassle of setting them up, the Peltier Tech Chart Utility add-in is definitely for you! You can learn more about this Excel add-in by visiting the. Trial Available? No Developer: Peltier Technical Services. My First Add-in My First Add-in allows you to create your very own Microsoft Office add-ins in Excel, PowerPoint, or Word by simply toggling on/off variables within the VBA code.

Think of it as flipping on/off light switches. The tools comes with over 150 buttons you can link your macros to (including drop down menus) and also gives you access to the entire Microsoft Office Icon Library! My First Add-in will allow you to create a professional looking add-in within hours and will give you a perfect way to access your favorite macros.