The Financial Reporting Toolkit's Formula Builder for MS Word is an add-in program that makes it easy to create formulas in Microsoft Word! A new menu added to the core Word program lets you create formulas in any new or existing Word document. Formula Builder feature - Word does not provide cell addresses in its core program. You have to figure out the cell address manually by counting the number of columns and rows. In smaller tables this isn't too difficult, albeit inconvenient. However, it can be a challenge in larger tables. If you miscount the columns or rows, you'll also get erroneous results. Word makes it impractical to use formulas, so most people don't. Formula Builder solves these problems. Formula Builder is a wizard that walks you through the steps of building a formula. Click on the cell address you want in your formula and Formula Builder automatically determines the cell address for you. If you need to add a range of cells using the SUM function just select the range and Formula Builder will compute the correct cell range address for you. The wizard includes easy access to any of Word's eighteen built in functions. Copy and Paste Table Formula feature - This is one of the most exciting features of the program. Excel automatically updates cell addresses in copied formula for their relative references. Word's core copy and paste functions simply duplicate formulas as written, resulting in erroneous calculations. The program's Copy and Paste Table Formula function solves this problem. Select the cell containing the formula you want to copy and click the Copy Table Formula button. Select a cell or a range of cells you want to copy the formula to and click the Paste Table Formula button. The formula cell addresses will be automatically updated for relative references. This feature alone can be a major time saver. No more rekeying data into Word documents from spreadsheets!
