The formula fill of Excel hardly anyone excites completely, however, many functions remain, with which add-ins can work more productively. Practical functions are still missing here and there, which ensure more comfort and faster working during working hours. Smart add-ins, also known as add-ins or office extensions, close these gaps, we introduce the most important
1. Thick functional package for savvy Excel users
The free ASAP Utilities 5.2.1 (www.asap-utilities.com) is a comprehensive collection of macros for Excel with several hundred commands for formatting worksheets and cells, for marking areas and for targeted access to data Certain conditions. This also simplifies the creation of index sheets and file extensions. Other features include removing links and accessing system features.
2. Currency translation with internet exchange rates
The free Currency Calculator Add-in (www.office-plugins.com) converts 160 currencies using daily updated exchange rates. To do this, Excel expands the CX (for Currency Exchange) formula to which the user attaches the reference cell, the source currency, and the target currency. The free version of the add-in is limited to one course update within 24 hours, and you can open hourly updates for 10 euros.
3. Replace formulas in cells with their computation results
The SmartTools Excel Weekly Formula Tools 5.0 (www.add-in-world.com, free) extend Excel by an additional menu. It contains a gross net tax calculator with selectable tax rate as well as a formula killer. It replaces formulas stored in cells with their results to prevent further automatic changes to the cells. The cells with the formulas of a table can be protected in one slip. You can also list all used formulas and create an overview of circular references.
4. Insert compact calendar for up to three months
Whether a holiday planning, relocation, calculation or project control - within the table, a suitable calendar provides for more overview in the term. The SmartTools Monthly Calendar Wizard 2017 (www.add-in-world.com, free) adds a mini calendar for one, two or three months including holidays.
The exact printing of spreadsheets is simplified by the fast printing function of Excel Weekly Druckertools 4.0 (www.add-in-world.com, free of charge). Use the pull-down menu to direct the printout to one of three printers, output only one page or the entire workbook, and specify the number of copies.
The importing of table data in the CSV exchange format in Excel sometimes fails on separate separators or invalid special characters. These problems solves CSVed (http://csved.sjfrancke.nl :) The free editor opens the delimited records and can customize format settings as well as swap values by searching and replacing. Other features include copying, deleting, and merge fields as well as a duplicate search.
If you need the menus from Excel 2003 in Excel 2007, 2010 or 2013, access the free SmartTools Classic Menu for Excel (www.add-in-world.com). The add-in brings back the good old days with the classic menu structure and all important bars. You can switch between old and new display as needed.
If the information contained in a PDF file is to be edited in Excel, the PDF-Excel converter from Nitro (www.pdftoexcelonline.com/en/, free of charge) can take over a part of the work. On the page of the online add-in to Excel, you upload the output file and receive the converted Excel file by e-mail. How useful the result is, depends on the formatting of the source material.
Finanzplan 2017 (www.add-in-world.com, free of charge) is an Excel template for private financial control. Revenue, expenditure, credit balances and liabilities are analyzed. The graphical yearly processing shows whether a credit balance or a negative amount remains at the end. The table is not protected.
5. Optimize the tables
6. Eliminate errors with CSV import
More about Office add-ins
7. Activate the conventional menu bar
8. Prepare PDF document for Excel
9. Monitor private money flow
No comments:
Post a Comment