
ãã³ã©ã ãExcelã®æŽå²ãæ¯ãè¿ã
Excelã¯ãããŸã衚èšç®ã®ä»£åè©ã
ã§ããæåããâçè
âã ã£ãããã§ã¯ãããŸããã
ãã€ãŠã¯ Lotus 1-2-3 ãå§åçã·ã§ã¢ãèªããExcelã¯ææŠè
ã®ç«å Žã§ããã
ä»åã¯ããã® é転ã®ç¬é ãâè©°ãExcelâã®èŠç¹ã§ãã©ããŸãã
ãã€ãŠè¡šèšç®ãšããã° Lotus 1-2-3 äžåŒ·ã ã£ãããã§ãã
ããã«æãã Excelããã©ã®ããã«ããŠèŠæš©ã奪ã£ãã®ãã
ä»åã¯ããã®é²åã®ç©èªãå°ã調ã¹ãŠã¿ãŸããã
ð 第0ç« ïŒLotusåžåœã®æä»£ïŒ1983ã1989ïŒ
ð 1983幎ãLotus 1-2-3 èªçãã衚èšç®ããã°ã©ãããããŒã¿ããŒã¹æäœããçµ±åããDOSã¢ããªãšããŠãç¬ãéã«äŒæ¥ã®æšæºããŒã«ãšãªããŸããã
ããŠã¹ãGUIããªãæä»£ãLotusã¯âããŒããŒãè·äººâãã¡ã®è±¡åŸŽã§ããããã®é ã®Excelã¯ããŸã Macå°çšã®æ°åè
ã誰ãç座亀代ãäºæ³ããŠããŸããã§ããã
â¡ïž 第1ç« ïŒWindowsãšããæ°ããç€é¢ïŒ1989ã1992ïŒ
æä»£ã¯ DOSããWindowsãžã
ããŠã¹æäœãšGUIãåœããåã«ãªãããœããã«ãçŽæçãªæäœæ§ããæ±ãããå§ããŸãã
ããã§ExcelãåããŸãã
Macã§éããGUIèšèšã掻ãããWindowsç°å¢ã«æé©åã
äžæ¹Lotusã¯ãDOSæä»£ã®æåäœéšãåŒããããç§»è¡ãé
ããŸããã
ð 1991幎æç¹ïŒ
⢠衚èšç®åžå Žå
šäœ â Lotusã58%ã§éŠäœ
⢠Windowsåžå Ž â Excelãæ¥äŒž
ð ãã㊠1993幎ã«ã¯Windowsåžå Žã§Excelãäž»å°ïŒDataquest調ã¹ã»ç±³å ±éïŒã
ãããããããããé転ã®å
ããã§ãã
𧩠第2ç« ïŒVBAãšãããããçãã âèªååã®å€æãâïŒ1993ã1997ïŒ
1993幎ãExcel 5.0 ã«ãã£ãŠ
VBAïŒVisual Basic for ApplicationsïŒ ãç»å ŽããŸãã
ããã«ãããç¹°ãè¿ãäœæ¥ããã¯ãã§èªååã§ããããã«ãªãã
ãæäœæ¥ãåœããåãã ã£ãæä»£ã«é©åœãèµ·ããŸããã
ããã«ãããããããŒãã«ã倧ããé²åã
ããŒã¿ããåãããŠçºãããæåãçãŸããŸããã
ð§ 第3ç« ïŒçåº§äº€ä»£ã®æ±ºçïŒ1995ã1997ïŒ
1995幎ãLotusã¯IBMã«è²·åã
ãã€ãŠã®çè
ãäŒæ¥ã®äžéšãšãªããExcelã¯å®å
šã«åžå Žããããžãšç»ãè©°ããŸãã
ãã®ææã® Excel 97 ã§ã¯ã
ãªãã³UIã®ååãšããããæäœäœç³»ãæ¡ä»¶ä»ãæžåŒãã°ã©ãã£ãã¯æ©èœãå
å®ãã
âæ¬¡ã®äžä»£ã®è¡šèšç®ãœããâã宿ããŸããã
ð 第4ç« ïŒããŒã¿æä»£ã®èŠè ïŒ2010ãïŒ
Power QueryãPower PivotãXLOOKUPãåçé
åãPythonçµ±åâŠã
Excelã®é²åã¯æ¢ãŸããŸããã
ãã®èæ¯ã«ã¯ãç©ã¿éããŠããé²åã®æ©ã¿ããããŸãã

ð® ãããŸã§ã®é²åããã©ããšã
Excelã¯ãã€ã®æä»£ããäººã®æèãæ¯ããããŒã«ããšããŠæ©ãã§ããããã«æããŸãã
ããããå
ãã©ããªåœ¢ã§é²åããŠããã®ãã
ãã®ç¶ããèŠå±ããã®ããä»ããæ¥œãã¿ã§ãã
Amazonã¢ãœã·ãšã€ãåå è ãšããŠã驿 Œè²©å£²ã«ããåå ¥ãåŸãå ŽåããããŸããããã ããåçããèšäºå·çãæŽ»åç¶ç¶ã®å±ã¿ã«ãªããŸãã