top of page






















Excel VBAã§æ¥åèªååããŒã«ãéçº
â å°ããå§ããDXã»Excelå¹çåæ¯æŽ â
æ¯æ¥ã®ç¹°ãè¿ãäœæ¥ãè€éãªäºååŠçã«æéãåãããŠããŸãããïŒ
Excelæ¥åã¯è² æ
ã倧ããäžæ¹ãäŒæ¥ã«ã·ã¹ãã éçºãäŸé Œãããšé«é¡ã«ãªããã¡ã§ãã
Softex Celware ã¯ãExcel VBAã«ããæ¥åèªååããŒã«éçºãå°éãšãã
ã·ãã衚ã»åšåº«ç®¡çã»è«æ±æžäœæãªã© “æ¢åExcelãã®ãŸãŸ” ã§å¹çåã§ããŸãã
é«é¡ãªã·ã¹ãã å°å
¥ãè¡ãããççŽæã»äœã³ã¹ãã§
ãå°ãã å§ããDXããå®çŸãããäŒæ¥ã»äºæ¥è
ããµããŒãããŸãã
è±å¯ãªå®çžŸãå°ããå§ããŠã確å®ã«å¹ãæ¥åæ¹åã
倧æãããªã·ã¹ãã åã®åã«ãæ¢åã®Excelãã«ã¹ã¿ãã€ãºã㊓æçè·é¢”ã§ææãåºããŸãã
â
çµæãæ©ãïŒæ¢åãã¡ã€ã«ïŒExcelïŒã掻ããã®ã§ãéçšéå§ãŸã§ãçãã
â
äœæ¥ãéããªãïŒå®åæ¥åãèªååããå
¥åã»éèšæéã倧å¹
åæžã
â
å°å
¥ãããããïŒExcelãå
¥ã£ãŠããã°ã€ã³ã¹ããŒã«äžèŠã仿¥ãã䜿ãã圢ã«ã
â
誰ã§ã䜿ããïŒæ®æ®µã®Excelæäœã§ãã®ãŸãŸéçšãæè²ã³ã¹ããäœãã
â
è²»çšå¯Ÿå¹æãé«ãïŒå¿
èŠãªç¯å²ããæ®µéå°å
¥ãã ããªéçºãããªãã
环èš750ä»¶è¶ (2025幎11æ)ã®å¯Ÿå¿å®çžŸ
ECãµã€ãã»å°å£²ïŒITäŒæ¥ïŒYoutuberïŒã€ãã³ãéå¶ïŒã€ã³ã¹ãã©ã¯ã¿ãŒïŒãªãŒã¯ã·ã§ã³åºåïŒã¯ãªããã¯ïŒã³ã³ãã©åºåè ïŒã³ã³ãµã«ã¿ã³ãïŒã¹ããŒãå£äœïŒã¿ã¯ã·ãŒïŒããã³ãçµå¶ïŒããã³ã³å±ïŒããã«ïŒã©ãžãªå±ïŒãªãµã€ã¯ã«æ¥è ïŒãªãã©ãŒã æ¥è ïŒäžè¬äŒæ¥ïŒäžæ°Žé調æ»äŒç€ŸïŒäžåç£ïŒä»è·ïŒäŒèšã»è²¡åïŒä¿è²åïŒä¿éºäŒç€ŸïŒå人ïŒå€§åŠçïŒå¶ææ¡å¯žïŒåç©ç é¢ïŒå»çã»èª¿å€ïŒå ãïŒåžå£²æ¥ïŒå€§åŠïŒåŠç¿å¡ŸïŒå·¥å ŽïŒåžåœ¹æïŒå¹ŒçšåïŒå»ºèšïŒåŒè·äºåæïŒæè³å®¶ïŒæŸéå±ïŒæè²ã»çŠç¥ïŒæ°èé éïŒæœå·¥æ¥è ïŒæ¯ç§å»é¢ïŒæž¬éïŒçºå·¥å ŽïŒç®¡çæ é€å£«ïŒçŽããã€é éïŒçŸå®¹ã»ãµãŒãã¹ïŒè¬å€åž«ïŒè£œé æ¥ïŒèšªåä»è·ïŒèšåæ©åšè£œäœïŒèŒžå ¥æ¥ïŒé»åäŒç€ŸïŒé£åå å·¥ïŒé£²é£åºïŒé§è»å Ž
âæŽæ°æ å ±

âæè¡è©è«ç€Ÿããæ¬ãåºç
2024/2/24ïœ å
šåœã®æžåºã«ãŠ
ãããŸã§ã®Excel VBAéçºè«è² ã®å®çžŸããå¹ã£ãæè¡ã1åã«ãŸãšããŸããã
âæ¬åœã®æåç·ã§ã®éçºçŸå Žã®æè¡ãç¶²çŸ
ããŠãããŸãã
âã客æ§ã®åã³ã®å£°
蚪åä»è·
ä»åãããããšãããããŸããã
ããªãé£æåºŠã®é«ãèŠæ±ããããŠé ããã®ã§ããã
åé¡ç¡ãååŒãçµããããšãã§ããŸããã
ä»åŸãšããããããé¡ãããããŸãã
2024/07/23
ã¹ããŒãæå®€
ãã®åºŠã¯äžå¯§ã«ã察å¿ããã ãããããšãããããŸãããç§ã®äžæ £ãã§ãšã©ãŒãšãªã£ãŠããŸã£ããã詊ããŠã¿ãŠããããã£ããšã©ãŒã§ã確å®ã«ã察å¿ããã ããšãŠãå©ãããŸããã
2025/09/05
èŒžå ¥æ¥
ä»åããäžè©±ã«ãªããŸããã
æ¥ãªãé¡ãã«ã芪åã«å¯Ÿå¿ããŠããã ããéåžžã«å©ãããŸããã
éåžžã«ä¿¡é Œã®ãããæè¡è
ã§ãããŸãäœããã£ãæã¯é ŒãããšæããŸãã
æ¬åœã«ããããšãããããŸããã
2024/03/29
åŒè·äºåæ
以åäœæããŠé ããŠãããã®ã®æ©èœè¿œå ã§ããã
äœåºŠããé¡ãããŠããããããšãã倧å€ã¹ã ãŒãºã§ãå®å¿ããŠãé¡ããããããšãã§ããŸããã
ã§ãããã£ããã®ãç§ã®åžæãåå
šã«å¶ãããã®ã§ããã
ãŸããæ©äŒãããã°ãé¡ãããããšæããŸãã
2025/01/28
åžå£²
åããŠã®ååŒã§äžå®ã®ããäžãæåããæåŸãŸã§äžå¯§ã«ã察å¿ããã ããŸããŠãå®å¿ããŠååŒãé²ããããšãã§ããŸããã
ãé¡ãããŸããäœæ¥å¹çåèªååããŒã«ã¯åžæã®èŠä»¶ããã¹ãŠçã蟌ãã§ããã ããŸããŠãäœæ¥å¹çã«ã€ãªãããé¡ãããŠããã£ãã§ãã
ããœã³ã³æäœã«äžæ
£ããªæ¹ã§ãç°¡åã«æäœã§ããããŒã«ãäœã£ãŠããã ããŸããã
ãŸããå¹çåãå³ãããå
容ãåºãŠããŸããããçžè«ãããŠãã ããã
ããããšãããããŸããã
2025/09/02
äžåç£
æ¥ãªäŸé Œã§ãçŽæã倧å€çãã£ãã®ã§ãããã察å¿ããã ããŠãšãŠãå©ãããŸãããã
ãŸãåç»ã§ã®èª¬æãããããããã£ãã§ãã
é£çµ¡ãã¹ã ãŒãºã§å®å¿ããŠãååŒã§ããŸããã
2024/02/02
â身è¿ã«Excelã§å°ã£ãŠã人ããŸãããïŒ
(å¶æ¥ä»£è¡åéäž)
Softex Celwareã®å¶æ¥ä»£è¡è
ãåéããŠããŸãã
âåœæ¹ã®éçºæè¡ç(ããŒããã©ãªãª)ãçè§£ããŠããããExcelããŒã«ã®éçºãäŸé Œãããæ¹ã玹ä»ããã ããŸãã
â玹ä»ã®ã¿ã§1ïœ2å²ã®å ±é
¬æ¯æãèŠä»¶å®çŸ©ã察å¿ããŠããã ããå Žåã¯4ïœ6å²å ±é
¬æ¯æã§å¯Ÿå¿äºå®ã§ãã
âãèå³ããããŸããããäžåºŠæåãããããŸãã
ãµãŒãã¹è©³çް

äŸ¡æ ŒäºäŸ
ITäŒæ¥ã«äŸé Œããã°100äžã¯äžããªãã·ã¹ãã ã10äžåå°ã§éçºå¯èœïŒã·ãã衚ãåšåº«ç®¡çãªã©ïŒ
ç°¡åãªçžè«ãéåå¹çåã§ããã°æ°äžåãã

ç¬èªæè¡
ãã·ãã衚é
眮èªååããªã©ã¯ããºã«ãè§£ããããªè€éãªããã°ã©ã ã®æ§ç¯ãå¿
èŠã
âãã®ãããªé«åºŠãªã¢ã«ãŽãªãºã ãèŠæ±ãããã·ã¹ãã ã§ãç¹æ®æè¡ãšæã¡åã®å°é ã§è§£æ±ºå¯èœ

ã¢ãã¿ãŒãã©ããŒ
çŽåããããŒã«ã®äœ¿ãæ¹ã仿§èª¬æã¯åãããããåç»ãéããŸãã
â仿²»åžè¿èŸºã§ããã°çŽæ¥ã䌺ãããŠä¿å®å¯Ÿå¿å¯èœã§ãã

ãã®ä»ã®å¯Ÿå¿äºäŸ
ã»Excelã®äœ¿ãæ¹ãªã©æå°
ã»ExcelVBAã®ããã°ã©ãã³ã°æå°
ã»Googleã¹ãã¬ããã·ãŒãã®éçº
ã»PCå
šè¬ã®çžè«
âã»Webãµã€ãäœæïŒä¿®è¡äžïŒ
æåãäºçŽ
- ãªã³ã©ã€ã³ã§å©çšå¯èœ
ãäŸé Œå 容ã«ã€ããŠZoomãå©çšããŠæåã
1æé
æåªç仿²»åžå ã§çŽæ¥çŸå°ã蚪åããŠäŸé Œå 容ã«ã€ããŠæåãããŸã
1æé
softex-celware 代衚
æ·±èŠ ç¥å£«
Fukami Yuji
ã»ãªãŒããŒã¡ã€ãã®Excelããã°ã©ã ã«ããæ¥åæ¹åã®å¯Ÿå¿å®çžŸ700ä»¶è¶
ã»ãªã³ã©ã€ã³ã®ã¹ãã«ããŒã±ããæå€§æã§ããã³ã³ãã©ã§
ã ITã»ããã°ã©ãã³ã°ã»éçºã«ããŽãª å®çžŸ1äœïŒçŽ5000ä»¶äžïŒ
ã»å€§æè£œé æ¥ãµã©ãªãŒãã³æä»£ã«æ¥éœéè·ãã瀟å¡1人åã®æ¥åã
ãäžæã«åŒãç¶ãããããã1ã¶æã§ãŸãããšèªååã宿é瀟ãå®çŸ
ã»å€§éªå
¬ç«å€§åŠ å·¥åŠéš èªç©ºå®å®æµ·æŽå°æ»ä¿®äº
ã»é·åŽç壱å²åžåºèº«
ã»äºå
ã®ç¶ å®®å€å³¶ãã©ã€ã¢ã¹ãã³ã壱å²ãŠã«ãã©ãã©ãœã³å®èµ°

bottom of page



































