有關excel問題,想問vlookup同埋pivot table有咩用,係點用?唔該詳細d,我d電腦好弱,謝謝!

vlookup - looks up a table by the left hand column:

eg. a table:

__| A | B | C
1 | a | 7 |
2 | b | 8 |
3 | c | 9 |

(the 1st row and 1st column (A, B, C) and (1, 2, 3) are column letters and row numbers in excel)

=vlookup("a", a1:b3, 2)

will give the answer 7 (looks at the left hand column of a1:b3, look for the letter "a", and give the value of the cell in the 2nd column.

A more detailed explanation is:
=vlookup(the value to find on the left hand column, where the table is, the column number from the left to retrieve the answer, whether the closest match would do [true/false]) - The last part is optional.


pivot table allows you to aggregate (produce a summary of) the data.

a simple example:

fruit | price
apple | 1.20
apple | 1.40
orange | 5.00
orange | 4.00

by making a pivot table, you can make excel calculate automatically:

fruit | average price | min price | max price
apple | 1.30 | 1.20 | 1.40
orange | 4.50 | 4.00 | 5.00


To create a pivot table, Excel provides a wizard to guide you through the process and I will not elaborate more (I can't put a screen shot or anything like that yet).

Both functions are available since Excel 5.0 (the version before Excel95. Excel 2000 is version 9.0).

There is a function call a cross tab table in Excel 4.0, which is similar to the pivot table.

我的名字is raymond li
我有網站可以賺錢和創業。
www.money128.biz和www.fast - beauty.6289.us
我還有美容產品可以免費試用詳情
請發送電子郵件給我。
[email protected]
感謝你。