-->

Top 10 Best Free Excel Add-ins for quality work

As we know that in Excel Office 365 already has several add-ins added. When I looked for it from the Microsort Store, it turned out that there were lots of them, but this time I will give you 10 best free add-ins.
Best Free Excel Add-ins, download add-in excel, add-in excel free, add-in excel 2007, add-in excel gratis, add-in window, install use excel add-ins, add-in office for excel, free add-ins, how do add an add in excel, excell add ins free, best excel add-ins, create add-in excel, add-in excel 2013, aplikasi add-in excel, add-in excel 2010, add-in excel 2020, office 365, excel spreadsheet, toolpak vba, excel 2010, excel vba, sum, microsoft office, excel 2007, excel 2013, visual studio, addin, formula,microsoft excel online; microsoft excel 2010; free; tips and trick; excel; excel vlookup; excel microsoft; excel online; excellent; excel google; excel remove duplicate; excel expert; excel 30s; excel kids; excel spreadsheets; create excel;

Are Excel Add In free? There are more features of Excel now and it has newer and more advanced add-ins. The features are definitely the best and the important thing is that they are free also available online for free. with the advanced features that will make the work of higher quality.To install add-ins in Excel for Office 365 just go to the Insert tab and click on Get Add-ins.

This brings up the Microsoft Store where you can select from several different apps. Click on My Add-ins to see the list of add-ins you've already installed. Let's get started with the top 10 best free add-ins.

1 .  Excel Colorizer

Excel Colorizer allows you to easily add color patterns to your spreadsheet data. Start by highlighting an area of your spreadsheet you want to colorize. Choose from four types of color styles. For Uniform, select a color from the palette and click Colorize. It applies the color to your highlighted data.
You can also apply a pattern - Interlaced or Waves and adjust the other settings accordingly. For the Vertical type choose a start and end color and it applies the color gradient across the highlighted area vertically. And as expected, Horizontal applies the color gradient in a horizontal direction. Matrix combines both Vertical and Horizontal gradient. One thing worth noting is that there is no remove color option. To do that go to the Home tab and choose Clear Formats from this pull-down menu. If you want to spice up your Excel spreadsheet use Excel Colorizer. It's easy to use and it's free.

2 .   QR4Office

I recommended QR4Office for PowerPoint but it also works great in Excel. It's the easiest way to add a QR code to your spreadsheet. Once installed simply enter a URL, select your color and size, and insert it into your spreadsheet. Now you can move and resize the image as needed. When you scan the QR code from a mobile device it directs you to the URL. QR4Office lets you select from multiple types of QR codes including URLs, mail addresses, phone numbers, text messages, geo locations, or customize your own. If you need a QR code in your spreadsheet use QR4Office.

3 .  Mini Calendar

Mini Calendar and Date Picker allows you to embed a calendar into your spreadsheet for reference and for quickly entering dates. Once installed it adds a calendar to your spreadsheet which you can position anywhere. Select a cell and then select a date on the calendar to insert it into your spreadsheet.

You can also insert the current time. Click on this icon to highlight a range of dates, hit OK, and it displays those dates in bold on your calendar. Click on the menu in the upper right and you can Show as a Saved Image. There are several other settings to adjust the size, theme, calendar system, show week numbers, and to hide the settings. Mini Calendar and Date Picker is a great tool to make date management easier in Excel.

4 .  Places

Places is a quick reference guide showing public location data from Foursquare. After installing just select a location in your spreadsheet and it displays local information nearby. You can use cities, states, countries, or other places of interest. Click on any of the locations listed and it connects directly to Foursquare with more details. Places will show public data even if you don't have a Foursquare account so give it a try.

5 . People Graph

People Graph is a Microsoft add-in to show a table of data visually. It opens with sample data. Click in the upper-right corner to bring up the menu where you can change the title and select data from your spreadsheet. It is designed for only two columns of data and ignores the headings so just select the core data you want to graph.

Now you can select settings from the menu to pick from three different types of graphs, eight different themes, and sixteen different shapes for your graph. It links to your data source and any changes are reflected in the graph but you can convert it to an image from the menu. People Graph is simplistic but it creates a visually pleasing representation of your data that normally would take several more steps in Excel. Check it out.

6 . Activity Timer

Activity Timer measures the time you take for activities in Excel and lets you place the recorded data into your spreadsheet. Once installed it shows up on the Home tab. When you're ready to time your activities open it and add your first activity. Give it a name and click Start to begin working on that activity. You can Pause and continue the timer as you're working and when you're done with that activity click Stop.

Add a second activity and use Start, Pause, and Stop again as needed. You may find that you need to return to a previous activity and continue. Just click the + on that line. This records a separate measurement of time for that activity and shows a running average across the multiple recordings. At any point you can paste the results of your activity measurements to excel. This shows the times of each recording. As a helpful suggestion highlight the data, click on the Quick Analysis Tool in the corner, select Totals, and this Sum if you want to see all the totals. Activity Timer is a simple but useful tool if you need to measure the time you spend on activities in Excel.

7 .  Bing Maps

Bing Maps is another add-in from Microsoft that lets you create plots the location and value data from the table in Excel to the map. When added to This spreadsheet displays a blank map. You can select sample data if needed, otherwise just highlight your data table including headers and clicks Show Location icon. It instantly plots your data points on the map at the location you specify.

The size of the circle is proportional to the data value from your table. Click the Settings icon to change the map view or pin color. If you have multiple data points, you can also select a pie chart to display. Like other add-ins, you can display the map as a saved image. Bing Maps is neat add-in to represent your data as a map and completely free.

8 . Remove Unwanted Characters

Remove Unwanted Characters is a useful add-in if you are working with text in Excel and need to clean it of non-printable characters, symbols, punctuation marks, or other unnecessary characters. Once installed, you just got it Highlight a series of text and select the option from the menu you want clean. Press Yes and it clears the numeric character.

You can delete text characters and you can remove symbols and punctuation marks. You also have option to delete custom characters. It is designed for the most cleaning common glitches with data, especially when you import text from externals source. Note that you don't want to use it in formulas. This will change them to text render it non-functional. Remove the Uwanted Character can be useful for large volumes of messy text.

9 .  Range Calculation

Distance Calculations apply basic math operations to the various values in you spreadsheet. Once installed, highlight a series of numbers and select it the mathematical operation you want to apply from the menu. Say we want add 20 to all of these numbers. Calculate and immediately update the whole distance.

How about multiplying by 3. You can also apply a percentage or increase and decrease the percentage from the value. Range calculations are really basic but faster than creating formulas and then copy and paste the result into a new location in your spreadsheet so be it can save you time, especially for large data sets.

10 . Power Pivot

Power Pivot is an add-in that you can use to perform data analysis and create a powerful data model in Excel. Since Power Pivot has been around for a while, it wasn't installed via the Microsoft Store interface like the others add-in mentioned in this video.

Instead, go to Files / Options / Add-ins and go down right here down and select COM Add-ins and hit Go. Check this box for Microsoft Power Pivot for Excel and hit OK. This adds Power Pivot to your menu. Power Pivot lets you manage large data sets from multiple sources such as SQL, Oracle, CSV files, websites, or data already in Excel. Excel is usually limited to about 1 million rows but Power Pivot is nearly unlimited. I've imported some data here as an example to gives you an idea of how the Power Pivot feature looks like.

When you bring up The Power Pivot menu has a Manage option which brings up the data you have in your spreadsheet. If it's not there just click Add to Data Model and that's it will bring data in. You can also get data from external sources. Once you've put all this data together, you can now create things like pivot table or pivot chart so if I want to create a pivot table just click on this go ahead to a new sheet, and now like a normal Excel pivot table I can pull the data into this pivot table and see a summary of my data. Come on back here, go to Manage.

Let's choose the Pivot Chart this time. Well create a new sheet. You have the same features available and it creates an chart. One of the benefits of Power Pivot is its ability to create relationships among your data elements. I won't go into detail but when you look at the Diagram View You can add relationships to this table.

This allows you to create very complex data analysis in Pivot tables and Pivot charts. Power Pivot is a very powerful add-in that you can use with large data sets imported from multiple locations and that's why I want to share them as one free add-in for excel. stay tuned for tips and tricks for Excel and many other Office.
LihatTutupKomentar