Tips
Avoid Retyping Data into Word documents from Excel
Digital Trends offer a Financial Reporting Toolkit’s Formula Builder for MS Word. This add-in program that makes it easy to create formulas in Microsoft Word.
Formula Builder 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, select the range and Formula Builder computes the correct cell range address for you.
Copy and Paste Table – Select the cell containing the formula you want to copy and click Copy Table Formula. 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.
Download the Formula Builder so you don’t have to rekey data into Word documents from spreadsheets.
