ãGoogleã¹ãã¬ããã·ãŒãã£ãŠäœïŒããšèããããšããGoogleãæäŸããŠããExcelã®ãããªãã®ããšçãã人ã¯å°ãªããªãã§ãããã
以åãŸã§è¡šèšç®ãã°ã©ãäœæã«ãããŠã¯Microsoft瀟ã®æäŸãããExcelïŒãšã¯ã»ã«ïŒããã¹ã¿ã³ããŒãã§ããããè¿å¹Žã§ã¯ãGoogleã¹ãã¬ããã·ãŒããGoogleãã©ã€ããã¯ãããšãããG Suite ã§å©çšã§ããããŒã«ã䜿ã£ãŠããæ¹ãå€ãããã£ããããšæããŸãã
ãã®èšäºã§ã¯ãGoogleã¹ãã¬ããã·ãŒãã®åºæ¬çãªäœ¿ãæ¹ããExcelãšã®éããGoogleã¹ãã¬ããã·ãŒãã®äŸ¿å©ãªäœ¿ãæ¹ãã玹ä»ããŸãã
ç®æ¬¡
- Googleã¹ãã¬ããã·ãŒããšã¯ïŒ
- Googleã¹ãã¬ããã·ãŒããšExcelïŒãšã¯ã»ã«ïŒã®éã
- Googleã¹ãã¬ããã·ãŒãã®åºæ¬çãªäœ¿ãæ¹
- Excelã«ã¯ãªãïŒGoogleã¹ãã¬ããã·ãŒããªãã§ã¯ã®æ©èœãã¹ã5
- formrunã§Google ã¹ãã¬ããã·ãŒããå©çšããæ¹æ³
Googleã¹ãã¬ããã·ãŒããšã¯ïŒ

GoogleãæäŸããç¡æããããã¯äŒæ¥åãã«æäŸããŠãã G Suite ã«ãŠãGoogle ãã©ã€ãå
ã§äœ¿ããè¡šèšç®ããŒã«ã§ãã
Googleãã©ã€ãã§ã¯è¡šèšç®ä»¥å€ã«ããGoogleããã¥ã¡ã³ãïŒææžäœæïŒãGoogleã¹ã©ã€ãïŒãã¬ãŒã³äœæïŒãªã©ã䜿çšã§ããŸãããã©ãŠã¶ããã¯ãã¡ããã§ãããiOS/Androidã®ã¹ããã¢ããªãå
å®ããŠãããã¡ãã£ãšããä¿®æ£ãªãã¹ããããã§ãã¹ãã¬ã¹ãªãã§ããŸãã
äœãããç¡æã®Googleã¢ã«ãŠã³ãã§äœ¿ããããšãç¹åŸŽã§ãå人ã§ãã©ã€ããŒãçšã«äœ¿ã£ãããããªãŒã©ã³ã¹ã®æ¹ããªãŒãºããã«ã«å©çšã§ããããšãéåžžã«äœ¿ãåæã®è¯ããµãŒãã¹ãšãªã£ãŠããŸãã
ãŸããã¯ã©ãŠãããŒã¹ã®ãµãŒãã¹ã§ããããšãããåãã¿ã€ãã³ã°ã§å¥ã®ãŠãŒã¶ãŒãšåããã¡ã€ã«ãå
±åã§ç·šéãããããã®é²èŠ§ãç·šéã®æš©éèšå®ã容æã«å¯èœãšãªã£ãŠããŸãã
å€éšããŒã«ãšã®é£æºãããããä»æ§ã§ãã£ãããã¹ã¯ãªãããç·šéããããšã§ã¡ãã£ãšããäœæ¥ã®èªååãç°¡åã«å®çŸã§ããããšãæ¡åŒµæ§ãéåžžã«å å®ããŠããŸãã
Googleã¹ãã¬ããã·ãŒããšExcelïŒãšã¯ã»ã«ïŒã®éã
æè¿ã¯ Microsoft Office ã§ãã¯ã©ãŠãçãæäŸãããŠããŸãããOffice ã¯ãã€ãŠã€ã³ã¹ããŒã«ãå¿ èŠãªãœãããŠã§ã¢ã§ãã£ããããåœæã®å°è±¡ãæ±ããŠããæ¹ãå€ããšæããŸãããªããäž»ãªéããšããŠã¯ä»¥äžã®ç¹ãæããããŸãã
1. ããœã³ã³ãžã®ã€ã³ã¹ããŒã«äœæ¥ãäžèŠã§ããã©ãŠã¶ã䜿ããããœã³ã³ã§ããã°å Žæãåããã©ãããã§ãå©çšå¯èœ
ãŸã1ç¹ç®ã«ãGoogleã¹ãã¬ããã·ãŒãã¯ã€ã³ã¹ããŒã«ãäžèŠã§ãWebäžã®ãã©ãŠã¶ããå©çšã§ãããšããç¹ãæããããŸãã
ã¢ããªã±ãŒã·ã§ã³ãã€ã³ã¹ããŒã«ããå¿ èŠãããExcelãšéããåæè²»çšãããããªãã£ãããã€ã³ã¹ããŒã«ããæéããããããã«ããŒã«ãå©çšã§ãããšããã¡ãªããããããŸãã
2. Google ã¢ã«ãŠã³ãã«ç»é²ããã°ç¡æã§å©çšã§ãã
Excelãå©çšããã«ã¯Microsoftããã©ã€ã»ã³ã¹ãè³Œå ¥ããå¿ èŠããããŸãããGoogleã¹ãã¬ããã·ãŒãã¯ãGoogleã¢ã«ãŠã³ããæã£ãŠãã人ãªã誰ã§ãç¡æã§äœ¿ãããšãã§ããŸãã
Googleã¢ã«ãŠã³ãã®ç»é²ãç¡æã§ã§ãããããGoogleã¹ãã¬ããã·ãŒãã®å©çšã«ã¯è²»çšãäžåããããŸããã
Excelãšã»ãšãã©åãæ©èœãæã£ãããŒã«ãç¡æã§äœ¿ãããšããç¹ã¯ãéåžžã«å€§ããªã¡ãªãããšèšããã§ãããã
3. è€æ°ãŠãŒã¶ãŒã§å ±æã»åæã«ç·šéã§ãã
Googleã¹ãã¬ããã·ãŒãã¯ã¯ã©ãŠãäžã§äœ¿çšã§ããããŒã«ã®ãããåãã·ãŒããè€æ°ã®ãŠãŒã¶ãŒã§åæã«èŠãããšãã§ããŸãã
ã·ãŒãäžã§è¡ã£ãç·šéã¯ãªã¢ã«ã¿ã€ã ã§åæ ããããããè€æ°ãŠãŒã¶ãŒã§åæã«ã·ãŒããç·šéããããšãå¯èœãExcelã®å Žåã¯å人ã§ç·šéããããŒã¿ãéœåºŠä¿åããŠå ±æããå¿ èŠããããããGoogleã¹ãã¬ããã·ãŒãã®æ¹ãããæ©ãããŒã¿ãå ±æã§ããŸãã
ãŸããExcelã®å Žåã¯ãäœæãããã¡ã€ã«ãã¯ã©ã€ã¢ã³ããšããåãããŠãããã¡ã«ãææ°çã®ãã¡ã€ã«ãã©ãããããªããªã£ãŠããŸããšãã£ãããšãèµ·ãã£ãŠããŸããã¡ã§ãããGoogleã¹ãã¬ããã·ãŒãã§ã¯ãã®ãããªç¹ã解決ããããšãã§ããŸãã
4. ç¹ã«ä¿åæäœãè¡ããªããŠãèªåä¿åããã
Googleã¹ãã¬ããã·ãŒããç·šéãããšãç¹ã«æäœãè¡ããªããŠãèªåã§ä¿åãããŸãã
Excelã§ã¯äœæ¥äžã«ãã¡ã€ã«ãä¿åãå¿ããæŽæ°å 容ãå šãŠæ¶ããŠããŸãå¯èœæ§ããããŸãããGoogleã¹ãã¬ããã·ãŒãã§ã¯ãã®ãããªå¿é ããªããªããŸãã
ããŒã¿ã¯ã¯ã©ãŠãäžã«ä¿åããããããå人ã®ããœã³ã³ã®ä¿å容éãå§è¿«ããããšããããŸããã
Googleã¹ãã¬ããã·ãŒãã®åºæ¬çãªäœ¿ãæ¹
1. Googleã¢ã«ãŠã³ããäœæãã
ãŸãã¯ãGoogleã¢ã«ãŠã³ãã®äœæããŒãžãããã¢ã«ãŠã³ããäœæããŸããååããŠãŒã¶ãŒåãªã©å¿ èŠãªæ å ±ãå ¥åããæ¬äººèªèšŒãå®äºãããŸãããã
2. ã¹ãã¬ããã·ãŒããäœæãã

Googleã¹ãã¬ããã·ãŒãããã¹ãã¬ããã·ãŒãã®ããŒã ç»é¢ãéããŸãã
å·Šäžã®ãæ°ããã¹ãã¬ããã·ãŒããäœæã ã®äžã«ããã空çœããã¯ãªãã¯ãããšãæ°ããã·ãŒããäœæãããŠéããŸãã
ãã³ãã¬ãŒãã®ã£ã©ãªãŒãããTodoãªã¹ããã«ã¬ã³ããŒãªã©ããã©ãŒããããéžæããŠå©çšããããšãã§ããŸãã
3. ã¹ãã¬ããã·ãŒããç·šéãã
ã»ã«ãã¯ãªãã¯ããŠãããã¹ããæ°åŒãé¢æ°ãè¿œå ããããšãã§ããŸãã
Googleã¹ãã¬ããã·ãŒãã®äŸ¿å©ãªé¢æ°ã«ã€ããŠã¯ããã¡ãããåç §ãã ããã
4. ä»ã®ãŠãŒã¶ãŒãšå ±æãã

Googleã¹ãã¬ããã·ãŒããä»ã®ãŠãŒã¶ãŒã«å
±æããåæã«é²èŠ§ã»ç·šéããããšãã§ããŸããä»ã®ãŠãŒã¶ãŒãåãã·ãŒããèŠããããã«ããããã«ã¯ãå
±ææš©éãèšå®ããå¿
èŠããããŸãã
ç»é¢å³äžã®ãå ±æããã¯ãªãã¯ããããŠãŒã¶ãŒãã°ã«ãŒããè¿œå ãã«Gmailã¢ãã¬ã¹ãè¿œå ãããšãè¿œå ãããŠãŒã¶ãŒãã·ãŒãã«ã¢ã¯ã»ã¹ã§ããããã«ãªããŸãã
ãŸããã©ã®ãããªãŠãŒã¶ãŒã§ãé²èŠ§ã§ããããã«ãããå Žåã¯ãããªã³ã¯ãç¥ã£ãŠããå šå¡ã«å€æŽããã¯ãªãã¯ããŸãã
å ±ææš©éãèšå®ããéã«ã¯ããé²èŠ§ã®ã¿ãããç·šéãå¯èœããªã©ã现ããªèšå®ãå¯èœã§ãã
Excelã«ã¯ãªãïŒGoogleã¹ãã¬ããã·ãŒããªãã§ã¯ã®æ©èœãã¹ã5
Googleã¹ãã¬ããã·ãŒããã©ããªããŒã«ãç解ããã ãããšæããŸããããã«ã€ã¡ãŒãžãæ·±ããããã«ãGoogleã¹ãã¬ããã·ãŒããªãã§ã¯ã®ä»£è¡šçãªæ©èœã®ãã¡5ã€ããã¯ã¢ããããŠçŽ¹ä»ããŸãã
1. ã»ã«ã«ã³ã¡ã³ããæžããããã£ãããã§ãã
å ±åç·šéãå¯èœãªGoogleã¹ãã¬ããã·ãŒããªãã§ã¯ã®æ©èœã§ããç·šéããŠããå šãŠã®ã¡ã³ããŒéã§ã³ã¡ã³ãã®ããåããã§ããŸãã
ã³ã¡ã³ãã®ã¿ã§ãªããå³ã¡ãã¥ãŒãããã£ããã§ããåãããããšãå¯èœã§ãã
2. å¥ã®ã¹ãã¬ããã·ãŒãããããŒã¿ãåç §ã§ãã
Excelã§ãåããã¡ã€ã«å
ã®å¥ã¿ãã«ååšããã·ãŒãã®ããŒã¿ããåç
§ã§ããŸãããGoogleã¹ãã¬ããã·ãŒããªããIMPORTRANGEããšããé¢æ°ã䜿ãããšã§ãå¥ã®ã·ãŒããããããŒã¿ãåç
§ã§ããŸãããã¡ãã®é¢æ°ã䟿å©ã«æããŠãã人ãå€ãã®ã§ã¯ãªãã§ããããã
äŸãã°ãäºæ¥èšç»ãªã©ãäœãéã«ãçŸå Žã®KPIã·ãŒããåç §ããç¹å®ã®ã¿ãå ã®ããŒã¿ã ããå¥ã·ãŒãã«ãåæ ãããããšãã§ããŸãã
3. ç·šéå±¥æŽã確èªã»åŸ©å ã§ãã

ç·šéã¡ã³ããŒããšã«éå»ã®ç·šéå±¥æŽã確èªããããç¹å®ã®ããŒãžã§ã³ã«æ»ãããããããšãã§ããŸãã誀ã£ãŠéå»ã®ããŒã¿ãåé€ããŠããŸã£ãããçŸåšç¢ºèªã§ããªããªã£ãŠããŸã£ãããŒã¿ããã£ããšããŠããéå»ã®ç·šéå±¥æŽãé¡ã£ãŠã·ãŒãã埩å
ããããšãã«äŸ¿å©ãªæ©èœã§ãã
ç·šéå±¥æŽã§ã¯ãæç³»åé ã«ç·šéããã¡ã³ããŒãšç·šéå 容ãããããŸãããŸããæå®ããç·šéæéã®å 容ã«åŸ©å ããããšãå¯èœã§ãã

ç·šéå±¥æŽã確èªããã«ã¯ããæçµç·šéããšè¡šç€ºãããŠããç®æãã¯ãªãã¯ããŸãã
4. é²èŠ§ãç·šéæš©éãã¡ã³ããŒåäœã§èšå®ã§ãã
ã¡ã³ããŒããšã«ãé²èŠ§ã®ã¿ããç·šéããããã¯ããURLãç¥ã£ãŠãã人ã§ããã°èª°ã§ãé²èŠ§å¯èœããªã©ã现ããæš©éèšå®ãå¯èœã§ããéåžžã¯ã¯ããŒãºãã«éãããã¡ã³ããŒã ãã§äœ¿ãã€ã€ãã¯ã©ã€ã¢ã³ããäžç¹å®å€æ°ãšãªãå Žåã¯ãURLãç¥ã£ãŠãã人ã§ããã°é²èŠ§å¯èœã«ããããšãã£ã䜿ãæ¹ãã§ããŸãã

å ±æèšå®ã«ãŠæš©éãèšå®ãããã¡ã³ããŒã®ã¡ãŒã«ã¢ãã¬ã¹ãå ¥åããŸãã
5. Excel圢åŒã§ãã¡ã€ã«ãããŠã³ããŒãã§ãã
äžèŠå°å³ã«èŠããŸãããé »ç¹ã«å©çšããã®ããã¡ãã®æ©èœã§ããGoogleã¹ãã¬ããã·ãŒãã§äœæãããã¡ã€ã«ãExcelïŒ.xlsxïŒåœ¢åŒã§ãšã¯ã¹ããŒãã§ããæ©èœã§ãã
ãã¡ã€ã«ãå
±åç·šéãããããã®ã¡ã³ããŒã§ããã°æš©éèšå®ã䟿å©ã§ãããäžåºŠã ãç¹å®ã®ç€Ÿå€ã®æ¹ã«å
±æãããšãã£ãå ŽåãExcel圢åŒã§ããŠã³ããŒãããŠä¿åããã¡ãŒã«ãªã©ã§Excelãã¡ã€ã«ãå
æ¹ã«ãéãããã»ããéœåã®è¯ãå ŽåããããŸãã

ããã¡ã€ã«ïŒããŠã³ããŒããããä¿åã§ããŸãã
Officeã¢ããªã±ãŒã·ã§ã³ã§ã®æ¥åããŸã äžè¬çãªæ¥çïŒããšãã°çµçé¢ä¿ãæ³åŸé¢ä¿ãªã©ïŒã¯Excel圢åŒã§ã®æåºãæ±ããŠããå ŽåããããããããŸããŸãªãã¡ã€ã«åœ¢åŒã«ã察å¿ã§ããã®ã¯å¿åŒ·ãã§ãããã
formrunã§Google ã¹ãã¬ããã·ãŒããå©çšããæ¹æ³
ãããªäŸ¿å©ãªGoogleã¹ãã¬ããã·ãŒããå®ã¯formrunã®STARTERããã³PROFESSIONALãã©ã³ã§ã¯formrunã®ãã©ãŒã ããå
¥åãããããŒã¿ãåæ ã§ããé£æºæ©èœããããŸãã
é£æºæ¹æ³ã¯2ã€ãããŸãã
- AïŒãã©ãŒã ããå ¥åãããããŒã¿ãæåã§åæ ïŒ1åã ãåºåãããå ŽååãïŒ
- BïŒãã©ãŒã ããå ¥åãããããŒã¿ãéœåºŠèªåã§åæ ïŒç¶ç¶çã«åºåãããå ŽååãïŒ
â»Bã¯PROFESSIONALãã©ã³ã®ã¿å¯Ÿå¿ãšãªããŸãã
ããããformrun管çç»é¢ãã以äžã®èšå®ã§ã¹ãã¬ããã·ãŒããžã®åæ ãã§ããŸãã
AïŒGoogle ã¹ãã¬ããã·ãŒãã«æåã§åæ ããïŒSTARTERãPROFESSIONALãã©ã³ããå©çšã®æ¹ïŒ
çŸåšã®å
¥åå
容ãæåã§åæ ããŸããäžåºŠã ãããŒã¿ãã¹ãã¬ããã·ãŒãã«åæ ããŠã以éã¯ã¹ãã¬ããã·ãŒãåŽã§ç·šéãããããªã±ãŒã¹ã«åããŠããŸãã
â ãã©ãŒã 管çç»é¢ã®ããªã¹ããã¿ãããç»é¢å³äžã®ãªã¹ãã¢ã€ã³ã³ãã¯ãªãã¯ãã

â¡ããšã¯ã¹ããŒãã«å€±æããŸãããã¡ãã»ãŒãžã®å³ã«ãããèšå®ããã¯ãªãã¯

â¢èšå®ç»é¢ã®ãé£æºããããã¿ã³ãã¯ãªãã¯

â£formrunããGoogle ã¢ã«ãŠã³ããžã®ã¢ã¯ã»ã¹ãèš±å¯ãã

é£æºãããšãã®ããã«é£æºã¢ã«ãŠã³ãåã衚瀺ãããŸãã

â€ã¹ãã¬ããã·ãŒãã«åæ ã確èª
ããäžåºŠâ ã®ãªã¹ãã¢ã€ã³ã³ãã¯ãªãã¯ãããšã¹ãã¬ããã·ãŒããäœæããããã©ãŒã å 容ãåæ ãããŸãã

BïŒGoogle ã¹ãã¬ããã·ãŒãã«èªåã§åæ ããïŒPROFESSIONALãã©ã³ã®ã¿ïŒ
åæ èšå®åŸãformrunã«æ°ãã«å
¥åãããããŒã¿ãèªåã§åæ ããŸããfomrunãžã®å
¥åå
容ãç¶ç¶çã«åæ ããŠãã§ãã¯ããããæ®æ®µformrunã䜿ã£ãŠããªããŠãŒã¶ãŒã«å
¥åå
容ãå
±æããã±ãŒã¹ãªã©ã«åããŠããŸãã
â Googleã¢ã«ãŠã³ããšé£æºãã
ãã©ãŒã 管çç»é¢ã®ããªã¹ããã¿ãããç»é¢å³äžã®ãªã¹ãã¢ã€ã³ã³ãããã¹ãã¬ããã·ãŒãïŒèªååºåïŒããã¯ãªãã¯ããä»åŸã¯ãGoogleã¹ãã¬ããã·ãŒãé£æºïŒèªåæŽæ°ïŒããšã¢ã«ãŠã³ããé£æºããŸãã

â¡é£æºã§ãããšèªåæŽæ°ãéå§ããŸã
Googleã¢ã«ãŠã³ããšé£æºã§ãã以äžã®ãããªè¡šç€ºã«ãªããŸããèªåæŽæ°ãããéã¯ãONãã«èšå®ããŠãããŸããæŽæ°å¯Ÿè±¡ã®ã·ãŒãã¯ãã¹ãã¬ããã·ãŒããã¿ãããã確èªã§ããŸãã
ããŒã¿åæ ãããèŠãç®ã¯Aã®æååæ ãšå€ãããããŸãããããã©ãŒã å ¥åããããã³ã«èªåçã«åæ ãããç¹ã§ç°ãªããŸãã
ããã¯çšéã«ãã£ãŠã¯ããªã䟿å©ãªæ©èœã§ããïŒ
以äžãGoogleã¹ãã¬ããã·ãŒãããã³formrunããã®é£æºã玹ä»ããŸããã
ããŸã Excelãã䜿ã£ãŠããªãããšããæ¹ã¯ããããæ©ã«ã¹ãã¬ããã·ãŒãããã³formrunãšã®é£æºããã²è©ŠããŠã¿ãŠãã ããïŒ
formrunããã©ãŒã äœæã顧客管çã«é¢ããæ å ±ãçºä¿¡ããŠãããŸãã
EFOïŒãšã³ããªãŒãã©ãŒã æé©åïŒãåãåãã察å¿ãªã©ã
ãã©ãŒã ã«é¢ãããæ©ã¿ã解決ããŸãã