ãããœã³ã³ã¯äººäžŠã¿ã«äœ¿ããããã©ã客芳çãªèšŒæã欲ããããè»¢è·æŽ»åã§æŠåšã«ãªãè³æ Œãç¥ããããâŠããããªããžãã¹ããŒãœã³ãåŠçã®éã§ãäžåã®äººæ°ãèªãã®ãMOSïŒMicrosoft Office SpecialistïŒã§ãã
/
ããããåéšæïŒ1ç§ç®çŽ1äžåãïŒãåŠç¿æéãèãããšããæ¬åœã«å ãåããã®ãïŒããšçåã«æãæ¹ãå€ãã§ããããæ¬èšäºã§ã¯ãMOSååŸãããããåçãªçç£æ§åäžãšããã£ãªã¢ã«ãããåžå ŽäŸ¡å€ã®åäžã«ã€ããŠã4,500æåãè¶ ããå§åçãªããªã¥ãŒã ã§è©³ãã解説ããŸãã
1. ð¡ MOSè³æ Œã®åºç€ç¥èïŒãªãä»ãäžçã§æ±ããããã®ã
MOSã¯ãWordãExcelãPowerPointãOutlookãAccessãšãã£ãMicrosoft Office補åã®å©çšã¹ãã«ã蚌æããããã€ã¯ããœããå ¬èªã®åœéè³æ Œã§ãã
/
1-1. ð 詊éšã®åœ¢åŒãšã宿éèŠãã®ææ³
MOSã®æå€§ã®ç¹åŸŽã¯ãçèšè©Šéšãäžåãªãããã¹ãŠã³ã³ãã¥ãŒã¿ã䜿ã£ãå®æè©ŠéšïŒCBTæ¹åŒïŒã§ããç¹ã§ãã詊éšç»é¢ã«è¡šç€ºãããæç€ºã«åŸããå®éã«ãã¡ã€ã«ãç·šéããŠãããŸãã
- ããŒãžã§ã³å¥è©ŠéšïŒ çŸåšã¯ãµãã¹ã¯ãªãã·ã§ã³çã®ãMicrosoft 365ããäž»æµã§ãã
- ã¬ãã«èšå®ïŒ åºç€çãªãäžè¬ïŒã¢ãœã·ãšã€ãïŒããšãé«åºŠãªãäžçŽïŒãšãã¹ããŒãïŒãã«åãããŠããŸãã
1-2. ð äžçå ±éã®ãITãã¹ããŒãã
MOSã¯äžç200以äžã®åœãšå°åã§å®æœãããŠããã环èšåéšè æ°ã¯æ°çŸäžäººã«ã®ãŒããŸããã°ããŒãã«äŒæ¥ã«ãããŠããOfficeã¹ãã«ã¯ãããžãã¹ã®å ±éèšèªããšããŠèªèãããŠãããããæµ·å€å°±è·ãå€è³ç³»äŒæ¥ãžã®è»¢è·ã§ãæå¹ãªæŠåšãšãªããŸãã
2. ð ã¡ãªãã1ïŒå°±è·ã»è»¢è·ã«ãããã客芳çè©äŸ¡ãã®ç²åŸ
ãExcelã䜿ããŸãããšããèšèã»ã©ãæ¡çšçŸå Žã§ä¿¡çšãã«ãããã®ã¯ãããŸããããã人ã¯ãæåå ¥åãã§ãããçšåºŠã§ããèšãããã人ã¯ããã¯ããçµãããã®ã«ããèšããŸãã
/
2-1. ð€ æ¡çšæ åœè ã®ãæè²ã³ã¹ãããåæžãã
äŒæ¥ãäžéæ¡çšã掟é£ç€Ÿå¡ãæ¡çšããéãæãæžå¿µããã®ã¯ããã®äººã¯å ¥ç€Ÿåæ¥ããæŠåã«ãªããïŒããšããç¹ã§ãã
MOSãä¿æããŠããããšã¯ããåºæ¬çãªæäœãäžéããã¹ã¿ãŒããŠãããæšªã§èª°ããæããªããŠãèªèµ°ã§ãããããšã®èšŒæã«ãªããŸãããã®ãå®å¿æãããæžé¡éžèã®ééçãåçã«åŒãäžããŸãã
/
2-2. âïž å±¥æŽæžãžã®æ£ããæžãæ¹ãšé¢æ¥ã§ã®ã¢ããŒã«äŸæ
å±¥æŽæžã«ã¯æ£åŒåç§°ã§èšèŒããŸãããã
- èšèŒäŸïŒ Microsoft Office Specialist Microsoft 365 Excel ååŸ
ãŸãã颿¥ã§ã¯åã«ãæã£ãŠããŸãããšèšãã ãã§ãªãã以äžã®ããã«äŒãããšå¹æçã§ãã
ãåè·ã§ã¯ããŒã¿ã®éèšã«æäœæ¥ã§1æéããã£ãŠããŸããããMOSã§åŠãã VLOOKUP颿°ãããããããŒãã«ã掻çšããäœæ¥ã5åã«ççž®ããŠãã¹ã®ãªãä»çµã¿ãäœããŸããã埡瀟ã§ããã®ã¹ãã«ã掻ãããäºåå¹çã®æ¹åã«è²¢ç®ããããšèããŠããŸããã
3. â¡ ã¡ãªãã2ïŒå®åã®ãã¹ããŒããã3å以äžã«è·³ãäžãã
MOSã®åŠç¿ã§åŸãããæå€§ã®æ©æµã¯ããäœæ¥æéã®ççž®ãã§ããèªå·±æµã§æäœããŠãã人ãšãMOSä¿æè ã®éã«ã¯ãç®ã«èŠããªã巚倧ãªãæéã®å£ããååšããŸãã
/
3-1. ð Excelã«ãããåçå€åïŒBefore/AfterïŒ
- BeforeïŒ æ°åè¡ã®ããŒã¿ããç¹å®ã®é ç®ãæ¢ãã®ã«ãå¿ æ»ã§ã¹ã¯ããŒã«ããæåã§ã³ããããŠéèšã1æéã®äœæ¥ã
- AfterïŒ ãXLOOKUP颿°ãããã¹ãã«æ©èœãã䜿ããäžã€ã®æ°åŒã§å šãŠã®ããŒã¿ãèªåæœåºãäœæ¥æéã¯ããã3åã
3-2. ð Wordã«ãããåçå€å
- BeforeïŒ è¡šçŽãç®æ¬¡ãæåã§äœããä¿®æ£ãå ¥ããã³ã«ããŒãžçªå·ãæã¡çŽãã
- AfterïŒ ãã¢ãŠãã©ã€ã³ããšãã¹ã¿ã€ã«ãæ©èœã䜿ããç®æ¬¡ãèªåçæãã¬ã€ã¢ãŠã厩ãã«æ©ãŸãããããšããªããªãã
3-3. ð» PowerPointã«ãããåçå€å
- BeforeïŒ ã¹ã©ã€ãããšã«ãã©ã³ããããŽã®äœçœ®ã調æŽã
- AfterïŒ ãã¹ã©ã€ããã¹ã¿ãŒãã䜿ããå šã¹ã©ã€ãã®ãã¶ã€ã³ãäžæ¬ç®¡çãã¢ãã¡ãŒã·ã§ã³ã广çã«äœ¿ãããã¬ãŒã³ã®è³ªãåäžã
4. ð ã¡ãªãã3ïŒææ°çãMOS 365ãã§åŠã¶æ¬¡äžä»£ã¹ãã«
çŸåšäž»æµã®ãMicrosoft 365ãããŒãžã§ã³ã®è©Šéšã§ã¯ãåŸæ¥ã®ããŒãžã§ã³ã«ã¯ãªãã£ã驿°çãªæ©èœãç¯å²ã«å«ãŸããŠããŸãããããç¥ã£ãŠããã ãã§ããææ°ã®ITãªãã©ã·ãŒãããããšè©äŸ¡ãããŸãã
/
4-1. ð Excelã®ãã¹ãã«ããšãXLOOKUPã
ææ°ã®Excel詊éšã§ã¯ãåŸæ¥ã®VLOOKUP颿°ã®åŒ±ç¹ãå æããXLOOKUP颿°ãç»å ŽããŸãããŸããäžã€ã®æ°åŒãå ¥åããã ãã§è€æ°ã®ã»ã«ã«çµæã溢ãåºããã¹ãã«ïŒSpillïŒãã®æŠå¿µãçè§£ããŠããããšã¯ãçŸä»£ã®ããŒã¿åæã«ãããŠå¿ é ã®ç¥èã§ãã
/
4-2. âïž å ±åç·šéãšã¯ã©ãŠã飿º
365çã§ã¯ãOneDriveãä»ããå ±åç·šéãã倿Žå±¥æŽã®ç®¡çãªã©ããã¬ã¯ãŒã¯æä»£ã®å¿ é ã¹ãã«ãåŠã¹ãŸããèªåäžäººã§å®çµããäœæ¥ã§ã¯ãªãããããŒã ã§å¹ççã«ä»äºãããæ¹æ³ããäœç³»çã«åŠã¹ãã®ãMOSã®é ããã¡ãªããã§ãã
5. â ã¡ãªãã4ïŒããŒã¿ã®ãæ£ç¢ºæ§ããšãä¿¡é Œæ§ãã®åäž
ä»äºã«ãããŠãéãããšåããããéèŠãªã®ããæ£ç¢ºããã§ããMOSã§åŠã¶æ©èœã¯ããã¥ãŒãã³ãšã©ãŒãé²ãããã®ä»çµã¿äœãã«çŽçµããŸãã
/
5-1. ð¡ïžãä»çµã¿ãã§ãã¹ãé²ã
äŸãã°ãExcelã®ãããŒã¿ã®å ¥åèŠåããåŠã¹ã°ãå šè§ã»åè§ã®æ··åšããæ°å€ä»¥å€ã®å ¥åãšãã£ããšã©ãŒãæªç¶ã«é²ãèšå®ãã§ããŸãããèšç®åŒãå ¥ã£ãŠããã»ã«ã«ããã¯ããããïŒã·ãŒãã®ä¿è·ïŒããšãã£ãç¥èãããã°ãå ±æãã¡ã€ã«ã誰ãã«å£ããããªã¹ã¯ãåé¿ã§ããŸãã
/
5-2. âš ãããã§ãã·ã§ãã«ãªèŠæ ã
MOSã®è©Šéšç¯å²ã«ã¯ãã°ã©ãã®é©åãªéžæããææžã®æžåŒèšå®ãå«ãŸããŸãã
ããªããšãªãäœã£ãè³æããšãã«ãŒã«ã«åºã¥ããèŠãããè³æãã§ã¯ãã¯ã©ã€ã¢ã³ããäžåžã«äžããå°è±¡ã倩ãšå°ã»ã©éããŸããã¹ãã«ã®èšŒæã¯ããã®ãŸãŸãä»äºã®äžå¯§ãããžã®è©äŸ¡ã«ç¹ãããŸãã

/
6. ð ãå®è·µãç¬åŠã§MOSã1ã¶æã§ååŸããããã®ã¹ã±ãžã¥ãŒã«
ãå¿ãããŠå匷æéãåããªãããšããæ¹ã®ããã«ãå¹ççãª1ã¶æïŒ4é±éïŒã®åŠç¿ãã©ã³ãææ¡ããŸãã
/
第1é±ïŒçŸç¶ææ¡ãšåºç€åºãïŒå¹³æ¥30åãäŒæ¥2æéïŒ
ãŸãã¯å¯Ÿçããã¹ããäžéãèªã¿ãŸãã
- ããã¹ãä»å±ã®æŒç¿ãã¡ã€ã«ã䜿ãã解説ãèŠãªããå®éã«æãåããã
- ããããªãçšèªïŒã絶察åç §ããã€ã³ãã³ãããªã©ïŒããŒãã«ããã
- ãã€ã³ãïŒ æåããæèšããããšãããããããªæ©èœããããã ããšããå šäœåãææ¡ããããšã«å°å¿µããŸãã
第2é±ïŒæ©èœã®å šç¶²çŸ ãšå埩緎ç¿ïŒå¹³æ¥1æéãäŒæ¥3æéïŒ
ããã¹ãã®å šç« ãç¶²çŸ ããŸãã
- èŠæãªæ©èœããªã¹ãã¢ããããïŒäŸïŒã°ã©ãã®è»žèšå®ãè€éãªIF颿°ãªã©ïŒã
- ããªããã®æäœãããã®ãããæèããªããé²ããã
- ãã€ã³ãïŒ 1é±ç®ã«ãã£ãå 容ãå¿ããããŠããã¯ããªã®ã§ã埩ç¿ãå ŒããŠç« æ«åé¡ãè§£ãé²ããŸãã
第3é±ïŒæš¡æ¬è©Šéšãžã®ææŠïŒå¹³æ¥1ååãäŒæ¥2ååïŒ
ãããæãéèŠã§ãã
- 察çããã¹ãã«ä»å±ããŠããæš¡æ¬è©Šéšãœãããè§£ãã
- æåã¯æéãããã£ãŠãè¯ãã®ã§ãèªåã§æåŸãŸã§è§£ãããã
- ééããåé¡ã¯ã解説ãèªã¿èŸŒã¿ãç¿æ¥ã«å床解ãçŽãã
- ç®æšïŒ æ£ççã«é¢ãããããè§£ãæ¹ã®ãã¿ãŒã³ãã«æ £ããããšã
第4é±ïŒä»äžããšæéççž®ïŒæ¯æ¥1ååïŒ
æ¬çªåœ¢åŒã§100ç¹ãçããŸãã
- è©Šéšæéã¯50åã§ãããæš¡æ¬è©Šéšã§30åã40å以å ã«çµããããã«ã¹ããŒããäžããã
- ãæäœãè¿·ãæéãããªããã
- æçµç®æšïŒ 3åé£ç¶ã§90%以äžã®ã¹ã³ã¢ãåºããããã«ãªãã°ãåæ Œã¯ç®åã§ãã
7. â ïž è©Šéšåœæ¥ïŒèœã¡çããŠå®åãçºæ®ããããã®æ³šæç¹
ã©ãã ãå匷ããŠããåœæ¥ã®ãã©ãã«ã§çŠã£ãŠã¯æå³ããããŸãããMOS詊éšç¹æã®ãããããããšå¯ŸçããŸãšããŸããã
/
7-1. ðãå顿ã®èšãåããã«æ £ãã
MOSã®å顿ã¯ãç¬ç¹ãªç¿»èš³èª¿ã§ããããšãå€ãã§ãããããæ§æããªããããããé©çšããªããããšãã£ã衚çŸã«æžæããªããããæš¡æ¬è©Šéšã®æ®µéã§æäœã«æ £ããŠãããŸãããã
/
7-2. ð ïž ããªãŒãºãåäœäžè¯ãèµ·ããã
詊éšäžã«ããœã³ã³ãåããªããªã£ãããæäœãåæ ãããªãã£ããããããšãçšã«ãããŸãããã®éã¯è¿·ãã詊éšå®ãåŒã³ãŸãããã 詊éšã®æ®ãæéã¯äžæåæ¢ãããã®ã§ãçŠãå¿ èŠã¯ãããŸããã
/
7-3. ðãããçŽãããã¿ã³ã掻çšãã
æäœãééãããšæã£ãããå³äžã®ããããžã§ã¯ãã®ãªã»ããããã¿ã³ã§åæç¶æ ã«æ»ããŸããå€ã«ä¿®æ£ãç¹°ãè¿ããŠããŒã¿ããã¡ããã¡ãã«ãªããããæœããªã»ããããæ¹ãæ£è§£ã«è¿ä»ãããšããããŸãã
8. ð ä»ã®ITè³æ Œãšã®æ¯èŒïŒMOSãéžã¶ã¹ã人ãéžã°ãªããŠè¯ã人
ãITãã¹ããŒããããæ¥åPCæ€å®ããªã©ã䌌ãè³æ Œãšã®éããæç¢ºã«ããŸãã
| è³æ Œå | ç¹åŸŽ | åããŠãã人 |
| MOS | Office補åã®çŽæ¥çãªæäœã¹ãã«ã蚌æã | å®åã§å³ãæçããã人ã転è·ã»æŽŸé£ã |
| ITãã¹ããŒã | ITå šè¬ã®ç¥èïŒçµå¶ãã»ãã¥ãªãã£ãçšèªïŒã | ITã®æé€ãæ·±ãããäººãæ°ååŠçã |
| æ¥åPCæ€å® | ããžãã¹ææžã®äœæèœåããå®åã§ã®å€æåã | æ¥æ¬ã®åç¿æ £ã«åºã¥ããã¹ãã«ã磚ããã人ã |
| VBAãšãã¹ããŒã | Excelçã®èªååïŒããã°ã©ãã³ã°ïŒã«ç¹åã | äºåäœæ¥ã極éãŸã§èªååãããå°éè·ã |
9. ð ååŸåŸã®ãªã¢ã«ãªå€åïŒ3ã€ã®åæ Œäœéšã¹ããŒãªãŒ
å®éã«MOSãååŸãã人ããã©ã®ãããªå€åã宿ãããã·ãã¥ã¬ãŒã·ã§ã³ããŠã¿ãŸãããã
/
ð€ AããïŒ30代ã»äžè¬äºåè·ïŒ
以åã¯Excelã®éèšãã¹ãäžåžã«ææãããè©èº«ã®çãæããããŠããŸãããMOS ExcelãååŸåŸãããããããŒãã«ãå°å ¥ããŠéèšã®èªååã«æåããã¹ããŒãã«ãªããä»ã§ã¯ãéšçœ²ã®ã·ã¹ãã æ åœãã®ãããªååšãšããŠé ŒãããŠããŸãã
/
ð€ BããïŒ20代ã»å¶æ¥è·ïŒ
PowerPointã®è³æäœæãèŠçã§ããã€ãæ·±å€ãŸã§æ®æ¥ããŠããŸãããMOSã§ã¹ã©ã€ããã¹ã¿ãŒãšã·ã§ãŒãã«ããããŒãåŠãã çµæãäœææéãåå以äžã«ãæµ®ããæéã§é¡§å®¢èšªåãå¢ãããæçŽçãåäžã瀟å ã§ã®è©äŸ¡ãäžãããæé²ã«ç¹ãããŸããã
/
ð€ CããïŒå€§åŠ4幎çã»å°±æŽ»çïŒ
å±¥æŽæžã®è³æ Œæ¬ãé転å èš±ã®ã¿ã§äžå®ã§ããããMOS ExcelãšWordãååŸã颿¥ã§ãITãªãã©ã·ãŒã®é«ãã客芳çã«èšŒæã§ããŸãããšèªä¿¡ãæã£ãŠçãã第äžå¿æã®ITäŒæ¥ããå å®ãç²åŸããŸããã
10. ð° åéšæãé«ãïŒ å®ã¯ãé«ã³ã¹ãããªæè³ã§ããçç±
MOSã®åéšæã¯çŽ10,780åïŒçšèŸŒãäžè¬ã¬ãã«ïŒã§ãããšãã¹ããŒããŸã§åããš2äžåãè¶ ããŸããããããé«ãããšæãããããããŸããããçæ¶¯è³éãæéã®äŸ¡å€ã§èããã°ç Žæ Œã®å®ãã§ãã
/
10-1. â° æçµŠæç®ã§ã®ã¡ãªãã
MOSãååŸããæ¥ã ã®æ¥åãæ¯æ¥30åççž®ããããšããŸãã
- 1ã¶æã§çŽ10æéã®ç¯çŽã
- æçµŠ2,000åã®äººãªããããã1ã¶æã§åéšæã®å ãåããèšç®ã«ãªããŸãã
- ãã®åŸã®æ°å幎ããã®ã¹ãã«ã¯ããªãã®ãè³ç£ããšããŠæ®ãç¶ããŸãã
10-2. ð è³æ Œæåœã®å¯Ÿè±¡ã«ãªãããšã
äŒæ¥ã«ãã£ãŠã¯ãMOSååŸã«å¯ŸããŠæ°ååã1äžåçšåºŠã®ãè³æ Œæåœãããäžæéããæ¯çµŠããŠããŸãã瀟å èŠå®ããã§ãã¯ããŠã¿ã䟡å€ã¯å€§ãã«ãããŸãã

/
11. ð ãŸãšãïŒMOSã¯ãèªç±ãªæéããæã«å ¥ããããã®ãã±ãã
æ¬èšäºã§ã¯ãMOSè³æ ŒååŸã®ã¡ãªãããå€è§çã«è§£èª¬ããŠããŸããã
- å°±è·ã»è»¢è·ã§ã®åŒ·åãªå®¢èгç蚌æïŒ ãèªç§°ã§ããããããå ¬èªã¹ãã«ããžã
- å®åã®åçãªã¹ããŒãã¢ããïŒ 1æéã®äœæ¥ã5åã«ççž®ããæè¡ã
- ãã¹ã®ãªãä»çµã¿äœãïŒ æ£ç¢ºæ§ãä¿¡é Œãçã¿ããã£ãªã¢ãå®å®ãããã
- ææ°365ã¹ãã«ã®ç¿åŸïŒ XLOOKUPãå ±åç·šéãªã©ãæä»£ã«å³ããæŠåšã
- èªå·±è¯å®æã®åäžïŒ ãããœã³ã³ãèŠæããããæããç«å Žããžã®è»¢æã
ãããœã³ã³ãã§ããããšããèªä¿¡ã¯ãããªãã®ä»äºã«å¯Ÿããã¹ãã¬ã¹ãå€§å¹ ã«è»œæžããŸããç· ãåãééã«çŠãèªåãããŒã¿ã®äžæŽåã«é ãæ±ããèªåãã忥ããŸãããã
/
MOSã®å匷ãå§ããããšã¯ãåãªãè³æ ŒååŸã§ã¯ãããŸããããèªåã®æéãã³ã³ãããŒã«ããæš©å©ããæã«å ¥ããããã®ææŠãªã®ã§ãã
/
ãŸãã¯1åã®ããã¹ããæã«åããæš¡æ¬è©Šéšã1åè§£ããŠã¿ãããšããå§ããŠãã ããããã®äžæ©ããæ°ã¶æåŸã®ããªãã®åãæ¹ãåçã«å€ããŠããã¯ãã§ãã
/
æ ªåŒäŒç€Ÿã€ãŒãã¯ã¹ãïŒåèçã®ããŒã ããŒãžå¶äœäŒç€Ÿ
æ ªåŒäŒç€Ÿã€ãŒãã¯ã¹ãïŒåèçã®SNSã»WEBããŒã±ãã£ã³ã°äŒç€Ÿ
/
ãç§ãã¡ã¯ã客æ§ãšãšãã«æªæ¥ãåµé ããæé·ã§ããååšã§ãããããã
åèçåžå·åžãæ ç¹ã«ããŠã§ããµã€ãïŒããŒã ããŒãžïŒå¶äœã»SEO察çã»MEOã»SNSã»WEBããŒã±ãã£ã³ã°ãéããŠããŠã§ããµã€ãã«ãã£ããåããŠããããæ¯æŽãè¡ã£ãŠããŸãã
ã客ããŸã®èª²é¡ãæ©ã¿ã解決ããé客ã¢ãããã売äžã¢ãããããã©ã³ãã£ã³ã°ã¢ããããå®çŸããŸãïŒ