ϸ ߱ ߴ.
Ʈ Į!
̹ ͼ ΰ ͼ Ʈ ұ? ʿ信 ٲϴ! Ʈ ۾, Ŭ, 迭 , ۽ ũƮ ѷ ְ, ̷ Ұϰų ŷο ۾ ִ. ߷ , Ʈ ġ⡻ μ ްϰ ϰ, ӵ 䱸Ǵ ٹ ȯ濡 Ʈ ȿ ϴ ˾ƺ.
б 濵а ϰ 2003 ȸ 迡 հߴ. 2004 2011 ȸ 纻ο ܺΰ, ȸ , SAP ERP ߰ 2014 FAS ο μǻ, Űڹ, cross-border M&A ߴ. ÷ ȸ翡 CFO ϸ ڽ 繫, 濵, IR Ѱ߰ ũ ŸƮ CFO ϸ Ʈ ̿ μ ٲٴ ߴ. ¶ Ŀӽ ÷ CFO ϰ ִ.
CHAPTER 01 Ʈ 1.1 Ʈ ũ̽ vs Ʈ Ʈ Ư¡ 1.2 ̺ ̺꿡 , ϱ ̺ ġ Ȯϱ ̺ 1.3 Ʈ ó̶ø Ʈ ϱ Ϸ ۾ϱ Ʈ ȯؼ Ȱϱ Ʈ 纻 CHAPTER 02 Ʈ ⺻ ۾2.1 Էϰ ٲٱ Էϱ [ ] Ʈ ԡ [ ] ũ⺸ Էµ ̰ ٿֱ [ ] Ctrl + Enter ۵ [ ] ȭ鿡 ̴ ã/ٲٱ [ ] ˻ ɼ 2.2 Էϱ Էغ ̰ ϰ Էϰ ϴ 2.3 Ʈ ̿ Ʈ а Ʈ ߰// [ ] Ʈ ̵ [ ] Ʈ ó ٸ Ʈ ϱ Ʈ Ʈ URL ϱ2.4 ۲, ϱ۲ ϱ ϱ [ ] ⺻ [ ] [ ] , ϱ [ ] ǥ Ÿ [ ] ¥ [ ] ý θ ϱ / ϱ 2.5 ۾: Ʈ ۾ ÿ ϰ Ǵ Ʈ , ä ٸ ϱ ˸ Ģ: Ǹ ̸ ޱ Ȱ ú ۾ ϱCHAPTER 03 Լ ۾ϱ3.1 Լ ϴ Լ ִ ϴ μ ãƳ ٽ ԼSUM, IF, COUNTIF, COUNTIFS Ƚ μ ϱ ٽ ԼAVERAGE, RANK, COUNTAλ ̺ μ ϱ ٽ ԼVLOOKUP3.2 /ǥ Լʰ, ̴ް ϱ ٽ ԼMAX, MINҼ Ʒ ݿø, , øϱ ٽ ԼROUND, ROUNDDOWN, ROUNDUP3.3 ڿ Լڿ ϴ ̾Ƴ ٽ ԼLEFT, RIGHT, MIDڿ ϴ ġ ãƳ ٽ ԼSEARCH, FINDڿ Ϻθ ****** ٲٱ ٽ ԼREPLACEڿ Ե - ϰ ϱ ٽ ԼSUBSTITUTEڿ Ե ϱ ٽ ԼTRIMڿ ¥ ȯϱ ٽ ԼDATE ڿ Ͽ ü ڵ ٽ ԼTEXTJOIN, JOIN3.4 /Ž Լǵ Ǿ Ȯϱ ٽ ԼAND, OR ǵ Ȯϴ ٽ ԼIF, IFSǰ/¥ հ ٽ ԼSUMIF, SUMIFSμ ڵ ϴ ȣ ̱ ٽ ԼMAXIFS ġϴ ġ ã ٽ ԼMATCH ġ ٽ ԼINDEX ٽ ԼVLOOKUP 0 ٲ ǥϱ ٽ ԼIFERROR3.5 ¥/ð Լ ¥ ϱ ٽ ԼTODAY Ÿӽ ߰ϱ ٽ ԼNOWڸ ¥ ٲٱ ٽ ԼYEAR, MONTH, DAYԻϰ Ϸ ټӿ ټӿ ϱ ٽ ԼDATEDIF ȸä ϱ ٽ ԼEOMONTH ¥ ϱ ٽ ԼWORKDAY, NETWORKDAYSCHAPTER 04 ͷ ۾ϱ4.1 ϱ Ʈ İ 4.2 ͷ ϱ [ ] ڵ , Լ ٽ ԼFILTER4.3 ǹ ̺ ϱǹ ̺ Ἥ հ ǹ ̺ ʵ带 ߰ϰ ̾ƿ ϱ ̼ ذ ʵ ǹ ̺ ٲֱȭ ǹ ̺ ϱ ؾ 4.4 , Ǻ ̺ ٹ̱ Ǻ Ͽ ڷ ã 4.5 ϰ ϰ Էϱߺ ϱ ؽƮ Ȯ [ ] Ӵٿ 4.6 Ʈ ̺ ϰ ȭCHAPTER 05 迭 ϱ5.1 迭 Լ ϱ迭 Լ ؽƮ ϱ ٽ ԼSPLIT, INDEX[ ] Ʈ ִ SPLIT Լ ߺ Լ ϱ ٽ ԼUNIQUEĵ Լ óϱ ٽ ԼSORT5.2 迭 ٷ迭 Լ ϸ ? ߰ȣ 5.3 ȯ Լ ARRAYFORMULAARRAYFORMULA ٽ ˾ƺ Լ ARRAYFORMULA &ٿֱ ֱ ٽ ԼARRAYFORMULAڵ Ǵ ϰ ̸ ּ ARRAYFORMULA 迭 VLOOKUP ε ҷ ARRAYFORMULA ؾ CHAPTER 06 Լ ͼ мϱ 6.1 ܺ Ʈ ϴ IMPORTRANGE ԼIMPORTRANGE IMPORTRANGE ֽ ҽ ϱ ٽ ԼIMPORTRANGE6.2 QUERY Լ ϴ QUERY Լ, ϰ ϱ ٽ ԼQUERYQUERY Լ QUERY ϱ μ , Ͽ QUERY ϱ QUERY ǹ ̺ 6.3 Լ ũѸϱIMPORTHTML ڵDZ ٽ ԼIMPORTHTMLIMPORTXML ̹ ٽ ԼIMPORTXML6.4 ܺ м ԼGOOGLEFINANCE ҷ ٽ ԼGOOGLEFINANCEGOOGLETRANSLATE ϱ ٽ ԼGOOGLETRANSLATESPARKLINE Ʈ ٽ ԼSPARKLINEIMAGE ڸ ٲٱ ٽ ԼIMAGECHAPTER 07 ۽ ũƮ 7.1 ۽ ũƮ Ұ۽ ũƮ ʿ ۽ ũƮ ϱ ˾ƾ ϴ 7.2 ۽ ũƮ ǽũη ۽ ũƮ ġ ֹȣ ǰ Ʈ PDF ϱ ư ۽ ũƮ ϱ Ʈŷ հ ϳ ʰ ũƮ ϱ ڵ 7.3 ۽ ũƮ ִ ϵ Ʈ ԼCHAPTER 08 ǹ ϴ ذϱ 8.1 ġ ʴ Ű 8.2 û Form û/ Է Ȱϱ 8.3 IMPORTXML IMAGE ũѸ Ͽ ǥ ̹ ߰ϱڵ QR ڵ ϱ 8.4 Ʈ ̳ ϱ ڵ ٿε ִ URL Խϰų embedϱ _ Ű ȳ _ ãƺ