å
容玹ä»
PCãã¢ããªãæäœããæèœïŒæ
å ±æè¡ãã€ã³ã¿ãŒãããæè¡ã«ãããæ©èœã»ä»çµã¿ïŒæ
å ±ãæ±ãå«çã»æ
åºŠïŒæ
å ±é¢é£æ³èŠïŒããã°ã©ãã³ã°çæèãªã©åŠãã§ããããèŠçŽ ãæ
å ±ã®åºç€åŠç¿ã«æå¹ãªæ§æã§ã³ã³ãã¯ãã«ãŸãšããã
ç®æ¬¡
1ïŒPCãšWindowsã®åºæ¬æäœ
1.1ãPCãšãããã¯ãŒã¯æ¥ç¶â
ã1.1.1ãPCã®èµ·åã»åæ¢ãšãã©ãã«å¯ŸåŠâ
ã1.1.2ãæç·LANãšç¡ç·LANã®åãæ¿ãâ
ã1.1.3ãWindows Updateãšã·ã£ããããŠã³â
1.2ãã¢ããªã®èµ·åâ
ã1.2.1ãã¹ã¿ãŒãã¡ãã¥ãŒâ
ã1.2.2ãã¢ããªã®æ€çŽ¢â
ã1.2.3ãã¿ã¹ã¯ããŒãžã®ãã³çãâ
1.3ããšã¯ã¹ãããŒã©ãŒã®æäœãšèšå®â
ã1.3.1ãããã¥ã¡ã³ããã©ã«ããŒã®æŽ»çšâ
ã1.3.2ããã¡ã€ã«åæ¡åŒµåã®è¡šç€ºâ
ã1.3.3ããã¡ã€ã«ã®æ€çŽ¢â
2ïŒWordâ
ââ
段èœã®æ§æâ
â
2.1ãç®æ¡æžãâ
ã2.1.1ãç®æ¡æžãã®é©çšâ
ã2.1.2ãè¡é æåã®å€æŽâ
2.2ãæ®µèœçªå·â
ã2.2.1ãæ®µèœçªå·ã®é©çšâ
ã2.2.2ãçªå·ã®å€æŽãšä»ãçŽãâ
3ïŒWordâ
ââ
段èœã®æžåŒèšå®â
â
3.1ãæ®µèœæžåŒâ
ã3.1.1ãå·Šæãã»äžå€®æãã»å³æãã»äž¡ç«¯æãâ
ã3.1.2ãåçå²ãä»ãâ
3.2ãã€ã³ãã³ãâ
ã3.2.1ãå·Šã»å³ã»åäžãã»ã¶ãäžãã€ã³ãã³ãâ
ã3.2.2ãç®æ¡æžãã»ã¿ãã»ã€ã³ãã³ãã®äœµçšâ
3.3ãè¡ééâ
ã3.3.1ãè¡ééã»æ®µèœåééã»æ®µèœåŸééâ
ã3.3.2ãè¡ééã®åæ ãšè¡æ°æå®â
4ïŒExcelâ
ââ
æ°åŒãšé¢æ°â
â
4.1ãã¯ãŒã¯ã·ãŒããšã»ã«ã®åºæ¬â
ã4.1.1ãåéšã®åç§°â
ã4.1.2ãã»ã«ã®å€ã»æ°åŒã»æžåŒâ
ã4.1.3ãã»ã«çªå°ã»åŒã»ååæŒç®â
4.2ã衚ã®äœè£ãšã»ã«æžåŒâ
ã4.2.1ã眫ç·ãšè²â
ã4.2.2ãã»ã«ã®è¡šç€ºåœ¢åŒâ
4.3ã颿°ãšæ°å€èšç®â
ã4.3.1ãSUM颿°ã»AVERAGE颿°â
ã4.3.2ãAVERAGE颿°ãšå²ãç®ã«ããå¹³åã®éãâ
ã4.3.3ãMAX颿°ã»MIN颿°â
ã4.3.4ãMOD颿°
ã4.3.5ãINT颿°ã»ROUND颿°â
ã4.3.6ãæååæäœãšMID颿°ã»CONCAT颿°ã»TEXTJOIN颿°â
5ïŒExcelâ
ââ
çžå¯Ÿåç
§ãšçµ¶å¯Ÿåç
§â
â
5.1ãçžå¯Ÿåç
§ãšçµ¶å¯Ÿåç
§â
ã5.1.1ãçžå¯Ÿåç
§ãšçµ¶å¯Ÿåç
§ã®æ§è³ªâ
ã5.1.2ãæ¯çèšç®ãšæ°åŒã³ããŒâ
ã5.1.3ãç©åœ¢ç¯å²ã³ããŒãšçžå¯Ÿã»çµ¶å¯Ÿã®çµã¿åããâ
5.2ã颿°ãšçµ¶å¯Ÿåç
§â
ã5.2.1ãRANK颿°ãšãªã³ã©ã€ã³ããã¥ã¢ã«â
ã5.2.2ãRANK颿°ã§ã®çµ¶å¯Ÿåç
§æå®â
6ïŒExcelâ
ââ
ãã£ã«ã¿ãŒãšäžŠã¹æ¿ãâ
â
6.1ããªãŒããã£ã«ã¿ãŒâ
ã6.1.1ãããŒã¿éžæã«ãããã£ã«ã¿ãªã³ã°â
ã6.1.2ãæ¡ä»¶åŒã«ãããã£ã«ã¿ãªã³ã°â
ã6.1.3ããã£ã«ã¿ãªã³ã°ç¶æ
ã§ã®ãã©ãã°ã³ããŒâ
ã6.1.4ããã£ã«ã¿ãªã³ã°ç¶æ
ã§ã®ã³ããŒäœæ¥â
6.2ãäžŠã¹æ¿ãâ
ã6.2.1ãäžŠã¹æ¿ãã®ããŒãšæé ã»éé â
ã6.2.2ãè€æ°ããŒã«ããæŽåâ
6.3ãæ¡ä»¶ä»ãæžåŒâ
ã6.3.1ãã«ã©ãŒã¹ã±ãŒã«â
ã6.3.2ãããŒã¿ããŒâ
7ïŒExcelâ
ââ
ã°ã©ãâ
â
7.1ãã°ã©ãäœæâ
ã7.1.1ãæ£ã°ã©ãâ
ã7.1.2ãæãç·ã°ã©ãâ
ã7.1.3ãåã°ã©ãâ
ã7.1.4ãæ£åžå³â
7.2ãã°ã©ãèŠçŽ â
ã7.2.1ãåéšã®åç§°â
ã7.2.2ãã°ã©ãã¿ã€ãã«ã»è»žã©ãã«â
ã7.2.3ãè»žã®æå°å€ã»æå€§å€ã»ç®çééâ
ã7.2.4ãããŒã¿ã©ãã«ã»å¡äŸâ
7.3ããã®ä»ã®ã°ã©ãâ
ã7.3.1ãçµã¿åããã°ã©ãâ
ã7.3.2ãç®±ã²ãå³â
ã7.3.3ãæ°åŒã䜿ã£ã环èšã°ã©ãâ
ã7.3.4ãæ°åŒã䜿ã£ããã¹ãã°ã©ã â
8ïŒExcelâ
ââ
ããŒã¿åŠçãšé¢æ°ã®æŽ»çšâ
â
8.1ãã«ãŠã³ãâ
ã8.1.1ãCOUNT颿°ã»COUNTA颿°â
ã8.1.2ãCOUNTIF 颿°
8.2ãæ¡ä»¶åå²â
ã8.2.1ãIF颿°ã»AND颿°ã»OR颿°â
ã8.2.2ãIF颿°ã®å€å²å岿§é â
ã8.2.3ãIFS颿°ã䜿ã£ãå€å²å岿§é â
8.3ãããŒã¿åç
§â
ã8.3.1ãVLOOKUP 颿°
ã8.3.2ãIFERROR 颿°â
9ïŒæ
å ±åé
9.1ãæ€çŽ¢ãšã³ãžã³â
ã9.1.1ãæ€çŽ¢ãµã€ãâ
ã9.1.2ãæ€çŽ¢ãšã³ãžã³ã®ä»çµã¿â
ã9.1.3ãSEOâ
9.2ãæ
å ±åéã®æ¹æ³â
ã9.2.1ãããŒã¯ãŒãæ€çŽ¢â
ã9.2.2ãç®çã«å¿ããæ€çŽ¢â
9.3ãæ
å ±å©çšâ
ã9.3.1ãæ
å ±ã®å€æâ
ã9.3.2ãæ
å ±ã®ä¿¡ææ§â
ã9.3.3ãæ
å ±ã®åŒçšâ
9.4ãããŒã¿ã®çš®é¡â
ã9.4.1ããã¡ã€ã«æ¡åŒµåâ
ã9.4.2ããã¡ã€ã«ãã©ãŒãããâ
10ïŒã³ã³ãã¥ãŒã¿æè¡
10.1ãã³ã³ãã¥ãŒã¿ãšãã®çš®é¡â
ã10.1.1ãPCãšæºåž¯ç«¯æ«
ã10.1.2ããµãŒãâ
ã10.1.3ããã€ã³ã³ãšçµèŸŒã¿â
10.2ãããŒããŠã§ã¢
ã10.2.1ãã³ã³ãã¥ãŒã¿ã®5倧æ©èœâ
ã10.2.2ãCPUãšãã¶ãŒããŒãâ
ã10.2.3ãã¡ã¢ãªãšãã£ãã·ã¥â
ã10.2.4ãè£å©èšæ¶è£
眮â
ã10.2.5ãå
¥åºåè£
眮â
ã10.2.6ãGPUãš3Dã°ã©ãã£ãã¯ã¹â
ã10.2.7ããããã¯ãŒã¯ããã€ã¹â
ã10.2.8ãICã«ãŒã
ã10.2.9ã3Dããªã³ã¿
ã10.2.10ãVRã»ARã»MRâ
ã10.2.11ãã·ã¹ãã ã®ä¿¡é Œæ§â
ã10.2.12ãããã¯ã¢ãããšãªã¹ãã¢â
10.3ããœãããŠã§ã¢
ã10.3.1ãOSâ
ã10.3.2ããœãããŠã§ã¢ã©ã€ã»ã³ã¹â
ã10.3.3ããªãŒãã³ãœãŒã¹ãšããªãŒãŠã§ã¢â
10.4ãæ
å ±ã®åäœãšèšç®â
ã10.4.1ãäºé²æ³â
ã10.4.2ãæ
å ±ã®åäœâ
ã10.4.3ãæ
å ±éã®èšç®â
ã10.4.4ãé床ã®èšç®â
ã10.4.5ãè«çæŒç®â
10.5ã笊å·åâ
ã10.5.1ãæåã³ãŒããšãã£ã©ã¯ã¿ã»ããâ
ã10.5.2ããšã³ã³ãŒããšãã³ãŒãâ
ã10.5.3ãããŒã¿å§çž®â
ã10.5.4ãæ åå質â
11ïŒã€ã³ã¿ãŒãããæè¡
11.1ãTCP/IPæè¡â
ã11.1.1ãLANâ
ã11.1.2ãTCP/IPãšãããã³ã«ã¹ã¿ãã¯â
ã11.1.3ãURLâ
ã11.1.4ãIPã¢ãã¬ã¹ãšDHCPãµãŒãâ
ã11.1.5ããã¡ã€ã³åãšDNSãµãŒãâ
11.2ãWebæè¡
ã11.2.1ãWebãµãŒããšWebãã©ãŠã¶â
ã11.2.2ãHTTPãšæå·åéä¿¡â
ã11.2.3ãCookieâ
ã11.2.4ãéçWebãšåçWebâ
ã11.2.5ãã€ã³ã¿ãŒãããåºåâ
11.3ããµãŒãâ
ã11.3.1ããµãŒããšOS
ã11.3.2ããã¡ã€ã«ãµãŒããšNASâ
11.4ãé»åã¡ãŒã«â
ã11.4.1ãã¡ãŒã«ãµãŒãâ
ã11.4.2ãé»åã¡ãŒã«ã®èšå®ãšæ©èœâ
ã11.4.3ãã¡ãŒãªã³ã°ãªã¹ãâ
ã11.4.4ãã¡ãŒã«ã®èšè¿°æ³ãšãããŒâ
12ïŒæ
å ±å«çãšé¢é£æ³èŠ
12.1ãæ
å ±å«çâ
ã12.1.1ããã£ãžã¿ã«æ
å ±ã®æ§è³ªãšæ
å ±å«çâ
ã12.1.2ãæ
å ±ç€ŸäŒã«ããã責任â
ã12.1.3ãæ
å ±çºä¿¡ã®çæç¹â
ã12.1.4ãã¡ãŒã«éä¿¡ã®çæç¹â
ã12.1.5ãèªå·±ã®å人æ
å ±éä¿¡ã®çæç¹â
ã12.1.6ãæ
å ±ã»ãã¥ãªãã£ã®çæç¹â
ã12.1.7ãPCã®ç®¡çãšãªãµã€ã¯ã«â
ã12.1.8ããã©ãã«çã®æ
å ±ãµã€ããšçžè«çªå£â
12.2ãæ
å ±ã«é¢ããæ³åŸâ
ã12.2.1ãç¥çè²¡ç£æš©å¶åºŠâ
ã12.2.2ããã©ã€ãã·ãŒã®æš©å©â
ã12.2.3ãå人æ
å ±ä¿è·æ³â
ã12.2.4ãäžæ£ã¢ã¯ã»ã¹çŠæ¢æ³â
ã12.2.5ãäžæ£æä»€é»ç£çèšé²ã«é¢ãã眪â
ã12.2.6ãç¹å®é»åã¡ãŒã«æ³â
ã12.2.7ããã€ãã³ããŒå¶åºŠâ
12.3ãæ
å ±ã«ããããäºäŸâ
ã12.3.1ãèäœæš©äŸµå®³â
ã12.3.2ãå人æ
å ±æŒããâ
ã12.3.3ãäžæ£ã¢ã¯ã»ã¹â
13ïŒæ
å ±ã»ãã¥ãªãã£
13.1ããããã¯ãŒã¯è
åšãšå¯Ÿçâ
ã13.1.1ãæ
å ±ã»ãã¥ãªãã£ãšè
åšâ
ã13.1.2ãã³ã³ãã¥ãŒã¿ãŠã€ã«ã¹â
ã13.1.3ãæ»æææ³â
ã13.1.4ãè¿·æã¡ãŒã«â
ã13.1.5ãèªç¶çœå®³â
ã13.1.6ãã»ãã¥ãªãã£å¯Ÿçâ
13.2ããã¹ã¯ãŒããšèªèšŒâ
ã13.2.1ããã¹ã¯ãŒãã®åŒ·åºŠâ
ã13.2.2ããã¹ã¯ãŒãã®æ±ºå®ãšç®¡çâ
ã13.2.3ããã°ã€ã³ãšèªèšŒâ
13.3ããã¡ã€ã«ã®å§çž®ãšæå·åâ
ã13.3.1ãå§çž®ãšå±éâ
ã13.3.2ãæå·åãšåŸ©å·â
13.4ãæå·åéä¿¡æ¹åŒâ
ã13.4.1ãå
±é鵿巿¹åŒâ
ã13.4.2ãå
¬é鵿巿¹åŒâ
ã13.4.3ãé»å眲åâ
14ïŒã·ã¹ãã éçºãšããã°ã©ãã³ã°
14.1ãã·ã¹ãã éçºâ
14.2ãããã°ã©ãã³ã°èšèªâ
ã14.2.1ãããã°ã©ãã³ã°èšèªã®åé¡â
ã14.2.2ããã®ä»ã®èšèªâ
14.3ãã¢ã«ãŽãªãºã â
ã14.3.1ãæ§é åããã°ã©ãã³ã°â
ã14.3.2ãã¢ã«ãŽãªãºã ã®äŸâ
14.4ãããã°ã©ãã³ã°â
ã14.4.1ãVBAããã°ã©ãã³ã°â
ã14.4.2ãèªåååŠçâ
ã14.4.3ãVBAããã°ã©ã äŸâ
玢åŒâ