9 Add-Ons for Excel to Make Spreadsheets Easier

9 Add-Ons for Excel To Make Your Spreadsheeting Easier

Microsoft Excel is one of the best spreadsheet software available which can do many things like calculations, tables, graphs, macro programming, etc. Out of the box, the Excel is pretty powerful, but if you want to extend the functionality or want to make your life a tad bit easier, installing add-ins is the best way to go. Here are some of the best Microsoft Excel add-ins that you should definitely try.

1. Quandl for Excel

Quandl is one of the best data analyst tools that helps you save a lot of time and effort gathering and formatting all the data you want. The good thing about Quandl Add-in for Excel is that it allows you to search through massive datasets for free and without any restrictions whatsoever. Moreover, you can also download the datasets you need in any format you want.

https://www.youtube.com/watch?v=8dz_b6EvwL8

2. Radial Bar Chart

Rather than reading through the tons of data, you can make your life easier by visualizing the data using charts and diagrams to quickly understand the big picture. Though Excel can create some good data visualization charts, you can also use free add-ins like Radial Bar Chart for something unique and special.

excel-addins-radial-bar-chart

3. Geographic Heat Map

If you are working with datasets that make use of geographical locations, then visualizing that data in the form of maps is a good way to analyze and present the information. Using the Geographic Heat Map add-in, you can do just that. The add-in takes the selected data in your excel sheet and creates a geographic map out of it.

excel-addins-geographic-heat-map

4. Percentage Calculator

Not every one of us is good at Math, especially when calculating percentages. So, if you find yourself needing to quickly calculate percentages, you can do that using the Percentage Calculator add-in. Other than calculating percentages, you can also calculate percent change and increase and decrease percentage value. The add-in also supports percentage markups.

excel-addins-percentage-calculator

5. Range Calculations

If you have worked with Excel sheets long enough, you will often find yourself in a situation where you need to change or recalculate numbers in multiple cells. Though you can do this manually, it is time consuming. In those situations you can use the Range Calculations add-in. This free add-in lets you easily recalculate the numbers in the selected range.

excel-addins-range-calculations

6. Favorite Bookmarks

If you regularly work on certain workbooks or Excel sheets in certain directories, then bookmarking them helps you launch those workbooks without fiddling around. To bookmark your favorite Excel sheets and directories, you can use the free add-in called Favorite Bookmarks.

excel-addins-favorite-bookmarks

7. RDBMail

If you want to quickly email your Excel sheets or parts of your Excel sheet without leaving your workbook, then you can use the free add-in called RDBMail to do that. The good thing about this add-in is that it allows a significant amount of customization of what you send and how you send.

8. Databurst for Excel

Databurst is a simple add-in that lets you create smart and interactive data visualizations. Databurst has several features and customizations like automatic data categorization, support for filters and Excel formulas, etc.

excel-addins-databurst

9. New Workbook Assistant

The default workbooks created in Excel are always the same; you cannot choose the default font for the workbook, number of sheets in the workbook, etc. Using the New Workbook Assistant add-in, you can create the Excel workbooks the way you want with just a few -clicks.

excel-addins-workbook-assistant

Do comment below sharing your favorite Excel add-in that you use in your daily workflow.

The Complete Windows 10 Customization Guide

The Complete Windows 10 Customization Guide

In this ebook we’ll be exploring the multitude of options to fully customize Windows 10. By the end of this ebook you’ll know how to make Windows 10 your own and become an expert Windows 10 user.

Get it now! More ebooks »

6 comments

  1. Kutools should be in the list.

  2. This is a good list. My favorite, which isn’t on here, is ASAP Utilities.

  3. I too like ASAP alot, but here’s a bunch of new cool tools to check out

  4. Are the Office addins asking for the Microsoft Live Account or just a private email address to use as a subscriber?

  5. I agree 100% Steven. It’s nice to have a list of new tools to try out and I’m not, for a second, knocking the article. It’s a good one that many folks can gain from.

  6. If you like pro excel charts I strongly recommend to visit: https://exceldashboardschool.com

Comments are closed.