ðãç¡æã§è±ªè¯ç¹å
žãLINEç»é²ããð
lstep.app/SUdD8n9
ðLINEç¡æç»é²ã§ç¹å
ž4åGETð
â
Excelã·ã§ãŒãã«ããé+α 288éž
â
480åãšã¯ã»ã«è¬çŸ©åç»
â
ãããæããExcelåŠç¿ã®ç§èš£ãã¬ãžã³
â
Excelè¬åº§æ倧41,000åOFFã¯ãŒãã³
ãšã¯ã»ã«ã®æ³äººç ä¿®ã®ãäŸé Œã¯ãã¡ããã
youseful.jp/corporatetraining...
ãã®ä»ã®ãåãåããããäŸé Œã¯ãã¡ããã
corp.youseful.jp/contact/
ð» MC ãããã£ãŒã«
ãããïŒé·å
åå¹³ã
Yousefulæ ªåŒäŒç€Ÿä»£è¡šåç· åœ¹
ç±³ã¯ã·ã³ãã³å€§åŠã«IBPçåŠãç¥æžå€§åŠçµå¶åŠéšãåæ¥åŸãæ°åã§äŒè€å¿ åäºæ ªåŒäŒç€Ÿã«å
¥ç€ŸãäŒèšã»çšåãå°éã«ãã¬ãŒãã»æè³æ¡ä»¶ã®ãããžã§ã¯ãã«åŸäºã2018幎7æã«å瀟ãéè·åŸãYousefulæ ªåŒäŒç€Ÿãåµæ¥ã360,000人ãç»é²ããæ¥æ¬æ倧çŽã®ããžãã¹æè²ãã£ã³ãã«ããŠãŒã¹ãã«/ã¹ãã«ã®å³æžé€šããéå¶ãããšå
±ã«ãå
šåœåå°ããåè¬ã§ããçæéäžExcelãªã³ã©ã€ã³è¬åº§ã®æ±ºå®çãExcelProããéçºã»éå¶ãããèæžãExcel çŸå Žã®æç§æžãã¯10äžéšçªç Žã®ãã¹ãã»ã©ãŒïŒAmazonã¬ãã¥ãŒ1,000件以äžã§4.2è©äŸ¡ïŒãæ³äººåãã«ã¯ããžã¿ã«äººæè²æãµãŒãã¹ãITãšã³ãžãã¢ã»ãã€ã¯ã©ã¹ããžãã¹äººæã®çŽ¹ä»æ¥ãææããããã®ä»ãçµå¶ã³ã³ãµã«ã»äŒæ¥è¬æŒã»ç ä¿®ã»å·çã»ã¡ãã£ã¢åºæŒçãå€æ¹é¢ã§æŽ»åäžã
AmazonïŒamzn.asia/d/fTLS4q0
WebïŒyouseful.jp/
ãŒãŒãŒãŒãŒãŒãŒãŒãŒãŒãŒãŒãŒãŒãŒ
ãŒãŒãŒãŒãŒãŒãŒãŒãŒãŒãŒãŒãŒãŒãŒ
00:00:00 ç®æ¬¡ ãã£ã1åç»ã§å
šãŠãåããExcelã®æç§æž
00:00:24 1-01 è·å Žã§ã¯æããŠãããªãå
¥åããŒã¿ã®ãçš®é¡ããšã¯ïŒ
00:04:21 1-02 æ°å€ã«ã¯è¡šãšè£ã®é¡ããã
00:08:11 1-03 æ¥ä»ãæå»ã瀺ããã·ãªã¢ã«å€ããç解ãã
00:12:23 1-04 ã©ããªæžé¡äœæã§ã圹ç«ã€é£ç¶ããŒã¿ã®å
¥åæ³
00:16:50 1-05 ã»ã«åç
§ãç解ããŠïŒã€ã®æ°åŒã䜿ãåãã
00:22:08 1-06 ããŒã¿è²Œãä»ãæã®ã圢åŒãéžã³ã極ããã
00:27:18 1-07 ãã¿ããã«è¡šãäœãåã«ããŒã¿ããŒã¹ã®æŠå¿µãç¥ã
00:32:19 1-08 ããã¹ããã¡ã€ã«ã¯åºåãäœçœ®ã§äžçºèªã¿èŸŒã¿
00:37:27 1-09 ããŒã¿ã®ä¿®æ£ãå¹çããç確ã«ããã³ã
00:41:47 1-10 äœèšãªã¹ããŒã¹ãåãé€ãTRIMé¢æ°ã掻çš
00:46:37 2-01ïŒ02 æ¡ä»¶ã«åãããŠè¡šç€ºãåãæ¿ããäžèœIFé¢æ°
00:54:10 2-03 ANDé¢æ°ãšORé¢æ°ã䜿ã£ãŠIFé¢æ°ã®å¹
ãåºãã
01:01:16 2-04 æ¡ä»¶ã«äžèŽããããŒã¿ã®æ°ãäžç¬ã§æ°ããCOUNTIFSé¢æ°
01:10:33 2-05 æ¡ä»¶ã«äžèŽããããŒã¿ã®åèšãç¬æã«æ±ããSUMIFSé¢æ°
01:15:44 2-06 éé¡ã®ç«¯æ°åŠçã«ã¯ROUNDDOWNé¢æ°ããã¹ã
01:19:26 3-01ïŒ02 VLOOKUPé¢æ°ã¯3ã¹ãããã§ãã¹ã¿ãŒïŒ
01:23:44 3-03 ãšã©ãŒå€ã衚瀺ãããè³æã¯çŸãããªã
01:26:51 3-04 å
¥åäžèŠã®ããªã¹ããã§ããã«å¹çå
01:29:37 3-05 ããŒãã«ã®æŽ»çšã§ããŒã¿ã®å¢æžã«èªå察å¿
01:33:30 3-06 åŒæ°[åçªå·]ãä¿®æ£ããã²ãšæéãçã
01:40:32 3-07ãïœä»¥äžïœæªæºãã®æ€çŽ¢ã¯çäºäžèŽã§ããTRUE(ïŒ)ã§ïŒ
01:46:05 3-08 å¥ã·ãŒãã«ãããã¹ã¿ããŒã¿ãåç
§ãã
01:50:15 3-09 è€éãªIDã®äžéšãåŒæ°ïŒ»æ€çŽ¢å€ïŒœã«ããã
01:58:40 3-10 éè€ããããŒã¿ããŠããŒã¯ãªãã®ã«çœ®ãæã
02:05:06 3-11 ããã«é«åºŠãªæ€çŽ¢ãå¯èœã«ããïŒã€ã®é¢æ°
02:11:19 4-01ïŒ02 ããŒã¿åæã®ç¬¬äžæ©ã¯ã䞊ã¹æ¿ããã®ãã¹ã¿ãŒãã
02:15:17 4-03 æ°åããããªã¬ããåãåºããŠä¿®æ£
02:19:17 4-04 欲ããæ
å ±ã ããç¬æã«çµã蟌ã
02:24:10 4-05ïŒ06 ããŒã¿ãããããèŠç¹ã§åæããŠã¿ãã
02:29:24 4-07ãååæå¥ãããæå¥ãã®å£²äžãããåãã
02:35:20 4-08 ã·ãŒãå¥ã«æ
åœè
ããšã®å£²äžè¡šãäžæ°ã«äœã
02:40:08 4-09 äŒããåãé«ããïŒ éèšçµæãèŠèŠåããã
02:46:25 5-01ïŒ02 å
±åç·šéãå¯èœã«ããŠããŒã ã§åæã«ç·šéãã
02:52:36 5-03 ãã çºããŠããã ãã§ã¯çºèŠã§ããªãæ°åŒã®ãšã©ãŒ
02:59:12 5-04 çŸããã·ãŒãã«ä»äžãããã¶ã€ã³ã®ã«ãŒã«
03:07:34 5-05 å
¥åãã¹ãçŽã¡ã«èŠã€ããä»çµã¿ãäœãã
03:12:36 5-06 ã»ã«ã«æžåŒãèšå®ããŠå
¥åæŒããé²ã工倫ãïŒ
03:18:44 5-07 誀ã£ãããŒã¿ã®åé€ãæ°åŒã®æžãæããé²ã
03:24:26 5-08 å°å·èšå®ã工倫ããŠèŠãããè³æã«ä»äžãã
#ExcelProè¬åº§ #2é±éã§åãæ¹ãå€ãã #æŠèŠæ¬ãã
ïŒïŒïŒïŒïŒïŒïŒïŒïŒïŒïŒïŒïŒïŒïŒïŒïŒïŒïŒïŒïŒïŒïŒïŒïŒïŒïŒïŒïŒïŒïŒïŒïŒïŒïŒïŒïŒïŒ
ãããšãšã¯ã»ã«ã®å®å
šçãExcelProãè¬åº§ïŒExcelå®åã®ããã®æããªãŒã«ã€ã³ã¯ã³ã§æã«å
¥ããªã³ã©ã€ã³Excelè¬åº§ã®æ±ºå®çãRU-vidã§ã¯æããŠããªãå®åãã¯ããã¯ãå
šéšçããŸããå
šé¡è¿éä¿èšŒä»ããåè¬è
4,000åãçªç ŽïŒâyouseful.jp/lp/excelpro/a/?ut...
19 Ќай 2024