Thứ Hai, 30 tháng 7, 2012

Using Excel for spreadsheet formulas of Word 2010

Many people can create and use tables in Microsoft Word 2010 but not everyone knows how to handle the data in Word tables efficiently as when working with Excel spreadsheets. Here are the steps that you can do that is amazing.
We start with a blank file in Word, then click on the Insert tab on the ribbon menu and then click on the Table:



To demonstrate this we created a 2x3 table:


Next, narrow the width of the box and add value to 4 cells on the same:

Now everything is ready for us to work with Word as in Excel. For the mouse cursor into a box and then click the Layout tab:



Click on the Formula bar to the right of ribbon:



A pop-up window will appear as follows:




At the top is the formula that you want to use, the box in the middle is the format for the cell number and allows you to select the available functions listed. Default function = SUM (ABOVE) will sum all cells above the current cell. Note that the "=" must be added to the formula can work. The formula is limited by the selection of data LEFT, RIGHT, ABOVE and BELOW so Word is the calculation with all cells in the direction indicated dinh.Nhan Enter you will get the result:
SUM function to add two numbers were placed above and results of a calculation on the current cell. To know the function of other functions, put quotes box next to Formula and open again. This time select Paste function menu:



Drag down and click on the COUNT function to be:



You must delete the default function of Word as follows:



Now click OK to insert content into the table. Ham COUTNT counted all cells that contain two numbers above it:


Microsoft has listed a full list of all Excel functions can work with tables in Word at the address Use a formula in a Word table. You can explore yourself.
Finally, you can use the Number menu format:



... To format the results given by the function, such as more money for the unit:


Table in Microsoft Word 2010 is not equipped with more powerful tools such as Excel, but if you're working with Word and just need some simple calculations to manipulate it, Word was able to meet the requirements of you an effective way.

0 nhận xét:

Đăng nhận xét