[B! excel] kazu_moriã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

kazu_mori id:kazu_mori

excelã«é–¢ã™ã‚‹kazu_moriã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (13)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

ä»•äº‹ãŒã‚‚ã£ã¨æ—ã‚‹ï¼Excelï¼ˆã‚¨ã‚¯ã‚»ãƒ«ï¼‰ã®ä¾¿åˆ©ãªä½¿ã„æ–¹ãŒåˆ†ã‹ã‚‹è¨˜äº‹ã¾ã¨ã‚
ä»•äº‹ã§Excelã‚’ä½¿ã£ã¦ã„ã¦ã€ã€Œã‚‚ã£ã¨æ—©ãè¦‹æ „ãˆã®è‰¯ã„è³‡æ–™ã‚’ä½œã‚ŒãŸã‚‰ãªãã€ã¨æ€ã£ã¦ã„ã¾ã›ã‚“ã‹ï¼ŸExcelï¼ˆã‚¨ã‚¯ã‚»ãƒ«ï¼‰ã®ä¾¿åˆ©ãªä½¿ã„æ–¹ãŒåˆ†ã‹ã‚‹è¨˜äº‹ã¾ã¨ã‚ ã§ã‚‚ã€ã‚‚ã†å¤§ä¸ˆå¤«ï¼ æœ¬æ—¥ã¯ã€ çµ¶å¯¾ã«çŸ¥ã£ã¦ãŠãã¹ãExcelã®ä¾¿åˆ©ãƒ¯ã‚¶åŠ¹çŽ‡UPã«å¿…é ˆã®æ™‚çŸãƒ¯ã‚¶ãƒ‡ãƒ¼ã‚¿ã®è¦‹æ „ãˆã‚’è‰¯ãã™ã‚‹å°ãƒ¯ã‚¶ã“ã‚“ãªã“ã¨ã¾ã§ã§ãã‚‹ã®ï¼Ÿï¼ã¨ã„ã†ä¸Šç´šãƒ¯ã‚¶ ãªã©ã€çŸ¥ã£ã¦ã„ã‚‹ã¨é©šãã»ã©å·®ãŒã¤ãExcelã®æŠ€ã‚’ã™ã¹ã¦ã”ç´¹ä»‹ã—ã¾ã™ã€‚ æ•°ã‚ã‚‹Excelè¨˜äº‹ã®ä¸ã‹ã‚‰ä½¿ãˆã‚‹è¨˜äº‹ã‚’åŽ³é¸ã—ãŸã®ã§ã€æ˜¯éžå‚è€ƒã«ã—ã¦ã¿ã¦ãã ã•ã„ã€‚ 1. çŸ¥ã£ã¦ã„ã‚‹ã¨çµ¶å¯¾ä¾¿åˆ©ãªExcelã®æŠ€ ç°¡å˜ãªã®ã«ã€çŸ¥ã£ã¦ã„ã‚‹ã¨ä½œæ¥æ™‚é–“ãŒé©šãã»ã©çŸç¸®ã§ãã‚‹æŠ€ã‚’ç´¹ä»‹ã—ã¦ã„ã‚‹è‰¯è¨˜äº‹ã‚’åŽ³é¸ã—ã¾ã—ãŸã€‚ã©ã‚Œã‚‚ä¸€ã¤ä¸€ã¤ã®æŠ€ã¯ç°¡å˜ãªã®ã§ã€å¿…ãšä»Šæ—¥ã‹ã‚‰ä½¿ãˆã¾ã™ï¼ â‘ Do you know these Double-click Tricks in Excel? ï¼ˆã‚ãªãŸã¯çŸ¥ã£ã¦ã‚‹ï¼Ÿãƒ€ãƒ–ãƒ«ã‚¯ãƒªãƒƒã‚¯ã ã‘
kazu_mori 2013/12/18
Excel

ä¾¿åˆ©

ä»•äº‹
ãƒªãƒ³ã‚¯
ãƒ—ãƒã‚°ãƒ©ãƒžãŒè€ƒãˆã‚‹åŠ‡çš„ã«åŠ¹çŽ‡ãŒä¸ŠãŒã‚‹Excelã‚·ãƒ¼ãƒˆã®ä½œã‚Šæ–¹
ãã“ãã“ã®è¤‡é›‘ãªè¨ˆç®—ã‚’ã™ã‚‹ã®ã«Excelã¯ã‚‚ã®ã™ã”ãä¾¿åˆ©ã§ã™ã€‚ä½•ã‹ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è¨€èªžã‚’ä½¿ã£ã¦æ›¸ã„ãŸã‚‰1æ™‚é–“ãã‚‰ã„ã‹ã‹ã‚‹ã‚ˆã†ãªè¨ˆç®—ãŒã€ã‚‚ã®ã®æ•°åˆ†ã§ã‚·ãƒ¼ãƒˆä¸Šã«ã§ãã‚ãŒã‚Šã¾ã™ã€‚ ã“ã®ç´ æ™´ã‚‰ã—ã„Excelã‚’ã€ã‚ˆã‚Šä½¿ã„ã‚„ã™ãã™ã‚‹ãƒ¯ã‚¶ã‚’ã€ãƒ—ãƒã‚°ãƒ©ãƒžçš„ãªè¦–ç‚¹ã‹ã‚‰æ›¸ããŸã„ã¨æ€ã„ã¾ã™ã€‚ æ‹¡å¼µæ€§ã®ãªã„ã‚·ãƒ¼ãƒˆ ãã†ã„ã†ã‚ã‘ã§ã€Excelã¯ç´ æ™´ã‚‰ã—ã„ã‚“ã§ã™ãŒã€ä½¿ã†äººã«ã‚ˆã£ã¦ã¯ãªã‚“ã¨ã‚‚ã€Œæ‹¡å¼µæ€§ã®ãªã„ã‚·ãƒ¼ãƒˆã€ãŒã§ãã‚ãŒã‚Šã¾ã™ã€‚ åƒ•ã¯ãƒ—ãƒã‚°ãƒ©ãƒžãªã®ã§ã€ã“ã†ã„ã†ç´ æ™´ã‚‰ã—ã„ãƒ„ãƒ¼ãƒ«ã‚’ä½¿ã„ã¯ã˜ã‚ã‚‹ã¨ã€ã©ã†ã—ã¦ã‚‚æ‹¡å¼µæ€§ã¨ã‹ä¿å®ˆæ€§ã¿ãŸã„ãªã‚‚ã®ãŒæ°—ã«ãªã£ã¦ã—ã¾ã„ã¾ã™ã€‚ãƒ—ãƒã‚°ãƒ©ãƒžã¯åŒã˜ã“ã¨ã‚’ç¹°ã‚Šè¿”ã™ã®ãŒè‹¦æ‰‹ã§ã™ã€‚ã‚·ãƒ¼ãƒˆã«ãƒ‡ãƒ¼ã‚¿ã‚’å…¥åŠ›ã—ã¦ã‹ã‚‰å®Œæˆå½¢ãŒã§ãã‚ãŒã‚‹ã¾ã§ã«äººæ‰‹ã‚’ä½¿ã†ã“ã¨ã‚’é¿ã‘ã¦ã€å…¨éƒ¨ã‚’è‡ªå‹•åŒ–ã—ãŸããªã‚Šã¾ã™ã€‚ æ¬¡ã®ã‚ˆã†ãªã“ã¨ã‚’ã—ã¦ã„ãŸã‚‰ã€Excelã‚’æ£ã—ãä½¿ãˆã¦ã„ãªã„ã‚ˆã†ãªæ°—ãŒã—ã¾ã™ã€‚ é€”ä¸ã§é›»å“ã‚’ä½¿ã£ã¦è¨ˆç®—ã—ã¦ã‚»ãƒ«ã‚’åŸ‹ã‚ã¦ã„
kazu_mori 2013/09/12
Excel

ä¾¿åˆ©
ãƒªãƒ³ã‚¯
ä»•äº‹ã§Excelä½¿ã†ãªã‚‰å¿…ãšèªã‚“ã§ãŠããŸã„è¨˜äº‹ã¾ã¨ã‚
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› NAVERã¾ã¨ã‚ã¯2020å¹´9æœˆ30æ—¥ã‚’ã‚‚ã¡ã¾ã—ã¦ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ç´„11å¹´é–“ã€NAVERã¾ã¨ã‚ã‚’ã”åˆ©ç”¨ãƒ»ã”æ„›é¡§ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚
kazu_mori 2012/06/08
ã¾ã¨ã‚

Excel
ãƒªãƒ³ã‚¯
æ±äº¬ã‚¨ã‚¯ã‚»ãƒ«ç‰©èªž -ç§ã®å¿ƒã®ä¸ã®é–¢æ•°
çœŸç”±ç¾Žã®ä¹—ã£ãŸã‚¿ã‚¯ã‚·ãƒ¼ã¯ã€èµ¤ç¾½æ©‹ã®äº¤å·®ç‚¹ã«å‘ã‹ã£ã¦ã„ãŸã€‚ è¦ªå‹ã®ãƒŠã‚ªã¨å‚åŠ ã™ã‚‹å©šæ´»ãƒ‘ãƒ¼ãƒ†ã‚£ãƒ¼ãŒã‚ã‚‹ã‹ã‚‰ã ã€‚ çœŸç”±ç¾Žã®è¶£å‘³ã¯ã€å©šæ´»ãƒ‘ãƒ¼ãƒ†ã‚£ãƒ¼ã§å‡ºä¼šã£ãŸç”·æ€§ã®ãƒ‡ãƒ¼ã‚¿ã‚’ã‚¨ã‚¯ã‚»ãƒ«ã®ã‚·ãƒ¼ãƒˆã§ç®¡ç†ã™ã‚‹ã“ã¨ã€‚ å½¼å¥³ã®ã‚·ãƒ¼ãƒˆã«ã¯ãŸãã•ã‚“ã®ç”·æ€§ã®ãƒ‡ãƒ¼ã‚¿ãŒè¨˜éŒ²ã•ã‚Œã¦ã„ãŸã€‚ èº«é•·ã€ä½“é‡ã€å¹´é½¢ã€è¡€æ¶²åž‹ã€ãã—ã¦ãƒ»ãƒ»ãƒ»å¹´åŽã€‚ ã“ã®æ—¥ã‚‚å½¼å¥³ã¯å¤šãã®ç”·æ€§ã¨å‡ºä¼šã£ãŸã€‚ ã„ã¤ã‚‚é€šã‚Šã‚¨ã‚¯ã‚»ãƒ«ã®ã‚·ãƒ¼ãƒˆã«ç”·æ€§ã®ãƒ‡ãƒ¼ã‚¿ã‚’è¨˜éŒ²ã™ã‚‹å½¼å¥³ã€‚ ã‚¤ã‚¿ã‚ºãƒ©ã«ã€ŒIFã€é–¢æ•°ã‚’ä½¿ã„ã€è‡ªåˆ†å¥½ã¿ã®ç”·æ€§ã‚’æŽ¢ã™ã€‚ ã—ã‹ã—ã€ã“ã®å¤œã®å½¼å¥³ã¯é•ã£ã¦ã„ãŸã€‚ æ°—ä»˜ã„ãŸã®ã ã€‚é ¬ã‚’ä¼ã†æ¶™ã«ã€‚ ã€Œãƒ»ãƒ»ãƒ»ç§ã£ã¦ãƒ›ãƒ³ãƒˆå«Œãªå¥³ã‚ˆãã€‚ ãªã‚“ã§ã“ã†ãªã£ã¡ã‚ƒã£ãŸã‚“ã ã‚ãƒ»ãƒ»ãƒ»ã€ è‡ªåˆ†å¥½ã¿ã®æ¡ä»¶ã§æ¤œç´¢ã—ã¦ã‚‚ã€ä¼šã£ãŸç”·æ€§ã®é¡”ã‚’ä½•ä¸€ã¤æ€ã„å‡ºã›ãªã„çœŸç”±ç¾Žã€‚ ã„ã¤ã®é–“ã«ã‹çª“ã®å¤–ã«ã¯é›¨ãŒé™ã£ã¦ã„ãŸã€‚ é›¨éŸ³ãŒçœŸç”±ç¾Žã®å¿ƒã‚’ãªãã•ã‚ã‚‹ã‹ã®ã‚ˆã†ã«ã€éƒ½ä¼šã®å¤œã¯é™ã‹ã«æ˜Žã‘ã¦ã„ãã®ã ã£ãŸã€‚ IFé–¢æ•°ã¯ã€æŒ‡å®šã—ãŸæ¡
kazu_mori 2010/12/24
ã“ã‚Œã¯ï½—ï½—ï½—

Excel

ã‚¨ã‚¯ã‚»ãƒ«
ãƒªãƒ³ã‚¯
Excel ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã‚ãƒ¼ä¸€è¦§ï¼šExcel ã‚¨ã‚¯ã‚»ãƒ«ã®ä½¿ã„æ–¹
ã€Žã‚¤ãƒ³ã‚¹ãƒˆãƒ©ã‚¯ã‚¿ãƒ¼ã®ãƒã‚¿å¸³ã€ã§ã¯ã€2003å¹´10æœˆã‹ã‚‰Microsoft Officeã®ä½¿ã„æ–¹ãªã©ã‚’ç´¹ä»‹ã—ç¶šã‘ã¦ã„ã¾ã™ã€‚ Excel VBAãƒ¦ãƒ¼ã‚¶ãƒ¼ã®æ–¹ã‚’å¯¾è±¡ã¨ã—ã¦ã€Wordã®è¡¨ã‚’VBAã§æ“ä½œã™ã‚‹åŸºç¤Žã‚’ã¾ã¨ã‚ã¾ã—ãŸâ†“â†“ Excel VBAã®çµŒé¨“ãŒã‚ã‚‹æ–¹ã‚’å¯¾è±¡ã«ã€Word VBAã®åŸºæœ¬ã‚’ã‚ãƒ³ãƒ‰ãƒ«æœ¬ã¨ã—ã¦ã¾ã¨ã‚ã¾ã—ãŸâ†“â†“ å›³å½¢ã‚’æ“ä½œã™ã‚‹Excel VBAã®åŸºæœ¬ã‚’è§£èª¬ã—ãŸã‚ãƒ³ãƒ‰ãƒ«æœ¬ã‚’å‡ºã—ã¾ã—ãŸâ†“â†“ ã‚°ãƒ©ãƒ•ã‚’æ“ä½œã™ã‚‹Excel VBAã®åŸºæœ¬ã‚’è§£èª¬ã—ãŸã‚ãƒ³ãƒ‰ãƒ«æœ¬ã§ã™â†“â†“ æ•°å¼ã‚’ä½¿ã£ãŸæ¡ä»¶ä»˜ãæ›¸å¼è¨å®šãŒè‹¦æ‰‹ãªæ–¹ã«å‘ã‘ãŸKindle æœ¬ã‚’æ›¸ãã¾ã—ãŸâ†“â†“ Pythonã®æ–‡å—åˆ—ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã®åŸºæœ¬ã‚’ã‚ãƒ³ãƒ‰ãƒ«æœ¬ã¨ã—ã¦ã¾ã¨ã‚ã¾ã—ãŸâ†“â†“ å°æ•°ã¨Pythonã®decimalãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã®åŸºæœ¬ã‚’ã‚ãƒ³ãƒ‰ãƒ«æœ¬ã¨ã—ã¦ã¾ã¨ã‚ã¾ã—ãŸâ†“â†“ Pythonã®å¤–éƒ¨ãƒ©ã‚¤ãƒ–ãƒ©ãƒªOpenPyXLï¼ˆã‚ªãƒ¼ãƒ—ãƒ³ãƒ‘ã‚¤ã‚¨ã‚¯ã‚»ãƒ«ï¼‰ã®å…¥é–€æ›¸ã‚’ã€Excel VB
kazu_mori 2010/11/01
ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã‚ãƒ¼

Excel

ã‚¨ã‚¯ã‚»ãƒ«
ãƒªãƒ³ã‚¯
ã‚¨ã‚¯ã‚»ãƒ«Excelå¤§äº‹å…¸ ãƒžã‚¯ãƒVBAãƒ¯ãƒ¼ã‚¯ã‚·ãƒ¼ãƒˆé–¢æ•°å…¥é–€å¿œç”¨ä½¿ã„æ–¹è¬›åº§
â– ã‚¨ã‚¯ã‚»ãƒ«VBAè¶…å…¥é–€ ãƒ»ï¼™ã‚¹ãƒ†ãƒƒãƒ—ã§"Hello World!" ã‹ã‚‰ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆæŒ‡å‘ã¾ã§ï¼ 1. "Hello World!"ã‚’è¡¨ç¤ºã—ã‚ˆã† 2. åŸºæœ¬ã¯ãƒ‡ãƒ¼ã‚¿ã®å…¥å‡ºåŠ› 3. ç¹°ã‚Šè¿”ã—å‡¦ç† 4. ã‚·ãƒ¼ãƒˆã§ç°¡æ˜“ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ 5. åå‰ã‚’ã¤ã‘ã‚ˆã† 6. æ§‹é€ åŒ–ãƒ—ãƒã‚°ãƒ©ãƒ ã«æŒ‘æˆ¦ 7. æ§‹é€ ä½“ã‚’ä½¿ã£ã¦ã¿ã‚ˆã† 8. ãƒ•ã‚©ãƒ¼ãƒ ã‚’ä½¿ã£ã¦ã¿ã‚ˆã† 9. ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆæŒ‡å‘ã«æŒ‘æˆ¦ â– ã‚¨ã‚¯ã‚»ãƒ«VBAä¸ç´šç·¨ ãƒ»VBAã§ã„ã‚ã‚“ãªãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ å¤‰æ•°ãƒ»é–¢æ•°ã®ã‚¹ã‚³ãƒ¼ãƒ— å¼•æ•°ã®å‚ç…§æ–¹æ³•ã‚’æ˜Žç¤º é…åˆ—ã®ä¸èº«ã‚’ä¸€æ°—ã«è¤‡å†™ è˜åˆ¥åãŒã‚ˆã„ã‚³ãƒ¼ãƒ‰ã‚’ä½œã‚‹ ãƒ‡ãƒ¼ã‚¿å®šç¾©åž‹ã‚’ã‚‚ã£ã¨çŸ¥ã‚ã† å®šæ•°ã¨åˆ—æŒ™åž‹ã‚’æ´»ç”¨ã—ã‚ˆã† ã‚¨ãƒ©ãƒ¼å‡¦ç†ã®é‡è¦æ€§ï¼‘ ã‚¨ãƒ©ãƒ¼å‡¦ç†ã®é‡è¦æ€§ï¼’ ã„ã‚ã„ã‚ãªæ¡ä»¶åˆ†å² ã„ã‚ã„ã‚ãªç¹°ã‚Šè¿”ã—å‡¦ç† æ¼”ç®—åã«ã¤ã„ã¦çŸ¥ã‚ã† æ–‡å—åˆ—æ“ä½œ é€£çµ å¤‰æ› ç½®æ› æ–‡å—åˆ—æ“ä½œ æ¤œç´¢ æ¯”è¼ƒ æ›¸å¼ æ—¥ä»˜æ“ä½œé–¢æ•°ã‚’çŸ¥ã‚ã† æ•°å€¤æ“ä½œãƒ»è©•ä¾¡ãƒ»ãã®ä»–é–¢æ•° ä¸¦ã³æ›¿ãˆã‚½
kazu_mori 2010/10/13
ã‚¨ã‚¯ã‚»ãƒ«

excel
ãƒªãƒ³ã‚¯
3åˆ†ã§ã‚ã‹ã‚‹ï¼ä»•äº‹ã«å½¹ç«‹ã¤Excelãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ï¼šITpro
Excelã¯ä»•äº‹ã®ãƒ„ãƒ¼ãƒ«ã¨ã—ã¦ã¯éžå¸¸ã«ãƒãƒ”ãƒ¥ãƒ©ãƒ¼ãªã‚½ãƒ•ãƒˆã§ã™ãŒï¼Œå¤šæ©Ÿèƒ½ãŒã‚†ãˆã«ï¼Œãã®ä¾¿åˆ©ãªæ©Ÿèƒ½ã‚’ååˆ†ã«ä½¿ã„ã“ãªã›ã¦ã„ãªã„äººãŒéžå¸¸ã«å¤šã„ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ãã“ã§ã“ã®é€£è¼‰ã§ã¯ï¼Œâ€œæ“ä½œè‡ªä½“ã¯æ±ºã—ã¦é›£ã—ã„ã‚‚ã®ã§ã¯ãªã„ã‘ã‚Œã©ï¼Œæ„å¤–ã¨çŸ¥ã‚‰ã‚Œã¦ã„ãªã„â€ã¨ã„ã†Excelã®ä¾¿åˆ©ãªãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’åŽ³é¸ã—ã¦ç´¹ä»‹ã—ã¦ã„ãã¾ã™ã€‚ãœã²ã”æœŸå¾…ãã ã•ã„ï¼
kazu_mori 2010/10/13
excel

ã‚¨ã‚¯ã‚»ãƒ«
ãƒªãƒ³ã‚¯
ã‚¨ã‚¯ã‚»ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’è¦‹ã‚„ã™ãã™ã‚‹5ã¤ã®ç°¡å˜ãªãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ | ã‚³ãƒªã‚¹
Chandoo.orgã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã‹ã‚‰ã€æ¡ä»¶ä»˜ãæ›¸å¼ã‚’åˆ©ç”¨ã—ã¦ã€ã‚¨ã‚¯ã‚»ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’è¦‹ã‚„ã™ãã™ã‚‹5ã¤ã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ Learn Cool Microsoft Excel Conditional Formatting Tricks ãƒ†ãƒ¼ãƒ–ãƒ«ã®æ¨ªåˆ—ãƒ»ç¸¦åˆ—ã‚’ãƒã‚¤ãƒ©ã‚¤ãƒˆ æ¡ä»¶ä»˜ãæ›¸å¼ã‚’ä½¿ç”¨ã—ãŸã‚¬ãƒ³ãƒˆãƒãƒ£ãƒ¼ãƒˆ ã‚»ãƒ«å†…ã«é…ç½®ã™ã‚‹ã‚°ãƒ©ãƒ• ãƒŸã‚¹ã‚„ã‚¨ãƒ©ãƒ¼ãƒ»ãƒ‡ãƒ¼ã‚¿æ¬ è½ãªã©ã®ãƒã‚¤ãƒ©ã‚¤ãƒˆè¡¨ç¤º ç›´æ„Ÿçš„ã«æŠŠæ¡ã§ãã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ†ãƒ¼ãƒ–ãƒ« [ad#ad-2] ã‚¨ã‚¯ã‚»ãƒ«ãƒ‡ãƒ¼ã‚¿ã¯ã€Chandoo.orgã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®ä¸€ç•ªä¸‹ã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã¾ã™ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã®æ¨ªåˆ—ãƒ»ç¸¦åˆ—ã‚’ãƒã‚¤ãƒ©ã‚¤ãƒˆ ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’è¦‹ã‚„ã™ãã™ã‚‹ãŸã‚ã«ã€æ¨ªåˆ—ãƒ»ç¸¦åˆ—ã‚’äº¤äº’ã«ãƒã‚¤ãƒ©ã‚¤ãƒˆè¡¨ç¤ºã«ã—ã¾ã™ã€‚ ãƒã‚¤ãƒ©ã‚¤ãƒˆã«ã™ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«å…¨ä½“ã‚’é¸æŠžã—ã¾ã™ã€‚ ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‚ˆã‚Šã€[æ›¸å¼] - [æ¡ä»¶ä»˜ãæ›¸å¼] ã‚’é¸æŠžã€‚ ã€Œæ•°å¼ã€ã‚’é¸æŠžã—ã€ã€Œ=MOD(ROW(),2)=0ã€ã‚’å…¥åŠ›ã—
kazu_mori 2010/10/13
ã‚¨ã‚¯ã‚»ãƒ«

excel
ãƒªãƒ³ã‚¯
è¦‹æ „ãˆãŒã‚ˆãã€åˆ†ã‹ã‚Šã‚„ã™ã„ã‚¨ã‚¯ã‚»ãƒ«ã®ã‚°ãƒ©ãƒ•ã‚’ä½œæˆã™ã‚‹5ã¤ã®ç°¡å˜ãªãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ | ã‚³ãƒªã‚¹
Chandoo.orgã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã‹ã‚‰ã€è¦‹æ „ãˆãŒã‚ˆãã€åˆ†ã‹ã‚Šã‚„ã™ã„ã‚¨ã‚¯ã‚»ãƒ«ã®ã‚°ãƒ©ãƒ•ã‚’ä½œæˆã™ã‚‹5ã¤ã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã¨ã‚«ãƒ©ãƒ•ãƒ«ã«ãƒ‡ã‚¶ã‚¤ãƒ³ã•ã‚ŒãŸ73ã®ã‚¨ã‚¯ã‚»ãƒ«ã®ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ How to NOT spend $ 150,000 and still dress up your charts è‰²ã®ä»£ã‚ã‚Šã«ã‚°ãƒ©ãƒ‡ãƒ¼ã‚·ãƒ§ãƒ³ã‚„ãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’ä½¿ç”¨ã—ãŸã‚°ãƒ©ãƒ• è‰²ã®ä»£ã‚ã‚Šã«ç”»åƒã‚’ä½¿ç”¨ã—ãŸã‚°ãƒ©ãƒ• æ³¨ç›®ã™ã‚‹ãƒã‚¤ãƒ³ãƒˆã«ãƒ†ã‚ã‚¹ãƒˆã‚’é…ç½®ã—ãŸã‚°ãƒ©ãƒ• ã‚ªãƒªã‚¸ãƒŠãƒ«ã®è‰²ã‚’ä½¿ç”¨ã—ãŸã‚°ãƒ©ãƒ• ãƒ©ãƒ™ãƒ«ã«ç”»åƒã‚’ä½¿ç”¨ã—ãŸã‚°ãƒ©ãƒ• ãƒ‡ã‚¶ã‚¤ãƒ³ã•ã‚ŒãŸã‚°ãƒ©ãƒ•ã®73ã®ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆ [ad#ad-2] è‰²ã®ä»£ã‚ã‚Šã«ã‚°ãƒ©ãƒ‡ãƒ¼ã‚·ãƒ§ãƒ³ã‚„ãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’ä½¿ç”¨ã—ãŸã‚°ãƒ©ãƒ• ã‚°ãƒ©ãƒ•ã®é…è‰²ã«ãƒ•ãƒ©ãƒƒãƒˆãªè‰²ã§ã¯ãªãã€ã‚°ãƒ©ãƒ‡ãƒ¼ã‚·ãƒ§ãƒ³ã‚„ãƒ‘ã‚¿ãƒ¼ãƒ³ã‚’ä½¿ç”¨ã—ã¾ã™ã€‚ ã‚¹ãƒ©ã‚¤ãƒ‰ã«ä½¿ç”¨ã™ã‚‹éš›ã¯ã€ã‚°ãƒ©ãƒ‡ãƒ¼ã‚·ãƒ§ãƒ³ã‚’æŽ§ãˆã‚ã«ã€‚ ã‚°ãƒ©ãƒ•ã‚’å³ã‚¯ãƒªãƒƒã‚¯ã—ã€ã€Œãƒ‡ãƒ¼ã‚¿ç³»åˆ—ã®æ›¸å¼ã€ã‚’è¡¨ç¤ºã—ã¾ã™ã€‚ ã€Œãƒ‘ã‚¿ãƒ¼ãƒ³
kazu_mori 2010/10/13
ã‚¨ã‚¯ã‚»ãƒ«

excel
ãƒªãƒ³ã‚¯
ã€Œã‚¨ã‚¯ã‚»ãƒ«ã‚·ãƒ¼ãƒˆã‚’HTMLãƒ†ãƒ¼ãƒ–ãƒ«ã«å¤‰æ›ã—ã¡ã‚ƒã†å› ã€ãŒã™ã”ãä¾¿åˆ©
çµ„ç¹”ã®ãƒžã‚¤ãƒ³ãƒ‰ãƒžãƒƒãƒ—ãƒ„ãƒ¼ãƒ«ã‚’ãƒžã‚¤ãƒ³ãƒ‰ãƒžã‚¤ã‚¹ã‚¿ãƒ¼ã«ã™ã¹ãç†ç”± ä¼¸ã³ã¦ã‚‹ç”£æ¥ã€ä¼šç¤¾ã€äº‹æ¥ã‚’ç´¹ä»‹ã—ã¾ãã‚‹Strainerã®ãƒ‹ãƒ¥ãƒ¼ã‚¹ãƒ¬ã‚¿ãƒ¼ã«ç™»éŒ²!! ã€Œã‚¨ã‚¯ã‚»ãƒ«ã‚·ãƒ¼ãƒˆã‚’HTMLãƒ†ãƒ¼ãƒ–ãƒ«ã«å¤‰æ›ã—ã¡ã‚ƒã†å› ã€ã§ã‚«ãƒ³ã‚¿ãƒ³ãƒ†ãƒ¼ãƒ–ãƒ«ä½œæˆ ã€Œã‚¨ã‚¯ã‚»ãƒ«ã‚·ãƒ¼ãƒˆã‚’HTMLãƒ†ãƒ¼ãƒ–ãƒ«ã«å¤‰æ›ã—ã¡ã‚ƒã†å› (Î²Î²)ã€ã¯ã€ã‚¨ã‚¯ã‚»ãƒ«ã®è¡¨ã‚’è²¼ã‚Šä»˜ã‘ã‚‹ã¨HTMLã®Tableã‚¿ã‚°ã§è¡¨ã‚’ç”Ÿæˆã€ãƒ—ãƒ¬ãƒ“ãƒ¥ãƒ¼ã‚‚è¡¨ç¤ºã—ã¦ãã‚Œã‚‹ä¾¿åˆ©ãƒ„ãƒ¼ãƒ«ã€‚ä»¥å‰ç´¹ä»‹ã—ãŸã‚µãƒ¼ãƒ“ã‚¹ã§ã¯æ—¥æœ¬èªžã‚’é€šã™ã®ã«ã²ã¨æ‰‹é–“å¿…è¦ã§ã—ãŸãŒã€ä»Šå›žã¯ãã®éƒ¨åˆ†ã§ã‚‚å•é¡Œã‚ã‚Šã¾ã›ã‚“ã€‚ å¤‰æ›ã—ã¡ã‚ƒã†å›ã®ç‰¹å¾´ ã€ŒTableizerã€ã¨ã®æ¯”è¼ƒã«ã‚‚ãªã£ã¦ã„ã¾ã™ã€‚ ã‚»ãƒ«å†…ã§ã®æ”¹è¡Œã«å¯¾å¿œ CSVã«ã‚‚å¯¾å¿œ å¼·å›ºãªã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£æ€§ï¼ˆã‚µãƒ¼ãƒãƒ¼ã¨ã®ã‚„ã‚Šå–ã‚Šãªã—ï¼‰ ã‚»ãƒ«ã®çµåˆãŒå¯èƒ½ æ£ã—ã„ãƒžãƒ¼ã‚¯ã‚¢ãƒƒãƒ—ãŒå¯èƒ½ è¡Œã”ã¨ã®è‰²æ›¿ãˆã‚‚è¨å®šå¯èƒ½ ClassæŒ‡å®šã‚‚ç´°ã‹ãä»˜ä¸Žå¯èƒ½ãªã®ã§ç‹¬è‡ªãƒ‡ã‚¶ã‚¤ãƒ³ã‚‚çµ„ã¿è¾¼ã¿ã‚„ã™ã„ ã‚µãƒ³ãƒ—ãƒ«ãƒ†ãƒ¼ãƒ–ãƒ« T
kazu_mori 2010/09/28
ä¾¿åˆ©

excel

table
ãƒªãƒ³ã‚¯
ASCII.jpï¼šé©šãã®Excel è¶…æ—©æŠ€ãƒ™ã‚¹ãƒˆ15ã€€ã“ã‚Œã¯ä¾¿åˆ©ï¼ï½œExcelé”äººã®æ–°å®šç•ªãƒ†ã‚¯60ã€€çŸ¥ã‚‰ãªã„ã‚ãªãŸã¯æã—ã¦ã‚‹ï¼
ãƒžãƒ³ãƒãƒªåŒ–ã—ãŸæ–¹æ³•ã§Excelã‚’ä½¿ã£ã¦ã„ãªã„ã§ã—ã‚‡ã†ã‹ã€‚å®Ÿã¯ã‚‚ã£ã¨ç°¡å˜ã§æ‰‹æ—©ãã§ãã‚‹æŠ€ãŒã‚ã‚‹ã®ã§ã™ã€‚ä½¿ã‚ãªã„ãªã‚“ã¦ã‚‚ã£ãŸã„ãªã„ã€‚ã‚¢ãƒŠã‚¿ã®çŸ¥ã‚‰ãªã„ã€Œæ–°ã€ExcelæŠ€å¤§ç‰¹é›†ï¼ã€€ç¬¬1å›žã¯ã€æ‰‹é–“ã‚’çœã„ã¦æ“ä½œã‚’ã™ã°ã‚„ãï¼ã€€ä»Šã™ãå½¹ç«‹ã¤åŽ³é¸æ—©æŠ€15ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚é¢å€’ãªå…¥åŠ›ã‚„ç·¨é›†ä½œæ¥ã‚’ã©ã‚“ã©ã‚“ç‰‡ã¥ãï¼ é©šãã®Excel è¶…æ—©æ¥ãƒ™ã‚¹ãƒˆ15â€•â€•ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ æŠ€1â€•â€•è¡¨ã®æ—©æŠ€ã€€è¡¨ã®è¦‹å‡ºã—ã‚’é™¤ã„ã¦åˆ—å¹…ã‚’è‡ªå‹•èª¿æ•´ æŠ€2â€•â€•å…¥åŠ›ã®æ—©æŠ€ã€€æ”¯åº—åã‚’ã„ã¤ã‚‚æ±ºã¾ã£ãŸé †ç•ªã§ã‚ªãƒ¼ãƒˆãƒ•ã‚£ãƒ«å…¥åŠ› æŠ€3â€•â€•å…¥åŠ›ã®æ—©æŠ€ã€€ã€Œï¼ã€ã®ä»£ã‚ã‚Šã«ã€Œï¼‹ã€ã‚ãƒ¼ã§å¼ã‚’å…¥åŠ› æŠ€4â€•â€•å…¥åŠ›ã®æ—©æŠ€ã€€ã‚»ãƒ«ã‚’çµ„ã¿åˆã‚ã›ã¦æ€ã„ã©ãŠã‚Šã«é€£ç¶šãƒ‡ãƒ¼ã‚¿ã‚’å…¥åŠ› æŠ€5â€•â€•å…¥åŠ›ã®æ—©æŠ€ã€€ãªãŒãƒ¼ã„é€£ç•ªã‚’ä¸€ç™ºå…¥åŠ› æŠ€6â€•â€•ç·¨é›†ã®æ—©æŠ€ã€€ãƒ„ãƒ¼ãƒ«ãƒãƒ¼ã®ï¼»ä¸‹ç·šï¼½ãƒœã‚¿ãƒ³ã§äºŒé‡ä¸‹ç·šã‚’å¼•ã æŠ€7â€•â€•è¡¨ã®æ—©æŠ€ã€€åŸºæœ¬ã®è¡Œåˆ—å…¥ã‚Œæ›¿ãˆã¯ãƒœã‚¿ãƒ³ã§ æŠ€8â€•â€•è¡¨ã®æ—©æŠ€ã€€å¤šæ§˜ãªç½«ç·šã‚’ä½¿ã£ãŸè¤‡é›‘ãªè¡¨ã¯ã€Œç½«ç·šãªã—ã€
kazu_mori 2010/09/07
ä¾¿åˆ©

excel

ã‚¨ã‚¯ã‚»ãƒ«
ãƒªãƒ³ã‚¯
TABLEIZER! | Spreadsheets to HTML Tables Tool
Paste your cells from Excel, Google Docs or another spreadsheet here: Table Style Options
kazu_mori 2010/07/12
excel

ä¾¿åˆ©

ã‚¸ã‚§ãƒãƒ¬ãƒ¼ã‚¿

webã‚µãƒ¼ãƒ“ã‚¹
ãƒªãƒ³ã‚¯
è¡å‹•è²·ã„ã‚’ã—ãªã„ã‚ˆã†ã«ã™ã‚‹ã»ã—ã„ç‰©ãƒªã‚¹ãƒˆã®ä½œã‚Šæ–¹ï¼†æ´»ç”¨æ–¹æ³• | nanapi[ãƒŠãƒŠãƒ”]
è¡å‹•è²·ã„ã‚’ã—ãªã„ã‚ˆã†ã«ã™ã‚‹ã»ã—ã„ç‰©ãƒªã‚¹ãƒˆã®ä½œã‚Šæ–¹ï¼†æ´»ç”¨æ–¹æ³• ã«é–¢ã™ã‚‹ãƒ©ã‚¤ãƒ•ãƒ¬ã‚·ãƒ”ã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚nanapi [ãƒŠãƒŠãƒ”]ã¯ã€ã¿ã‚“ãªã§ä½œã‚‹æš®ã‚‰ã—ã®ãƒ¬ã‚·ãƒ”ã‚µã‚¤ãƒˆã§ã™ã€‚ã¯ã˜ã‚ã« èª°ã§ã‚‚å°‘ãªã‹ã‚‰ãšç‰©æ¬²ã¯ã‚ã‚Šã¾ã™ãŒã€ã‚ˆãè€ƒãˆãšã«å¿…è¦ãªã„ç‰©ã‚’è²·ã£ã¦å¾Œæ‚”ã—ãŸã“ã¨ã¯ã‚ã‚Šã¾ã›ã‚“ã‹ï¼Ÿ ã—ã‚‡ã£ã¡ã‚…ã†ã‚ã‚‹ã¨ã„ã†æ–¹ã¯ã“ã®ãƒ¬ã‚·ãƒ”ã‚’è©¦ã—ã¦ã¿ã¦ã‚‚ã„ã„ã‹ã‚‚ã—ã‚Œã¾ã›ã‚“ ã“ã‚“ãªäººã«ã‚ªã‚¹ã‚¹ãƒ¡ï¼ è¡å‹•è²·ã„ã‚’ã—ãªã„ã‚ˆã†ã«ã—ãŸã„ ç‰©æ¬²ã‚’ã¸ã‚‰ã—ãŸã„ ã»ã—ã„ç‰©ãŒãŸãã•ã‚“ã‚ã£ã¦ã©ã‚Œã‚’è²·ãˆã°ã„ã„ã‹è¿·ã£ã¦ã—ã¾ã† ã»ã—ãã¦è²·ã£ãŸã‘ã©ã€ã‚„ã£ã±ã‚Šã»ã‹ã®ç‰©ã‚’è²·ãˆã°ã‚ˆã‹ã£ãŸ ã“ã‚Œã‹ã‚‰ã”ç´¹ä»‹ã™ã‚‹ã€Žã»ã—ã„ç‰©ãƒªã‚¹ãƒˆã€ã‚’åˆ©ç”¨ã—ãŸã‚Šã€å‚è€ƒã«ã—ã¦ãƒªã‚¹ãƒˆã‚’ä½œã£ã¦ã„ãŸã ãã“ã¨ã§ã€ãªã«ã‚’è²·ã†ã‹ã®åˆ¤æ–ææ–™ã«ã—ãŸã‚Šã€ã¾ãšã¯ãƒªã‚¹ãƒˆã‚’ãƒã‚§ãƒƒã‚¯ã—ã¦è€ƒãˆã¦ã‹ã‚‰ç‰©ã‚’è²·ãŠã†ã¨ã„ã†æ„è˜ã«ãªã‚Šã€ç„¡é§„ãªå‡ºè²»ã‚’ãªãã™ã®ãŒç›®çš„ã§ã™ã€‚ ãƒªã‚¹ãƒˆã®ä½œæˆã¨åˆ©ç”¨ã«ã¤ã„ã¦ ã»ã—ã„ç‰©ãƒªã‚¹ãƒˆã‚’ã‚¨ã‚¯ã‚»ãƒ«ã§æ–°è¦ã«ä½œ
kazu_mori 2010/04/12
lifehack

Excel

ãŠå½¹ç«‹ã¡
ãƒªãƒ³ã‚¯
1