In Microsoft Excel it is convenient to make calculations according to pre-set formulas, so this tool is used by almost all accountants. But as the main tool in small businesses, the text editor Microsoft Word is often used. Perhaps it will be useful to you too. Therefore, if you are not yet familiar with it, study its functionality and computing capabilities.
Commercial offers and price lists with a list of goods usually include tables with prices, names of goods, their quantities. If any data changes, then you have to adjust the information in these tables. You can do all the necessary manipulations by transferring the mentioned tables to Excel, and then returning them back in an already corrected form. However, you will have to create an additional .xls file and not forget where it is saved. And a little later you will not remember why this document was needed at all, and as a result, the information may get lost.
Additional complications zalo database arise if you provide individual discounts to some of your clients. Then you need to prepare a separate table for each one and not forget how much you change the price. And what is important is that any, even the smallest changes, are not made in five minutes, it is a long and routine process. For example, exchange rates have changed. This means you need to: open your file in another application, recalculate everything, copy the data in an already updated form, etc. And here the built-in calculation functionality of Microsoft Word will help perfectly.
The essence of creating tables in Microsoft Word and Microsoft Excel is very similar. It is possible to refer to cells of a table created in Word. Short references look like A1, A2, B1, B2, etc. Here, the columns are designated by letters, and the rows by numbers. It is more clearly seen in the example of a small table:
A B C
1 A1 B1 C1
2 A2 B2 C2
3 A3 B3 C3
The difference between Microsoft Word and Microsoft Excel is that in the first case the references are absolute. This means that when a cell address is specified in a formula, it (this address) does not depend on where the cell with the formula is located. Excel uses references of the format $A$1, and Word does not use the dollar sign. That is, if in Microsoft Word the cell designation is A1, then in Microsoft Excel it looks like $A$1.
Let's say, for example, that a store's price list contains a table with products and prices, and the data in it needs to be adjusted after the exchange rate of the conventional unit changes. Of course, the cost in rubles and the total amounts will be different.
y.e. 26.75
Name Price, USD Price, RUB Quantity, pcs. Cost, RUB
Computer 567 15 167,25 5 75 836
Monitor 135 3611.25 5 18,056.25
Total 702 18,778.5 10 93 892,25
When using references in formulas, the separators for them are a comma and a colon (this is how the range of actions is designated, i.e. the first and last cells). How can I make a reference to the entire row or column at once in a formula? There are several options. For example, to specify the entire first row of the table in the reference, only the letter or number is written in the range.
If the reference is 1:1, it means that all cells of the first row are automatically included in the formula, and new cells (if any need to be added later) too. If you need to make a reference to the first column, which includes the first three rows of the table, then the range is specified as follows: a1: a3. Thus, only those cells that you have specified will be used in the formula. If you need to include other cells, you will need to change the letters and numbers in the formula as needed.
Let's say, for example, the exchange rate of the conventional unit changed from 26.75 to 26.18 rubles. What steps should be taken to make the necessary recalculations in the table? First, you need to delete the old value in cell E1 at the top and enter a new one instead.
Read also!