¹øÈ£ |
°Á¸í |
º¸±â |
1 |
???? ????? ??? 2014 ??? ????, ??????, ????, ?????? |
|
2 |
???? ??? ?? ????, ?????? ????, ???????, ?? ??? ?? ??? |
|
3 |
??? ?????, ?????? ???? ???? ??????, ?? ???? ????, ???? ???? |
|
4 |
??????????, ?????? ????, ?????? |
|
5 |
?? ????, ??/?? ???? ?? ??? ???? , ?? ????(?????? ????) |
|
6 |
??? ???? ?? ????, ???? ???? ?? ???? |
|
7 |
????? ???? , ??????, ????, ????? ????? |
|
8 |
?????? ????, ????? ????, ? ?????? ? |
|
9 |
??? ??????, ??? ???? |
|
10 |
???? ????, ????, ????, ??? ???? |
|
11 |
??? ????, ? ????, ??? ??????, ?????, ????? ?? |
|
12 |
???? ??? (sum, sumif, round, subtotal ? |
|
13 |
?? ??? (if, and, or, not...) |
|
14 |
????? ??? (left, right, mid, lower, upper....) |
|
15 |
???/?©£? ??? (year, month,day, date,datedif ...) |
|
16 |
???? ??? (average,count, countif, max,min,....) |
|
17 |
??? ??? (vlookup, hlookup, match ...) |
|
18 |
?????? ????? ??? (dsum, daverage,dmax,dmin ...) |
|
19 |
??????????, ????, ??? ???? ?? ???? ????, ???? ?????? ?? ??? |
|
20 |
?¥ê???, ?¥ê??? ??? ???, ??? ???? ?? ????, ???????? ???? |
|
21 |
???????? ???? ?? ???? |
|
22 |
?? ????, ?¥ì????????, ?¥ì |
|
|