˻ , Ẹ ģϴ!
ȸ翡 ϴ ٽ ɸ ̾ ǹ ° .
500
ǽ о Ʈ 1
25 ̻ 500 ް ִ ϱ⡯ ø ϰ ְ ǽ ٽ ǹԴϴ. ǻ翡 ϴ Ϳ å ϸ鼭 ñ̳ żϰ Ȯϰ óϿ A/S Ϻϰ åϴ.
ذ
ǽ ⺻⸦ źźϰ ְ, ȿ ִ ٽ ʼ Ͽ ˷ݴϴ.
å Microsoft 365, ǽ 2013 ֽ 2019 ־ ʿ ϴ ٷ ã ذ ֽϴ.
켱 TOP20
⺻+ǹ Ϻ
̹ iN, ǽ ǹ ī α, , ˻ϰ ãƺ Ű带 Ͻ ۼ α ǹ ʿ 켱 ɸ ȿ н ֵ ݴϴ. ϴ ¶ Ƿ .
CHAPTER 1 ⺻ ۼϱ
[]
Section 01 ϱ
01 ȭ 캸
02 ȭ 캸
[] 03 ϴ ߰ϱ
05 ´ ȯ ϱ
06 ߰ ġϱ
[]
Section 02 Ȯϰ ٷ
01 ˾ƺ
[켱] 02 ؽƮ ȣ Էϱ
03 ڿ ¥/ð Էϱ
04 ڷ ȯϰ Է ϱ
[] 05 ڵ ä ڵ Էϱ
[켱] 06 Է ϰ ϱ
Section 03 Ӱ ũƮ ٷ
[] 01 ϱ
[켱] [] 02 ϰ ̵ϱ
[켱] 03 ġ ̵ϰ ʺ ϱ
04 Ʈ ̸ Ʈ ġ ϱ
05 Ʈ ϱ
Section 04 μ ȯ ϱ
[켱] 01 ϱ
[] 02 μ μ ϱ
03 μ Ӹ/ٴڱ ϱ
04 μ ż ũ ϱ
05 ȣ ϱ
ٽ! ǹ Ʈ
OneDrive ϰ ϱ
CHAPTER 2 ð ǥϱ
[]
Section 01 ٹ̱
[] 02 ٹ̱
03 θ ϱ
[켱] 04 ڿ ¥ Ϳ ǥ ϱ
[켱][] 05 ǥ 캸
06 忡 ǥ ϱ
Section 02 Ǻ ϱ
[켱] 01 Ư ǿ ´ ϱ
02 / 20 Ǹ ϱ
[] 03 Ǻ İ Ģ ϱ
[] 04 мϱ
[Ʈ]
Section 03 Ʈ ũ ǥϱ
01 Ʈ ҿ Ʈ ۼϱ
[켱] 02 õ Ʈ ̿ Ʈ ϱ
[켱] 03 Ʈ Ʈ ϱ
[] 04 Ʈ ϱ
05 ũ ̿ Ǹ 캸
[] 06 ٸ Ʈ ϳ ǥϱ- Ʈ
07 ǥϱ-Ʈ Ʈ
ٽ! ǹ Ʈ
Ϳ Ͱ꼭 мϱ
ķ Ʈ ̿ мϱ
[] Ʈ ̿ Ͱ꼭 мϱ
CHAPTER 3 ǹ Լ ٷ
[Լ]
Section 01 İ ڵ Լ
[켱] 01 ۼ 캸
[] 02 ⺻ ̿ ϱ
03 ̸ ϱ
[켱][] 04 ڵ հ Լ ̿ հ/ ϱ
05 Լ ̺귯 ü ְ ݾ ϱ
Section 02 ⺻ Լ
[] 01 Ǹ հ ϱ⡡-SUBTOTAL Լ
02 ݾ ϱ – RANK.EQ Լ
03 ϱ –ROUND Լ
04 ϰ Top3 ϱ-LARGE Լ
05 Ƚ ϰ Ȯϱ – COUNT, OR Լ
[켱] 06 ϱ – IF Լ
07 ǰ/ȯ ϱ – LEFT Լ
08 óڿ ϱ – DATE, MONTH Լ
[] 09 ó ϱ – TEXT Լ
Section 03 ǹ Լ
[켱][] 01 з ϱ –IFS, VLOOKUP Լ
[켱][] 02 κ, з Ǹż Ѹ ϱ – SUMIFS Լ
03 ϱ – IFERROR, AVERAGEIFS Լ
[] 04 TF – VLOOKUP, COLUMN Լ
05 Ⱓ ϼ ˾ƺ – NETWORKDAYS, DATEDIF Լ
[] 06 Ʈ ϱ – INDEX, MATCH Լ
ٽ! ǹ Ʈ
ø Լ ۼϴ Ͽ!
ġϿ ø Լ ۼϱ
[] Ʈ Լ ġϱ
CHAPTER 4 ͺ̽ мϱ
[İ]
Section 01 ͺ̽ ٷ
01 ǥ ϰ ٹ̱
[] ǥ ϰ ϱ
[켱] 03 ʵ ̿ ϱ
04 ϱ
05 κ ̿ ۼϱ
06 κ ̿ ϱ
Section 02 ϴ ˻ϰ ϱ
[켱] 01 ڵ ̿ ϱ
02 Ϳ ǽ ϱ
03 ̿ ϱ
[]04 Լ ϱ
05 ϰ ϱ
[ǹ̺]
Section 03 м ٷ
01 õ ǹ ̺ ϰ ٹ̱
[켱][] 02 ǹ ̺ ߰ϱ
[] 03 ǹ ̺ ϰ ǥ ϱ
04 ǹ Ʈ ̿ ۼϱ
[] 05 ̼ ð ǥ ϱ
[ũ]
Section 04 ܺ Ŀ Ȱϱ(2016 ̻ )
01 CSV
[] 02 ٸ ǥ
[] 03 Ŀ ϱ
[] 04 Ŀ ȯϰ ߰ϱ
05 ߰ϰ ġ
ٽ! ǹ Ʈ
ȿ мϰ Ʈϱ
ǹ ̺ м Ǻ ̵ϱ
̼ ð ǥ ú ۼϱ
ĿƮ
CHAPTER 1 ⺻ ̼ ۼϱ
[ۼ]
Section 01 ĿƮ ϱ
01 ȭ 캸
02 ȭ 캸
03 ̼ 캸
04 ̼
[] 05 ī ̵ ϱ
[] 06 ϱ
07 ̼ ϱ
Section 02 ̵ ٷ
01 ̵ ϱ
02 ̵ ϰ ̾ƿ ϱ
03 ̵ ϰ ̵ϱ
04 ̵ ϰ ϱ
05 ̵ ϱ
[] 06 ̵ ϱ
[ؽƮ]
Section 03 ؽƮ ̵
[켱] 01 ؽƮ Էϱ
02 ۲ ؽƮ ٹ̱
03 ܶ ϱ
[] 04 ۸Ӹ ȣ ϱ
05 ȣ Ͽ ȣ ϱ
[] 06 ؽƮ ϱ
07 ѱ ܾ ߸ ʰ ٲٱ
08 Ʈ ŸϷ ٹ̱
09 ؽƮ ڷ ϴ ġ ؽƮ Էϱ
[ƮƮ ]
Section 04 ƮƮ ̵
[켱] 01 ƮƮ ϰ ̾ƿ ϱ
02 ƮƮ Ÿ ϱ
[] 03 ؽƮ ƮƮ ϱ
[] 04 ƮƮ ؽƮ ϱ
[] 05 ƮƮ ϱ
ٽ! ǹ Ʈ
۸Ӹ ȣ ؽƮ ϱ
CHAPTER 2 ü ־ ̼
[/]
Section 01 ̿ ̵
[켱] 01
[켱] 02 ȭϰ ְ ġϱ
[켱] 03 Ÿ ϰ Ʈ ϱ
04 ϱ
[] 05 ݺ ϱ
[] 06 ο
07 ڿ ü ȿ ϱ
08 ϱ
[/ǥ/Ʈ]
Section 02 ̹ ̿ ǰ ̼ ۼϱ
[켱] 01 ϴ ̹ 캸
02 ϰ ݰ ߱
03 ϰ ȿ ϱ
[] 04 ΰ ϰ ٲٱ
[켱] 05 ʿ ϰ ٲٱ
06 ϸ鼭 ٲٱ
[] 07 ڸ ȭ Ʈ
08 ϰ · ǵ
09 ٹ ϱ
Section 03 ǥ Ʈ ̵
[켱] 01 ǥ ϰ ؽƮ Էϱ
02 ǥ ǥ Ÿ ϱ
03 ǥ ̾ƿ ϱ
[] 04 ǥ θ ȿ ϱ
05 ǥ ϱ
[켱] 06 Ʈ ϰ / ȯϱ
[] 07 Ʈ ϰ ̾ƿ ϱ
ٽ! ǹ Ʈ
̼ ȿ ٹ̰ ϱ
CHAPTER 3 ġ Ƽ̼
[/]
Section 01 Ƽ̵ ̵
01 ϰ ڵ ϱ
02 Ÿϰ ȿ ϱ
[켱][] 03 ϴ κи ϱ
[켱][] 04 ϰ ϱ
05 ȭ ȭؼ ϱ
[ִϸ̼]
Section 02 ִϸ̼ ü ȿ ϱ
[켱] 01 Ŭ ϳ ϴ ִϸ̼
02 Ʈ ϰ ִϸ̼ ٲٱ
03 Ŭϸ ȭ鿡 ִϸ̼
[] 04 ó 帮 ؽƮ ǥϱ
[] 05 ȭ鿡 ǥϱ
03 ⡯ ִϸ̼ ϰ ð ϱ
[̵]
Section 03 ̵ ȭ ȯ ȿ ϱ
[켱] 01 ̵忡 ȭ ȯ ȿ ϱ
[] 02 ̵ ȭ ȯ ӵ ϱ
[] 03 ȯ Ư ȿ ϱ
04 ڵ Ǵ ̼
[켱] ǥ ó ̼ ǥϱ
ٽ! ǹ Ʈ
߰ κи ϱ
CHAPTER 4 ̼
[]
Section 01 ͷ ̼ ϱ
[켱][] 01 ̵ Ϳ ̵ ̾ƿ ϱ
[] 02 ̵ ϱ
[켱][] 03 ̵忡 ΰ ϱ
[] 04 Ưϰ ǥ ̵ ϱ
[켱][] 05 ̵忡 ̵ ȣ ϱ
Section 02 ũ ̿ ̵ϴ ̵
[켱][] 01 Ȯ/ҷ ȭ ̵
[] 02 Ȯ/ϴ ̵
03 ٸ ̵ ̵ϴ ũ
04 ̵ ٸ ϱ
[/μ]
Section 03 پ ̼ ϱ
[켱] 01 ̼ PDF ϱ
[] 02 ̼ ϱ
[] 03 ̼ CD Ű ϱ
04 ̼ ϱ
05 ʿ ̵常 ؼ ȸ μϱ
06 3̵ ι μϱ
ٽ! ǹ Ʈ
̵ ϱ
Section 03 ̼ μ ȯ ϱ
01 μ ̵ ϱ
[켱 20] 02 ʿ ̵常 ȸ μϱ
03 3̵ ι μϱ
04 Ư 徿 μϱ
! ǹ / ȸ μ / 2̵ ι μ
[ۼ]
CHAPTER 1 ⺻
Section 01 ϱ
01 ȭ 캸
02 ȭ 캸
[켱] 03 ۲, ۲ ũ, ۲ ϱ
[켱] 04 ȣ ϰ ȯϱ
05 پ
[켱] 06 ο ؽƮ ϱ
[] 07 ϴ ġ
[]
Section 02 ٹ̱
01 ܶ , θ ϱ
02 ù 鿩 ϱ
[켱] 03 ݰ ܶ ϱ
[켱][] 04 ϱ
05 յ ؽƮ ڵ ϱ
Section 03 ȣ ۸Ӹ ȣ
01 ȣ Ÿ
[켱][] 02 ۸Ӹ ȣ Ÿ ϱ
[켱][] 03 ٴܰ غ ϱ
04 ȣ ϱ
ٽ! ǹ Ʈ
ã ٲٱ ̿ ӵ
CHAPTER 2 ü ϱ
[]
Section 01 ϰ μϱ
[켱] 01 ϱ
[켱] 02 PDF ϱ
[] 03 ϰ
[켱] 04 ϱ
05 μϱ
[ü]
Section 02 ʿ ϰ ü ϱ
[켱][] 01 ϰ ؽƮ ︮ ġϱ
[켱] 02 ǥ ϼϱ
03 ۸ũ ϱ
04 ϰ ϱ
[] 05 ϰ ϱ
[켱] ¶ ϰ ϱ
Section 03 ǥ Ʈ ϱ
[켱] 01 ǥ ϰ Ÿ ϱ
02 ǥ ߰ϱ
[켱] 03 ǥ ũ ʺ/ ϱ
[] 04 ǥ 밢 θ ϱ
[켱][] 05 Ʈ ϰ Ʈ ϱ
ٽ! ǹ Ʈ
ҿ ǥ ߰ϰ ϱ
CHAPTER 3 ǰ ۼϱ
[Ÿ]
Section 01 Ÿ ̿ ϰ ִ ۼϱ
[켱] 01 Ÿ ϱ
02 ܶ Ÿ ϰ ϱ
[] 03 Ÿ ϱ
04 ŸϿ ϱ
[켱] 05 Ÿ ̿ ڵ ۼϱ
[]
Section 02 ϱ
01 ũ θ ϱ
[켱] 02 ȣ ϱ
[켱] 03 Ӹ ϰ ¥ ϱ
04 ٴ ϰ
[] 05 ٲ κ
[ۼ]
Section 03 , , ۼϱ
[] 01 ϱ
[] 02 ϼϱ
03 Ʈ ۼϱ
04 ϱ
ٽ! ǹ Ʈ
̿ ڵ ʴ ϱ
ѱ(2020)
Chapter 1 ⺻ ۼϱ
[ۼ]
Section 01 ѱ 2020 ϱ
01 ȭ 캸
02 ڿ 캸
03 ̿
04 ؽƮ Էϱ
[켱][] 05 Էϰ ȯϱ
[켱][] 06 Ư Էϰ ġ
07 ۾ ǵ ٽ ϱ
[ۼ]
Section 02 İ ̿ ٹ̱
[켱][] 01 ϰ ϱ
[켱] 02 ۲ð ũ ٲٱ
03 ٲٱ
[켱][] 04 ٲٰ 鿩 ϱ
[켱] 05 ã ٲٱ ؽƮ ϱ
[켱] 06 θ ٹ̰ ϱ
[켱][] 07 ϱ
Section 03 ϰ μϱ
01 ٲٱ
02 ϰ ϱ
03 ϱ
[켱][] 04 ٸ ϱ
05 μ ȯ ϰ μ ̸
ٽ! ǹ Ʈ
PDF ᄒᆞᆫPDF ּ ޱ
Chapter 2 پ ۼϱ
[]
Section 01 ִ ü
[켱] 01 ۸Ӹǥ ̿ ϱ
[켱][] 02 ȣ ϱ
03 ȣ ϰ ϱ
04 ϱ
[] 05 ȣ
! ǹ / ȣ /
[]
Section 02 ϱ
01 θ ϱ
[켱] 02 Ӹ/ ϱ
[켱] 03 ȣ ű
[] 04 ٴ ̾ƿ ϱ
[켱][] 05 ٸ ϱ
06 ּ ް ֱ
[ü]
Section 03 ü ٹ̱
[켱][] 01 ϱ
[켱] 02 ۻ ؽƮ Էϱ
03 ٲٰ ϱ
04 URL ּҿ ۸ũ ϱ
05 ϰ ϱ
06 Էϱ
[ǥ/Ʈ]
Section 04 ǥ Ʈ ϱ
[켱] 01 ǥ ϰ Էϱ
[켱][] 02 ǥ ߰ϰ ġ
[] 03 ǥ ũ ϱ
04 ǥ ϱ
05 ǥ ϴ Ʈ ۼϱ
ٽ! ǹ Ʈ
Ʈ ϰ ϱ
Chapter 3 ۼϱ
[Ÿ]
Section 01 Ÿϰ ۼϱ
[켱] 01 Ÿϰ Ÿ ϱ
[] 02 Ÿ ϱ
03 ٸ Ÿ ϱ
04 Ÿ
[] 05 Ÿ ̿
Section 02
[켱][] 01 ̿ ʴ ۼϱ
02 DM ۿ
03 ͷ ϼϱ
04 ü ̿ ѽ ǥ ۼϱ