ã¢ã¡ãªã«ã®Microsoft瀟ãéçºããè¡šèšç®ãœãããExcelããExcelã¯ä»ãæãããªãã£ã¹ã§å©çšãããããœã³ã³ãœããã®ä»£è¡šã ãé¢æ°ã該åœã®ã»ã«ã«å
¥åããã ãã§ãèªåã§èšç®ãè¡ã£ãŠããããã£ãšããéã«ã°ã©ããè¡šã«ãŸãšããŠããããããããå°ããããããèšç®ãæå®ãããå Žåã¯ã該åœã®é¢æ°ãå
¥åããã®ã«æããã£ãŠããŸã£ãçµéšããããšãã人ãå€ãã®ã§ã¯ãªãã ãããã
2023幎8æ28æ¥ã«æçš¿ããããusutaku@AIæ
å ±è§£èª¬@usutaku_comããã®ãããããããšãæžãããããšã¯ã»ã«ã®é¢æ°ã«å€æããŠãããAIãé¢çœããã»ææ§ãªæžãæ¹ã§ãããæãã«çŽããŠããããã»é·æã§ãåé¡ãªããã»åºåçµæãé¢æ°ã ãã§ã·ã³ãã«âChatGPTãšã®å·®ç°ãã»ãã¯ãïŒVBAïŒãSQLã«ã察å¿ãé·ãã®é¢æ°ãšããæžãæãšãã«éå®ããã®ã§ãã²äœ¿ã£ãŠã¿ãŠæ¬²ãããAIåå¿è
ã«ãããããããšããæžã蟌ã¿ã«ã¯ãå®éã«AIãç¥ãããé¢æ°ãèªåçæããŠãããæ§åãã¹ã¯ã·ã§ããç»åãæ·»ããããŠããããã®æçš¿ã«ã¯ããªããš7100件ãè¶
ããããããããã€ããŠãããã€ã³ã¿ãŒãããäžã§å€§ããªè©±é¡ãšãªã£ãŠããã
ä»åã¯ããã¡ãã®æçš¿ã«é¢ãã詳现ãçããã«ã玹ä»ããŸãã
AIã¹ãã¬ããã·ãŒãããŒã«ãGPTExcelãïŒ
æçš¿è
ã®usutaku@AIæ
å ±è§£èª¬ããã¯ä»åãAIã¹ãã¬ããã·ãŒãããŒã«ãGPTExcelããå©çšããŠãExcelã®æ°åŒãèªåçæããããã ã
ïŒç»åã¯ãusutaku@AIæ
å ±è§£èª¬ïŒ@usutaku_comïŒãããæäŸïŒ
ãGPTExcelãã¯äœ¿ãæ¹ãç°¡åã§ããŸãã¯äœãããæ°åŒãæç« ã§æå®ããããµã€ãã¯è±èªã ããå
¥åã«é¢ããŠã¯æ¥æ¬èªã§ã倧äžå€«ãªããã ã
usutaku@AIæ
å ±è§£èª¬ããã¯ãç»åå
ã§ãSheet1ã®Aåã®ã»ã«ãšãSheet2ã®Aåã®ã»ã«ã§åäžã®å€ããããããSheet2ã®è©²åœè¡ã®Båã®å€ãåºåãäžèŽããªãå Žåã¯ãã€ãã³ãæ¿å
¥ããŠããšãããªã现ããªæ瀺ãåºããŠãããããã®ã¬ãã«ã§ãåé¡ãªãçæããããããã
次ã«ãæ°åŒã®äœ¿çšå
ãéžæãããããGPTExcelãã§ã¯ããExcelãã ãã§ãªããSheetsããAirtableãã®ïŒçš®é¡ããéžã¶ããšãã§ãããä»åã¯ãExcelããéžæããããéžã¶çš®é¡ã«ãã£ãŠçæãããã³ãã³ããç°ãªãå Žåãããã®ã§ãééããªãããã«æ°ãä»ããŠã»ããã
æåŸã«ãGENERATEããšæžããããã¿ã³ãã¯ãªãã¯ããã°ãé¢æ°ãèªåã§çæãããã®ã ã
é¢æ°ã®ä»çµã¿ãŸã§è§£èª¬ããŠããã!!
ãã®æçš¿ãèªãã ããããŠãŒã¶ãŒãã¡ããã¯ããã°ã°ã£ãŠããšã¯ã»ã«é¢æ°ã調ã¹ãªããŠããããã䜿ãã°ãã€ã¡ãŒãžããé¢æ°ãåºãŠããã®ã¯ãããããããšãé¢æ°ãããããèªåã§èª¿ã¹ãæéãçããã®ã¯å©ãããšãã£ã声ãããæ¥åèŠä»¶å®çŸ©èœåã®å·®ã«ãã£ãŠïŒäžåœã«ïŒè©äŸ¡ãããããããªããŒã«ã§ãããããšãããã«åœäººãæ確ãªæ瀺ãAIã«åºãããã§ããŒã«ã®è©äŸ¡ã«å·®ãéãããã ãšãã£ã声ãªã©ãããŸããŸãªã³ã¡ã³ããè¿ä¿¡æ¬ã«ã¯å¯ããããŠããã
ãã£ãšããéã«ç¥ãããé¢æ°ãçæããŠããããGPTExcelãã ãããã®ããŒã«ã®åãã¯ããã ãã§ã¯ãªããäžããïŒçªç®ã®ãExplainerãã¿ãã«çæãããæ°åŒã貌ãä»ãããEXPLAINããã¿ã³ãã¯ãªãã¯ãããšããªããšããã®åŒãåãä»çµã¿ãŸã§è§£èª¬ããŠãããã®ã§ããã
ãã¡ãããæ°åŒã®ä»çµã¿ãç解ããªããŸãŸã§ã䜿ããã®ã ããç¥ããããšãã人ã«ã¯ããã¡ããšçŽ°ãã説æãè¡ã£ãŠããããããããã¹ãã¿ãªãã£ã®é«ãã«é©ãã°ããã ããªããŠé Œãããã®ããAIã ãããã
äœæ¥ã®å¹çåã«çãããã®ã§ããã°äœ¿ããªãæã¯ãªã!!
è¿å¹ŽãAIã¯ããŸããŸãªåéã«ãããŠè©±é¡ãšãªããæ¥éãªçºå±ãšæ®åãéããŠããããããšãããããžã£ã³ã«ã«ãããŠããããã人éã®ä»äºã奪ãã¯ãããŠããAIã ããäœæ¥ã®å¹çåã«çãããã®ã§ããã°ã䜿ããªãæã¯ãªãã¯ãã ãä»äºãAIã«å¥ªãããã®ãšã人éã楜ã§ããã®ã¯ã€ã³ãŒã«ã§ã¯ãªãã
ããããããšãæåã§æžããããExcelã®é¢æ°ã«èªåã§å€æããŠããã䟿å©ãªAIãGPTExcelãã玹ä»ããä»åã®æçš¿ãæ®æ®µããä»äºã§é »ç¹ã«Excelãã䜿ãã«ãªãããæ¹ã¯ãä»æ¥ãããã£ãããªãã£ã¹ã«ãGPTExcelããå°å
¥ããŠã¿ãŠã¯ãããã ãããã
âGPTExcel ã¯âãã¡ã
â»ãµã ãã€ã«ç»åïŒImage:ãusutaku@AIæ
å ±è§£èª¬ïŒ@usutaku_comïŒãããæäŸïŒ