
å ¬èªäŒèšå£«ãå¿åŽæ²ç·Excel &åæ Œäœéšèš
ã¯ããã«
ãnoteå 容ã
åããŸããŠãããŸãšç³ããŸãïŒ
twitterãhttps://twitter.com/kuma_cpaã
ããŒãã®å
容ã¯ä»¥äžã®éãã§ãã
â å¿åŽæ²ç·Excelã·ãŒã
â¡åæ ŒäœéšèšïŒããŸïŒïŒ12æâ8æåãïŒ
â¢åæ ŒäœéšèšïŒRKïŒãïŒãŽãããåãïŒïŒåç§ç®ã®å匷æ³ã«ã€ããŠïŒ
â£åæ ŒäœéšèšïŒåžé«ªïŒïŒQ and A圢åŒïŒ
â ïžåæ Œäœéšèšã¯3åãšãCPAäŒèšåŠé¢åºèº«è
ãªã®ã§ããããåæãšããèšäºã«ãªã£ãŠãããŸãã
ãããŒãè²·ã䟡å€ãæå³ããªã¹ã¹ã¡ããã人ã
â ã®Excelã·ãŒãã§åŸ¹åºããã埩ç¿ã¹ã±ãžã¥ãŒã«ããšãåŠç¿ç®¡çãã
ãããŠâ¡ãâ£ã®åæ Œäœéšèšã§ããå¹ççãªåŠç¿æ¹æ³ããåŠã¶ããšãã§ã
ãå¹ççã«ããã€ãå
å®ã«ãåæ Œå¯èœæ§ãé«ããããšãã§ãããšæã£ãŠãããŸãã
ããã飲ã¿äŒ1åææ
¢ããã°ããé£ããæ¥ããããã§æã«å
¥ããŸãïŒ
ãŸããšã¯ã»ã«åå¿è
ã§ãæ±ããããå
å®ãã説æãä»ããŠããã®ã§ãå®å¿äžããâŒïž
ãããªäººã«ã¯ç¹ã«ãªã¹ã¹ã¡ã«ãªããŸã
ã»ãªããšãªãè¬çŸ©ãé²ããŠããŠèšç»ãããŠãªãã£ã
ã»ç§ç®éãè«ç¹éã®åŸ©ç¿ãã©ã³ã¹ãæéé
åãé£ãã
ã»äžèЧããŠã¿ããèšç»è¡šããªã
ã»åŸ©ç¿æéãè¬çŸ©ã®èŠèŽäºå®ãå®ããªã
ã»ææ¥ãåããŠãã埩ç¿ããã®ãå
å»¶ã°ãã«ããŠããŸã
ã»åŸ©ç¿ã®æã«ã¯ææ¥ã®å
容ãèŠããŠããªã
ã»ä»ãŸã§äœåšãããããããéé²ã«åŸ©ç¿ããŠã
ã»ææ¥ãã¿ãŠçè§£ããã€ããã ããçç·Žã§ç¹ããšããªã
ãå¿åŽæ²ç·ã«ã€ããŠã

ãŸãåãã«å¿åŽæ²ç·ãšã¯äœãã説æããããšæããŸãã
ïŒïŒååŸã«ã¯ïŒïŒïŒ
å¿ãã
ïŒæéåŸã«ã¯ïŒïŒïŒ
å¿ã
ïŒæ¥åŸã«ã¯ïŒïŒïŒ
å¿ã
ïŒé±éåŸã«ã¯ïŒïŒïŒ
å¿ã
ïŒã¶æåŸã«ã¯ïŒïŒïŒ
å¿ããã
人ã¯ããããå¿ããçãç©ã§ãã
ã§ã¯ãå¿ããªãããã«ã©ãããã°è¯ãã®ãïŒ
ããã¯ïŒã«åŸ©ç¿ïŒïŒã«åŸ©ç¿ïŒïŒã«åŸ©ç¿ïŒåŸ©ç¿ããã®ã¿ïŒ
Q,ã埩ç¿ã®æé©ãªã¿ã€ãã³ã°ã¯ïŒã
ãŠãªãŒã¿ãŒã«å€§åŠã¯å®éšã«ãããš
ã»è¬çŸ©ããïŒïŒæé以å
ã«ïŒïŒåã®åŸ©ç¿ããããšãèšæ¶ãïŒïŒïŒïŒ
ïŒè¬çŸ©çŽåŸã®ç¶æ
ïŒã«æ»ã
ã»è¬çŸ©ããïŒé±éåŸã«ïŒåç®ã®åŸ©ç¿ããããšãïŒåã§èšæ¶ãåãæ»ãã
ã»è¬çŸ©ããïŒã¶æåŸã«ïŒåç®ã®åŸ©ç¿ããããšãïŒïœïŒåã§èšæ¶ãåãæ»ãã
ãã®å®éšãåèã«ãããšã埩ç¿ã®ã¿ã€ãã³ã°ã¯ãïŒïŒæé以å
ããïŒé±éåŸããïŒã¶æåŸããæãŸããšãããŸãã
ãããïŒïŒå
¬èªäŒèšå£«ã®é£æåºŠãšããªããšäžèšã®åŸ©ç¿ã¹ã±ãžã¥ãŒã«ã§ã¯è¶³ããªããšç§ã¯èããŠãããŸãã
ããã§ç§ãæšå¥šããã¹ã±ãžã¥ãŒã«ã¯
1æ¥åŸâ3æ¥åŸâ7æ¥åŸâ14æ¥åŸâ14æ¥åŸâ20æ¥åŸâŠâŠâŠâŠ
ã§ãïŒ
Q.ããªããããªé«é »åºŠã®åŸ©ç¿ãå¿ èŠãªã®ïŒã
ãªããããªé«é »åºŠãªã®ããšãããšããã®å
¬èªäŒèšå£«è©Šéšãšãããã®ã¯åã«æèšããŠããã°è§£ããããã§ã¯ãªããäœç³»çãªçè§£ãæ¬è³ªçãªçè§£ãå¿
èŠã§ãã
ããããè¿å¹Žã®åéšè
æ°ã®å¢å ã«äŒŽããé£æåºŠã¯é£åããŠããŠãããšèšããããåŸãŸããã
ããã§ãææ¥ã§åŸããçè§£ããå¿ããªãããã«é«é »åºŠã§ã®åŸ©ç¿ãå¿
èŠãšãªã£ãŠããã®ã§ãã
Q.ã埩ç¿ãããè¬çŸ©ãé²ããã®ãæåªå
ã«ããã»ããããã®ã¯ïŒã
â
çãã¯No!!!埩ç¿ãæ»ã¬ã»ã©å€§äºã§ãã
ãè¬çŸ©ãã©ãã©ãé²ããããŸã埩ç¿ãçãã«ãªããæ¬¡åŸ©ç¿ããæã«ã¯è¬çŸ©ã®å
容ãã»ãšãã©èŠããŠããªãã
ãšãããã¿ãŒã³ã§ãããã®çŸè±¡ã«é¥ã£ãå Žåãåé¡éã¯è§£ãããã©çç·Žã§ã¯ç¹æ°ã¯åããªããšããããšãèµ·ãããŸãã
è¬çŸ©ã§åŸãããçŽåŸæããçè§£ããæ®ã£ãŠããç¶æ³ã§åŸ©ç¿ãããªããšãå¿çšåã®ããç¥èã«ã¯ãªãããã¡ãã£ãšåé¡ãã²ããããã ãã§è§£ããªããªã£ãŠããŸããŸãã
Qããããªé«é »åºŠãªåŸ©ç¿ã ãšå匷æéè¶³ããªããã
â
1æ¥4ïŒ5æéãããã£ãŠããªãåéšçã¯ããæããããšã«ãªãã§ãããã
ãã®å¿åŽæ²ç·ã®ã¹ã±ãžã¥ãŒã«ãããªãããšæããšãèªåçã«å匷æéã¯7.8æéå¿
èŠã«ãªã£ãŠããŸãã
ããããé£åãç¶ããäŒèšå£«è©Šéšã«ãããŠã4ïŒ5æéã§ã¯åãããªããšèããæ¹ãããã§ãïŒåæ Œã«äœå¹Žãæãã£ãŠããäººãæ±å€§çãšãã®ã¹ãã³ã³é è³æã¡ã¯é€ãïŒ
ãã£ãŠããå¿åŽæ²ç·ãããªããïŒãåæ Œã«å¿
èŠãªæéæ°ã確ä¿ãããããšã«ãªããšæããŸãã
ãšã¯ããã瀟äŒäººåéšçãªã©ãäºæ
ãããæ¹ãå€ãããã£ããããšæããŸãã®ã§ã埩ç¿ã¹ã±ãžã¥ãŒã«ãèªç±ã«å€æŽã§ããããã«ããŠãããŸãã
ãèªèº«ã®ããŒã¹ã«åãããŠãå©çšé ããã°ãšæããŸãïŒ
äŸãã°ãèŠæåéã®ã¿é«é »åºŠåŸ©ç¿ã¹ã±ãžã¥ãŒã«ã«ãããšãã£ãã«ã¹ã¿ã ãå¯èœã«ãªã£ãŠããã®ã§ãè¬åž«ã«çžè«ããªããé²ãããšãããšæããŸãã
Q,ãExcelã·ãŒãã䜿ããšã©ããªç®¡çãã§ããããã«ãªãã®ïŒã
次ã«åŸ©ç¿ãã¹ãæ¥çšãæç¢ºã«ãªã
é©åãªåŸ©ç¿ã¹ã±ãžã¥ãŒã«ã«ããããšã§å¹ççã«é ã«ç¥èãæ®ãã
ç§ç®éã®ãã©ã³ã¹ãåãã
çæãäžæèšç»ã1ã€ã®ãšã¯ã»ã«ã§ç®¡çã§ãã
ã©ã®åéãäœåšåããããæçã«åãã
1è«ç¹åãã®ã«äœåãããããåããã®ã§ãã¹ã±ãžã¥ãŒã«ãç«ãŠããã
èŠæç§ç®ãéç¹çã«åŠç¿ã§ãã
åŠç¿çžè«ã®æã«ããšã¯ã»ã«ãèŠããã°äœãã©ã®ããããã£ãŠãã®ãäžç®çç¶ãªã®ã§é©åãªã¢ããã€ã¹ããããããã
埩ç¿ã¹ã±ãžã¥ãŒã«ã«ä¹ãããšã§å¿ ç¶ãšå匷æéãå¢ãã
å³ãåçãçšããäžå¯§ãªèª¬æãããã®ã§ããšã¯ã»ã«ãèŠæãªäººã§ãå®å¿
詊éšçŽåã«ããã ãåãããã ããåããã ãããšããç®ã«èŠããèªä¿¡ã«ãªã
ïŒPCãã䜿ãã®æ¹ïŒ
â ïžExcelã®2007幎以åverã®å Žåãæ°åŒãããŸãæ©èœããŸããâ ïž
âãšã¯ã»ã«ã®ãããŒãžã§ã³ãäžãããããã¹ããã¢ããªããå©çšããããšã§æ¹åã§ããŸã
ãªããã¹ãããããipadããã䜿ãã®æ¹ã¯åé¡ããããŸããã
ãåæ Œäœéšèšã«ã€ããŠã
æ£çŽãªãã±çšåºŠã«æã£ãŠãããŠãã ããã
ããããã£ããæäŸããããã«ã¯å
šèº«å
šé蟌ããŠæžããŸãïŒïŒ
â ãããŸã®åæ Œäœéšèšã
https://twitter.com/kuma_cpa
ç§ã¯å€§åŠçæä»£ã«å匷ãå§ããåæ ŒãŸã§6ã7幎æãããŸããã
æ£çŽãèªä¿¡ãæã£ãŠå匷æ³ãé²ãããããšãããããããã ãã¯ç䌌ãããªãã¿ãããªå
容ãå€ãã§ãã
ããšã¯ç£æ»è«ã®è«æã§äœ¿ããã¡ãã£ãšãããã¯ããã¯ã¯ããªã匷ãã£ãã®ã§ãããã玹ä»ããããšæããŸãã
â¡ãRKããã®åæ Œäœéšèšã
RKãããç°¡åã«ç޹ä»ãããšå匷ãªãã±ã§ãð»
以äžãè«ææš¡è©Šã®çµæã§ãã


è«æš¡è©Š20äœããããã
åãããŸãããããããäŒèšåŠå
é€ã§ãã
RKããã«ã¯ãäž»ã«ãŽãããåãã«ããããåããŠç§ç®ããšã«ã¢ããã€ã¹ãæžããŠããããŸããã
â¢ãåžé«ªããã®åæ Œäœéšèšã
å»å¹Žãçµå¶ãç§çšãç§ç®åæ Œããä»å¹Žã®è«æã§ã¯äŒèšåŠã®åå·®å€60overãå©ãåºããæ¹ã§ãã
åžé«ªããã«ã¯ãäŒèšåŠã®åŠç¿æ³ãã¡ã€ã³ã«QïŒA圢åŒã§æ§ã
質åã«çããŠé ããŸããã


ãæåŸã«ã
ãã®å
ã®èŠããªãäŒèšå£«åéšã«æãã§ããäºãæ¬åœã«èªãã«æã£ãŠãããšæããŸãã
èšå€§ãªè¬çŸ©ãããªããåšãã®å€§åŠçãã¡ãéãã§ããäžãçç·Žãè§£ããæ£æããçãè¿äžããŠå匷ãç¶ãããããã ãå匷ããŠãçäžå°œãªççããŒããŒã«æ³£ããè«æã®èš³åãããåé¡ã§äººçãçããããã
ã©ãã ã倧å€ãªæããããŠãæããæããããŠãå®¶æãæäººã®æããèè² ã£ãŠããããã®æ°æã¡ã¯äŒèšå£«åéšãçµéšãã人ããç¥ããªããšæããŸãã
ç§ã6.7幎ãšé·æåããççããŒããŒã«3床泣ãããã絶察åããèš³ããªããšæãçµ¶æããæ¥ã
ã§ããã
ãããããããªèªåã§ãåæ Œã§ããŸããã
ãã®è©Šéšã¯æ¬åœã«çã£ãŠãã»ã©é£ãããã©ãã諊ããªããã°å¿
ãåæ Œã§ããŸãã
é«ãé«ãå±±ã ããããããã®å±±é ã«ã¯ãã£ãšçŽ æŽãããæ¯è²ãåºãã£ãŠããŸãã
é äžã§ã«ãã麺ã«ã湯ãå
¥ããŠåŸ
ã£ãŠããŸããããŒã«ã§ä¹Ÿæ¯ããŸãããã
çããã®åæ Œãç¥ã£ãŠãããŸãã
ãèªè
ã®å£°ã





以äžããææèšäºã«ãªããŸãã
ïŒè»¢èŒãå人éã§ã®èŠãåãçã¯ãé æ
®ãã ããã
çºèŠããå Žåã«ã¯å³æ Œãªå¯Ÿå¿ãåãããŠé ããŸãã®ã§ã泚æãã ããïŒ