ã ä»äºã®ã¬ã·ãåã»ä»çµã¿å ãïŒ7/23ïŒ åçã®è²Œãä»ããåç»æ®åœ±ããªã³ã©ã€ã³ãµãŒãã¹ãããŸã æãåºããªïŒ ãã§ãã¯ã·ãŒãã®ãã©ãŒã 解説ãšãããªããäžçªäœ¿ãæ £ããŠããããŒã«ã䜿ãã¹ãçç±
âŒãESTRELAãèª 2015幎11æïŒNo.260ïŒå· ãéãæéã皌ãã ããä»çµã¿åãå®è·µã³ã©ã 第ïŒå
ååãŸã§ã§ãã§ãã¯ã·ãŒãäœãã®åºç€ããäŒãããŸããã®ã§ããã§ãã¯ã·ãŒãã«ã€ããŠã¯ä»åã§ãã£ããç· ãããããŸãã
æåŸã¯ãç§ãå®éã«äœ¿ã£ãŠããExcelã®ãã§ãã¯ã·ãŒããããŒã¹ã«ãããã§ãã¯ã·ãŒãã«ã¯äœãæžã蟌ãã®ããã«ã€ããŠãäŒãããŠãããŸãã
ä»åã¯ç§ã®Excelãã©ãŒã ãã玹ä»ããŸãããããŒã«èªäœã¯Excelã§ãWordã§ãææžãã§ãè¯ãã§ãããã
ããªããæã䜿ãæ £ããŠããããŒã«ã䜿ã£ãŠãã ããã
ç§ãExcelãããããããçç±ã¯ãè¡ããšåãåã£ããã貌ãä»ããããç°¡åã«ã§ããããã§ãã
äœæ¥ã®é çªã®å ¥ãæ¿ããåé€ãè¿œå ãã¹ã ãŒãºã«ã§ããã®ã倧ããªã¡ãªããã§ãã
ä»åã¯ãç§ãå®éã«äœ¿ã£ãŠããExcelã®ãã§ãã¯ã·ãŒãã®åãããšã«è©±ãé²ããŸãã
ãã®ãã§ãã¯ã·ãŒãã¯ãç§ããããŸã§æ°çŸã®ãã§ãã¯ã·ãŒããäœã£ãŠããŠãã©ãçãããç§ãªãã«ãã£ãšã䜿ãããããšèããŠãã圢ã§ãã
ïŒ ãã§ãã¯ã·ãŒãã®äœäŸ ïŒ
â ãã§ãã¯ã·ãŒãã®åå
âãã®ãã§ãã¯ã·ãŒãã§è¡ãäœæ¥ã®æŠèŠããç°¡æœã«äžæã§æžããŸãã
ãããèŠãã°ãä»ããèªåãè¡ãäœæ¥ãã²ãšç®ã§åãããŸãã
â¡ ãã®ãã§ãã¯ã·ãŒããäœã£ã人ã®åå
âç§ã®ã¬ã·ãåã»ä»çµã¿åã«å¯Ÿããã¹ã¿ã³ã¹ã¯ããä»çµã¿ã䜿ã£ãŠçãŸãããã¹ã¯ãäœæ¥è ãæªãã®ã§ã¯ãªããä»çµã¿ãäœã£ã人ãæªãããšãããã®ã§ãã
ãã§ãã¯ã·ãŒãã䜿ã£ãŠãã¹ããã£ãå Žåããã®ãã§ãã¯ã·ãŒããäœã£ã人ã«çŽããŠãããå¿ èŠããããŸãã
ããã«ä¿®æ£ããå ŽæãäŒããŠçŽããŠãããããã«ããã§ãã¯ã·ãŒããäœã£ã人ã®ååãèšé²ããŠãããŸãã
⢠ãã®ãã§ãã¯ã·ãŒãã䜿ã£ãæ¥
âäœæ¥ã®èšé²ãæ®ãä»äºã®å Žåãäœæ¥ãããæ¥ä»ãæžããŠãããããšã§äœæ¥å ±åæžä»£ããã«ããŠããŸããã
⣠ãã®ãã§ãã¯ã·ãŒãã䜿ã£ã人ã®åå
â誰ããã®ãã§ãã¯ã·ãŒãã䜿ã£ãŠäœæ¥ãããã®ããèšé²ãããŠããã£ãŠããŸããã
äœæ¥è ã«ããã®ãã§ãã¯ã·ãŒãã®æ¹åç¹ãªã©ãèããšãã«ãæå¹ã§ããã
†ãã®ãã§ãã¯ã·ãŒãã§è¡ãäœæ¥ã®æŠèŠããŽãŒã«
ããã«ã¯ã
âã»ä»ããããä»äº
ã»ãã®ãã§ãã¯ã·ãŒãã§çµéšã§ããäº
ã»ç®æããŽãŒã«
ãªã©ãç°¡æœã«æžããŠãããŸãã
åœåããã®æ¬ã¯ãããŸããã§ããã
ãããåŸèŒ©ãéšäžããããææã¯åºãããèªåãä»äœãããŠããã®ãåãããªãããšããæèŠããããããšããã£ãã®ã§ãã
ä»ããèªåãããä»äºã俯ç°ã§ããããããã®æ¬ãè¿œå ããŸããã
⥠äºåã«æºåããŠãããã®ã®ã¡ã¢
âå人çã«ãšãŠãå«ãªã®ããäœæ¥ã®éäžã§éå ·ã足ããªããŠäœæ¥ãäžæãããããããšã§ããã
äœæ¥ãããåã«ããã®äœæ¥ã§äœ¿ãéå ·ãªã©ããã¹ãŠæå ã«æºåããŠããããã£ãã®ã§ããã®æ¬ã«å¿ èŠãªéå ·ãæžãåºãããã«ããŸããã
⊠äœæ¥ã®åºåã
âãã§ãã¯ã·ãŒããäœããšãã€ãäœããŒãžã«ããªã£ãŠããŸããã¡ã§ãã
è¡ååãæèããŠæžãåºããšãäºæ³ä»¥äžã«é·ããªãããšããããããŸãã
äœæ¥ãå¡ããšã«åããŠèŠãããããããã«ãè¡ã®è²ãå€ããããã«ããŸããã
ãïŒïŒå šè§ãã€ãã³ïŒããå ¥åãããšããã®è¡ã®å šãŠãç°è²ã«ãªãããã«èšå®ããŠããŸãã
⧠äœæ¥ã®ã倧ãŸããªæŠèŠã
âã詳现ãæžããåäœæ¥ãããã倧ãŸããªæŠèŠãã«åããŸãã
ããšãã°ã次ã®ãããªæé€ã®ãã§ãã¯ã·ãŒãããããšããŸãã
ãïŒïŒïŒãžã§ãŠãã«æ°Žãæ±²ããéã¯ããžã§ãŠãã®ååãŸã§ã
ãïŒïŒïŒå¿æ¥å®€ã®èŠ³èæ€ç©ã«ãæ°Žãããã
ãïŒïŒïŒå¿æ¥å®€ã®ããŒãã«ããéå·Ÿã§æãã
ãïŒïŒïŒçé¢ã®å€ã§ãçé¢ã®ãããããïŒåã¯ããã
ãïŒïŒïŒã»ãããšã¡ããšããæã£ãŠãããçé¢ã®å€ãã»ããã§ã¯ãã
ããããã
ãã»ïŒïŒïŒïœïŒïŒïŒãâãå¿æ¥å®€ã®æé€
ãã»ïŒïŒïŒïœïŒïŒïŒãâãçé¢ã®æé€
ãšãã£ãããã«ãã倧ãŸããªæŠèŠãã«åããŠã°ã«ãŒãåããŸãã
ããããã倧ãŸããªæŠèŠãã®åã«æžããŠããã®ã§ãã
ãããã®ãã§ãã¯ã·ãŒããèŠãªãã§ãã®äœæ¥ãã§ããããã«ãªã£ã人ã§ããæã«ãä»äºã®å€§ããªæµããå¿ãããããããšããããŸãã
ãããªå Žåã§ããããããäœæ¥ã®è©³çŽ°ã¯èŠãã«ããã®äœæ¥ã®ã倧ãŸããªæŠèŠããæžããŠããåã ããèŠãŠããã°ãä»äºã®æµããæãåºãããšãã§ããŸãã
âš äœæ¥ã®ã詳现ã
âããã¯ãå®éã«è¡ãäœæ¥ã®è©³çŽ°ãæžããŠãããŸãã
ãããŸã§ãäŒãããå 容ãæãåºããŠã誰ã§ãè¡åã§ããã¬ãã«ãç®æããŠèšé²ãããŠãããŸãããã
â© ãã§ãã¯ããã¯ã¹
âäœæ¥ãçµããããã§ãã¯ãå ¥ããããã¯ã¹ã§ãã
æ®éã¯å·Šã«ãã§ãã¯ããã¯ã¹ããããŸãããç§ã®å Žåã¯å³ã
çç±ã¯ãå³å©ãã®äººãå€ãããã
ãã§ãã¯ã·ãŒããå°å·ããŠå®éã«äœ¿ã£ãŠã¿ããšåããã®ã§ãããæç« ãèªãã§äœæ¥ãçµããŠãã§ãã¯ãå ¥ãããšãã«ãå·ŠåŽã«ãã§ãã¯ããã¯ã¹ãããããããå³åŽã«ããæ¹ãæç« ãèªãã§ãã®ãŸãŸãã§ãã¯ãã§ããŸãã
ããã«ãã£ãŠããã§ãã¯ãããã¹ã ãŒãºã«ãªããŸãã
ã¡ãªã¿ã«ãåã«ãã§ãã¯ããã¯ã¹ãå³ã«ããã°è¯ãããšããããã§ã¯ãããŸããã
ãã§ãã¯ããã¯ã¹ãå·Šã«ãã£ãŠãåé¡ããªãã®ã¯ãæé ã¯æã£ãŠãããã®ã ããã
ããããææ«ã¯æã£ãŠããªããã®ãªã®ã§ããã§ãã¯ããã¯ã¹ãå³ã«ãããšãã©ã®æç« ã®ãã§ãã¯ããã¯ã¹ããåããã¥ãããªããŸãã
å®è·µãç¶ããçµæããã§ãã¯ããã¯ã¹ãå³ã«ããããã®æ¡ä»¶ã«æ°ä»ããŸããã
ãããã
ãã»ïŒç§ã®ãã§ãã¯ã·ãŒãã®ããã«ïŒäžè¡ããšã«ãç·ãåŒããŠããããš
ãã»äžè¡ããšã«ãè¡ã®è²ãå€ãã£ãŠããããš
ãšãããã®ã
ãã®ã©ã¡ããã®åœ¢ã§ãã°ããã§ãã¯ããã¯ã¹ãå³ã«ãã£ãŠãããã®ãã§ãã¯ããã¯ã¹ã¯ã©ã®æç« ã®ãã§ãã¯ããã¯ã¹ããæ確ã«åãããŸãã
åã«ããã§ãã¯ããã¯ã¹ãå³ã«ãããšè¯ãããšèšã人ãããŸãããäžèšã®ïŒã€ã®ã©ã¡ããã®åœ¢ã§ããããšã¯å¿ é ã§ãã
ãããæºãããŠããªããšããã§ãã¯ããã¯ã¹ãå³ã«ããå©ç¹ã掻ããããšã¯æ±ºããŠã§ããŸããã
ãã§ãã¯ã·ãŒãã¥ããã«æ £ããªããã¡ã¯ãã€ããã®ã§ç²Ÿäžæ¯ã§ããã®10ãã®ã«ãŒã«ãèŠããããšã¯å€§å€ã ãšæããŸãã
ãŸãã¯ãâ ã»â€ã»â¥ã»â§ã»âšã®ïŒã€ã ããå ¥åããŠã¿ãŠãã ããã
ããã§ãååãªãã§ãã¯ã·ãŒããã§ãããããŸãã
⌠ãã§ãã¯ã·ãŒãã¥ããã§ãç»å貌ãä»ãã
ã ãªã³ã©ã€ã³ãµãŒãã¹ãå§ããªãçç±
ãã§ãã¯ã·ãŒãäœãã«ããã£ãŠã¯ã
ãã»åçïŒç»é¢ã®ãã£ããã£ãŒïŒã®è²Œãä»ã
ãã»åç»ã®æ®åœ±
ãã»ãªã³ã©ã€ã³ãµãŒãã¹ã®æŽ»çš
ãšãã£ãæ¹æ³ããããŸãã
ããã§ãç§ããæåã®ãã¡ã¯Excelãšæåæ å ±ã®ã¿ã«ãã ããã®ã«ã¯çç±ããããŸãã
ããã¯ããã§ãã¯ã·ãŒãã¥ãããæ«æããèŠå ãå¢ããŠããŸãããã
ãŸã ãã§ãã¯ã·ãŒããã€ããã ãã§ã倧å€ãªã®ã«ã
æ°ããããŒã«èªäœã®äœ¿ãæ¹ãåŠã¶å¿ èŠããã£ããã
ããŒã«ã«ãã£ãŠã¯ç°å¢ãã·ãã¥ãšãŒã·ã§ã³ãéå®ããããããããšãããããã§ãã
ãããã£ãŠããããã®æ¹æ³ã¯ãããªãããã§ãã¯ã·ãŒããäœããããã«ãªããŸã§ã¯ãã§ããã°æãåºããªãããšãããããããŸãã
ããšãã°ãåçã®è²Œãä»ããã¯ãããã§ãã¯ã·ãŒãã§ã®äœæ¥ã®æŽãåºãããšããäœæ¥ã«å ããŠããåçã®ãã£ããã£æ®åœ±ã»å å·¥ã»è²Œä»ããšããäœæ¥ãå¢ããŸãã
ãåç»ã®æ®åœ±ããã§ãããä»äºã®ããæ¹ãæé ã段åããå€ãã£ãã ãã§ãæ®ãçŽããç·šéãçŽãã«ãªã£ãŠããŸããŸãã
ãã®ä¿®æ£ãéåžžã«é¢åã
ããªãé«ã確çã§ããã§ãã¯ã·ãŒãã¥ãããæ«æããããšã§ãããã
ãããåçã®è²Œãä»ããããåç»ã®æ®åœ±ãã«ãããã§ãã¯ã·ãŒããã€ããããã®ã§ããã°ã次ã®æ¡ä»¶ãæºãããå Žåã«éããšèããŸãã
ã»ãæãå¹ççã§å®ç§ãªä»äºã®æµãããã§ãã
ã» ãã®æµãã«ãããä¿®æ£ã®å¯èœæ§ããªã
ãããã®æ¹æ³ã«ãããã§ãã¯ã·ãŒãã¥ããã¯ãå°ãªããšãåå¿è ã«ãšã£ãŠã¯ãŸã èããªããŠè¯ãææ³ã ãšãããŸãã
ãŸãããªã³ã©ã€ã³ãµãŒãã¹ãã§ãããç§ãããã€ãè©ŠããŠã¿ãŸããã
ãããããã§ãã¯ã·ãŒããã€ãã以åã«ããã®ããŒã«ã®äœ¿ãããªãæ¹ãèŠããã®ã§äžèŠåŽã
æè¿ã¯ããªãç°¡åãªæäœã«ãªã£ãŠããŠã¯ããŸãããããã§ãæ®æ®µäœ¿ãæ £ããŠããŠãã€ã³ã¿ãŒããããã€ãªãã£ãŠããªããŠã䜿ããExcelãWordã§ååã ãšæããŸãã
ããã§ãã¯ã·ãŒããã€ããããšããã§ããããã«ãããªãã°ãã©ããªããŒã«ã§ã掻çšããŠããããšã¯å¯èœã§ãã
ãããŒã«ã䜿ãããªãããšãã«æéãå²ãã®ã§ã¯ãªãããŸãã¯Excelãªã©ã®äœ¿ãæ £ããããŒã«ã䜿ãããããŸã§ã®æ¬é£èŒã§ã®æ³šæç¹ãå®ããªãããããã§ãã¯ã·ãŒããäœãããšãã«æ £ããŠããããšãåªå ããŸãããã
ãç®çããšãæ段ããå±¥ãéããªãããã«æ°ãä»ããããšããã§ãã