z**********8
发帖数: 2049 | 1 EXCEL 当中，可以被称为advanced skills , 有哪些？
vba/excel? 还有哪些？ 谢谢先 |
E*****e
发帖数: 197 | 2 vba 算是advanced 了吧，其他不知道，PowerPivot? 等高人补充 |
e****7
发帖数: 4387 | 3 这个弄不来，每次看analyst 操作excel 都看得一愣一愣的 |
z**********8
发帖数: 2049 | 4 HLOOKUP
VLOOKUP
TRANSPOSE
INDIRECT
MATCH
INDEX
CHOOSE
COUNTIF
COUNTIFS
COUNTBLANK
AVERAGEIF
AVERAGEIFS
FREQUENCY |
w*r
发帖数: 2421 | 5 If you know how to write VBA it is good enough.
Rest of work is use macro recording function to record template and then
modify the code...
【在 z**********8 的大作中提到】
: EXCEL 当中，可以被称为advanced skills , 有哪些？
: vba/excel? 还有哪些？ 谢谢先
|
e****7
发帖数: 4387 | 6
这些我都得狗狗一下才会用
【在 z**********8 的大作中提到】
: HLOOKUP
: VLOOKUP
: TRANSPOSE
: INDIRECT
: MATCH
: INDEX
: CHOOSE
: COUNTIF
: COUNTIFS
: COUNTBLANK
|
w*r
发帖数: 2421 | 7 also pivot table... very important skill.
I once wrote a package using apache excel writer to populate data in a excel
file (with vba code template) and publish report to user. User only has to
open the web page input a couple parameters. it will generate excel file
with macros automatically build formatting, charts, pivot tables
automatically once he/she opens it. |
s**********o
发帖数: 14359 | |
