Microsoft Excel has an array of useful features for creating powerful spreadsheets with charts and tables. But, when you want to take your spreadsheet to the next level, beyond fancy text or themes, you may need the help of an add-in.
1. Excel Colorizer
For an easy way to add color to your spreadsheet data, the Excel Colorizer add-in works great. To make your data simpler to read, just pick the colors and pattern and let the add-in do the rest of the work.
You can choose a type from uniform, horizontal, vertical, or matrix and pick your four colors. Then, adjust the interpolation to smooth or linear and the color space to RGB or HSV. You can also pick the pattern from interlaced or waves. So, select your data, make it look amazing, and hit Colorize! to finish.
2. Radial Bar Chart
For displaying an organizational chart, HierView is the add-in for you. Your data should include a row identifier with the information included across the columns. Then, configure your data with filtering, automatic refreshing, column names, and data per node.
Once your chart is complete, you can zoom in or out, move in all four directions, or fit the chart to the plotted area. You can also move the entire chart or resize it if needed. Adjust the settings or get help at any time with the convenient buttons at the top of the chart.
5. Bing Maps
If adding a map to your spreadsheet is useful, the Bing Maps add-in makes it simple. Your data can include addresses, cities, states, zip codes, or countries as well as longitude and latitude. Just open the add-in, select your data cells, and click the Location button on the map.
The Bing Maps tool is ideal for displaying numeric data related to locations. So, if you work in sales, you can show new markets to cover or if you work for a company with multiple locations, you can present those facilities to clients clearly.
6. Geographic Heat Map
When a heat map is what you really need, the Geographic Heat Map add-in is terrific. From the same developer as the Radial Bar Chart add-in, you have similar settings. Select your data, choose a U.S. or world map, pick your column headings, and add a title.
You can reselect the data set if you add more columns or rows and if you change a value already in the set, you will see the heat map update automatically. For a fast glance at data related to countries, states, or regions, you can pop this heat map into your spreadsheet easily.
7. Pickit Free Images
For adding photos and other images to your spreadsheets, Pickit Free Images is the perfect tool. Once you access the add-in, you have a few options for finding the image you need. You can do a keyword search, browse through collections, or pick a category from a huge selection.
Click a spot to put it in your spreadsheet, select the image you want, and hit the Insert button. You can move, resize, or crop images as needed. And, if you create a free Pickit account, you can mark favorites to reuse and follow fellow users or categories to stay up-to-date on new uploads.
8. Web Video Player
Maybe your company has videos on YouTube or tutorials on Vimeo that would be beneficial to your workbook. With the Web Video Player add-in, you can pop a video from either of these sources right into your spreadsheet.
Open the add-in and then either enter the URL of the video or click to visit YouTube or Vimeo to obtain the link. Hit the Set Video button and you are done. Then, when you open the spreadsheet, the video is there and ready for you to click the Play button.
For a one-time $5 fee, you can set your videos to play automatically or start and end at specific spots in the clip. This option is included within the add-in.