, ĿƮ, , ѱ н ִ 켱 ٽɱɸ ! ȭ ǹ ܼ ϴ ϴ !ǽ 2007, 2010, 2013, 2016, Office 365 ѱ 2010, 2014, NEO, 2018 ǹ ϴ ʿ , ĿƮ, , ѱ å н ִ. α ֿ켱 88 нϰ ȸ翡 ٷ 500 ǹ ϸ鼭 ǽ ʺ Ȯϰ Ȱϴ Ѵ. ȿ , ĿƮ û ǥ Ͽ츦, ѱۿ ǹ ٷ Դ ۼ źź ǹ ִ.
Z, Zװ, Zڴ, ZƼķ۽, Zȭ, Ǽ, , , , Ѿ, ķ۽, ȿ, , ΰǰ ĿƮ, α Ǹ ߽ϴ. ȭŻ, Ű, ұ ϰ , δ ȸ翡 ٷ ϴ ǹ ǡ(Ѻ̵, 2018), ȸ翡 ٷ ϴ +ĿƮ+ 2016&ѱ NEO& 10(Ѻ̵, 2018), ȸ翡 ٷ ϴ 2016 FOR STARTERS(Ѻ̵, 2017) ֽϴ
PART 01 CHAPTER 01 ۼϱ 000 ⺻ ȭ 캸 ٽɱɽǽ 001 Ϸ ϱ ٽɱɽǽ 002 PDF Ϸ ϱ ٽɱɽǽ 003 ȭ ̱/ ٽɱɽǽ 004 Ű ϱ__[켱 ] __ Note Ű ٽɱɽǽ 005 ̸ Ƿ ϱ__[켱 ] __ Note ̸ ڷ ̸ //ϱ ٽɱɽǽ 006 ʺ ϱ ٽɱɽǽ 007 ʺ Ͽ ٿֱ Ͽ ٿֱ __ Note ҿ ٽ ٽɱɽǽ 008 Ͽ ٿֱ __ Note Ͽ ٿֱ ɼ 캸 ٽɱɽǽ 009 ũƮ ̸ ϱ__[켱 ] ٽɱɽǽ 010 ũƮ ̵//ϱ__[켱 ] ٽɱɽǽ 011 ũƮ ȣϱ __ Note [] -[ȣ] 캸 ٽɱɽǽ 012 / Էϱ__[켱 ] ٽɱɽǽ 013 ¥/ð Էϱ__[켱 ] __ Note ¥ ð ٽɱɽǽ 014 /ȣ Էϱ __ Note ڸ ̿ؼ Ư Էϱ ٽɱɽǽ 015 /ϱ ٽɱɽǽ 016 ä ڵ ̿ ä__[켱 ] ٽɱɽǽ 017 ä żϰ ä ٽɱɽǽ 018 ȿ ˻ ѱ/ ϱ ٽɱɽǽ 019 ȿ ˻ ϱ CHAPTER 02 μϱٽɱɽǽ 020 ǥ Ÿϰ Ÿ ϱ ٽɱɽǽ 021 ǥ ȯϱ ٽɱɽǽ 022 ۲ 쿡 ϱ__[켱 ] ٽɱɽǽ 023 , ǥ 쿡 ϱ__[켱 ] ٽɱɽǽ 024 , ǥ ϱ__[켱 ] __ Note ǥ ٽɱɽǽ 025 ڸ ѱ۷ ǥϴ ϱ __ Note ڸ ѱ, ڷ ǥϴ ڵ ٽɱɽǽ 026 ǥ //0 ϱ ٽɱɽǽ 027 鸸 ڸ/ ǥ ǥϱ ٽɱɽǽ 028 ϰ ð ǥ ϱ __ Note ¥/ð Ŀ Ǵ ǥ ٽɱɽǽ 029 / Ģ Ǻ ϱ__[켱 ] ٽɱɽǽ 030 , Ǻ ϱ ٽɱɽǽ 031 Ǻ Ģ ϱ ٽɱɽǽ 032 Ǻ ϱ ٽɱɽǽ 033 м ǥ, Ǻ ϱ ٽɱɽǽ 034 Ʋ ϱ ٽɱɽǽ 035 ٵǽ ؼ ۾ϱ ٽɱɽǽ 036 μ ̸ μ ϱ__[켱 ] ٽɱɽǽ 037 ݺ μ ϱ ٽɱɽǽ 038 ̸ μ ϱ ٽɱɽǽ 039 м ϱ ٽɱɽǽ 040 ̾ƿ Ӹ/ٴڱ ϱ ٽɱɽǽ 041 ϱ __ Note [Ӹ/ٴڱ ]-[] 캸 CHAPTER 03 ۼ Լ Ȱϱٽɱɽǽ 042 __[켱 ] ٽɱɽǽ 043 __[켱 ] ٽɱɽǽ 044 ȥ __[켱 ] __ Note ٽɱɽǽ 045 ̸ ٽɱɽǽ 046 ڵ հ ϱ ٽɱɽǽ 047 ǥ ̿ ϱ __ Note ǥ ٽɱɽǽ 048 ǥ ϱ ٽɱɽǽ 049 MAX, LARGE Լ ִ ϱ(Լ ̺귯 ڵ ϼ ̿ϱ) __ Note Լ ˾ƺ ٽɱɽǽ 050 COUNTBLANK, COUNTA Լ ⼮/Ἦ ϱ__[켱 ] ٽɱɽǽ 051 INT, ROUND Լ ݿø ǥϱ ٽɱɽǽ 052 QUOTIENT, MOD Լ , ǥϱ ٽɱɽǽ 053 ROW, SUMPRODUCT Լ ȣ հ ݾ ϱ ٽɱɽǽ 054 RANK.EQ, RANK.AVG Լ ϱ ٽɱɽǽ 055 IF Լ ڿ ϱ__[켱 ] ٽɱɽǽ 056 ø IF Լ ſ ϱ ٽɱɽǽ 057 IF, AND, OR Լ ſ뵵 зϱ ٽɱɽǽ 058 COUNTIF, COUNTIFS Լ ϴ ο ϱ__[켱 ] ٽɱɽǽ 059 SUMIF, SUMIFS Լ ϴ հ ϱ__[켱 ] ٽɱɽǽ 060 FREQUENCY Լ ɴ ϱ ٽɱɽǽ 061 CHOOSE, MID Լ ϱ ٽɱɽǽ 062 DATE, LEFT, MID Լ ϱ ٽɱɽǽ 063 LEFT, FIND, SUBSTITUTE Լ ̵ ̸ ּ ϱ ٽɱɽǽ 064 DATEDIF, EOMONTH Լ ٹⰣ ϱ __ Note ¥ , , ϴ DATEDIF Լ ٽɱɽǽ 065 HLOOKUP, VLOOKUP Լ ǰ, ܰ, ǥϱ__[켱 ] __ Note Table_Array( ) Ģ ٽɱɽǽ 066 IFERROR Լ óϱ__[켱 ] ٽɱɽǽ 067 INDEX, MATCH Լ ü ϱ CHAPTER 04 Ʈ ٽɱɽǽ 068 Ϳ Ʈ Ʈ ϱ__[켱 ] ٽɱɽǽ 069 Ʈ ̾ƿ, , Ÿ, ϱ ٽɱɽǽ 070 Ʈ ̺, ǥϱ ٽɱɽǽ 071 Ʈ ݼ ֱ__[켱 ] ٽɱɽǽ 072 Ʈ 3 ٲٱ__[켱 ] ٽɱɽǽ 073 ( ȥ) Ʈ ٽɱɽǽ 074 Ʈ Ʈ Ѵ 캸 ٽɱɽǽ 075 ũ Ʈ ϰ ϱ ٽɱɽǽ 076 ũ Ʈ Ÿϰ ϱ CHAPTER 05 ͺ̽ /м ڵȭϱٽɱɽǽ 077 ؽƮ __[켱 ] ٽɱɽǽ 078 ߺ ϱ__[켱 ] ٽɱɽǽ 079 ϰ ϱ__[켱 ] ٽɱɽǽ 080 ϱ__[켱 ] __ Note ͺ̽ ۼ Ģ ٽɱɽǽ 081 ڰ ϱ ٽɱɽǽ 082 SUBTOTAL Լ ̿ ϱ __ Note κ ϴ SUBTOTAL Լ ٽɱɽǽ 083 ڵ ͷ ϱ__[켱 ] ٽɱɽǽ 084 հ 10 ϱ ٽɱɽǽ 085 κ ۼϱ__[켱 ] ٽɱɽǽ 086 κ ϱ ٽɱɽǽ 087 õ ǹ ̺ ٽɱɽǽ 088 ǹ ̺ __[켱 ] ٽɱɽǽ 089 ǹ ̺ / ʵ ϱ ٽɱɽǽ 090 ǹ ̺ ̾ƿ ϱ ٽɱɽǽ 091 ǹ ̺ ̼, ð ǥ /ϱ ٽɱɽǽ 092 ߰ ũ ϱ ٽɱɽǽ 093 ڵ ũ ϱ ٽɱɽǽ 094 ٷ Ű Ʈѷ ũ ϱ ٽɱɽǽ 095 ũ ϱ __ Note ־ ̽ ȭ 캸 ٽɱɽǽ 096 ũ ϱ PART 02 ĿƮCHAPTER 01 ⺻ ̼ 000 ĿƮ ⺻ ȭ 캸 ٽɱɽǽ 001 ٽɱɽǽ 002 ϴ ϱ ٽɱɽǽ 003 ̵ ũ ϱ__[켱 ] ٽɱɽǽ 004 ̵ ߰ ̾ƿ ϱ__[켱 ] ٽɱɽǽ 005 ̵ ̵ / / ٿֱ / ϱ__[켱 ] __ ĿƮ Note ٿֱ ɼ ٽɱɽǽ 006 ؽƮ Է Ÿ ϱ__[켱 ] ٽɱɽǽ 007 Ÿ WordArt ؽƮ Էϱ__[켱 ] ٽɱɽǽ 008 Ÿ ϱ__[켱 ] ٽɱɽǽ 009 Ÿ ϱ__[켱 ] ٽɱɽǽ 010 ǥ Ÿ ϱ__[켱 ] ٽɱɽǽ 011 Ʈ Ÿ ϱ__[켱 ] ٽɱɽǽ 012 ̼ ϱ__[켱 ] __ ĿƮ Note ڵ ڵ ϱ CHAPTER 02 ̼ ̵ ٽɱɽǽ 013 ۲ __[켱 ] ٽɱɽǽ 014 __[켱 ] ٽɱɽǽ 015 ̵ ϱ ٽɱɽǽ 016 ̵ ĸ ϱ ٽɱɽǽ 017 ̾ƿ ̵ ϱ ٽɱɽǽ 018 ̵忡 ȣ ϱ ٽɱɽǽ 019 ϱ CHAPTER 03 ̼ ۼ ϱٽɱɽǽ 020 ̵忡 ؽƮ Էϱ ٽɱɽǽ 021 ۲, ۲ ũ, ۲ ϱ__[켱 ] __ ĿƮ Note Ʈ ٿε ϱ ٽɱɽǽ 022 ۸Ӹ ȣ ϱ __ ĿƮ Note ۸Ӹ ȣ ϱ ٽɱɽǽ 023 ۸Ӹ ȣ ȣ ϱ ٽɱɽǽ 024 ܶ ϱ ٽɱɽǽ 025 ϱ CHAPTER 04 ̼ ðȭ ϱٽɱɽǽ 026 ϱ__[켱 ] ٽɱɽǽ 027 Ͽ ο ٽɱɽǽ 028 ũ ϱ ٽɱɽǽ 029 յ ϱ __ ĿƮ Note Ʈ ̵ ǥ ϱ ٽɱɽǽ 030 Ʈ ϱ ٽɱɽǽ 031 ٸ Ȱ ϱ ٽɱɽǽ 032 ü ٽɱɽǽ 033 SmartArt ؽƮ Էϱ__[켱 ] ٽɱɽǽ 034 SmartArt Ÿ ϱ ٽɱɽǽ 035 SmartArt ȿ ߰ϱ ٽɱɽǽ 036 ؽƮ SmartArt ȯϱ ٽɱɽǽ 037 SmartArt ȯϱ ٽɱɽǽ 038 ǥ ϱ ٽɱɽǽ 039 Ʈ ϱ ٽɱɽǽ 040 Ʈ Ȱϱ ٽɱɽǽ 041 ¶ ϱ ٽɱɽǽ 042 Ư κи ϱ ٽɱɽǽ 043 ϰ ϱ ٽɱɽǽ 044 ʿ κ ϱ ٽɱɽǽ 045 ϴ ڸ 뷮 ̱ ٽɱɽǽ 046 ȭ Ϻκ ĸóϿ ̵忡 ߰ϱ CHAPTER 05 ̼ǿ Ƽ̵ ϰ ϱٽɱɽǽ 047 Ŭ Ư ̵ ϱ__[켱 ] ٽɱɽǽ 048 ü Ŭ ϴ κи ٽɱɽǽ 049 ε巴 ϰ Ŭ ٽɱɽǽ 050 Ÿ ϱ__[켱 ] __ ĿƮ Note ¶ο ִ ϱ ٽɱɽǽ 051 Ŭ ϱ ٽɱɽǽ 052 ü Ŭ ϴ κи ٽɱɽǽ 053 Ŭ Ư ϱ ٽɱɽǽ 054 Ŭ ̸ ̹ ϱ ٽɱɽǽ 055 ̵ ϱ CHAPTER 06 ̼ ̵ ϱٽɱɽǽ 056 ̵带 ϱ ٽɱɽǽ 057 ̼ ϱ __ ĿƮ Note Ŭ OneDrive ٽɱɽǽ 058 PDF ٽɱɽǽ 059 __ ĿƮ Note ϱ ٽɱɽǽ 060 ̼ ٽɱɽǽ 061 ̵带 JPEG Ϸ ϱ CHAPTER 07 ̼ ǥ غ ǥϱٽɱɽǽ 062 ü ִϸ̼ ϱ__[켱 ] ٽɱɽǽ 063 ִϸ̼ ߰ϰ ٸ ü Ȱ ϱ ٽɱɽǽ 064 ̵忡 ȭ ȯ ȿ ϱ__[켱 ] __ ĿƮ Note ȯ ȿ ϱ ٽɱɽǽ 065 ̵ ϱ __ ĿƮ Note [ ] ȭ ˾ƺ ٽɱɽǽ 066 ̵ 籸ϱ ٽɱɽǽ 067 ǥ ۼϰ μϱ ٽɱɽǽ 068 û ι μϱ __ ĿƮ Note ι ȣ ϱ ٽɱɽǽ 069 ǥ ϱ ٽɱɽǽ 070 ̵ ϱ__[켱 ] ٽɱɽǽ 071 ǥ Ͽ ǥϱ__[켱 ] ٽɱɽǽ 072 ̵ ȭϱ ٽɱɽǽ 073 ¶ ̼ ϱ PART 03 CHAPTER 01 ⺻ 000 ⺻ ȭ 캸 ٽɱɽǽ 001 ϱ ٽɱɽǽ 002 ȣ ϱ ٽɱɽǽ 003 ȭ Ȯ/ϰ ɼ ϱ CHAPTER 02 Է ⺻ ϱٽɱɽǽ 004 Է ȯϰ ϴ ϱ__[켱 ] ٽɱɽǽ 005 Ư ȣ Էϱ __ Note Ư ٷ Ű Ȯϱ ٽɱɽǽ 006 ȣ Էϰ ڵ ħ ϱ __ Note ڵ ħ ϱ ٽɱɽǽ 007 ã ٲٱ __ Note [ã ٲٱ] ȭ [ٲٱ] 캸 ٽɱɽǽ 008 ٽ ϱ ٽɱɽǽ 009 ̵ ϰ ǥ __ Note Ʈ ± ϱ __ Note [Ŭ] ۾ â 캸 ٽɱɽǽ 010 ϱ __ Note ǥ ϱ CHAPTER 03 ۲ ٹ̱ٽɱɽǽ 011 ۲, ۲ , ۲ ũ, ϱ__[켱 ] __ Note Ÿ ϱ ٽɱɽǽ 012 ݰ ϱ__[켱 ] ٽɱɽǽ 013 ȿ ϱ __ Note [ؽƮ ȿ ] ȭ ɼ 캸 ٽɱɽǽ 014 ÷, , Էϱ__[켱 ] CHAPTER 04 ܶ ٹ̱ٽɱɽǽ 015 ܶ ȣ ϰ ȣ ϱ__[켱 ] __ Note ܶ 鿩 ϱ ٽɱɽǽ 016 ܶ ۸Ӹ ȣ ϱ__[켱 ] ٽɱɽǽ 017 ù 鿩 ° 鿩__[켱 ] __ Note ѱ۰ ڵ ϱ ٽɱɽǽ 018 ܶ ϱ__[켱 ] ٽɱɽǽ 019 ܶ ϰ ϱ ٽɱɽǽ 020 ٴ ϱ__[켱 ] __ Note [] ȭ ˾ƺ ٽɱɽǽ 021 Ÿ ̿Ͽ Ÿ ϱ ٽɱɽǽ 022 Ÿ __[켱 ] __ Note ȣ Ÿ ϱ CHAPTER 05 ü Ȱϱٽɱɽǽ 023 ˻ ϰ ϱ ٽɱɽǽ 024 ؽƮ ġϱ__[켱 ] __ Note [ؽƮ ٲ] ̿ϱ ٽɱɽǽ 025 ٹ̰ ĸ ϱ ٽɱɽǽ 026 ϰ ȿ ؽƮ Էϱ __ Note [ ] ۾ â Ȱϱ ٽɱɽǽ 027 , , ȸϱ__[켱 ] __ Note 콺 巡Ͽ ü ϱ ٽɱɽǽ 028 WordArt ϱ ٽɱɽǽ 029 SmartArt ̾ ٽɱɽǽ 030 Ʈ ϰ Ÿ, , ũ ϱ__[켱 ] ٽɱɽǽ 031 Ʈ ̾ƿ ϰ Ʈ ϱ CHAPTER 06 ǥ ٹ̱ٽɱɽǽ 032 ǥ , ũ , ̵, ϱ__[켱 ] ٽɱɽǽ 033 ǥ / , ϰ ڿ ϱ__[켱 ] ٽɱɽǽ 034 θ ϱ__[켱 ] __ Note [θ ] ̿ θ ϱ ٽɱɽǽ 035 ǥ Ÿ ϱ ٽɱɽǽ 036 ǥ ̳ ϱ ٽɱɽǽ 037 ̿Ͽ ǥ ڵ ϱ CHAPTER 07 ϱٽɱɽǽ 038 ϰ ٽɱɽǽ 039 θ ϱ ٽɱɽǽ 040 Ӹ/ٴڱ ϱ__[켱 ] ٽɱɽǽ 041 Ӹ/ٴڱ ϱ ٽɱɽǽ 042 ¦/Ȧ ٴڱ ϱ__[켱 ] ٽɱɽǽ 043 ȣ /ϰ ϱ ٽɱɽǽ 044 ֿ ϱ ٽɱɽǽ 045 ٽɱɽǽ 046 ǥ ϰ ũ ϱ ٽɱɽǽ 047 ϱ__[켱 ]__ Note ϱ ٽɱɽǽ 048 μ ̸ μϱ__[켱 ] __ Note μ ̸ 캸 PART 04 ѱCHAPTER 01 ѱ ⺻ 000 ѱ ⺻ ȭ 캸 __ ѱ Note / ٽɱɽǽ 001 ϱ __ ѱ Note ٸ ̸ ϱ ٽɱɽǽ 002 ҷ ȣ ϱ __ ѱ Note [ҷ] ȭ ˾ƺ __ ѱ Note [ ȣ ] ȭ ˾ƺ ٽɱɽǽ 003 ڵ ϱ __ ѱ Note [ ] ȭ ˾ƺ CHAPTER 02 Է ⺻ ϱٽɱɽǽ 004 Է ȯϱ__[켱 ] __ ѱ Note [ڷ ٲٱ] ȭ ˾ƺ __ ѱ Note ȹ μ ̿ؼ Էϱ ٽɱɽǽ 005 ܾ ϱ __ ѱ Note [ ܾ ] ȭ ˾ƺ ٽɱɽǽ 006 ǥ ̿ Ư Էϱ ٽɱɽǽ 007 ȣ Էϱ ٽɱɽǽ 008 ϱ ٽɱɽǽ 009 å/۸ũ ̿ϱ __ ѱ Note [å] ȭ ˾ƺ __ ѱ Note [۸ũ] ȭ ˾ƺ ٽɱɽǽ 010 ˻ϱ__[켱 ] __ ѱ Note [ ˻/] ȭ ˾ƺ ٽɱɽǽ 011 ѱ ϱ CHAPTER 03 ۲ ٹ̱ٽɱɽǽ 012 Ŭ ϱ __ ѱ Note [Ŭ] ۾ â ˾ƺ __ ѱ Note 콺 ̵ϱ ٽɱɽǽ 013 ۲, , ũ ϱ__[켱 ] __ ѱ Note [ ] ȭ [⺻] ˾ƺ ٽɱɽǽ 014 ϱ __ ѱ Note [ ] ȭ [θ/] ˾ƺ __ ѱ Note ϱ ٽɱɽǽ 015 , , Ҽ ϱ__[켱 ] __ ѱ Note [ ] ȭ [Ȯ] ˾ƺ ٽɱɽǽ 016 ڰ, ϱ__[켱 ] ٽɱɽǽ 017 ϱ __ ѱ Note [ ] ȭ ˾ƺ CHAPTER 04 ٹ̱ٽɱɽǽ 018 ϱ__[켱 ] ٽɱɽǽ 019 鿩 __[켱 ] ٽɱɽǽ 020 ȣ ȣ Ȱϱ__[켱 ] ٽɱɽǽ 021 Ÿ ϱ__[켱 ] ٽɱɽǽ 022 Ÿ ϱ ٽɱɽǽ 023 Ÿ ߰ϱ __ ѱ Note / ȣ ȣ ϱ ٽɱɽǽ 024 ã ã ٲٱ __ ѱ Note [ ٲٱ] ̿ ã ٲٱ ٽɱɽǽ 025 м ְ ϱ ٽɱɽǽ 026 θ ٹ̱ CHAPTER 05 ٹ̱ٽɱɽǽ 027 ϱ__[켱 ] ٽɱɽǽ 028 Ӹ/ ϱ__[켱 ] ٽɱɽǽ 029 ȣ ֱ ٽɱɽǽ 030 ȣ ȣ ϱ ٽɱɽǽ 031 ȣ ⸦ ̿ ȣ ٽɱɽǽ 032 ٴ ٹ̱__[켱 ] ٽɱɽǽ 033 ϱ ٽɱɽǽ 034 /ַ ο ۼϱ ٽɱɽǽ 035 ٽɱɽǽ 036 ȭ ȸ __ ѱ Note μ ̸ ̸ CHAPTER 06 ü Ȱϱٽɱɽǽ 037 ĸ ϱ ٽɱɽǽ 038 ϰ ġ ϱ__[켱 ] __ ѱ Note ġ ϱ ٽɱɽǽ 039 ٹ̱ ٽɱɽǽ 040 ŬƮ ϱ ٽɱɽǽ 041 ٹ̰ ϱ__[켱 ] CHAPTER 07 ǥ ٹ̱ٽɱɽǽ 042 ǥ , ũ , ̵ϱ__[켱 ] ٽɱɽǽ 043 /ĭ ϱ__[켱 ] ٽɱɽǽ 044 ġ ٽɱɽǽ 045 ̿ ϱ ٽɱɽǽ 046 ǥ /̱/ ̿ϱ ٽɱɽǽ 047 ǥ Ӽ ϱ ٽɱɽǽ 048 ǥ ̳ ϱ ٽɱɽǽ 049 ǥ Ű ũ ϱ