Microsoft Excel
Training
Videos ## Excel like calculations in Word |
|||

Most of us are comfortable with Microsoft Word. Wouldn't it be nice if we could perform Excel like calculations in Word? This has many advantages including the ones mentioned here: - Tables in Word can be formatted in a variety of ways to make our documents look professional and beautiful
- We don't need to copy and paste an Excel worksheet
Word provides many equations and arithmetic formulae like sum for addition, product for multiplication, etc. Once we have our data in a table we can perform the relevant calculations as shown in the training video. The cells in a table can be accessed using notations like A1, B1, C1, etc. In the description A1 the letter A represents the first column and '1' represents the first row. Also you need to click on 'Table', then on 'Formula...' and in the formula pop-up window you can specify the formula and the number formatting. As mentioned before Word has many arithmetic functions available to the user which can be pasted quickly and easily to perform the specified calculation. Tip::
If you
change some values in the cells of the table where you had accessed the
cells using cell addresses you can select the result of the earlier
calculation and press F9 to recalculate. |
|||

Another interesting article on the topic Excel like calculations in Word |