ãç¹ã¯ç·ã«ãªãããããŠç·ã¯é¢ã«ãªããïœå± é å±ãã€ãã§åäœãèœãšããç·ã蟿ãçããä»äºè«ïœ
ã¯ããã«
ç§ã¯å€ãã®æéãPCã®ããŒã¿äœæãããã°ã©ã ã»AIãªã©ã詊è¡é¯èª€ããªããæ¥ã
ãéã£ãŠããŸãã
ãã äžã€èšã£ãŠãããŸããæåããPCãåŸæã ã£ãããã§ã¯ãããŸããã
倧åŠã®ææ¥ã§ãã£ããæ
å ±åŠçãªãã¡ããïŒãã®ãããªååã®PCã®ææ¥ãããïŒæéç®ã®ææ¥ã§ãå±
é
å±ãã€ãåŸã§èµ·ãããªããšããçç±ã«åäœãåã£ãŠããŸããã§ããã
ã§ã¯ã©ãããŠãïŒïŒå¹Žãã£ãä»ãããã»ã©PCãåŸæã«ãªãããããäž»æŠå Žãšããããšãªã£ããã仿¥ã¯çŽè§£ããŠãããããšæããŸãã
第1ç« ïœç¹ã¯æ€åŠããå§ãŸã£ã
ããå ååãåŸèŒ©ããããPCé¢ä¿ã®å€§åŠã«è¡ã£ãŠãããã§ããïŒããšè³ªåãåããŸããçãã¯NoïŒã¬ãããªçŠç¥ç³»å€§åŠã§ããäœãªãPCã®ææ¥ããåããŠããŸãããç¬
ããããã©ãããŠãããŸã§åŸæã«ãªã£ããïŒ
ããã¯ç§ãå
¥è·ããæ³äººã®ïŒå¹Žç®ãExcelã§äœãããå©çšè
管çããŒã¿ã§ãããã®ããŒã¿ã«ã¯æ§ã
ãªããããããªãè±èªïŒïŒé¢æ°ïŒãéæã«æ£ãã°ããããæã¡èŸŒãã å€ã«ãã£ãŠãå¥sheetã®å€ãå€ãããç§ã¯ããè峿ޥã
ã
åœæã®ç®¡çè
ã«ãé¡ãããã³ããŒãäœãããŠããããïŒãã¡ããå©çšè
æ
å ±ãªã©ãã¹ãŠãæ¶ããç¶æ
ã§ïŒæã¡åž°ãããšã«ããŸããã
ãŸãã«ãã®æããç§ãæã¡èŸŒãã 瀟äŒäººåããŠã®ãç¹ïŒãããïŒãã§ããã
第2ç« ïœç¹ãšç¹ãèªåã§çµã³ã«ãã
äžã€ã®ç¹ã¯ãããã ãã§ã¯äœã«ããªããŸããã
ãã ã®ãã¡ãã£ãšè©³ãã人ãã§çµãã£ãŠããŸããŸãã
ç§ã®å Žåããã®å©çšè
管çããŒã¿ã®Excelããã£ããã«ããããããã£ãšãããããæ©ãçµããããããªããïŒããšããçºæ³ãæ¢ãŸããªããªããŸããã
IF颿°ãèŠããã°ãVLOOKUPãèŠããããªããVLOOKUPãèŠããã°ãããããããŒãã«ãæ°ã«ãªããæ°ã¥ãã°ãæ¥ã
ã®æ¥åã®äžã§ãé¢åã ãªããšæããç¬éãããã®ãŸãŸæ¬¡ã®ç¹ãæ¢ãã»ã³ãµãŒã«ãªã£ãŠãããã§ãã
13幎éã管çè
ãšããŠçŸå Žã«ç«ã¡ç¶ããäžã§ããã®ãç¹ãæ¢ãçãã¯å é床çã«å¢ããŠãããŸãããç¬
å ç®ã®å®çžŸç®¡çã皌åçã®èšé²ãã·ããäœæãã¿ã€ã ã«ãŒãåŠçãææ«è«æ±æ¥åâŠâŠã
ãã©ãã©ã«èŠããŠãããããã®ç¹ãããã€ã®éã«ããæ¥åæ¹åããšããäžæ¬ã®ç·ã§ç¹ãã£ãŠããããšã«ãããæ¥ãµãšæ°ã¥ãããã§ãã
ç·ãšã¯ãç¹ãšç¹ãããããšãããå®ã¯é¢ä¿ããããããªããïŒããšèªåã§çµã³ã«ãã£ãçµæçãŸãããã®ã ãšä»ã¯æã£ãŠããŸãã
誰ããæåããç·ãåŒããŠãããããã§ã¯ãããŸããã
第3ç« ïœæ°ã¥ãã°ç·ãéãªã£ãŠãé¢ã«ãªã£ãŠãã
ç·ãå¢ããŠãããšã次ã«èµ·ããã®ã¯ãé¢ããžã®åºããã§ãã
Excelã®å»¶é·ã§VBAãè§Šãããã«ãªããããããGoogleã¹ãã¬ããã·ãŒãã®GASã«æãåºããAIããŒã«ã詊ãããã«ãªããnoteã§çºä¿¡ããããã«ãªããç»åãã¢ããªãŸã§äœãããã«ãªããŸããã
äžã€ã²ãšã€ã¯ãæ¥åæ¹åããšããåãç·ã®äžã«ããããã§ãå®éã«ã¯ãä»è·ã®ç®¡çæ¥åããããžã¿ã«ããŒã«ã®æŽ»çšããçºä¿¡ã»èšèªåããšããè€æ°ã®ç·ããæ°ã¥ãã°éãªãåã£ãŠäžã€ã®é¢ã«ãªã£ãŠãããã§ãã
ããããŸãã«ãä»ã®ç§ã®ä»äºãã®ãã®ã§ãã
18幎éã®ä»è·çŸå Žã®çµéšãšããåå°ã®äžã«ã13幎éã®ç®¡çè
ãšããŠã®çŸå Žãããžã¡ã³ãçµéšããããŠExcelããå§ãŸã£ãããžã¿ã«ã¹ãã«ãéãªãããä»è·ç¹ååã»ããžã¿ã«æ¥åæ¹åãããã¥ãŒãµãŒãã§ãããã皌åçåäžã³ã³ãµã«ã¿ã³ããã§ãããä»ã®ç«ã¡äœçœ®ã圢äœãããŸããã
é¢ã¯ãçã£ãŠäœããã®ã§ã¯ãããŸããã
ç·ã䌞ã°ãç¶ããçµæãåŸããæ¯ãè¿ã£ãŠãããé¢ã«ãªã£ãŠããã ããšæ°ã¥ããã®ãªãã ãšæããŸãã
第4ç« ïœãã¹ãŠãç¹ãããããããconnecting the dotsã
ã¹ãã£ãŒãã»ãžã§ããºãã¹ã¿ã³ãã©ãŒã倧åŠã®ã¹ããŒãã§èªã£ããšãŠãæåãªåèšïŒèãæ¹ïŒããããŸãã
ãæªæ¥ãå åãããŠç¹ãç¹ããŠã¿ãããšã¯ã§ããŸããã
ããéå»ãæ¯ãè¿ã£ãŠç¹ãšç¹ãç¹ãããšããã§ããªããã
ç§ãããã®å±
é
å±ãã€ãã®åœ±é¿ã§åäœãèœãšããæ
å ±åŠçã®ææ¥ã®ããšããå©çšè
管çããŒã¿ã®Excelã«èå³ãæã£ã1幎ç®ã®ããšããæ£çŽãã®æã¯ããããå°æ¥ã®ä»äºã«ç¹ããããªããŠåŸ®å¡µãæã£ãŠããŸããã§ããã
ãã ãé¢çœããªãããã£ãšç¥ããããªããšãããããã ãã®æ°æã¡ã§æã䌞ã°ããŠããã ãã§ãã
ã§ã18幎çµã£ãä»ãæ¯ãè¿ã£ãŠã¿ããšããã®äžã€ã²ãšã€ã®ç¹ãå šéšç¹ãã£ãŠãä»ã®ç§ãšãããé¢ããäœã£ãŠãããããããã®é¢ã¯ãä»ããŸã åºããç¶ããŠããŸãããããŠãŸãæ°ãã«æŽŸçãã皌åçåäžã³ã³ãµã«ãšããæ°ããç·ãããããããŸãå¥ã®é¢ãäœã£ãŠããã¯ãã§ãã
ãããã«
ãèªåã«ã¯äœãç¹æããªãããä»ããäœããå§ããŠãé ãããšæã£ãŠããæ¹ãããããäžã€ã ããäŒããããããšããããŸãã
ç¹æã匷ã¿ã¯ãæåããé¢ãšããŠååšãããã®ã§ã¯ãããŸããã仿¥ãç®ã®åã§ãµãšæ°ã«ãªã£ãå°ããªç¹ããããã¹ãŠã¯å§ãŸããŸãã
ãã®ç¹ãããŸãããããã§æµããããã¡ãã£ãšè§Šã£ãŠã¿ããããªãã§æŸãäžãããããã®å·®ããæ°å¹ŽåŸã®æ¯è²ã倧ããå€ããŸãã
仿¥ãããªãã®ç®ã®åã«ããå°ããªèå³ã¯äœã§ããïŒ
ããã®äžç¹ãããŸãã¯æŸãäžããŠã¿ãããšããå§ããŠã¿ãŸãããïŒð
ãããªãšæã£ããå¿æŽãããïŒ
æåŸãŸã§ãèªã¿ããã ãããããšãããããŸãâ¢â¢ä»æ¥ã®å
容ããããïœïŒïŒãããããïŒïŒãããªã¯ãïŒïŒãããããåžããããªå
容ã§ããã°ãæ¯éããã£ãšãæ¯æŽããã ããã°å¹žãã§ãâªâ¬