|
|
 |
| IT오피스 > MS 엑셀 2013 매뉴얼 및 실무기능배우기 |
| |
| 번호 |
강좌명 |
보기 |
| 1 |
???? 2013 ??? ????, ??? ????, ???? ?? ?????? |
 |
| 2 |
???? ??? ?? ????, ???? ???, ??? ???, ?? ???? ???? ? |
|
| 3 |
??? ????, ???? ????, ?? ??? ?? ????, ?????? ???, ??????? ?????? ? |
|
| 4 |
??? ?????. ?????? ???? ???? ??????, ???, ?? ???? ?? ???? |
|
| 5 |
?? ????(??θ? ?? ?????), ??? ????, ??? ???? |
|
| 6 |
?? ????(?????? ????), ?????? ???? |
|
| 7 |
?? ????? ???? ?? ????, ? ???? ?? ????(????? ????) |
|
| 8 |
???????, ????, ????, ??? ????, ??? ????, ???? ???? |
|
| 9 |
??? ???? ?? ????, ?????, ? ???? ?? ??????, ??? ????, ??? ????? |
|
| 10 |
???? ??????, ?????? ????, ??? ?????? ????, ????? ?? |
|
| 11 |
??? ???? ?? ????, ???? ???? ?? ???? |
|
| 12 |
????? ????1(??????, ????/???? ???, ?????????, ????, ?????? ????) |
|
| 13 |
????? ????2(?? ??? ??????, ??? ???? ? |
|
| 14 |
??? ???? ?? ????(??????, ????) |
|
| 15 |
????/?? ???1(sum, sumif, product, round, int, abs? |
|
| 16 |
?? ???(IF , AND, OR, NOT) |
|
| 17 |
???? ???(LEFT, MID, RIGHT, LOWER, UPPER? |
|
| 18 |
??? ???(YEAR, MONTH, DAY, DATE, DATEDIF, TODAY ? |
|
| 19 |
???? ???(AVERAGEA, AVERAGEIF, COUNTA, COUNTIF ? |
|
| 20 |
???/???? ???(VLOOKUP, INDEX, MATCH ? |
|
| 21 |
?????????? ???(DSUM, DAVERAGE, DMAX ? |
|
| 22 |
?????????? ????????, ????? ????, ??? ??? |
|
| 23 |
?κ???. ????? ???, ??????? ??? |
|
| 24 |
????????, ???????, ???????? ???? ?? ???? |
|
| 25 |
?????? ????, ?????? ?, ????? ??? ?? ???? |
|
| 26 |
????? ????, ????? ???? ???? |
|
| 27 |
??? ????? ????? |
|
| 28 |
??? ????? ??? ??? ?? ???? |
|
| 29 |
??? ????? & ??? ??? ???? |
|
| 30 |
?μ? ???????. ?????? ??????, ?????? ???? |
|
|
| |
|
| |
|
