ãšã¯ã»ã«ã®åæç·šéã»ãªã¢ã«ã¿ã€ã å ±æã®ããæ¹ïœèšå®æé ãšãã©ãã«è§£æ±ºæ³ãå®å šè§£èª¬
ãããŒã ã§Excelãã¡ã€ã«ãåæã«ç·šéããããã©ãèšå®æ¹æ³ãããããªãã
ãå ±åç·šéãèšå®ããã¯ããªã®ã«ããªãããã¡ã€ã«ãããã¯ãããŠããŸãã
ãåšå® å€åã§ãã¡ã€ã«ã®ããåããç ©éã«ãªããäœæ¥å¹çãèœã¡ãŠããã
ãã®ãããªæ©ã¿ãæ±ããŠããŸãããïŒ
ãªã¢ãŒãã¯ãŒã¯ã®æ®åã§ãExcelã®åæç·šéããŒãºã¯æ¥å¢ããŠããŸããæ£ããèšå®ããããã°ã誰ã§ãç°¡åã«äœ¿ãããªããŸããïŒ
Excelã®åæç·šéæ©èœã¯éåžžã«äŸ¿å©ã§ãããæ£ããç°å¢ãæŽã£ãŠããªããšåäœããŸããã
Microsoft 365ã®ã©ã€ã»ã³ã¹ãOneDriveãžã®ä¿åãèªåä¿åã®èšå®ãªã©ãããã€ãã®æ¡ä»¶ãæºããå¿ èŠããããŸãã
äžã€ã§ãæ¬ ããŠãããšãšã©ãŒãçºçããããç·šéå å®¹ãæ¶ããŠããŸã£ãããããã©ãã«ã«ã€ãªãããŸãã
ãã®èšäºãèªãã°ã仿¥ããããŒã ã¡ã³ããŒãšExcelãã¡ã€ã«ããªã¢ã«ã¿ã€ã ã§å ±åç·šéã§ããããã«ãªããŸãã
ãã¡ã€ã«ã®åãæž¡ãã«ããã£ãŠããæéãå€§å¹ ã«åæžã§ããŸãã
ãã©ãã«ãçºçããéããåå ãçŽ æ©ãç¹å®ããŠè§£æ±ºã§ããããã«ãªãã§ãããã
ããã§ã¯ãå ·äœçãªèšå®æ¹æ³ãèŠãŠãããŸãããïŒ
- ãšã¯ã»ã«ã®ãªã¢ã«ã¿ã€ã åæç·šéãšã¯ïŒ3ã€ã®å¿ é æ¡ä»¶ã解説
- ã5åã§å®äºããšã¯ã»ã«ã®ãªã¢ã«ã¿ã€ã åæç·šéã®èšå®æé
- ãšã¯ã»ã«ã§åæç·šéãã§ããªãæã®åå ãšå¯ŸåŠæ³
- ãšã¯ã»ã«ã®åæç·šéã®ãã¡ãªãããšå¶éäºé
- ã¬ã¬ã·ãŒå ±æããã¯ããæ°ãããªã¢ã«ã¿ã€ã å ±åç·šéãžã®ç§»è¡

ç®æ¬¡
- ãšã¯ã»ã«ã®ãªã¢ã«ã¿ã€ã åæç·šéãšã¯ïŒ3ã€ã®å¿ é æ¡ä»¶ã解説
- ã5åã§å®äºããšã¯ã»ã«ã®ãªã¢ã«ã¿ã€ã åæç·šéã®èšå®æé
- ãšã¯ã»ã«ã§åæç·šéãã§ããªãæã®åå ãšå¯ŸåŠæ³
- ãšã¯ã»ã«ã®åæç·šéã®ãã¡ãªãããšå¶éäºé
- ã¬ã¬ã·ãŒå ±æããã¯ããæ°ãããªã¢ã«ã¿ã€ã å ±åç·šéãžã®ç§»è¡
ãšã¯ã»ã«ã®ãªã¢ã«ã¿ã€ã åæç·šéãšã¯ïŒ3ã€ã®å¿ é æ¡ä»¶ã解説
Excelã§ããŒã ã¡ã³ããŒãšåããã¡ã€ã«ããªã¢ã«ã¿ã€ã ã§ç·šéã§ããã°ãæ¥åå¹çã¯å€§å¹ ã«åäžããŸãã
ããã¡ã€ã«ãéã£ãŠãç·šéããŠããŸãéãè¿ãããšããç ©éãªããåãããè§£æŸãããäŒè°äžã«ãã®å Žã§æ°å€ãæŽæ°ããããåšå® å€åã®ã¡ã³ããŒãšåæã«äœæ¥ãé²ãããããããšãå¯èœã«ãªããŸãã
Googleã¹ãã¬ããã·ãŒãã®ãããªãªã¢ã«ã¿ã€ã å ±åç·šéããExcelã§ãå®çŸã§ãããã§ãïŒ
ããããExcelã®åæç·šéæ©èœã¯ãã©ã®ç°å¢ã§ã䜿ãããããã§ã¯ãããŸããã
å®éã«åæç·šéãå§ããåã«ããèªèº«ã®ç°å¢ããã®æ©èœã«å¯Ÿå¿ããŠãããã©ããã確èªããããšãéèŠã§ãã
- Microsoft 365ã®ãµãã¹ã¯ãªãã·ã§ã³ããŸãã¯ç¡æã®Excel Onlineãå©çš
- ãã¡ã€ã«ãOneDriveã»SharePointã»Teamsã«ä¿åãããŠãã
- èªåä¿åæ©èœããªã³ã«ãªã£ãŠãã
ãããã®æ¡ä»¶ãæºãããªãå Žåãåæç·šéæ©èœã¯åäœããŸããã
ããšãã°ãè²·ãåãçã®Excel 2019ãExcel 2021ãããŒã«ã«ç°å¢ã§äœ¿çšããŠããå Žåã¯ããªã¢ã«ã¿ã€ã ã§ã®å ±åç·šéã¯ã§ããŸããã
ãŸãã瀟å ã®ãã¡ã€ã«ãµãŒããŒãNASã«ä¿åãããŠãããã¡ã€ã«ã§ããåæç·šéæ©èœã¯å©çšã§ããªãããæ³šæãå¿ èŠã§ãã
ãèšå®ããã®ã«åæç·šéã§ããªãâŠããšããæ¹ã¯ããŸããã®3æ¡ä»¶ããã§ãã¯ããŠã¿ãŠãã ããïŒ
以äžã§ã¯ãããã3ã€ã®å¿ é æ¡ä»¶ã«ã€ããŠè©³ãã解説ããŠãããŸãã
èªåã®ç°å¢ã§åæç·šéãå¯èœãã©ããã確èªããå¿ èŠãªæºåãæŽããŸãããã
æ¡ä»¶1: Microsoft 365ãŸãã¯Excel Onlineã®å©çš
Excelã®åæç·šéæ©èœãå©çšããããã®æãéèŠãªæ¡ä»¶ã¯ãMicrosoft 365ã®ãµãã¹ã¯ãªãã·ã§ã³ãå¥çŽããŠããããç¡æã®Excel Onlineã䜿çšããŠãããã®ããããã§ãã
Microsoft 365ã¯ãæé¡ãŸãã¯å¹Žé¡æéãæ¯æã£ãŠå©çšãããµãã¹ã¯ãªãã·ã§ã³åã®ãµãŒãã¹ã§ãã
| ãã©ã³çš®å¥ | ãã©ã³å |
|---|---|
| å人åã | Microsoft 365 Personal |
| å®¶æåã | Microsoft 365 Family |
| æ³äººåã | Business Basic / Standard / Premium |
| å€§äŒæ¥åã | Enterpriseåçš®ãã©ã³ |
ãããã®ãã©ã³ã§ã¯ããã¹ã¯ãããçã®Excelã¢ããªã±ãŒã·ã§ã³ã§ãªã¢ã«ã¿ã€ã åæç·šéæ©èœãå©çšããããšãã§ããŸãã
è²·ãåãçã䜿çšããŠããå Žåã§ãããã¡ã€ã«ãOneDriveã«ã¢ããããŒããããã©ãŠã¶äžã®Excel Onlineã§éãããšã§åæç·šéã¯å¯èœã§ãã
ãã ãããã¹ã¯ãããã¢ããªã§ã®åæç·šéäœéšã¯åŸãããŸããã
äºç®ãéãããŠããæ¹ã¯ãç¡æã®Excel Onlineããå§ããŠã¿ãã®ãããããã§ãïŒ
ð ç¡æã§äœ¿ããExcel Online
Microsoftã¢ã«ãŠã³ãããããã°èª°ã§ãå©çšå¯èœã§ãã
Webãã©ãŠã¶äžã§åäœããããããœãããŠã§ã¢ã®ã€ã³ã¹ããŒã«ã¯äžèŠã§ãOneDriveã«ä¿åããããã¡ã€ã«ãè€æ°äººã§åæã«ç·šéã§ããŸãã
ãã ããExcel Onlineã¯ãã¹ã¯ãããçãšæ¯èŒããŠæ©èœãå¶éãããŠããŸãã
ãã¯ãã®å®è¡ãããããããŒãã«ã®äžéšæ©èœãé«åºŠãªæžåŒèšå®ãªã©ã¯å©çšã§ããŸããã
ããã§ããåºæ¬çãªããŒã¿å ¥åãæ°åŒã®å©çšã衚ã®äœæãšãã£ãäžè¬çãªäœæ¥ã§ããã°åé¡ãªãè¡ããŸãã
Microsoftå ¬åŒãµããŒãã«ãããšãå ±åç·šéæ©èœã䜿çšããããã«ã¯ãMicrosoft 365ãµãã¹ã¯ãªãã·ã§ã³ããŸãã¯ç¡æã®OneDriveã¢ã«ãŠã³ããšExcel for the webãå¿ èŠãšãããŠããŸãã
ã€ãŸããäºç®ã®å¶çŽãããå Žåã§ããExcel OnlineãæŽ»çšããããšã§åæç·šéã®æ©æµãåããããšã¯å¯èœã§ãã
Excelã®åæç·šéæ©èœãå©çšããããã«ã¯ããã¡ã€ã«ãã¯ã©ãŠãã¹ãã¬ãŒãžã«ä¿åããå¿ èŠããããŸãã
å ·äœçã«ã¯ãOneDriveãSharePointããŸãã¯Teamsã®ããããã«ãã¡ã€ã«ãé 眮ããããšãå¿ é æ¡ä»¶ãšãªããŸãã
ããªãããŒã«ã«ã瀟å ãã¡ã€ã«ãµãŒããŒãNASã§ã¯ãã¡ãªã®ïŒããšããçåã«ãçãããŸãïŒ
ãã®çç±ã¯ãåæç·šéæ©èœã®ä»çµã¿ã«ãããŸãã
è€æ°ã®ãŠãŒã¶ãŒãåããã¡ã€ã«ããªã¢ã«ã¿ã€ã ã§ç·šéããããã«ã¯ãåãŠãŒã¶ãŒã®ç·šéå 容ãç¬æã«åæããç«¶åãèªåçã«è§£æ±ºããé«åºŠãªãµãŒããŒåŠçãå¿ èŠã§ãã
OneDriveãSharePointãTeamsã¯ãMicrosoftã®ã¯ã©ãŠãã€ã³ãã©ã¹ãã©ã¯ãã£äžã§åäœãããã®åæåŠçãæ ã£ãŠããŸãã
ããŒã«ã«ç°å¢ãNASã«ã¯ãã®ãããªåææ©èœãåãã£ãŠããªããããåæç·šéã¯æè¡çã«äžå¯èœãªã®ã§ãã
| ãµãŒãã¹å | ç¹åŸŽ | ããããã®çšé |
|---|---|---|
| OneDrive | å人çšã¯ã©ãŠãã¹ãã¬ãŒãžïŒ1TBïŒ | å人ã®ãã¡ã€ã«ç®¡çã»å°äººæ°ã§ã®å ±æ |
| SharePoint | çµç¹åãããã¥ã¡ã³ã管ç | éšéã»ãããžã§ã¯ãåäœã®ãã¡ã€ã«å ±æ |
| Teams | ã³ãã¥ãã±ãŒã·ã§ã³çµ±åå | äŒè°äžã®å ±åç·šéã»æ¥åžžçãªé£æºäœæ¥ |
OneDriveã¯å人çšã®ã¯ã©ãŠãã¹ãã¬ãŒãžã§ãå人ã®ãã¡ã€ã«ç®¡çãå°äººæ°ã§ã®å ±æã«é©ããŠããŸãã
Microsoft 365ã®å人åããã©ã³ã§ã¯1TBã®ã¹ãã¬ãŒãžå®¹éãæäŸãããæ³äººåããã©ã³ã§ãåæ§ã«ååãªå®¹éã確ä¿ãããŠããŸãã
SharePointã¯çµç¹åãã®ããã¥ã¡ã³ã管çãã©ãããã©ãŒã ã§ãããŒã ãµã€ããããã¥ã¡ã³ãã©ã€ãã©ãªãéããŠãã¡ã€ã«ãçµç¹çã«ç®¡çã§ããŸãã
ã¢ã¯ã»ã¹æš©éã®çްããèšå®ãããŒãžã§ã³å±¥æŽã®ç®¡çãã¯ãŒã¯ãããŒã®æ§ç¯ãªã©ãæ³äººå©çšã«é©ããæ©èœãè±å¯ã«çšæãããŠããŸãã
éšéããããžã§ã¯ãåäœã§ã®ãã¡ã€ã«å ±æã«ã¯ãSharePointã®å©çšãæšå¥šãããŸãã
Teamsã¯ããã£ããããããªäŒè°ãšãã¡ã€ã«å ±æãçµ±åããã³ãã¥ãã±ãŒã·ã§ã³ãã©ãããã©ãŒã ã§ãã
Teamsã«ã¢ããããŒãããããã¡ã€ã«ã¯ãå®éã«ã¯SharePointäžã«ä¿åãããŸãããTeamsäžããçŽæ¥ãã¡ã€ã«ã«ã¢ã¯ã»ã¹ããåæç·šéãéå§ã§ããŸãã
äŒè°äžã«åå è å šå¡ã§åãExcelãç·šéãããªããTeamsãšã®é£æºãæãå¹ççã§ããïŒ
ã»åäººäœæ¥ã»å°äººæ°ã®å ±æ â OneDrive
ã»éšéã»ãããžã§ã¯ãåäœã®ç®¡ç â SharePoint
ã»æ¥åžžçãªã³ãã¥ãã±ãŒã·ã§ã³é£æº â Teams
ãããã®å Žåãããã¡ã€ã«ããããã®ã¯ã©ãŠãã¹ãã¬ãŒãžã«ä¿åãããŠããããšããåæç·šéã®å€§åæãšãªããŸãã
æ¡ä»¶3: èªåä¿åæ©èœã®ãªã³èšå®
åæç·šéãæ£ããæ©èœãããããã®æåŸã®æ¡ä»¶ããèªåä¿åæ©èœããªã³ã«ããããšã§ãã
èªåä¿åã¯ããã¡ã€ã«ãžã®å€æŽãæ°ç§ããšã«èªåçã«ã¯ã©ãŠãã«åæããæ©èœã§ãããã«ãã£ãŠãªã¢ã«ã¿ã€ã ã§ã®å ±åç·šéãå®çŸããŸãã
ãèªåä¿åããªãã ãšã©ããªãã®ïŒããšããç¹ã詳ãã解説ããŸããïŒ
èªåä¿åããªãã®ç¶æ ã§è€æ°äººããã¡ã€ã«ãéããšãåãŠãŒã¶ãŒã®ç·šéå 容ã¯ããããã®ããŒã«ã«ç°å¢ã«ã®ã¿ä¿æãããŸãã
æåã§ä¿åãããŸã§ã¯ã©ãŠãã«ã¯åæ ãããŸããã
ãã®çµæãä»ã®ãŠãŒã¶ãŒã®ç·šéå 容ããªã¢ã«ã¿ã€ã ã§è¡šç€ºããããæåä¿åã®ã¿ã€ãã³ã°ã§ç«¶åãçºçããå¯èœæ§ããããŸãã
ð èªåä¿åããªã³ã«ããæ¹æ³
OneDriveãSharePointããŸãã¯Teamsã«ä¿åãããExcelãã¡ã€ã«ããã¹ã¯ãããçã®Excelã§éããšãç»é¢å·Šäžã«ãèªåä¿åãã®ãã°ã«ã¹ã€ããã衚瀺ãããŸãã
ãã®ã¹ã€ãããã¯ãªãã¯ããŠãªã³ã«ããã ãã§ãèªåä¿åãæå¹ã«ãªããŸãã
ãã¡ã€ã«ãã¯ã©ãŠãã«æ£ããä¿åãããŠããã°ããã®ã¹ã€ããã¯ããã©ã«ãã§ãªã³ã«ãªã£ãŠããããšãå€ãã§ãã
äœããã®çç±ã§ãªãã«ãªã£ãŠããå Žåã¯æåã§ãªã³ã«åãæ¿ããŠãã ããã
ãã®å Žåã¯ããŸããã¡ã€ã«ãOneDriveãSharePointã«ã¢ããããŒãããå¿ èŠããããŸãã
誀ã£ãŠåé€ããããŒã¿ãããŒãžã§ã³å±¥æŽãã埩å ã§ããã®ã§ãå®å¿ããŠäœæ¥ã§ããŸããïŒ
ã5åã§å®äºããšã¯ã»ã«ã®ãªã¢ã«ã¿ã€ã åæç·šéã®èšå®æé
Excelã®åæç·šéãå§ããããã®æºåã¯ãå®ã¯5åãããã°å®äºããŸãã
é£ããèšå®ã¯äžåäžèŠã§ãåºæ¬çãªæäœã ãã§ããŒã ã¡ã³ããŒãšãªã¢ã«ã¿ã€ã ã§ã®å ±åäœæ¥ãéå§ã§ããŸãã
ãèšå®ãé£ãããâŠããšæã£ãŠããæ¹ãå€ãã§ãããå®éã«ãã£ãŠã¿ããšãã£ãšããéã«çµãããŸããïŒ
ãã®ã»ã¯ã·ã§ã³ã§ã¯ãããŒã«ã«ã«ä¿åãããŠããExcelãã¡ã€ã«ãOneDriveã«ã¢ããããŒãããããŒã ã¡ã³ããŒã«å ±æãªã³ã¯ãéããåæç·šéãéå§ãããŸã§ã®äžé£ã®æµãããã¹ããããã€ã¹ãããã§è§£èª¬ããŸãã
ãŸããTeamsã䜿ã£ãŠããå Žåã®é£æºæ¹æ³ã«ã€ããŠã詳ãã説æããŸãã®ã§ãèªç€Ÿã®ç°å¢ã«åã£ãæ¹æ³ãéžæããŠãã ããã
ãŸãã¯æãã·ã³ãã«ãªæ¹æ³ããå§ããŠãæ £ããŠãããTeams飿ºãªã©ã®å¿çšçãªäœ¿ãæ¹ã«é²ãããšããå§ãããŸãã
æé 1: ãã¡ã€ã«ãOneDriveã«ã¢ããããŒã
åæç·šéãå§ããæåã®ã¹ãããã¯ãç·šéãããExcelãã¡ã€ã«ãOneDriveã«ã¢ããããŒãããããšã§ãã
ãã§ã«OneDriveãSharePointã«ä¿åãããŠãããã¡ã€ã«ã§ããã°ããã®æé ã¯ã¹ãããããŠæ¬¡ã«é²ãã§ãã ããã
ããŒã«ã«ä¿åã®ãã¡ã€ã«ãã¯ã©ãŠãã«ç§»ãã ãã§ãåæç·šéã®æºåãæŽããŸãïŒ
ããŒã«ã«ã«ä¿åãããŠãããã¡ã€ã«ãOneDriveã«ã¢ããããŒãããæ¹æ³ã¯è€æ°ãããŸãããããã§ã¯æãç°¡åãª2ã€ã®æ¹æ³ã玹ä»ããŸãã
ð æ¹æ³1ïŒExcelã¢ããªããçŽæ¥ã¢ããããŒã
ããŒã«ã«ã«ä¿åãããŠããExcelãã¡ã€ã«ãéããç»é¢äžéšã®ãã¡ã€ã«åã衚瀺ãããŠããéšåãã¯ãªãã¯ããŸãã
ãããšãä¿åå Žæã倿Žãããªãã·ã§ã³ã衚瀺ãããŸãã®ã§ããOneDriveããŸãã¯ãOneDrive – å人çšããéžæããŸãã
æ³äººåãã®Microsoft 365ãå©çšããŠããå Žåã¯ããOneDrive – [äŒç€Ÿå]ããšããéžæè¢ã衚瀺ãããŸãã
ä¿åå ã®ãã©ã«ããéžæãããä¿åããã¯ãªãã¯ããã°å®äºã§ãã
ãã¡ã€ã«ãOneDriveã«ç§»åãããç»é¢å·Šäžã®ãèªåä¿åããèªåçã«ãªã³ã«ãªããŸãã
ð æ¹æ³2ïŒãã¡ã€ã«ã¡ãã¥ãŒããæäœ
Excelã§ãã¡ã€ã«ãéããç¶æ ã§ãããã¡ã€ã«ãã¿ããã¯ãªãã¯ãããååãä»ããŠä¿åããéžæããŸãã
ä¿åå ãšããŠãOneDriveããéžã³ãå¿ èŠã«å¿ããŠãã©ã«ããäœæãŸãã¯éžæãããä¿åããã¯ãªãã¯ããŸãã
ãã®æ¹æ³ã§ã¯ãå ã®ããŒã«ã«ãã¡ã€ã«ã¯æ®ãããŸãŸãOneDriveäžã«ã³ããŒãäœæãããŸãã
å ãã¡ã€ã«ãæ®ããŠããããå Žåã¯ãæ¹æ³2ãããããã§ãïŒ
ãã©ãŠã¶ããOneDriveã«çŽæ¥ã¢ããããŒãããããšãå¯èœã§ãã
Webãã©ãŠã¶ã§onedrive.comïŒå人åãïŒãŸãã¯portal.office.comïŒæ³äººåãïŒã«ã¢ã¯ã»ã¹ããMicrosoftã¢ã«ãŠã³ãã§ãµã€ã³ã€ã³ããŸãã
ã¢ããããŒãããããã©ã«ãã«ç§»åãããã¢ããããŒãããã¿ã³ãã¯ãªãã¯ããŠãããŒã«ã«ã®Excelãã¡ã€ã«ãéžæããŸãã
ã¢ããããŒããå®äºãããããã¡ã€ã«ãã¯ãªãã¯ãããšExcel Onlineã§éãããšãã§ãããã®ãŸãŸåæç·šéãéå§ã§ããŸãã
ããã§ããã¡ã€ã«ãžã®å€æŽã¯èªåçã«ã¯ã©ãŠãã«åæãããåæç·šéã®æºåãæŽããŸããã
æé 2: å ±æãªã³ã¯ã®äœæãšæš©éèšå®
ãã¡ã€ã«ãOneDriveã«ã¢ããããŒãããããæ¬¡ã¯ããŒã ã¡ã³ããŒããã¡ã€ã«ã«ã¢ã¯ã»ã¹ã§ããããã«å ±æèšå®ãè¡ããŸãã
å ±ææ¹æ³ã«ã¯ãå ±æãªã³ã¯ãçºè¡ããæ¹æ³ãšãç¹å®ã®ãŠãŒã¶ãŒãçŽæ¥æåŸ ããæ¹æ³ããããŸãã
ããããã®ç¹åŸŽãšèšå®æé ã解説ããŸãã
ð å ±æãªã³ã¯ãçºè¡ããæ¹æ³
å€ãã®ã¡ã³ããŒã«çŽ æ©ãå ±æãããå Žåã«äŸ¿å©ã§ãã
Excelã§ãã¡ã€ã«ãéããç¶æ ã§ãç»é¢å³äžã«ãããå ±æããã¿ã³ãã¯ãªãã¯ããŸãã
å ±æãã€ã¢ãã°ã衚瀺ãããããããªã³ã¯ã®ã³ããŒããéžæããŸãã
ãã®æç¹ã§ãããã©ã«ãã§ã¯ããªã³ã¯ãç¥ã£ãŠãããŠãŒã¶ãŒãç·šéã§ããŸãããšããèšå®ã«ãªã£ãŠããããšãå€ãã§ãããçµç¹ã®èšå®ã«ãã£ãŠç°ãªãå ŽåããããŸãã
å ±æãã¿ã³ãã¯ãªãã¯ããã ãã§ãç°¡åã«ãªã³ã¯ãçºè¡ã§ããŸããïŒ
æš©éèšå®ã倿Žããã«ã¯ãããªã³ã¯ã®ã³ããŒãã®äžã«ããæ¯è»ã¢ã€ã³ã³ãŸãã¯ããªã³ã¯ã®èšå®ããã¯ãªãã¯ããŸãã
ããã§ããªã³ã¯ã䜿çšã§ãããŠãŒã¶ãŒã®ç¯å²ãéžæã§ããŸãã
ãŸãããç·šéãèš±å¯ãããã®ãã§ãã¯ããã¯ã¹ã§ãå ±æçžæã«ãã¡ã€ã«ã®ç·šéæš©éãäžãããã©ãããèšå®ã§ããŸãã
åæç·šéãè¡ãããå Žåã¯ããã®ãã§ãã¯ããã¯ã¹ãå¿ ããªã³ã«ããŠãã ããã
ãã§ãã¯ãå€ããšãçžæã¯ãã¡ã€ã«ã®é²èЧã®ã¿ãå¯èœãšãªããç·šéã¯ã§ããŸããã
ãç·šéãèš±å¯ãããã®ãã§ãã¯ãå¿ãããšãé²èЧå°çšã«ãªã£ãŠããŸãã®ã§æ³šæããŠãã ãããïŒ
Microsoft 365ã®æ³äººåããã©ã³ãå©çšããŠããå Žåã¯ã远å ã®ã»ãã¥ãªãã£ãªãã·ã§ã³ãå©çšã§ããŸãã
| ã»ãã¥ãªãã£ãªãã·ã§ã³ | æ©èœèª¬æ |
|---|---|
| æå¹æéã®èšå® | äžå®æéãéãããèªåçã«ãªã³ã¯ãç¡å¹å |
| ãã¹ã¯ãŒãèšå® | ãªã³ã¯ãç¥ã£ãŠããã ãã§ã¯ã¢ã¯ã»ã¹äžå¯ã« |
| ããŠã³ããŒãçŠæ¢ | ãã¡ã€ã«ã®äžæ£ãªã³ããŒã鲿¢ |
ð ç¹å®ã®ãŠãŒã¶ãŒãçŽæ¥æåŸ ããæ¹æ³
ããå®å šã§ç®¡çããããå ±ææ¹æ³ã§ãã
å ±æãã€ã¢ãã°ã§ãæåŸ ããããŠãŒã¶ãŒã®ã¡ãŒã«ã¢ãã¬ã¹ãå ¥åãããéä¿¡ããã¯ãªãã¯ããŸãã
å ¥åãããŠãŒã¶ãŒã«ã¯ããã¡ã€ã«ãžã®ã¢ã¯ã»ã¹æš©ãä»äžãããæšã®ã¡ãŒã«éç¥ãéãããŸãã
ãã®æ¹æ³ã§ã¯ã誰ããã¡ã€ã«ã«ã¢ã¯ã»ã¹ã§ããããæç¢ºã«ç®¡çã§ããå¿ èŠã«å¿ããŠã¢ã¯ã»ã¹æš©ãåå¥ã«åãæ¶ãããšãã§ããŸãã
æ©å¯æ§ã®é«ããã¡ã€ã«ã¯ãçŽæ¥æåŸ ããæ¹æ³ãããããã§ãïŒ
å ±æèšå®ãå®äºããããçºè¡ãããªã³ã¯ãã¡ãŒã«ããã£ããããŸãã¯ç€Ÿå ã®ã³ãã¥ãã±ãŒã·ã§ã³ããŒã«ã§å ±æçžæã«éä¿¡ããŠãã ããã
çžæããªã³ã¯ãã¯ãªãã¯ãããšãExcelãã¡ã€ã«ãéããåæç·šéãéå§ã§ããŸãã
æé 3: Teamsãšé£æºããåæç·šéã®éå§æ¹æ³
Microsoft Teamsãå©çšããŠããå Žåã¯ããã£ãã«ããã£ããããçŽæ¥ãã¡ã€ã«ã«ã¢ã¯ã»ã¹ããŠåæç·šéãè¡ãããšãã§ããŸãã
Teamsãšã®é£æºã«ãããã³ãã¥ãã±ãŒã·ã§ã³ãšãã¡ã€ã«ç·šéãã·ãŒã ã¬ã¹ã«è¡ãããããç¹ã«ãªã¢ãŒãã¯ãŒã¯ç°å¢ããããžã§ã¯ãããŒã ã§ã®äœæ¥ã«ãããŠå¹ççã§ãã
Teamsãæ®æ®µãã䜿ã£ãŠããæ¹ã¯ããã®æ¹æ³ãäžçªã¹ã ãŒãºã§ããïŒ
ð Teamsã®ãã£ãã«ã«ãã¡ã€ã«ãã¢ããããŒãããŠå ±æããæ¹æ³
ãŸããTeamsã¢ããªãéãããã¡ã€ã«ãå ±æãããããŒã ã®ãã£ãã«ã«ç§»åããŸãã
ãã£ãã«ç»é¢äžéšã®ããã¡ã€ã«ãã¿ããã¯ãªãã¯ãããã¢ããããŒãããã¿ã³ããããŒã«ã«ã®Excelãã¡ã€ã«ãã¢ããããŒãããŸãã
ãŸãã¯ããæ°èŠããã¿ã³ãã¯ãªãã¯ããŠæ°ããExcelãã¡ã€ã«ãçŽæ¥äœæããããšãå¯èœã§ãã
ã¢ããããŒããããã¡ã€ã«ã¯ãããŒã ã¡ã³ããŒå šå¡ãèªåçã«ã¢ã¯ã»ã¹ã§ããããã«ãªããŸãã
ãã£ãã«ã®ããã¡ã€ã«ãã¿ãã«è¡šç€ºãããŠãããã¡ã€ã«åãã¯ãªãã¯ãããšãTeamså ã§Excelãã¡ã€ã«ãéããŸãã
ããã©ã«ãã§ã¯Teamså èµã®Excelæ©èœã§éããŸãããããé«åºŠãªç·šéãå¿ èŠãªå Žåã¯ããã¡ã€ã«åã®æšªã«ããã…ãã¡ãã¥ãŒããããã¹ã¯ãããã¢ããªã§éãããéžæããŠãã ããã
è²ä»ãã®æ ç·ã§ã誰ãäœãç·šéããŠãããäžç®ã§ãããã®ã§å®å¿ã§ããïŒ
ð TeamsäŒè°äžã«ãã¡ã€ã«ãå ±æããŠåæç·šéããæ¹æ³
äŒè°äžã«ãå ±æããã¿ã³ãã¯ãªãã¯ãããOneDriveãåç §ããŸãã¯ãã³ã³ãã¥ãŒã¿ãŒãåç §ãããExcelãã¡ã€ã«ãéžæããŸãã
ãã®æããå ±åç·šéããªãã·ã§ã³ãéžæãããšãäŒè°åå è å šå¡ããã¡ã€ã«ãç·šéã§ããããã«ãªããŸãã
ãã¬ãŒã³ããŒã·ã§ã³äžã«åå è ããã®ãã£ãŒãããã¯ãçŽæ¥ãã¡ã€ã«ã«åæ ããããããã¬ã€ã³ã¹ããŒãã³ã°ã®çµæããªã¢ã«ã¿ã€ã ã§èšé²ãããããéã«æŽ»çšã§ããŸãã
ð ãã£ããã§ãã¡ã€ã«ãå ±æããæ¹æ³
ãã£ããç»é¢äžéšã®ã¯ãªããã¢ã€ã³ã³ïŒæ·»ä»ïŒãã¯ãªãã¯ãããOneDriveããã¢ããããŒãããŸãã¯ãã³ã³ãã¥ãŒã¿ãŒããã¢ããããŒãããéžæããŠãã¡ã€ã«ãæ·»ä»ããŸãã
ãã£ããã«æ·»ä»ããããã¡ã€ã«ããã¯ãªãã¯ããã ãã§åæç·šéãéå§ã§ããŸãã
1察1ã®ããåãã§ãããã£ãããããµã¯ããšå ±åç·šéã§ããŠäŸ¿å©ã§ãïŒ
Teamsã«ã¢ããããŒãããããã¡ã€ã«ã¯ãããã¯ãšã³ãã§ã¯SharePointã«ä¿åãããŠããŸãã
ãã®ãããSharePointã®ç®¡çç»é¢ããã¢ã¯ã»ã¹æš©éã®è©³çްãªèšå®ãããŒãžã§ã³å±¥æŽã®ç¢ºèªãè¡ãããšãã§ããŸãã
Teamsäžã§ã¯ç°¡åãªå ±æèšå®ã®ã¿ãå¯èœã§ããããã现ããå¶åŸ¡ãå¿ èŠãªå Žåã¯SharePointçµç±ã§ç®¡çããŠãã ããã
以äžã®æé ã§ãOneDriveãžã®ã¢ããããŒãããå ±æãªã³ã¯ã®çºè¡ãTeamsãšã®é£æºãŸã§ãExcelã®åæç·šéãå§ããããã®èšå®ã¯å®äºã§ãã
å®éã«è€æ°äººã§ãã¡ã€ã«ãéããŠããªã¢ã«ã¿ã€ã ã§åæ ãããç·šéãäœéšããŠã¿ãŠãã ããã
æåã¯æžæãããšããããããããŸããããæ £ããŠããŸãã°ãã¡ã€ã«ã®ããåãã«ããã£ãŠããæéãå€§å¹ ã«åæžã§ããããŒã å šäœã®çç£æ§åäžã«ã€ãªãããŸãã
ãŸãã¯è©ŠããŠã¿ãããšã倧åã§ããäžåºŠäœéšããã°ãããå ã®ããæ¹ã«ã¯æ»ããªããªããŸããïŒ
ãšã¯ã»ã«ã§åæç·šéãã§ããªãæã®åå ãšå¯ŸåŠæ³
ãèšå®ããã¯ããªã®ã«åæç·šéãã§ããªããããšã©ãŒã¡ãã»ãŒãžã衚瀺ãããŠå°ã£ãŠããããšããç¶æ³ã¯ãExcelã®åæç·šéã詊ã¿ãå€ãã®ãŠãŒã¶ãŒãçµéšããåé¡ã§ãã
åæç·šéãæ£ããåäœããªãåå ã¯è€æ°ããããšã©ãŒã®çš®é¡ã«ãã£ãŠå¯ŸåŠæ³ãç°ãªããŸãã
ãã®ã»ã¯ã·ã§ã³ã§ã¯ãåæç·šéã§ããçºçãããã©ãã«ãšãã®è§£æ±ºçããå ·äœçãªãšã©ãŒã¡ãã»ãŒãžå¥ã«è§£èª¬ããŸãã
åå ãæ£ããç¹å®ããé©åãªå¯ŸåŠãè¡ãããšã§ãã»ãšãã©ã®åé¡ã¯è§£æ±ºã§ããŸãã
ãŸãã¯åºæ¬çãªãã§ãã¯ãã€ã³ãã確èªããŠãããåå¥ã®ãã©ãã«ã·ã¥ãŒãã£ã³ã°ã«é²ã¿ãŸãããïŒ
ãŸããåæç·šéãããŸããããªãå Žåã®äžè¬çãªãã§ãã¯ãã€ã³ãã確èªããŸãããã
- ãã¡ã€ã«ãOneDriveãSharePointããŸãã¯Teamsã«ä¿åãããŠããã
- èªåä¿åããªã³ã«ãªã£ãŠããã
- Microsoft 365ã®ãµãã¹ã¯ãªãã·ã§ã³ãæå¹ã
- ã€ã³ã¿ãŒãããæ¥ç¶ãå®å®ããŠããã
ãããã®åºæ¬æ¡ä»¶ã確èªããäžã§ãããã§ãåé¡ã解決ããªãå Žåã¯ã以äžã®å ·äœçãªãã©ãã«ã·ã¥ãŒãã£ã³ã°ãåç §ããŠãã ããã
ãããã¯ãããã¯ãããŠããŸãããšã©ãŒã®è§£æ±ºç
ãããã¯ãããã¯ãããŠããŸãããŸãã¯ããã®ãã¡ã€ã«ã¯ç·šéã®ããã«ããã¯ãããŠããŸãããšãããšã©ãŒã¡ãã»ãŒãžã¯ãExcelã®åæç·šéã§æãé »ç¹ã«ééãããã©ãã«ã®äžã€ã§ãã
ãã®ãšã©ãŒã衚瀺ãããåå ã¯è€æ°ãããããããç°ãªã察åŠãå¿ èŠã§ãã
åæç·šéãæ£ããèšå®ãããŠããã°ãè€æ°ãŠãŒã¶ãŒãåæã«éããŠãããã¯ã¯ããããªãã¯ãã§ãããšã©ãŒãåºãå Žåã¯åææ¡ä»¶ãèŠçŽããŸãããïŒ
æãäžè¬çãªåå ã¯ãä»ã®ãŠãŒã¶ãŒããã§ã«ãã¡ã€ã«ãæä»çã«ç·šéäžã§ããå Žåã§ãã
ãã ããåæç·šéãæ£ããèšå®ãããŠããã°ãè€æ°ãŠãŒã¶ãŒãåæã«éããŠãããã¯ã¯ããããªãã¯ãã§ãã
ãã®ãšã©ãŒã衚瀺ãããå Žåã¯ãåæç·šéã®åææ¡ä»¶ãæºããããŠããªãå¯èœæ§ãé«ãã§ãã
ð åå 1ïŒãã¡ã€ã«ã®ä¿åå Žæãäžé©å
ãã¡ã€ã«ãããŒã«ã«ãã©ã€ãã瀟å ãã¡ã€ã«ãµãŒããŒã«ä¿åãããŠããå Žåãåæç·šéæ©èœã¯åäœãããåŸæ¥ã®æä»ããã¯ãé©çšãããŸãã
ãã®å Žåããã¡ã€ã«ãOneDriveãŸãã¯SharePointã«ç§»åããããšã§åé¡ã解決ããŸãã
ãã¡ã€ã«ã®ä¿åå Žæã確èªããã¯ã©ãŠãã¹ãã¬ãŒãžã«ç§»è¡ããŠãã ããã
ð åå 2ïŒã¬ã¬ã·ãŒãå ±æããã¯ãæ©èœãæå¹
ã¬ã¬ã·ãŒã®ãå ±æããã¯ãæ©èœãæå¹ã«ãªã£ãŠãããã¡ã€ã«ã§ããæ°ããåæç·šéæ©èœã¯åäœããŸããã
ãæ ¡é²ãã¿ãã«ãããã¯ã®å ±æããšããé ç®ãããå Žåã¯ããã®æ©èœãæå¹ã«ãªã£ãŠããå¯èœæ§ããããŸãã
ã¬ã¬ã·ãŒå ±æããã¯ããæ°ããåæç·šéæ©èœãžã®ç§»è¡ã«ã€ããŠã¯ãåŸã®ã»ã¯ã·ã§ã³ã§è©³ãã解説ããŸãã
ð åå 3ïŒäžæçãªããã¯ãã¡ã€ã«ãæ®ã£ãŠãã
ãã¡ã€ã«ã以åã®ã»ãã·ã§ã³ã§æ£ããéããããªãã£ãå Žåãäžæçãªããã¯ãã¡ã€ã«ãæ®ã£ãŠããããšããããŸãã
OneDriveãSharePointã®å Žåãéåžžã¯æ°åã§èªåçã«è§£é€ãããŸãã
ð åå 4ïŒExcelã®ããŒãžã§ã³ãå€ã
Excelã®ãã¹ã¯ãããã¢ããªãå€ãããŒãžã§ã³ã®å Žåããåæç·šéã«åé¡ãçºçããããšããããŸãã
Microsoft 365ã®Excelã䜿çšããŠããå Žåã¯ãããã¡ã€ã«ãã¡ãã¥ãŒãããã¢ã«ãŠã³ãããéžæãããæŽæ°ãªãã·ã§ã³ããããä»ããæŽæ°ããå®è¡ããŠãææ°ã®ç¶æ ã«ä¿ã£ãŠãã ããã
ð åå 5ïŒãã¡ã€ã«åã«ç¹æ®æåãå«ãŸããŠãã
ãã¡ã€ã«åã«ç¹æ®æåãå«ãŸããŠããå Žåãããã¯ã®åå ãšãªãããšããããŸãã
ãããã®æåããã¡ã€ã«åã«å«ãŸããŠããå Žåã¯åé€ããŠãããOneDriveã«åã¢ããããŒãããŠãã ããã
ãã¡ã€ã«åã¯ã·ã³ãã«ã«ïŒæ¥æ¬èªãè±æ°åããã€ãã³ãã¢ã³ããŒã¹ã³ã¢çšåºŠã«ããŠãããšå®å¿ã§ãã
ç·šéå å®¹ãæ¶ããã»åæ ãããªãåé¡ã®å¯ŸåŠæ³
åæç·šéäžã«å ¥åããããŒã¿ãæ¶ããŠããŸãããŸãã¯ä»ã®ãŠãŒã¶ãŒã®ç·šéå 容ãåæ ãããªããšããåé¡ã¯ãäœæ¥å¹çã倧ããæãªãã ãã§ãªããéèŠãªããŒã¿ã®æå€±ã«ãã€ãªãããããŸããã
ãã®åé¡ã®åå ãšå¯ŸåŠæ³ã«ã€ããŠè©³ãã解説ããŸãã
ãã£ããå ¥åããããŒã¿ãæ¶ããŠããŸãã®ã¯æ¬åœã«å°ããŸããããåå ãææ¡ããŠãäºåã«å¯ŸçããŠãããŸãããïŒ
ð åå 1ïŒèªåä¿åããªãã«ãªã£ãŠãã
ç·šéå å®¹ãæ¶ããæãäžè¬çãªåå ã¯ãèªåä¿åããªãã«ãªã£ãŠããããšã§ãã
èªåä¿åããªãã®ç¶æ ã§è€æ°äººãåããã¡ã€ã«ãç·šéãããšãããããã®å€æŽããªã¢ã«ã¿ã€ã ã§åæãããŸããã
åãŠãŒã¶ãŒãåå¥ã«ãä¿åããå®è¡ããã¿ã€ãã³ã°ã§ãå ã«ä¿åãããå 容ãåŸããä¿åãããå 容ã§äžæžããããŠããŸãå¯èœæ§ããããŸãã
ð åå 2ïŒã€ã³ã¿ãŒãããæ¥ç¶ãäžå®å®
ã€ã³ã¿ãŒãããæ¥ç¶ãäžå®å®ãªå Žåããç·šéå 容ã®åæã«åé¡ãçºçããŸãã
Excelã¯æ¥ç¶ãåããŠããéããªãã©ã€ã³ã§ç·šéãç¶ããããšãã§ããŸãããæ¥ç¶ã埩æ§ããéã«åæã®ç«¶åãçºçããããšããããŸãã
æ¥ç¶ãäžå®å®ãªç°å¢ã§äœæ¥ããå Žåã¯ãé »ç¹ã«æ¥ç¶ç¶æ³ã確èªããéèŠãªç·šéãè¡ãåã«ã¯æ¥ç¶ãå®å®ããŠããããšã確èªããŠãã ããã
ð åå 3ïŒåãã»ã«ãåæã«ç·šéããŠãã
åæç·šéäžã«è€æ°ã®ãŠãŒã¶ãŒãåãã»ã«ãåæã«ç·šéããããšãããšãç«¶åãçºçããŸãã
Excelã¯éåžžãåŸããä¿åããã倿Žãåªå ããŸãããå Žåã«ãã£ãŠã¯ãç«¶åã®è§£æ±ºããã€ã¢ãã°ã衚瀺ãããããšããããŸãã
ãã®å Žåã¯ãã©ã¡ãã®å€æŽãæ¡çšããããéžæããå¿ èŠããããŸãã
ç«¶åãé¿ããã«ã¯ãããŒã ã¡ã³ããŒéã§ç·šéããç¯å²ãäºåã«åæ ããŠããã®ãããããã§ãïŒ
ã»ãŸãExcelãåèµ·åããŠãã¡ã€ã«ãéãçŽã
ã»OneDriveãŸãã¯SharePointã®Webã€ã³ã¿ãŒãã§ãŒã¹ãããã¡ã€ã«ãéã
ã»ããŒãžã§ã³å±¥æŽã確èªããŠå¿ èŠã«å¿ããŠåŸ©å ãã
ããŒãžã§ã³å±¥æŽã«ã¯éå»ã®ä¿åç¶æ ãèšé²ãããŠãããå¿ èŠã«å¿ããŠä»¥åã®ããŒãžã§ã³ã«åŸ©å ããããšãã§ããŸãã
ð ããŒãžã§ã³å±¥æŽã®ç¢ºèªæ¹æ³ïŒOneDrive WebçïŒ
OneDriveã®Webçã§ããŒãžã§ã³å±¥æŽã確èªããã«ã¯ããã¡ã€ã«ãå³ã¯ãªãã¯ããŠãããŒãžã§ã³å±¥æŽããéžæããŸãã
衚瀺ãããããŒãžã§ã³äžèЧããã埩å ãããããŒãžã§ã³ãéžã³ãã埩å ããã¯ãªãã¯ããŸãã
ãã®æ©èœã«ããã誀ã£ãŠåé€ãããããŒã¿ãäžæžããããå 容ãåãæ»ãããšãã§ããŸãã
ããŒãžã§ã³å±¥æŽã¯äžãäžã®ä¿éºãšããŠèŠããŠãããšå®å¿ã§ããïŒ
ããŒã«ã«ç°å¢ã»NASã§åæç·šéã§ããªãçç±ãšä»£æ¿æ¡
瀟å ã®ãã¡ã€ã«ãµãŒããŒãNASïŒNetwork Attached StorageïŒã«Excelãã¡ã€ã«ãä¿åããŠåæç·šéããããšããŠãããªã¢ã«ã¿ã€ã ã§ã®å ±åç·šéæ©èœã¯åäœããŸããã
ããã¯æè¡çãªå¶çŽã«ãããã®ã§ãããèšå®å€æŽã§è§£æ±ºã§ããåé¡ã§ã¯ãããŸããã
ããªãããŒã«ã«ã§ã¯ãã¡ãªã®ïŒããšããçåãæã€æ¹ã¯å€ãã§ããæè¡çãªèæ¯ãçè§£ããŠãããšã察çãç«ãŠããããªããŸããïŒ
ð ãªãããŒã«ã«ç°å¢ãNASã§ã¯åæç·šéãã§ããªãã®ã
Excelã®ãªã¢ã«ã¿ã€ã åæç·šéæ©èœã¯ãMicrosoftã®ã¯ã©ãŠãã€ã³ãã©ã¹ãã©ã¯ãã£ã«äŸåããŠããŸãã
è€æ°ã®ãŠãŒã¶ãŒãåæã«ãã¡ã€ã«ãç·šéããéãåãŠãŒã¶ãŒã®å€æŽãç¬æã«æ€ç¥ããç«¶åãèªåçã«è§£æ±ºããå šå¡ã®ç»é¢ã«ãªã¢ã«ã¿ã€ã ã§åæ ãããšããé«åºŠãªåŠçãå¿ èŠã§ãã
ãã®åŠçã¯ãOneDriveãSharePointãTeamsã®ããã¯ãšã³ããµãŒããŒã§å®è¡ãããŠãããäžè¬çãªãã¡ã€ã«ãµãŒããŒãNASã«ã¯ãã®ãããªæ©èœãåãã£ãŠããŸããã
ãã®åé¡ã解決ããããã®çŸå®çãªä»£æ¿æ¡ãããã€ã玹ä»ããŸãã
- Microsoft 365ã®æ³äººåããã©ã³ã§å©çšå¯èœ
- æ¢åãã¡ã€ã«ãµãŒããŒããæ®µéçã«ç§»è¡ã§ãã
- é·æçã«ã¯æ¥åå¹çã®å€§å¹ ãªåäžãæåŸ ã§ãã
ç§»è¡ã«ããã£ãŠã¯ãã¢ã¯ã»ã¹æš©éã®åèšå®ããã©ã«ãæ§é ã®èŠçŽãããŠãŒã¶ãŒãžã®æè²ãªã©ãå¿ èŠã«ãªããŸãããåæç·šéæ©èœã掻çšã§ããããã«ãªããŸãã
- ã¯ã©ãŠãäžã®ãã¡ã€ã«ãããŒã«ã«ãã©ã€ãã«åæããã
- ãšã¯ã¹ãããŒã©ãŒããçŽæ¥ã¢ã¯ã»ã¹å¯èœ
- åŸæ¥ã®ãã¡ã€ã«ãµãŒããŒãšåãæèŠã§æäœã§ãã
ãŠãŒã¶ãŒã¯åŸæ¥ã®ãã¡ã€ã«ãµãŒããŒãšåããããªæèŠã§ãã¡ã€ã«ãæäœã§ããŸãããããã¯ãšã³ãã§ã¯OneDriveã®ã¯ã©ãŠãã¹ãã¬ãŒãžãå©çšããŠãããããåæç·šéæ©èœãå©çšå¯èœã§ãã
OneDriveåæã¢ããªã䜿ãã°ãèŠãç®ã¯ããŒã«ã«ãã©ã«ããšåããªã®ã§ã瀟å¡ã®æ¹ãéåæãªãç§»è¡ã§ããŸããïŒ
ã©ãããŠãããŒã«ã«ç°å¢ã§ãã¡ã€ã«ã管çããå¿ èŠãããå Žåã¯ãåæç·šéã¯è«ŠããŠéçšã«ãŒã«ã§å¯Ÿå¿ãããšããéžæããããŸãã
ãã ããããã¯ãªã¢ã«ã¿ã€ã åæç·šéã®ä»£æ¿ã«ã¯ãªããããããŸã§æ«å®çãªå¯Ÿå¿çã§ãã
é·æçã«ã¯ã¯ã©ãŠãã¹ãã¬ãŒãžãžã®ç§»è¡ãæ€èšããããšãããããããŸãïŒ
ð ã¯ã©ãŠãç§»è¡ã®ã¡ãªãã
åæã®ç§»è¡ã³ã¹ããåŠç¿ã³ã¹ãã¯ããããŸãããåæç·šéã ãã§ãªããã©ãããã§ããã¡ã€ã«ã«ã¢ã¯ã»ã¹ã§ããæè»æ§ãèªåããã¯ã¢ããã«ããããŒã¿ä¿è·ãããŒãžã§ã³å±¥æŽã«ãã倿Žç®¡çãªã©ãå€ãã®ã¡ãªããã享åã§ããŸãã
| ä»£æ¿æ¡ | ç¹åŸŽ | ãããã床 |
|---|---|---|
| OneDrive/SharePointç§»è¡ | åæç·šéãã«å¯Ÿå¿ãé·æçã«æé© | â â â â â |
| OneDriveåæã¢ã㪠| åŸæ¥ã®æäœæãç¶æãã€ã€ç§»è¡ | â â â â â |
| éçšã«ãŒã«ã§å¯Ÿå¿ | æ«å®å¯Ÿå¿ãåæç·šéã¯äžå¯ | â â âââ |
ãšã¯ã»ã«ã®åæç·šéã®ãã¡ãªãããšå¶éäºé
Excelã®åæç·šéæ©èœã¯æ¥åå¹çãå€§å¹ ã«åäžããã䟿å©ãªæ©èœã§ãããäžèœã§ã¯ãããŸããã
å°å ¥åã«ãã¡ãªãããå¶éäºé ãæ£ããçè§£ããŠããããšã§ããæã£ãŠããã®ãšéã£ãããšããäºæ ãé¿ããèªç€Ÿã®éçšã«é©ããäœ¿ãæ¹ãæ€èšã§ããŸãã
ãèšå®ããã®ã«åããªãâŠããšãããã©ãã«ã®å€ãã¯ãå¶éäºé ãç¥ããªãã£ãããšãåå ã§ã
ãã®ã»ã¯ã·ã§ã³ã§ã¯ãåæç·šéæ©èœã䜿ãéã«ç¥ã£ãŠããã¹ãå¶éäºé ãšãããããã®å¶éã«å¯ŸããçŸå®çãªå¯ŸåŠæ³ã解説ããŸãã
ç¹ã«ããã¯ããVBAãæ¥åã§æŽ»çšããŠããäŒæ¥ã«ãšã£ãŠã¯éèŠãªæ å ±ãšãªããŸãã®ã§ãå°å ¥å€æã®åèã«ããŠãã ããã
ãã¯ãã»VBAã䜿ããªãåé¡ãšä»£æ¿æ¡
Excelã®åæç·šéæ©èœãå©çšããéã®æå€§ã®å¶éäºé ã®äžã€ãããã¯ãããã³VBAïŒVisual Basic for ApplicationsïŒã®å®è¡å¶éã§ãã
æ¥åžžæ¥åã§ãã¯ããå€çšããŠããäŒæ¥ã«ãšã£ãŠããã®å¶éã¯åæç·šéæ©èœã®å°å ¥ãèºèºããã倧ããªèŠå ãšãªã£ãŠããŸãã
çµçãå¶æ¥éšéãªã©ãå®åäœæ¥ããã¯ãã§èªååããŠããå Žåã¯ç¹ã«æ³šæãå¿ èŠã§ãã
åæç·šéäžã«ãã¯ãã䜿ããªãçç±ã¯ãæè¡çãªè€éãã«ãããŸãã
ãã¯ããVBAã¯ãã¯ãŒã¯ããã¯å šäœã«å¯ŸããŠåŠçãå®è¡ãããããè€æ°ã®ãŠãŒã¶ãŒãåæã«ãã¯ããå®è¡ãããšãäºæããªãçµæãããŒã¿ã®ç ŽæãåŒãèµ·ããå¯èœæ§ããããŸãã
ããšãã°ããããŠãŒã¶ãŒããã¯ãã§ã»ã«ã®å€ã倿ŽããŠããæäžã«ãå¥ã®ãŠãŒã¶ãŒãåãã»ã«ã«å¯ŸããŠãã¯ããå®è¡ããå Žåãã©ã¡ãã®å€æŽãåªå ãã¹ãã倿ã§ããŸããã
ãã®ãããªç«¶åãé¿ãããããMicrosoftã¯åæç·šéäžã®ãã¯ãå®è¡ãå¶éããŠããŸãã
ãã®å¶éã«å¯Ÿããå¯ŸåŠæ³ãããã€ã玹ä»ããŸãã
ð å¯ŸåŠæ³â ïŒãã¯ãã®å®è¡ã¿ã€ãã³ã°ã工倫ãã
åæç·šéäžã«ãã¯ããå®è¡ããã®ã§ã¯ãªããããŒã¿å ¥åäœæ¥ãå®äºããåŸã«ãäžäººã®ãŠãŒã¶ãŒããã¡ã€ã«ãéããŠãã¯ããå®è¡ãããšããéçšã«å€æŽããŸãã
ããšãã°ãææ¬¡ã¬ããŒããè€æ°äººã§åæã«å ¥åããå ¥åå®äºåŸã«æ åœè ããã¯ãã§éèšåŠçãå®è¡ãããšããæµãã§ãã
ð å¯ŸåŠæ³â¡ïŒPower Automateãžã®ç§»è¡
Power AutomateïŒæ§Microsoft FlowïŒã¯ãMicrosoft 365ã«å«ãŸããèªååããŒã«ã§ãExcelã®ããŒã¿åŠçãèªååãããããŒãäœæã§ããŸãã
ãã¯ãã§è¡ã£ãŠããå®ååŠçãPower Automateã®ãããŒã«çœ®ãæããããšã§ãåæç·šéãšã®å ±åãå¯èœã«ãªããŸãã
Power Automateã¯ã¯ã©ãŠãäžã§å®è¡ãããããããŠãŒã¶ãŒã®Excelæäœãšã¯ç¬ç«ããŠåäœããç«¶åã®åé¡ãçºçããŸããã
Power Automateã¯åŠç¿ã³ã¹ãã¯ããããŸãããäžåºŠèŠããã°Excel以å€ã®æ¥åèªååã«ã掻çšã§ããŸã
ð å¯ŸåŠæ³â¢ïŒOffice ScriptsãæŽ»çšãã
Office Scriptsã¯ãExcel for the webããã³Windowsãã¹ã¯ãããçExcelã§å©çšã§ããã¹ã¯ãªããæ©èœã§ãTypeScriptãããŒã¹ãšããæ°ããèªååã®ä»çµã¿ã§ãã
åŸæ¥ã®VBAãšã¯ç°ãªããã¯ã©ãŠãç°å¢ã§ã®å®è¡ãåæã«èšèšãããŠãããPower Automateãšã®é£æºãå¯èœã§ãã
ãã ããOffice Scriptsã¯çŸæç¹ã§ã¯VBAã»ã©é«åºŠãªåŠçã«ã¯å¯Ÿå¿ããŠããªããããè€éãªãã¯ãã®å®å šãªç§»è¡ã¯é£ããå ŽåããããŸãã
ð å¯ŸåŠæ³â£ïŒãã¡ã€ã«ãåé¢ãã
ãã¯ãæ©èœãæ¥åäžäžå¯æ¬ ã§ãäžèšã®ä»£æ¿æ¡ã§ã¯å¯Ÿå¿ã§ããªãå Žåã¯ãåæç·šéãå¿ èŠãªãã¡ã€ã«ãšãã¯ããå¿ èŠãªãã¡ã€ã«ãåé¢ãããšããæ¹æ³ãæ€èšããŠãã ããã
ããŒã¿å ¥åçšã®ãã¡ã€ã«ã¯åæç·šéå¯èœãªåœ¢åŒã§äœæãããã¯ãåŠçãå¿ èŠãªéèšãã¡ã€ã«ã¯å¥é管çããŸãã
ããŒã¿å ¥åãã¡ã€ã«ãããã¯ããã¡ã€ã«ãžã®ããŒã¿åã蟌ã¿ã¯ãPower QueryãPower Automateã䜿ã£ãŠèªååã§ããŸãã
倧容éãã¡ã€ã«ã»è€éãªæ°åŒã§ã®åäœãžã®åœ±é¿
åæç·šéæ©èœãå©çšããéããã¡ã€ã«ãµã€ãºã倧ããå Žåãè€éãªæ°åŒãå€çšããŠããå Žåã¯ãããã©ãŒãã³ã¹ã®äœäžã«æ³šæãå¿ èŠã§ãã
åæç·šéã§ã¯ãåãŠãŒã¶ãŒã®å€æŽããªã¢ã«ã¿ã€ã ã§ã¯ã©ãŠãã«åæããä»ã®ãŠãŒã¶ãŒã®ç»é¢ã«åæ ãããåŠçãåžžã«è¡ãããŠããããããã¡ã€ã«ãéãã»ã©åæã«ãããæéãé·ããªããŸãã
ããªããåäœãéãâŠããšæãããããã¡ã€ã«ãµã€ãºã確èªããŠã¿ãŠãã ãã
åæã®é å»¶ã倧ãããªããšãåãã»ã«ãåæã«ç·šéããŠããŸãç«¶åã®ãªã¹ã¯ãé«ãŸããŸãã
ç¹ã«ãããã¯ãŒã¯ç°å¢ãäžå®å®ãªå Žåã¯ããã®åé¡ãé¡èã«ãªããŸãã
倧容éãã¡ã€ã«ãžã®å¯ŸçãšããŠã以äžã®æ¹æ³ãæ€èšããŠãã ããã
ð 察çâ ïŒãã¡ã€ã«ã®åå²
äžã€ã®å·šå€§ãªãã¡ã€ã«ã§å šãŠã管çããã®ã§ã¯ãªããçšéãéšéããšã«ãã¡ã€ã«ãåå²ããããšã§ãåãã¡ã€ã«ã®ãµã€ãºãæããããŸãã
è€æ°ã®ãã¡ã€ã«ã«åæ£ããããŒã¿ã¯ãPower QueryãVLOOKUP颿°ã䜿ã£ãŠå¿ èŠã«å¿ããŠçµ±åã§ããŸãã
ð 察çâ¡ïŒäžèŠãªããŒã¿ã®åé€
éå»ã®ããŒã¿ã§åç §ããå¿ èŠããªããã®ã¯ãå¥ãã¡ã€ã«ã«ã¢ãŒã«ã€ããããåé€ããŠãã ããã
ãŸããæžåŒèšå®ãéå°ã«é©çšãããŠããã»ã«ãã空çœã®ã»ã«ã«æžåŒã ããèšå®ãããŠããããŽãŒã¹ãã»ã«ããããã¡ã€ã«ãµã€ãºãå¢å ãããåå ãšãªããŸãã
ãããŒã ãã¿ãã®ãæžåŒã®ã¯ãªã¢ãæ©èœã§äžèŠãªæžåŒãåé€ããããšã§ããã¡ã€ã«ãµã€ãºãåæžã§ããŸãã
æå€ãšèŠèœãšããã¡ãªã®ãããŽãŒã¹ãã»ã«ãã䜿ã£ãŠããªãç¯å²ã«ãæžåŒãæ®ã£ãŠããããšããããŸã
ð 察çâ¢ïŒæ°åŒã®æé©å
VLOOKUP颿°ãå€çšããŠããå Žåã¯ãããå¹ççãªXLOOKUP颿°ãINDEX/MATCH颿°ãžã®çœ®ãæããæ€èšããŠãã ããã
ãŸããæ®çºæ§é¢æ°ïŒNOWãTODAYãINDIRECTãOFFSETãªã©ïŒã¯ããã¡ã€ã«ãéããã³ã«åèšç®ããããããããã©ãŒãã³ã¹ãžã®åœ±é¿ã倧ãããªããŸãã
å¯èœã§ããã°ããããã®é¢æ°ã®äœ¿çšãæå°éã«æããããå€ãšããŠè²Œãä»ããããšãæ€èšããŠãã ããã
ð 察çâ£ïŒç»åããªããžã§ã¯ãã®æé©å
é«è§£å床ã®ç»åããã®ãŸãŸæ¿å ¥ãããšããã¡ã€ã«ãµã€ãºãæ¥æ¿ã«å¢å ããŸãã
ç»åãæ¿å ¥ããåã«ãé©åãªãµã€ãºã«å§çž®ããããšããå§ãããŸãã
Excelã®ãå³ã®å§çž®ãæ©èœã䜿ãã°ãæ¿å ¥æžã¿ã®ç»åãäžæ¬ã§å§çž®ããããšãå¯èœã§ãã
| 察ç | 广 | é£æåºŠ |
|---|---|---|
| ãã¡ã€ã«ã®åå² | å€§å¹ ãªãµã€ãºåæžãå¯èœ | äž |
| äžèŠããŒã¿ã®åé€ | å³å¹æ§ãé«ã | äœ |
| æ°åŒã®æé©å | åäœéåºŠã®æ¹å | äžãé« |
| ç»åã®å§çž® | ç»åãå€ãå Žåã«å¹æå€§ | äœ |
OneDrive以å€ã§ã®åæç·šéæ¹æ³ãšä»£æ¿ææ®µ
Excelã®åæç·šéæ©èœã¯ãOneDriveãSharePointãTeamsã«ä¿åããããã¡ã€ã«ã§ã®ã¿å©çšå¯èœã§ãã
ããããããŸããŸãªçç±ãããããã®ãµãŒãã¹ãå©çšã§ããªãããŸãã¯å©çšããããªãå Žåãããã§ãããã
ããã§ã¯ãOneDrive以å€ã®éžæè¢ãšãããããã®ã¡ãªããã»ãã¡ãªããã«ã€ããŠè§£èª¬ããŸãã
ããã¡ã®äŒç€Ÿã¯Dropboxã䜿ã£ãŠãããã ãã©âŠããšããæ¹ãå€ãã®ã§ã¯ãªãã§ãããã
ð Googleã¹ãã¬ããã·ãŒããšã®æ¯èŒ
Googleã¹ãã¬ããã·ãŒãã¯ãGoogleãæäŸããã¯ã©ãŠãããŒã¹ã®è¡šèšç®ã¢ããªã±ãŒã·ã§ã³ã§ãæåãããªã¢ã«ã¿ã€ã åæç·šéãåæãšããŠèšèšãããŠããŸãã
Googleã¢ã«ãŠã³ããããã°ç¡æã§å©çšã§ãããã©ãŠã¶äžã§åäœãããããœãããŠã§ã¢ã®ã€ã³ã¹ããŒã«ãäžèŠã§ãã
åæç·šéã®å®å®æ§ã䜿ããããã§ã¯ãGoogleã¹ãã¬ããã·ãŒããåªããŠãããšããè©äŸ¡ããããŸãã
æ¥åã§è€éãªåŠçãè¡ã£ãŠããå Žåã¯ãGoogleã¹ãã¬ããã·ãŒããžã®ç§»è¡ãé£ããããšããããŸãã
ãŸããæ¢åã®Excelãã¡ã€ã«ãGoogleã¹ãã¬ããã·ãŒãã«å€æãããšãæžåŒãæ°åŒãæ£ããåçŸãããªãå ŽåããããŸãã
äž¡è ã䜵çšããå Žåã¯ãäºææ§ã®åé¡ã«æ³šæãå¿ èŠã§ãã
ð Dropboxã®å Žå
Dropboxãå©çšããŠããå ŽåãDropboxãšMicrosoft Officeã®é£æºæ©èœã䜿ã£ãŠãDropboxã«ä¿åãããExcelãã¡ã€ã«ãç·šéããããšã¯å¯èœã§ãã
ãããããã®å Žåã®åæç·šéã¯ãOneDriveãSharePointãšåãã¬ãã«ã®ãªã¢ã«ã¿ã€ã åæã§ã¯ãããŸããã
Dropboxã«ã¯ç¬èªã®ç«¶åãã¡ã€ã«åŠçæ©èœããããŸãããExcelã®åæç·šéæ©èœãšã¯ä»çµã¿ãç°ãªããããè€æ°äººãåæã«ç·šéãããšç«¶åã³ããŒãäœæãããããšããããŸãã
æ¬æ Œçãªåæç·šéãå¿ èŠãªå Žåã¯ãOneDriveãŸãã¯SharePointãžã®ç§»è¡ãæšå¥šããŸãã
ð Boxã®å Žå
BoxïŒã¯ã©ãŠãã¹ãã¬ãŒãžãµãŒãã¹ïŒããMicrosoft Officeãšã®é£æºæ©èœãæäŸããŠããŸãã
Boxäžã®Excelãã¡ã€ã«ããªã³ã©ã€ã³ã§ç·šéããããšã¯å¯èœã§ãããDropboxãšåæ§ã«ãExcelã®ãã€ãã£ããªåæç·šéæ©èœãšã¯ç°ãªãåäœãšãªããŸãã
Boxãå©çšããŠããäŒæ¥ã§æ¬æ Œçãªåæç·šéãå®çŸãããå Žåã¯ãBoxãšSharePointã®äœµçšããOneDriveãžã®æ®µéçãªç§»è¡ãæ€èšããŠãã ããã
DropboxãBoxã§ãç·šéã¯ã§ããŸãããããªã¢ã«ã¿ã€ã åæç·šéããšãªããšå¶éããããã§ãã
ð ãªã³ãã¬ãã¹ç°å¢ã§ã®éžæè¢ïŒSharePoint Server
ã¯ã©ãŠãã¹ãã¬ãŒãžãå©çšã§ããªãç°å¢ã§ã®ä»£æ¿ææ®µãšããŠãSharePoint Serverã®ãªã³ãã¬ãã¹çããããŸãã
SharePoint Serverã瀟å ã«æ§ç¯ããããšã§ãã¯ã©ãŠããä»ããã«åæç·šéæ©èœãå©çšã§ããŸãã
ãã ããSharePoint Serverã®å°å ¥ã«ã¯å°éçãªç¥èãšçžå¿ã®ã³ã¹ããå¿ èŠã§ãããäžå°äŒæ¥ã«ãšã£ãŠã¯ããŒãã«ãé«ãéžæè¢ã§ãã
ãŸãããªã³ãã¬ãã¹çã¯ã¯ã©ãŠãçãšæ¯èŒããŠæ©èœã®ã¢ããããŒããé ãããããææ°æ©èœãå©çšã§ããªãå ŽåããããŸãã
| ãµãŒãã¹ | åæç·šé | ç¹åŸŽ |
|---|---|---|
| OneDrive/SharePoint | â å®å šå¯Ÿå¿ | Excelæ¬æ¥ã®åæç·šéæ©èœããã«æŽ»çšå¯èœ |
| Googleã¹ãã¬ããã·ãŒã | â å®å šå¯Ÿå¿ | ç¡æã§å®å®ããåæç·šéããã ãExcelãšã®äºææ§ã«æ³šæ |
| Dropbox | â³ å¶éãã | ç«¶åã³ããŒãäœæãããå¯èœæ§ãã |
| Box | â³ å¶éãã | Dropboxãšåæ§ã®å¶é |
| SharePoint Server | â å¯Ÿå¿ | ãªã³ãã¬ãã¹ç°å¢åããå°å ¥ã³ã¹ãé« |
ã©ã®éžæè¢ãå®ç§ã§ã¯ãªããããããã«ãã¬ãŒããªãããããŸãã
èªç€Ÿã®èŠä»¶ãäºç®ãã»ãã¥ãªãã£ããªã·ãŒãæ¢åã®ã·ã¹ãã ç°å¢ãªã©ãç·åçã«èæ ®ããŠãæé©ãªæ¹æ³ãéžæããŠãã ããã
ã»Microsoft補åãšã®çµ±åéèŠ â OneDriveãŸãã¯SharePointãžã®ç§»è¡ãæã確å®
ã»ã³ã¹ããæããŠæè»œã«å§ããã â Googleã¹ãã¬ããã·ãŒããæåãªåè£
ã»ã¯ã©ãŠãå©çšäžå¯ã®ç°å¢ â SharePoint Serverãæ€èš
å°æ¥çãªæ¡åŒµæ§ãèæ ®ããŠãé·æçãªèŠç¹ã§éžæããããšãããããããŸã
ã¬ã¬ã·ãŒå ±æããã¯ããæ°ãããªã¢ã«ã¿ã€ã å ±åç·šéãžã®ç§»è¡
Excelã«ã¯ä»¥åãããããã¯ã®å ±æããšããæ©èœãååšããŠãããè€æ°ã®ãŠãŒã¶ãŒãåæã«ãã¡ã€ã«ãç·šéã§ããä»çµã¿ãæäŸãããŠããŸããã
ãããããã®åŸæ¥ã®å ±æããã¯æ©èœïŒã¬ã¬ã·ãŒå ±æããã¯ïŒãšãçŸåšæšå¥šãããŠããæ°ããå ±åç·šéæ©èœã¯ãæè¡çãªä»çµã¿ã䜿ãåæã倧ããç°ãªããŸãã
ãããã¯ã®å ±æããã¿ã³ãèŠåœãããªãâŠãšããæ¹ãå€ãã®ã§ã¯ãªãã§ããããïŒããã¯ä»æ§å€æŽã«ãããã®ãªãã§ãïŒ
ã¬ã¬ã·ãŒå ±æããã¯æ©èœã¯ãããŒã«ã«ãããã¯ãŒã¯äžã®ãã¡ã€ã«ãµãŒããŒã§è€æ°ãŠãŒã¶ãŒãåæã«äœæ¥ããããšãæ³å®ããŠèšèšãããå€ãæ©èœã§ãã
äžæ¹ãæ°ããå ±åç·šéæ©èœã¯ãã¯ã©ãŠãã¹ãã¬ãŒãžã掻çšãããªã¢ã«ã¿ã€ã åæãåæãšããŠãããããé«åºŠãªç«¶å解決ã倿Žå±¥æŽã®ç®¡çãå¯èœã§ãã
ãã®ã»ã¯ã·ã§ã³ã§ã¯ãã¬ã¬ã·ãŒå ±æããã¯ããæ°ããå ±åç·šéæ©èœãžã®ç§»è¡æ¹æ³ãšãäž¡è ã®éãã«ã€ããŠè©³ãã解説ããŸãã
æ¢åã®éçšã倿Žããéã®åèã«ããŠãã ããã
ã¬ã¬ã·ãŒå ±æããã¯æ©èœã衚瀺ãããªãçç±
Excel 365ãExcel 2019以éã®ããŒãžã§ã³ã䜿çšããŠããå Žåããæ ¡é²ãã¿ããèŠãŠããããã¯ã®å ±æããã¿ã³ãèŠåœãããªãããšããããŸãã
ããã¯ãMicrosoftãã¬ã¬ã·ãŒå ±æããã¯æ©èœãããã©ã«ãã§é衚瀺ã«ããŠããããã§ãã
ãæ©èœãæ¶ããïŒããšçŠãæ¹ãå€ãã§ããã廿¢ã§ã¯ãªã”é衚瀺”ã«ãªã£ãŠããã ããªãã§ãã
Microsoftããã®æ©èœãé衚瀺ã«ããçç±ã¯ãæ°ããå ±åç·šéæ©èœãžã®ç§»è¡ãä¿é²ããããã§ãã
æ°ããå ±åç·šéæ©èœã¯ããããã®å¶çŽãè§£æ¶ããããå¿«é©ãªå ±åäœæ¥äœéšãæäŸããŸãã
ãã®ãããMicrosoftã¯æ°èŠãŠãŒã¶ãŒã«ã¯ã¬ã¬ã·ãŒæ©èœã§ã¯ãªãæ°æ©èœã䜿ã£ãŠããããããšèããŠãããããã©ã«ãã§ã¯é衚瀺ãšããŠããŸãã
ã¬ã¬ã·ãŒå ±æããã¯æ©èœããªãã³ã«è¿œå ããæé ã説æããŸãã
Excelãéãããªãã³äžã®ä»»æã®å Žæãå³ã¯ãªãã¯ããŠããªãã³ã®ãŠãŒã¶ãŒèšå®ããéžæããŸãã
ãŸãã¯ãããã¡ã€ã«ãã¡ãã¥ãŒããããªãã·ã§ã³ããéžã³ãããªãã³ã®ãŠãŒã¶ãŒèšå®ããéžæããŠãåãç»é¢ã«ã¢ã¯ã»ã¹ã§ããŸãã
å·ŠåŽã®ãã³ãã³ãã®éžæãããããããŠã³ããããªãã³ã«ãªãã³ãã³ãããéžæããŸãã
衚瀺ãããã³ãã³ãäžèЧãããããã¯ã®å ±æïŒã¬ã¬ã·ïŒããæ¢ããŸãã
ã³ãã³ãã¯ã¢ã«ãã¡ãããé ãŸãã¯äºåé³é ã«äžŠãã§ãããããã¹ã¯ããŒã«ããŠæ¢ãããå é ã®æåãå ¥åããŠçµã蟌ãã§ãã ããã
å³åŽã®ãªãã³ã¿ãäžèЧã§ããã¿ã³ã远å ãããã¿ããéžæããŸãã
éåžžã¯ãæ ¡é²ãã¿ããé©åã§ãã
ã¿ããå±éãããã¿ã³ã远å ãããã°ã«ãŒããéžæãããããæ°ããã°ã«ãŒãããã¿ã³ãã¯ãªãã¯ããŠæ°ããã°ã«ãŒããäœæããŸãã
ã°ã«ãŒããéžæããç¶æ ã§ãå·ŠåŽã®ãããã¯ã®å ±æïŒã¬ã¬ã·ïŒããéžã³ãäžå€®ã®ã远å ããã¿ã³ãã¯ãªãã¯ããŸãã
æåŸã«ãOKããã¯ãªãã¯ããŠèšå®ãä¿åããŸãã
ããã§ãæ ¡é²ã¿ãã«ãããã¯ã®å ±æïŒã¬ã¬ã·ïŒããã¿ã³ã远å ãããã¬ã¬ã·ãŒå ±æããã¯æ©èœã䜿çšã§ããããã«ãªããŸãã
ãã¿ã³ã®è¿œå èªäœã¯ç°¡åã§ããããã®æ©èœã¯éæšå¥šã§ããå¯èœã§ããã°æ°ããå ±åç·šéæ©èœãžã®ç§»è¡ãæ€èšããŸãããïŒ
æ°ããå ±åç·šéæ©èœãšä»¥åã®å ±æããã¯æ©èœã®éã
ã¬ã¬ã·ãŒå ±æããã¯æ©èœãšæ°ããå ±åç·šéæ©èœã¯ãååã¯äŒŒãŠããŸãããæè¡çãªä»çµã¿ãšæäŸãããæ©èœã倧ããç°ãªããŸãã
äž¡è ã®éããæ£ããçè§£ããããšã§ãç§»è¡ã®å¿ èŠæ§ãšã¡ãªããã倿ã§ããŸãã
ãååã䌌ãŠããããåãã§ããïŒããšæããã¡ã§ãããå®ã¯äžèº«ã¯å šãå¥ç©ãªãã§ãïŒ
ð ãªã¢ã«ã¿ã€ã åæã«é¢ããéã
ãªã¢ã«ã¿ã€ã åæã«é¢ããéãã¯æãéèŠãªãã€ã³ãã§ãã
ã¬ã¬ã·ãŒå ±æããã¯æ©èœã§ã¯ãåãŠãŒã¶ãŒã®å€æŽã¯æåã§ä¿åãããŸã§ä»ã®ãŠãŒã¶ãŒã«åæ ãããŸããã
ä¿åã®ã¿ã€ãã³ã°ã§å€æŽãçµ±åãããç«¶åãããã°æåã§è§£æ±ºããå¿ èŠããããŸããã
äžæ¹ãæ°ããå ±åç·šéæ©èœã§ã¯ã倿Žãæ°ç§ä»¥å ã«èªåçã«ã¯ã©ãŠãã«åæãããä»ã®ãŠãŒã¶ãŒã®ç»é¢ã«ãªã¢ã«ã¿ã€ã ã§åæ ãããŸãã
誰ãã©ã®ã»ã«ãç·šéããŠããããèŠèŠçã«ç¢ºèªã§ããçã®æå³ã§ã®ãåæç·šéããå®çŸããŸãã
ð 倿Žå±¥æŽã®ç®¡çæ¹æ³ã®éã
ã¬ã¬ã·ãŒå ±æããã¯æ©èœã«ã倿Žå±¥æŽæ©èœã¯ãããŸããããå±¥æŽã®ä¿ææéã«å¶éããããäžå®æéãéãããšå€ãå±¥æŽã¯èªåçã«åé€ãããŠããŸããã
æ°ããå ±åç·šéæ©èœã§ã¯ãOneDriveãSharePointã®ããŒãžã§ã³å±¥æŽæ©èœãšé£æºããŠãããããé·æéã«ããã£ãŠå€æŽå±¥æŽãä¿æã§ããŸãã
ãŸããä»»æã®æç¹ã®ããŒãžã§ã³ã«åŸ©å ããããšã容æã§ãã
ð å©çšã§ããæ©èœã®ç¯å²ã®éã
ã¬ã¬ã·ãŒå ±æããã¯æ©èœãæå¹ã«ãªã£ãŠãããã¡ã€ã«ã§ã¯ãããŒãã«æ©èœãæ¡ä»¶ä»ãæžåŒã®äžéšãããããããŒãã«ã®äœæãã·ãŒãã®ä¿è·ãã»ã«ã®çµåãªã©ãå€ãã®æ©èœãå¶éãããŠããŸããã
ããã¯ãè€æ°ãŠãŒã¶ãŒã®åæç·šéãšç«¶åããå¯èœæ§ãããæ©èœãç¡å¹åããŠããããã§ãã
æ°ããå ±åç·šéæ©èœã§ã¯ããããã®æ©èœã®å€ããå©çšå¯èœã§ãããããèªç±åºŠã®é«ãäœæ¥ãã§ããŸãã
ãã ããåè¿°ã®éããã¯ããVBAã®å®è¡ã«ã¯äŸç¶ãšããŠå¶éããããŸãã
ããããããŒãã«ãããŒãã«æ©èœã䜿ããããã«ãªãã®ã¯ãå®åäžããªã倧ããªã¡ãªããã§ããïŒ
ð ç«¶å解決ã®ä»çµã¿ã®éã
ã¬ã¬ã·ãŒå ±æããã¯æ©èœã§ã¯ãåãã»ã«ãè€æ°ãŠãŒã¶ãŒãç·šéããå ŽåãåŸããä¿åãããŠãŒã¶ãŒã«å¯ŸããŠç«¶å解決ãã€ã¢ãã°ã衚瀺ãããã©ã¡ãã®å€æŽãæ¡çšãããæåã§éžæããå¿ èŠããããŸããã
æ°ããå ±åç·šéæ©èœã§ã¯ãåãã»ã«ã®åæç·šéãæ€ç¥ããŠèŠåã衚瀺ããç«¶åãæªç¶ã«é²ãä»çµã¿ãå°å ¥ãããŠããŸãã
ãŸããç«¶åãçºçããå ŽåããããæŽç·Žãããæ¹æ³ã§è§£æ±ºãããŸãã
ð å¿ èŠãªç°å¢ã®éã
ã¬ã¬ã·ãŒå ±æããã¯æ©èœã¯ãããŒã«ã«ãããã¯ãŒã¯äžã®ãã¡ã€ã«ãµãŒããŒã§ãåäœããã¯ã©ãŠããµãŒãã¹ãžã®æ¥ç¶ã¯å¿ èŠãããŸããã§ããã
ãã®ãããã€ã³ã¿ãŒãããæ¥ç¶ããªãç°å¢ãã»ãã¥ãªãã£äžã®çç±ã§ã¯ã©ãŠãã䜿çšã§ããªãç°å¢ã§ãå©çšå¯èœã§ããã
æ°ããå ±åç·šéæ©èœã¯ãOneDriveãSharePointããŸãã¯Teamsãžã®ãã¡ã€ã«ä¿åãå¿ é ã§ãããã€ã³ã¿ãŒãããæ¥ç¶ãå¿ èŠã§ãã
| æ¯èŒé ç® | ã¬ã¬ã·ãŒå ±æãã㯠| æ°ããå ±åç·šé |
|---|---|---|
| ãªã¢ã«ã¿ã€ã åæ | æåä¿åæã®ã¿åæ | æ°ç§ä»¥å ã«èªååæ |
| 倿Žå±¥æŽ | ä¿ææéã«å¶éãã | é·æéä¿æå¯èœ |
| å©çšå¯èœæ©èœ | å€ãã®æ©èœãå¶é | ã»ãšãã©ã®æ©èœãå©çšå¯èœ |
| ç«¶å解決 | æåã§éžæ | èªåæ€ç¥ã»èŠå |
| å¿ èŠç°å¢ | ããŒã«ã«ãããã¯ãŒã¯ã§ãå¯ | ã¯ã©ãŠãæ¥ç¶å¿ é |
å ±æè§£é€ã»ã¬ã¬ã·ãŒæ©èœããç§»è¡ããæé
çŸåšã¬ã¬ã·ãŒå ±æããã¯æ©èœã䜿çšããŠãããã¡ã€ã«ããæ°ããå ±åç·šéæ©èœã«ç§»è¡ããããã«ã¯ããŸãã¬ã¬ã·ãŒå ±æãè§£é€ãããã®åŸãã¡ã€ã«ãOneDriveãŸãã¯SharePointã«ã¢ããããŒãããå¿ èŠããããŸãã
ããã§ã¯ãç§»è¡ã®å ·äœçãªæé ãšæ³šæç¹ã解説ããŸãã
ç§»è¡äœæ¥ãå§ããåã«ãããã€ãã®æºåãšç¢ºèªãè¡ããŸãããã
ãŸããçŸåšãã¡ã€ã«ãç·šéäžã®ãŠãŒã¶ãŒãããªãããšã確èªããŠãã ããã
ç§»è¡äœæ¥äžã«ä»ã®ãŠãŒã¶ãŒãç·šéãè¡ããšã倿Žã倱ãããå¯èœæ§ããããŸãã
å šå¡ããã¡ã€ã«ãéããããšã確èªããŠããäœæ¥ãéå§ããŠãã ããã
äœæ¥åã«ããŒã ã¡ã³ããŒãžãããããç§»è¡äœæ¥ãããã®ã§ãã¡ã€ã«ãéããŠãã ããããšé£çµ¡ããŠãããšå®å¿ã§ãïŒ
次ã«ããã¡ã€ã«ã®ããã¯ã¢ãããäœæããŸãã
äžãäžç§»è¡äœæ¥ã§åé¡ãçºçããå Žåã«åããŠãå ã®ãã¡ã€ã«ã®ã³ããŒãå¥ã®å Žæã«ä¿åããŠãããŸãããã
ã¬ã¬ã·ãŒå ±æããã¯æ©èœãè§£é€ããæé ã説æããŸãã
ã¬ã¬ã·ãŒå ±æãæå¹ã«ãªã£ãŠããExcelãã¡ã€ã«ãéããŸãã
ãã®ãšããä»ã®ãŠãŒã¶ãŒãåæã«éããŠããªãããšãå床確èªããŠãã ããã
ãæ ¡é²ãã¿ãã«ç§»åãããããã¯ã®å ±æããã¿ã³ãã¯ãªãã¯ããŸãã
ãã®ãã¿ã³ã衚瀺ãããŠããªãå Žåã¯ãåã®ã»ã¯ã·ã§ã³ã§èª¬æããæé ã§ãªãã³ã«è¿œå ããŠãã ããã
ãããã¯ã®å ±æããã€ã¢ãã°ããã¯ã¹ã衚瀺ããããããç·šéãã¿ãã§ãè€æ°ã®ãŠãŒã¶ãŒã«ããåæç·šéãšãããã¯ã®çµåãèš±å¯ãããã®ãã§ãã¯ããã¯ã¹ããªãã«ããŸãã
ãOKããã¯ãªãã¯ãããšãå ±æãè§£é€ãããŸãã
ãã®æç¹ã§ã倿Žå±¥æŽãåé€ãããæšã®èŠåã衚瀺ãããå ŽåããããŸãã
ç¶è¡ããŠãããã°ãã¯ãããã¯ãªãã¯ããŠãã ããã
å ±æãè§£é€ããããããã¡ã€ã«ãä¿åããŸãã
ãã®æç¹ã§ããã¡ã€ã«ã¯éåžžã®Excelããã¯ã«æ»ããã¬ã¬ã·ãŒå ±æããã¯ç¹æã®å¶éãè§£é€ãããŸãã
ãããŸã§ã§ãã¬ã¬ã·ãŒå ±æã®è§£é€ããå®äºã§ããç¶ããŠã¯ã©ãŠããžã®ã¢ããããŒããè¡ããŸãããïŒ
ç¶ããŠããã¡ã€ã«ãOneDriveãŸãã¯SharePointã«ã¢ããããŒãããŸãã
ããã¡ã€ã«ãã¡ãã¥ãŒãããååãä»ããŠä¿åããéžæããä¿åå ãšããŠãOneDriveããŸãã¯ãSharePointããéžã³ãŸãã
é©åãªãã©ã«ããéžæãããä¿åããã¯ãªãã¯ããŸãã
ã¢ããããŒããå®äºãããšãç»é¢å·Šäžã«ãèªåä¿åããã°ã«ã衚瀺ãããŸãã
ããããªã³ã«ãªã£ãŠããããšã確èªããŠãã ããã
æåŸã«ãããŒã ã¡ã³ããŒã«æ°ãããã¡ã€ã«ã®å Žæãå ±æããŸãã
ãå ±æããã¿ã³ãã¯ãªãã¯ããŠå ±æãªã³ã¯ãçºè¡ããããSharePointãTeamsã®ãã¡ã€ã«ã©ã€ãã©ãªã«é 眮ããŠãã¡ã³ããŒãã¢ã¯ã»ã¹ã§ããããã«ããŠãã ããã
ç§»è¡æã®æ³šæç¹ãšããŠãã¬ã¬ã·ãŒå ±æããã¯ã§èšå®ãããŠãã倿Žå±¥æŽã®è¿œè·¡èšå®ã¯ãå ±æè§£é€æã«ãªã»ãããããŸãã
æ°ããå ±åç·šéæ©èœã§ã¯ãOneDriveãSharePointã®ããŒãžã§ã³å±¥æŽæ©èœã倿Žå±¥æŽã®åœ¹å²ãæãããããç§»è¡åŸã¯å¿ èŠã«å¿ããŠããŒãžã§ã³å±¥æŽã®èšå®ã確èªããŠãã ããã
ãŸããã¬ã¬ã·ãŒå ±æããã¯ã§äœ¿çšããŠãããŠãŒã¶ãŒå¥ã®ã¢ã¯ã»ã¹æš©éã¯ãæ°ããç°å¢ã§ã¯åèšå®ãå¿ èŠã§ãã
OneDriveãSharePointã®å ±æèšå®ã§ãé©åãªã¢ã¯ã»ã¹æš©éãèšå®ããŠãã ããã
ç§»è¡ãå®äºããããããŒã ã¡ã³ããŒãšäžç·ã«æ°ããç°å¢ã§ã®åäœç¢ºèªãè¡ããŸããããå šå¡ãã¢ã¯ã»ã¹ã§ããããåæç·šéãæ£ããåäœãããããã§ãã¯ããŠããæ¬æ Œéçšãéå§ããã®ãããããã§ãïŒ
æ ªåŒäŒç€Ÿã¹ãŒãã代衚åç· åœ¹ç€Ÿé·CEO
2013幎3æã«ãæ°åã§å
¥ç€ŸãããœãŒã·ã£ã«ã»ãšã³ããžãŒã»ãããžã§ã¯ãæ ªåŒäŒç€ŸïŒçŸç€ŸåïŒäŒè±ã·ã£ããã³ãªãŸãŒãæ ªåŒäŒç€Ÿãæ±èšŒã¹ã¿ã³ããŒãäžå ŽäŒæ¥ïŒã®ä»£è¡šåç· åœ¹ç€Ÿé·ã«å°±ä»»ãå瀟ã°ã«ãŒãã7幎ã¶ãã®é»ååã«å°ãã2014幎12æã«æ ªåŒäŒç€Ÿã¹ãŒãèšç«ãšåæã«ä»£è¡šåç· åœ¹ã«å°±ä»»ã2016幎4æããç·åçå°åååµé ã¢ããã€ã¶ãŒåã³å
é£å®æ¿å°å掻æ§åäŒéåž«ã2019幎6æããåœå亀éçPPPãµããŒã¿ãŒã2020幎10æã«YouTuberäºåæã®æ ªåŒäŒç€ŸVAZã®ä»£è¡šåç· åœ¹ç€Ÿé·ã«å°±ä»»ãææ¬¡é»ååãå®çŸãã2022幎1æã«äžå ŽäŒæ¥ã®åäŒç€Ÿåãå®çŸã2022幎12æã«ã¹ãŒãç€Ÿãæ°èšåå²ãå瀟ãåå·å€æŽãæ°ãã«æ ªåŒäŒç€Ÿã¹ãŒãèšç«ãšåæã«ä»£è¡šåç· åœ¹ç€Ÿé·CEOã«å°±ä»»ã
çŸåšãã¹ãŒã瀟ã§ã¯ãããŒã ã®ã¿ã¹ã¯ç®¡çããŒã«ãã¹ãŒãã¢ãããã®éçºã»éå¶ãè¡ããäžå°äŒæ¥ããå€§äŒæ¥ã®ããŒã ãŸã§ãæ¥æ¬ç€ŸäŒå
šäœã®åŽåçç£æ§ã®åäžãç®æããŠããã
ããŒã ã®ã¿ã¹ã¯ç®¡ç / ãããžã§ã¯ã管çã§ãã®ãããªãæ©ã¿ã¯ãããŸãããïŒ

ãããªããŸããããç§ã以åã¯ããã§ãããã¿ã¹ã¯ç®¡çããŒã«ãå°å ¥ããŠãé¢åã§äœ¿ã£ãŠãããªãããçµå±æå³ãªããªãã

ãããã©ããããããã®ãïŒããã§çãŸããã®ãã¹ãŒãã¢ããã§ãã

ããããšã¯ã»ã«ç®¡çã¿ããã§ããïŒãããªãã§ããææ £ããæäœã§ããŒã ã®ã¿ã¹ã¯ç®¡çãã§ãããã§ãïŒ

èŠãç®ããšã¯ã»ã«ã ãããšãã£ãŠäŸ®ããªããããšã¯ã»ã«ã¿ããã«å ¥åããã ãã§ããããªããšã

ãããªããšã

ãããªããšãŸã§ã§ãã¡ãããã§ãã

ãšã¯ã»ã«æèŠã§ã¿ããªã§ã¿ã¹ã¯ç®¡çã
ãŸãã¯ä»¥äžããã詊ãããã ããã©ãã ãç°¡åãäœéšããŠã¿ãŠãã ããã