ãšã¯ã»ã«ã掻çšããŠã¢ã³ã±ãŒããäœæããããšæã£ãŠããã©ã®ããã«é²ããŠããã°ããã®ããéããã¢ã³ã±ãŒãã®çµæãã©ã®ããã«æŽ»çšã§ããã®ããããããªãæ¹ãããã®ã§ã¯ãªãã§ããããã
æ¬èšäºã§ã¯ãExcelãã¢ã³ã±ãŒãã«æŽ»çšããæ¹æ³ã玹ä»ããŠããŸãããŸããéããã¢ã³ã±ãŒãã®çµæãã©ã®ããã«éèšããã©ããã£ãå Žé¢ã§ããŒã¿ã掻çšã§ããã®ãããŸãšããŠã¿ãŸããã
ãŸããã¢ã³ã±ãŒããã©ãŒã äœæããŒã«ãšããŠãformrunãã玹ä»ããŸããformrunã¯ãç®çã«å¿ããŠçšæããããã³ãã¬ãŒããã¯ãªãã¯ã§èšåé ç®ã远å ããã ãã§ãç°¡åã«ã¢ã³ã±ãŒãã®äœæãå¯èœã§ãã
ç¡æãã©ã³ã§ããèšåæ°ã¯ç¡å¶éã§ãã®ã§ãã¢ã³ã±ãŒãã®å 容ãå å®ãããããŸããããã«ãæ¡ä»¶ã«ãã£ãŠè³ªåã®å 容ãåå²ãããããšãã§ããåççãå€§å¹ ã«åäžãããããã®ãformrunã®é åã§ãã
éèšããåçã¯ããªã¹ãã»æ£ã°ã©ãã»åã°ã©ããªã©åœ¢åŒã§è¡šç€ºã§ããCSVãã¹ãã¬ããã·ãŒããžã®åºåãå¯èœã§ãã
ãŸããã¢ã³ã±ãŒãã®ãã³ãã¬ãŒããé åžããŠãããŸãã®ã§ãæ°ã«ãªãæ¹ã¯ãã¡ããã確èªãã ããã
>> ã¢ã³ã±ãŒããã©ãŒã ãã³ãã¬ãŒããèŠã
ç®æ¬¡ [é衚瀺]
- Excel(ãšã¯ã»ã«)ã䜿ã£ãåºæ¬ã®ã¢ã³ã±ãŒãã®äœãæ¹
- Excel(ãšã¯ã»ã«)ã¢ã³ã±ãŒãã®æç¥šãã¿ã³ã®äœãæ¹
- Excel(ãšã¯ã»ã«)ã䜿ã£ãŠã¢ã³ã±ãŒããäœæããã¡ãªããã»ãã¡ãªãã
- Excel(ãšã¯ã»ã«)ã§äœæããã¢ã³ã±ãŒããèªåéèšããæ¹æ³
- Excel(ãšã¯ã»ã«)ã®ã¢ã³ã±ãŒãçµæã®6ã€ã®ãŸãšãæ¹
- Excel(ãšã¯ã»ã«)ã®ã¢ã³ã±ãŒãçšçŽã«äœ¿ããç°¡åãªãã³ãã¬ãŒãã¯ãããŸããïŒ
- ãã©ãŒã äœæããŒã«ãformrunããããããïŒ
- Excel(ãšã¯ã»ã«)ã®ã¢ã³ã±ãŒãã¯äœãæ¹ãå°ãè€éâŠ
Excel(ãšã¯ã»ã«)ã䜿ã£ãåºæ¬ã®ã¢ã³ã±ãŒãã®äœãæ¹

ãŸããExcelã䜿çšããŠã¢ã³ã±ãŒããäœæããéã®åºæ¬ã®å·¥çšã解説ããŠãããŸãã
ã¢ã³ã±ãŒããäœæããããã®å·¥çšã¯ãäžèšã®4ã€ã®å·¥çšããããŸãã
- éçºã¿ãã衚瀺ããã
- 質åé ç®ãå ¥åãã
- åçããæ¬ãæ¿å ¥ãã
- ã·ãŒãã®ä¿è·ãèšå®ãã
STEP1ïŒéçºã¿ãã衚瀺ããã
Excelã¯åæç¶æ ã®ãŸãŸã ãšãã¢ã³ã±ãŒããã©ãŒã ãäœæããéã«å¿ èŠãªããŒããé衚瀺ã«ãªã£ãŠããŸãã
Excelã䜿ã£ãŠã¢ã³ã±ãŒããã©ãŒã ãäœæããéã«ã¯ãéçºãã¿ãã衚瀺ãããããšããå§ããŸãããã
ããã¡ã€ã«ããã¯ãªãã¯ããå·Šäžã«è¡šç€ºãããããªãã·ã§ã³ããéžæããŸããããæ¬¡ã«ããªãã³ã®ãŠãŒã¶ãŒèšå®ããéžæããéçºãã®ãã§ãã¯ããã¯ã¹ã«ãã§ãã¯ãå ¥ããOKããéžæããŠå®äºã§ãã
STEP2ïŒè³ªåé ç®ãå ¥åãã
éçºã¿ãã衚瀺ãããã質åé ç®ãå ¥åããŠãããŸãããããŸãå ¥åãããäœçœ®ã®ã»ã«ãã¯ãªãã¯ããŸãã
æåãå ¥åããããã»ã«å ãããã¯ã¿åºããããã«èšå®ããŠãããŸããããã»ã«ããé·ãæååãå ¥åãããšãæååãåæã«ã»ã«å ã§æãè¿ãããšãªã衚瀺ãããã®ã§ãèŠãããã¢ã³ã±ãŒããäœæå¯èœã§ãã
STEP3ïŒåçããæ¬ãæ¿å ¥ãã
質åé ç®ãå ¥åããããåçæ¬ãæ¿å ¥ããŸããããåçæ¬ã¯äžèšã®3ã€ã®æ¹æ³ã§æ¿å ¥ã§ããŸãã
- ãªãã·ã§ã³ãã¿ã³
- ãã§ãã¯ããã¯ã¹
- ããããããŠã³ãªã¹ã
- ããã¹ãããã¯ã¹
ãªãã·ã§ã³ãã¿ã³ã¯ãç·æ§ãã女æ§ããªã©ã®ããã«ãéžæåŒã®åçã®å Žåã«ããããã®åçæ¬ã§ãããã§ãã¯ããã¯ã¹ã¯ãããã€ãã®éžæè¢ã®äžããè€æ°ãéžãã§åçããå Žåã®è³ªåã«æ¿å ¥ããŸãããã
ããããããŠã³ãªã¹ãã¯ãè€æ°ã®åçããäžã€ã ããéžã¶è³ªåã®åçæ¬ãšããŠæŽ»çšã§ããŸãã
èšè¿°åŒã§ã®åçãæ±ããå Žåã«ã¯ãããã¹ãããã¯ã¹ãæ¿å ¥ããã®ãããããã§ãã
STEP4ïŒã·ãŒãã®ä¿è·ãèšå®ãã

Excelã§äœæããããŒã¿ã¯ãéåžžããã¯ãããã£ãŠããŸããããã¯ãäœæãã人以å€ãã·ãŒããé²èЧããå Žåã«ãç·šéãã§ããªãããã«ããããã§ãã
䟿å©ãªæ©èœã§ãããã¢ã³ã±ãŒããã©ãŒã ãšããŠæŽ»çšããéã«ã¯äžäŸ¿ãªã®ã§ãä¿è·èšå®ã倿Žããå¿ èŠããããŸãã
åçæ¬ãæ¿å ¥ããŠããã»ã«ãã¯ãªãã¯ããŸããããéžæããã»ã«ã®äžã§å³ã¯ãªãã¯ããããšãã»ã«ã®æžåŒèšå®ãã衚瀺ãããã®ã§ãä¿è·ãã¿ããéžæããããã¯ãã®ã»ã«ãå€ãã°ãç·šéãå¯èœã«ãªããŸãã
ã¢ã³ã±ãŒãã«å ããŠãExcelã§ã®å
¥åãã©ãŒã ã®äœææ¹æ³ã«ã€ããŠç¥ãããæ¹ã¯ãã¡ãã®èšäºãã芧ãã ããã
>> ExcelïŒãšã¯ã»ã«ïŒå
¥åãã©ãŒã ã®äœãæ¹ïŒãã¶ã€ã³ã®ã«ã¹ã¿ãã€ãºæ¹æ³
Excel(ãšã¯ã»ã«)ã¢ã³ã±ãŒãã®æç¥šãã¿ã³ã®äœãæ¹

Excelã䜿ã£ãŠã¢ã³ã±ãŒããã©ãŒã ãäœæããæ¹æ³ã玹ä»ããŸãããããã«äŸ¿å©ã«æŽ»çšããããã«ãæç¥šãã¿ã³ãã€ããæ¹æ³ããããŸãã
ãŸããéçºãã¿ãã®äžã«ãããæ¿å ¥ããéžæããã©ãžãªãã¿ã³ããã¯ãªãã¯ããŸããããã©ãžãªãã¿ã³ã¯ã·ãŒãäžã«è¡šç€ºãããã®ã§ãäœçœ®ã倧ãããèªç±ã«å€æŽããŸãã
ãã¿ã³ãå³ã¯ãªãã¯ãããšãã³ã³ãããŒã«ã®æžåŒèšå®(F)ãã衚瀺ãããã®ã§éžæããã³ã³ãããŒã«ãã¿ããéžæããŸãã
ããªã³ã¯ããã»ã«(L)ãã¯åçNOã衚瀺ããã»ã«ãæå®ããŠå®äºã§ãã
Excel(ãšã¯ã»ã«)ã䜿ã£ãŠã¢ã³ã±ãŒããäœæããã¡ãªããã»ãã¡ãªãã

ã¢ã³ã±ãŒããäœæããå·¥çšã«é¢ããç¥èãæ·±ããããšãã§ããŸããããããããæç¥šãã¿ã³ã®äœæãªã©ãå°ãè€éã«æããæ¹ãããã®ã§ã¯ãªãã§ããããã
ãã®èŠåºãã§ã¯ãExcelã䜿ã£ãŠã¢ã³ã±ãŒããäœæããã¡ãªãããšãã¡ãªããã玹ä»ããŠãããŸãã
Excel(ãšã¯ã»ã«)ã䜿ã£ãŠã¢ã³ã±ãŒããäœæãã3ã€ã®ã¡ãªãã
Excelã䜿ã£ãŠã¢ã³ã±ãŒããäœæããã¡ãªããã¯ãäžèšã®3ã€ããããããŸãã
- 远å ã³ã¹ãããããã«ã¢ã³ã±ãŒãã®äœæãã§ãã
- å°å·ãå¿ èŠãªå Žåã§ãããã«å¯Ÿå¿ã§ãã
- 颿°ã䜿çšããã°åçãèªåéèšã§ãã
远å ã³ã¹ãããããã«ã¢ã³ã±ãŒãã®äœæãã§ãã
ExcelãWordãã¯ãããšããofficeãœããã¯ãã€ã³ã¹ããŒã«ãããŠããäŒæ¥ãã»ãšãã©ã§ãããã
Excelã¯officeãœãããã€ã³ã¹ããŒã«ãããŠããã°ãã³ã¹ãããããããšãªã䜿çšã§ããŸããææãœãããªã©ã䜿çšããã³ã¹ãããããªããŠãã䟿å©ãªã¢ã³ã±ãŒããã©ãŒã ãäœæã§ããã®ã¯ã¡ãªããã§ãã
å°å·ãå¿ èŠãªå Žåã§ãããã«å¯Ÿå¿ã§ãã

äŒæ¥ãšäŒæ¥ã®éã§ã¢ã³ã±ãŒã調æ»ã宿œããéã«ãéµéã§ã¢ã³ã±ãŒã衚ã®éä»ãæ±ããããã±ãŒã¹ããããŸãã
ã¢ã³ã±ãŒãäœæãã©ãŒã ãªã©ã§äœæããŠããå Žåã«ãã¢ã³ã±ãŒã衚ã®å°å·ãæå³ãã圢ã§ã§ããªããªã©ãšäžäŸ¿ãªããšããããŸãã
ããããExcelã䜿çšããŠäœæããŠããã¢ã³ã±ãŒããã©ãŒã ã ãšæå³ãã圢ã§å°å·ãå¯èœã§ãã
颿°ã䜿çšããã°åçãèªåéèšã§ãã
Excelã®é¢æ°ã䜿ããæ¹ã§ããã°ãéèšããã¢ã³ã±ãŒãã®çµæã®èªåéèšãå¯èœã§ãããŸããGoogleãã©ãŒã ãã¹ãã¬ããã·ãŒããšã®é£æºãåãããã颿°ã䜿ãã¢ã³ã±ãŒããèªåšã«éèšã§ããç¹ãã¡ãªããã§ãã
Googleãã©ãŒã ãã¹ãã¬ããã·ãŒããšé£æºãããããšã§ãè€æ°äººã§ã®åæç·šéãããªã¢ã«ã¿ã€ã ã§ã®ããŒã¿æŽæ°ãã§ããããã«ãªããŸãã
Excel(ãšã¯ã»ã«)ã䜿ã£ãŠã¢ã³ã±ãŒããäœæãã4ã€ã®ãã¡ãªãã
Excelã䜿ã£ãŠã¢ã³ã±ãŒããäœæãããã¡ãªããã¯ãäžèšã®4ã€ãã¡ãªããããããããŸãã
- 颿°ã®ç¥èãæ·±ããå¿ èŠããã
- 倧éã®ã¢ã³ã±ãŒããéèšããã«ã¯äžåã
- ç¹å®ã®äººããæŽ»çšã§ããªããªãå¯èœæ§ããã
- ãã¶ã€ã³æ§ã®é«ãã¢ã³ã±ãŒãã®äœæãé£ãã
颿°ã®ç¥èãæ·±ããå¿ èŠããã

ã¢ã³ã±ãŒãã®çµæãèªåéèšãããªã©ãExcelãæŽ»çšããã«ã¯ã颿°ã®ç¥èãæ·±ããå¿ èŠããããŸãã
Excelãæ®æ®µããæŽ»çšããŠãã人ã§ãã£ãŠãããã¹ãŠã®é¢æ°ãçè§£ã§ããŠãã人ã¯å°ãªãã§ãããã
ã¢ã³ã±ãŒããã©ãŒã ãäœæããããŸãåäœããããŸã§ã«é¢æ°ã®ç¥èãæ·±ããã«ã¯æéãããããŸãã
倧éã®ã¢ã³ã±ãŒããéèšããã«ã¯äžåã
Excelã§äœæããã¢ã³ã±ãŒããã©ãŒã ã䜿ã£ãŠã倧éã®ã¢ã³ã±ãŒããéèšããã®ã¯äžåãã§ãã
äœæããã¢ã³ã±ãŒããæŽ»çšããŠããªã³ã©ã€ã³äžã§åéããå Žåã«ãã¡ãŒã«ã§ãã¡ã€ã«ãæ·»ä»ããå¿ èŠããããŸãã
ã¢ã³ã±ãŒãã«çããŠã»ãã人ããäŒæ¥å šå¡ã«ã¢ã³ã±ãŒããäžéãã€éãã®ã¯çŸå®çã§ã¯ãããŸããã
ç¹å®ã®äººããæŽ»çšã§ããªããªãå¯èœæ§ããã
åè¿°ã§ã玹ä»ããéããExcelãæŽ»çšããã«ã¯é¢æ°ã®ç¥èãå¿ èŠãšãªã£ãŠããããã颿°ã«å¯ŸããŠç¥èã®ããæ¹ããæŽ»çšã§ããªããªãå¯èœæ§ãåŠå®ã¯ã§ããŸããã
ã¢ã³ã±ãŒããèªåéèšããããã«ã¯ãã»ã«ããšã«é¢æ°ãæžã蟌ãã§ããå¿ èŠããããŸãã颿°ãè€éã«ãªã£ãŠãããããããŒã¿ã屿§åããŠããŸãã®ã¯ãã¡ãªããã§ãã
ãã¶ã€ã³æ§ã®é«ãã¢ã³ã±ãŒãã®äœæãé£ãã
Excelã䜿ã£ãã¢ã³ã±ãŒãã§ã¯ãé«ããã¶ã€ã³æ§ã®ã¢ã³ã±ãŒããã©ãŒã ãäœãã«ã¯éçããããŸãã
ãªããªããExcelã¯ã¢ã³ã±ãŒããã©ãŒã äœæããŒã«ã§ã¯ãªããããšããšã¯è¡šèšç®ãããããã®ãœããã ããã§ãã
ãã®ãããã¢ã³ã±ãŒãçšã®ãã³ãã¬ãŒããé åžãããŠããŸãããç»åã®æ¿å ¥ããæåã®ãã©ã³ããè²ã§ã«ã¹ã¿ãã€ãºã¯å¯èœã§ãããã€ãã³ããã»ãããŒã®å 容ã«å¿ããã¢ã³ã±ãŒããã©ãŒã ã®äœæã¯é£ããã§ãããã
formrunã§ããã°ãã¶ã€ã³ã®ç¥èããªããŠããè±å¯ãªãã³ãã¬ãŒãã®äžããéžæããæç30ç§ã§ã¢ã³ã±ãŒããã©ãŒã ã®äœæãã§ããŸãã
äœæã¯ç¡æã§å¯èœãªã®ã§ãæ°è»œã«ããã£ãŠã¿ãŠãã ããã
Excel(ãšã¯ã»ã«)ã§äœæããã¢ã³ã±ãŒããèªåéèšããæ¹æ³

Excelã䜿ã£ãŠã¢ã³ã±ãŒããäœæããã¡ãªããã»ãã¡ãªããã«é¢ããç¥èãæ·±ããããšãã§ããŸããã
次ã«ç޹ä»ããã®ã¯ãExcelã§äœæããã¢ã³ã±ãŒããèªåéèšããæ¹æ³ã§ããExcelã§äœæããã¢ã³ã±ãŒããèªåéèšããæ¹æ³ã¯ãäžèšã®2ã€ã®æ¹æ³ããããŸãã
- COUNTIF颿°
- SUM颿°ã»INDEX颿°
æ¹æ³1ïŒCOUNTIF颿°ïœåäžåçãéèš
COUNTIF颿°ã¯ãåäžã®æ¡ä»¶ã«äžèŽããã»ã«ã®æ°ã®èšç®ãã§ãã颿°ã§ããäŸãã°ãæ§å¥ã«é¢ããŠãç·æ§ãã女æ§ãããã®ä»ãã§åçããŠããã£ãã¢ã³ã±ãŒãããããšããŸãã
ã¢ã³ã±ãŒããããšã«ãç·æ§ãã©ãã ãããããéèšãããããªã©ã®å Žåãªã©ã«æŽ»çšã§ãã颿°ã§ãã
COUNTIF颿°ã¯ãæ°åŒããŒã«=COUNTIF(ç¯å²,æ€çŽ¢æ¡ä»¶)ãšå ¥åãããšèªåéèšãã§ããŸãã
æ¹æ³2ïŒSUM颿°ã»INDEX颿°ïœè€æ°åç
SUM颿°ã®ãªãã§INDEX颿°ã䜿çšããã°ãæå®ããç¯å²ã®åèšã衚瀺ãããããŸããæ°åŒããŒã«ãã=SUM(INDEX(ç¯å²,è¡çªå·,åçªå·))ããšå ¥åããã°åäœããŸãã
è¡çªå·ã»åçªå·ã¯ãæå®ããªãå Žåã¯0ãå ¥åããŠãããšããšã©ãŒã¡ãã»ãŒãžã衚瀺ãããããšããããŸããã
äžèšã®è¡šãããšã«ã¢ã³ã±ãŒãéèšãã§ãã颿°ã玹ä»ããŸãã
ID | 幎霢 | 質å1 | 質å2 | 質å3 |
1 | 20代 | 10 | 20 | 30 |
2 | 30代 | 10 | 20 | 30 |
ID2ã®åèšæ°ã調ã¹ãããšããŸãããããã®å Žåã¯ãçµæã衚瀺ãããã»ã«ãéžæããæ°åŒããŒã«ã=SUM(INDEX(,,))ããšå ¥åããã°èªåèšç®ãå¯èœã«ãªããŸãã
äžã€ç®ã®æ°å€ãšããŠéèšãããã»ã«ã®ç¯å²ããäºã€ç®ã«2ãäžã€ç®ã«0ãå ¥åããããšãID2ã®åã®åèšã¯ã60ãšè¡šç€ºãããŠããã¯ãã§ãã
Excel(ãšã¯ã»ã«)ã®ã¢ã³ã±ãŒãçµæã®6ã€ã®ãŸãšãæ¹

Excelã§äœæããã¢ã³ã±ãŒããèªåéèšããæ¹æ³ã¯ããããããã ããŸããããããã§ãæ°ã«ãªã£ãŠããã®ã¯ãExcelã§éããŠéèšããããŒã¿ãã©ã®ããã«ãŸãšããããã®ããšããç¹ã§ã¯ãªãã§ããããã
Excelã§éèšããããŒã¿ã¯ãäžèšã®6ã€ã®æ¹æ³ã§ãŸãšããããŸãã
- åã°ã©ã
- 垯ãã©ã
- æ£ã°ã©ã
- æãç·ã°ã©ã
- ã¬ãŒããŒãã£ãŒã
- æ£åžå³
ãŸãšãæ¹1ïŒåã°ã©ã
åã°ã©ãã¯ãç·æ§ãã女æ§ãããã®ä»ããªã©åçã1ã€ãããªãå Žåã®ã¢ã³ã±ãŒãçµæã®éèšã«äŸ¿å©ã§ãã
åã°ã©ãã¯ãå šäœã100ïŒ ãšããããããã®é ç®ãå šäœã®äœããŒã»ã³ãå ããŠããã®ãããŸãšããŠããŸãã
ãŸãšãæ¹2ïŒåž¯ãã©ã
垯ã°ã©ããåã°ã©ããšåæ§ã«åäžåçã¢ã³ã±ãŒãéèšã«ããããã§ããåã°ã©ããšç°ãªãç¹ã¯ãè€æ°ã®ã¢ã³ã±ãŒãçµæãšåæã«æ¯èŒããå Žåã«ã䞊ã¹ãŠè¡šç€ºãå¯èœãªããšã§ãã
䞊ã¹ãŠè¡šç€ºããããšã§ãæ¯çãåããããããªããŸãã
ãŸãšãæ¹3ïŒæ£ã°ã©ã

æ£ã°ã©ãã¯ãããŒã¿ã®å€§å°ãæ¯èŒããéã«äŸ¿å©ãªãŸãšãæ¹ã§ããäŸãã°ãå¶æ¥æ åœè å¥ã®å£²äžããã°ã©ãã§ãŸãšããå Žåã«ã¯ãæ£ã°ã©ãã«ãŸãšãããšæ¯èŒããããã§ãããã
ãŸãšãæ¹4ïŒæãç·ã°ã©ã
æãç·ã°ã©ãã¯ã売äžã®å€åãªã©ãæèŠçã«ã€ãã¿ããå Žåã«ããããã®ãŸãšãæ¹ã§ããæããšã®å£²äžéé¡ã衚ã«è¡šãéã«ã¯ãæãç·ã°ã©ããããããããã§ãããã
売äžãªã©ã®æ°åã瞊軞ã«èšå®ãã幎ãããæããªã©ã®é£ç¶ãã倿°ã暪軞ã«èšå®ããŸããæãç·ã°ã©ãã¯ãåäžåçãšè€æ°åçã®ã©ã¡ãã§ã䜿çšå¯èœãªã®ãç¹åŸŽã§ãã
ãŸãšãæ¹5ïŒã¬ãŒããŒãã£ãŒã
æ£å€è§åœ¢ã®åœ¢ãããã°ã©ããã¬ãŒããŒãã£ãŒãã§ããã¬ãŒããŒãã£ãŒãã®ç¹åŸŽã¯ã5çš®é¡ä»¥äžã®ããŒã¿ã1ã€ã®ã°ã©ãã«ãŸãšããããããšã§ãã
5çš®é¡ä»¥äžã®ããŒã¿ã1ã€ã®ã°ã©ãã«ãŸãšããããšã§ãå šäœã®åŸåã®èŠããåãå¯èœã«ãªããŸãã
ãŸãšãæ¹6ïŒæ£åžå³
æåŸã«ç޹ä»ããã®ãæ£åžå³ã§ããæ£åžå³ã¯2ã€ã®èŠçŽ ã®çžé¢é¢ä¿ã衚ãéã«äŸ¿å©ã«æŽ»çšã§ããŸãã
äŸãã°ã身é·ãšäœéã®é¢ä¿ãåºåè²»çšãšå£²äžãªã©ã¯æ£åžå³ã§ãŸãšããæ¹ãæ¯èŒã»ããŒã¿åæããããããªããŸãã
ã身é·ãé«ãã»ã©äœéãå¢ããåŸåã«ããã®ãããåºåã«äœ¿ã£ããéã売äžã«ã©ã®ããã«åœ±é¿ããŠããã®ãããªã©ã®ããŒã¿ãèŠããåããå Žåã¯æ£åžå³ã§ãŸãšããŠã¿ãŸãããã
Excel(ãšã¯ã»ã«)ã®ã¢ã³ã±ãŒãçšçŽã«äœ¿ããç°¡åãªãã³ãã¬ãŒãã¯ãããŸããïŒ
ããžãã¹ã·ãŒã³ã§äœ¿ããã·ã³ãã«ãªã¢ã³ã±ãŒãçšçŽã®ãã³ãã¬ãŒãã玹ä»ããŸãã
ãã¡ãã§ç޹ä»ããŠãããã³ãã¬ãŒãã¯ã質åã®é ç®ãèªç±ã«å€æŽãå¯èœã§ããMicrosoft瀟ãæäŸããŠãããã³ãã¬ãŒããã玹ä»ããŸãã®ã§ãæ°ã«ãªãæ¹ã¯ãã§ãã¯ããŠã¿ãŠãã ããã
ã¢ã³ã±ãŒãçšçŽïœmicrosoft
ãã©ãŒã äœæããŒã«ãformrunããããããïŒ

formrunã«ã¯ä»¥äžã®ç¹åŸŽããããŸããformrunãå©çšããã¡ãªããã¯äžèšã®4ç¹ã§ãã
- ãã¶ã€ã³æ§ã®é«ããã©ãŒã ãäœæã§ãã
- EFOïŒãã©ãŒã æé©åïŒã«åœ¹ç«ã€
- åãåãã管çãŸã§ã§ãã
- ã»ãã¥ãªãã£ãé«ã
ãã¶ã€ã³æ§ã®é«ããã©ãŒã ãäœæã§ãã
formrunã¯ããã¶ã€ã³ã®æè»æ§ãé«ããã©ã³ãã€ã¡ãŒãžã«ãã£ããã©ãŒã ãäœæã§ããŸãã
ãŸãã120çš®é¡ä»¥äžã®ãã³ãã¬ãŒããæã£ãŠãããããå¹
åºãæ¥çš®ãçšéã«åããããã©ãŒã ã«å¯Ÿå¿ã§ããŸãã
URLãäºæ¬¡å ã³ãŒãã§ç°¡åã«ã¢ã³ã±ãŒããéä»ã§ãããããªãã¯ã¹éžæãªã©åçãããããã©ãŒã ãäœããã®ã§ã瀟å å€åããã¢ã³ã±ãŒã調æ»ãæ¥åã«ããŠããæ¹å šè¬ã«ããããã§ãã
âŒformrunã®ãã³ãã¬ãŒãäžèЧã¯ãã¡ãããã確èªãã ãã
EFOïŒãã©ãŒã æé©åïŒã«åœ¹ç«ã€
EFOïŒãã©ãŒã æé©åïŒã«åœ¹ç«ãŠãããããšãformrunã«ç§»è¡ããã¡ãªããã®1ã€ã§ãããŠãŒã¶ãŒã«èŠªåãªãã©ãŒã ãäœæããããã«å¿ èŠãªEFOæ©èœããformrunã«ã¯æèŒãããŠããŸãã
äŸãã°ä»¥äžã®ãããªæ©èœã§ãã
- ãªã¢ã«ããªããŒã·ã§ã³æ©èœ
- äœæè£å®æ©èœ
- ããªã¬ãèªåå ¥åæ©èœ
- å šè§å ¥åã®èªååè§å
ãŠãŒã¶ãŒãå ¥åãã¹ãã¬ã¹ã«æããªããããªãã©ãŒã ãäœæã§ããããããŠãŒã¶ãŒã®é¢è±ã鲿¢ãå¯èœã§ãã
âŒformrunã®EFOæ©èœã«ã€ããŠè©³çްã¯ãã¡ãããã確èªãã ãã
ã¢ã³ã±ãŒããèªåã§éèš
formrunãæŽ»çšããã°ãé¢åãªéèšäœæ¥ãçãããšãã§ããŸãã
åçããªã¢ã«ã¿ã€ã ã§éèšããŠãããã ãã§ãªããã°ã©ãåããããããéèšç»é¢ã®ãã£ããã£ã貌ãä»ããã ãã§å ±åè³æãäœæããããšãã§ããŸãã
ãŸããéèšãããæéãéžæããCSVãã¡ã€ã«ãžã®ãšã¯ã¹ããŒããå¯èœãªãããæå ã§è€éãªéèšãããããšãå¯èœã§ãã
ã»ãã¥ãªãã£å¯Ÿçãäžå š
ã»ãã¥ãªãã£ãé«ãã®ãformrunã®é åã®ãã€ã³ãã§ãããISO 27001 (ISMS)ãã®èªèšŒååŸããã©ã€ãã·ãŒããŒã¯ã®ä»äžèªå®ãSSL/ TLSã«ããæå·åéä¿¡ã24æé365æ¥ã®ãµãŒããŒç£èŠäœå¶ãªã©å¯ŸçããšãããŠããŸãã
ãã©ãŒã ãæŽ»çšããéã¯ãååãäœæãã¡ãŒã«ã¢ãã¬ã¹ãªã©éèŠãªå人æ å ±ãåãæ±ããŸãããŠãŒã¶ãŒã«å®å¿ããŠãã©ãŒã ãå©çšããŠãããããã«ãããã©ãŒã ã®ã»ãã¥ãªãã£ã¯å¿ é ã§ãã
âŒformrunã®ã»ãã¥ãªãã£ã®è©³çްã¯ãã¡ããã確èªãã ãã
ãäºäŸç޹ä»ã倧æäŒæ¥ã®å Žåã¯ããŒã«å©çšã®ããŒãã«ã¯äºç®ããèªç€Ÿã®ã»ãã¥ãªãã£èŠä»¶ïŒïŒ

åçïŒäŒè€å¿ ãã¯ããœãªã¥ãŒã·ã§ã³ãºæ ªåŒäŒç€Ÿæ§
äŒè€å¿ ãã¯ããœãªã¥ãŒã·ã§ã³ãºæ ªåŒäŒç€Ÿã¯ãã³ã³ãµã«ãã£ã³ã°ããèšèšãéçºã»æ§ç¯ãéçšã»ä¿å®ãµããŒããŸã§ãå é²ã®ãã¯ãããžãŒã«åºã¥ãã¯ã©ãŠããµãŒãã¹ã補åãçµã¿åããããœãªã¥ãŒã·ã§ã³ãæäŸããŠããŸãã
å瀟ã§ã¯ãã»ãã¥ãªãã£ã®å®å šæ§ãformrunã®å°å ¥ã決ããèŠå ã®äžã€ãšãªã£ãŠããŸãã
åãããã«ç€Ÿå ã®å³ããã»ãã¥ãªãã£ãã§ãã¯ã«ãã£ãŠãããŒã«ã®å°å ¥ãé²ã¿ã«ãããšããæ¹ã¯ããã²formrunãæ€èšããŠã¿ãŠãã ããã
察象 | formrunå©çšçšé |
---|---|
瀟å€åã | ⢠ãåãåãããã©ãŒã ⢠ã€ãã³ãåå åä»ãã©ãŒã ã»ãã£ã³ããŒã³ãªã© |
瀟å åã | ⢠ã¢ã³ã±ãŒãããµãŒãã€ãªã© |
ã顧客ã®å£°ã
Googleãã©ãŒã ãMicrosoft Formsãæ€èšããŠããã®ã§ãããã»ãã¥ãªãã£ã®åé¡ã瀟å€åããã©ãŒã ãšããŠã®æ©èœäžè¶³çã§å¥ã®ãã©ãŒã ãæ¢ããŠããŠãformrunãèŠã€ããŸããã
ã»ãã¥ãªãã£é¢ãšããŠãããããæäœãããããå©çšã¡ã³ããŒã®åŠç¿ã³ã¹ããäœãã®ã§ããããã§ãã
倧æäŒæ¥ã®å Žåã¯ããŒã«å©çšã®ããŒãã«ã¯äºç®ããèªç€Ÿã®ã»ãã¥ãªãã£èŠä»¶ã ãšæã£ãŠããã®ã§ããã®èгç¹ã§ãformrunã¯ã¯ãªã¢ã§ããã®ã§ããã²è©ŠããŠã¿ãŠã»ããã§ãã

Excel(ãšã¯ã»ã«)ã®ã¢ã³ã±ãŒãã¯äœãæ¹ãå°ãè€éâŠ

äœã³ã¹ãã§å©çšãã§ãããŸãéããçµæãåã°ã©ããæ£ã°ã©ããªã©ããŸããŸãªãŸãšãæ¹ãã§ããã®ãå©ç¹ã®Excelã§ãã
ãããã颿°ã®ç¥èãæ·±ããå¿ èŠãããããšãã倧éã®ã¢ã³ã±ãŒããéèšããã«ã¯äžäŸ¿ãªç¹ãããã®ã¯äºå®ã§ãã
ããŸãåäœãããããã«ã¯ãå°ãè€éãªç¹ããã£ãŠãå¥ã®æ¹æ³ã§ã¢ã³ã±ãŒãã宿œããæ¹ãããã®ã§ã¯ïŒãšæããæ¹ããããããããŸããã
æ¬èšäºã§ã¯ãã¢ã³ã±ãŒããã©ãŒã äœæããŒã«ãformrunãã®ç¹åŸŽã詳ãã玹ä»ããŠããŸãã
ããã°ã©ãã³ã°ã®ç¥èããªãæ¹ã§ãããã©ãŒã ã®äœæãã§ããããŒãã«åãããŠå€æ°ã®ãã³ãã¬ãŒãã®äžããéžæãã§ããã®ãformrunã ããããã§ãã
formrunã®FREEãã©ã³ã¯æ°žä¹ ã«ç¡æã§ãå©çšããã ããŸãã
ãŸããææãã©ã³ã¯14æ¥éç¡æã§äœ¿çšã§ãããããææãã©ã³ã®æ©èœãæ°ã«ãªãæ¹ã¯ç¡ææéã§è©ŠããŠã¿ãã®ãããããã§ãã
formrunã®ããšãããå°ã詳ããç¥ãããæ¹ã¯ããã¡ãã®å ¬åŒããŒã ããŒãžããåç §ãã ããã
formrunããã©ãŒã äœæã顧客管çã«é¢ããæ å ±ãçºä¿¡ããŠãããŸãã
EFOïŒãšã³ããªãŒãã©ãŒã æé©åïŒãåãåãã察å¿ãªã©ã
ãã©ãŒã ã«é¢ãããæ©ã¿ã解決ããŸãã