Ʃ 28 IT Ʃ ä ʺ 3 å !
ʺ ٷ ϴ Թ!
IT 3 Ǵ ʺ ϰ ֱ . پ ϴ κ ۾ ϰ ߿ ʺڰ ˾ƾ Ǿ ִ. IT 3 ʺ ð ȿ ģ Ȱ ֵ ȭ Ŀŧ Ѵ.
ȭ н ð ִٸ ε ̴. å ϵϰ ǿ Բ ϴ ʺ Ż ִ.
̳ʷ ù ȸȰ ǻ 湮 âϿ 13Ⱓ , ĿƮ, , 伥, , ̾ Ͽϴ. ¶ ȸ縦 ϸ鼭 θ â, α , Ʃ ȰϿ 4 , 3 ¶ ͳ Ǹ Ͽϴ. IT( ƴ IT) ǥ ټ б ȭ ַ ϰ ¶ ϰ ֽϴ. Ʃ ũͿ Ʃ 缺 鼭 3 IT ¶ α ϰ ֽϴ.
å Ȱ ̵ н ̵ Ȱ ̵Chapter 01 ó ٷ ˾ƾ ϴ ⺻ Lesson 01 ǻͿ ã ϱ PC α ã ϱLesson 02 Էϰ ϱ ǥ [ ] ɰ ؽƮ ⺻ ϱ [ ] Excel İ xlsx Ȯ [ IT ] ǥ Lesson 03 ϱ ⺻ ߰ϰ ϱ ϴ ߰ϱ [ ] Ű Ȱϱ Ʒ ǥϱ [ IT ] ȰϱLesson 04 پϰ ϰ ǥ ϱ ٸ ̸ ϱ 纻 PDF ϱ ī ǥ ̹ [ IT ] īī ǥ ̹ Lesson 05 ϰ, ϱ Էµ ؽƮ [ ] ѹ ϴ [] ϱ [ ] Ư Էϱ [ IT ] İ ϰ ϱ [ IT ] Ư ԷϱLesson 06 پ ٿֱ ϱ , ߶, ٿֱ پ ٿֱ [ ] ٿֱ ɼ ˾ƺ [ ] [Ͽ ٿֱ] ȭ [] ϱ [ ] [ ] Ÿ ϱ [ IT ] پ , ٿֱLesson 07 , ϰ ʺ, ϱ , Ӹ ʺ ϱ ʺ ϰ ϱ [ ] ϳ ϱ ϰ ϱ [ IT ] , ϱLesson 08 Ʈ ϱ Ʈ ߰, ϰ ̸ ϱ Ʈ ϰ ̸ ̵ϱ Ʈ ٸ Ϸ ̵ϱLesson 09 ȶ ڵ ä ϼϱ پ ڵ ä ¥ ڵ ä [ ] ¥ Է ¥ ϱ [ ] ڵ ä ɼǿ ¥ ä [ ] ä Ȱϱ [ IT ] ڵ ä Lesson 10 Ʋ ȭ Ȱϱ Ʋ Ȯ, ݼ, Ӹ, Է ߱Lesson 11 μغ ° ϱ Ը ° μϱ ϴ κи ϰ μϱ ݺ μϱ Ӹ۰ ٴڱ ߰ μϱ Ӹۿ ȸ ΰ ϱ [ ] , ϱLesson 12 μ ݿ ðǥ A4 ϱ ⺻ ä ǥ ϱ [ IT ] 30 ȿ ðǥ [ ] ڵ ä Ȯϰ ϴ Lesson 13 ǰǼ ǰǼ غϱ ǰǼ ä ̹ ٿֱ ǰǼ ϼϱLesson 14 Ӱ , ϱ ϱ [ ] ȭ ɰ Ϲ [ IT ] ϱLesson 15 Ͽ ȣ ϰ Ǯ ȣ ϱ ȣ ϱChapter 02 Լ ִ Lesson 01 ڵ հ հ ϱ ڵ հ հ ϱ [ ] پ ڵ հ ϱ [ ] ٸ Ʈ ϱ [ IT ] 0.1ʸ հ ϱLesson 02 հ, ִ, ּڰ ϱ ϱ ִ, ּڰ ϱLesson 03 Լ Լ ۼ ˾ƺ Լ հ踦 ϴ SUM Լ Էϱ [ ] Լ μ հ踦 ϴ SUM Լ ˾ƺ Լ ̺귯 ϴ AVERAGE Լ Էϱ [ ] ϴ AVERAGE Լ ˾ƺ Էٿ ִ ϴ MAX Լ Էϱ Լ μ ȭڷ ּڰ ϴ MIN Լ Էϱ [ ] ִ, ּڰ ϴ MAX, MIN Լ ˾ƺ ũƮ Լ Ȯϱ [ IT ] Լ SUM, AVERAGE, MAX, MIN Lesson 04 ð, ¥ õ پ Լ ˾ƺ ¥, ð Էϴ TODAY, NOW Լ ˾ƺ , , YEAR, MONTH, DAY Լ ǥ ϱLesson 05 ROUND 迭 Լ ø ݿø, ϱ ݿø ROUND Լ Ҽ ù° ڸ ݿøϱ ø ROUNDUP Լ 10 ϱ ROUNDDOWN Լ 1 ϱ[ ] ROUND 迭 Լ ˾ƺLesson 06 Ŀ ˾ƾ ϴ , ϱ Ȱ ȯ ϱLesson 07 ű RANK.EQ Լ ϴ RANK.EQ Լ ڵ Ǹŷ ϱ RANK.EQ Լ ݴ ϱ [ ] RANK, RANK.EQ Լ ˾ƺLesson 08 ̸ Ƿ Ǵ ϰ ϱ ̸ ϰ Լ Ȱϱ ǥ ѹ ̸ ϰ Ȯϱ ǵ ̸ Ǵ ϱLesson 09 IF, IFS Լ ϰ IF Լ ̿Ͽ ǥ ϱ [ ] ǿ ϴ ؽƮ ϴ IF Լ ˾ƺ IF Լ ø [ ] IF Լ øϴ ˾ƺ IFS Լ øϱ [ ] IFS Լ ԷϱLesson 10 ؽƮ ϴ κи ϴ پ Լ ʺ ؽƮ ϴ LEFT Լ ֹεϹȣ ϱ ߰ ؽƮ ϴ MID Լ ֹεϹȣ ϱ [ ] LEFT Լ MID Լ ˾ƺ ʺ ؽƮ ϴ RIGHT Լ ϱ CHOOSE Լ MID Լ Ͽ ֹεϹȣ ϱ [ ] ڴ ϴ CHOOSE Լ ˾ƺLesson 11 COUNT 迭 Լ COUNT 迭 Լ μ ˾ƺ COUNT Լ ü ο ϱ [ ] ڵ ϱ Ͱ ִ COUNTA Լ ȸ ο ϱ COUNTBLANK Լ ȸ ̳ ο ϱLesson 12 ǿ ϴ COUNTIF Լ ǿ ´ COUNTIF Լ ˾ƺ ǿ COUNTIF Լ μ ο ϱLesson 13 ǿ ϴ ϴ SUMIF Լ ǿ ϴ ϴ SUMIF Լ ˾ƺ ǥ ̸ Ͽ Ȱϱ SUMIF Լ з Ѽ ϱ SUMIF Լ з հ ϱLesson 14 VLOOKUP Լ ǥ ϴ ã VLOOKUP Լ Ȱ ǰڵ ǰ ã VLOOKUP Լ Ȱ ǰڵ ܰ ã VLOOKUP Լ Ȱ ٻ ϱ [ ] ġϴ ǥ ãִ VLOOKUP Լ ˾ƺ [ ] ذ Chapter 03 ϰ ϱLesson 01 Է ˾ƺ Է ټ ˾ƺ [ ] ̺ Lesson 02 , ϱ ȸ縦 ٴ ̸ Lesson 03 ϴ Ư ؽƮ ѹ ٲٴ ã ٲٱ [ ] ã ٲٱ [ɼ] ϳ ߺ ã ϱ ؽƮ [ ] ̵ϴ ŰLesson 04 ȿ Էϱ ȿ ˻ Ͽ Էϱ ȿ ˻ ؽƮ ԷϱLesson 05 Ѵ ִ Ʈ ϱ ǥ ͷ Ʈ ϴ Ʈ [ ] õϴ Ʈ ϱLesson 06 ϴ Ʈ ϱ 뿡 ڵ ٲ Ͱ ǥõǴ Ʈ Ʈ ߰ϱ ϱ Ʈ Ÿ ϱ Ʈ Ȱ ϴ ǥϱ [ ] Ʈ ٲ㼭 ǥϱ Ʈ ϰ Ʈ иϱLesson 07 ڵ ͷ ϰ зؼ ϰ ϱ Ƽ 200,000 ̻ ϱ ѹ ϱ ǽ ܾ ǰ ϱ ϴ ¥ ϱ [ ] ¥ ϱ Ϳ ڵ ϱLesson 08 ǥ Ͽ Ȱϱ ǥ ϱ ǥ Է ϱ ǥ ߰ϰ ϱ [ ] ߰ϱ ǥ ̼ ϱ ǥ ϱLesson 09 κ 캸 κ ϱ κ ϱLesson 10 ǹ ̺ ϴ ǹ ̺ ϱ ǹ ̺ Ϳ 1,000 ȣ ߰ϱ ǹ ̺ ̻ ʵ ϰ ϱ ǹ ̺ ϱ [ ] ǹ ̺ ؿ [] ʵ ϱ [ ] ǹ ̼ ߰ϰ ϱãƺ