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

drillbits id:drillbits

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

${{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}}

åƒ•ãŸã¡Pythonistaã¯ã€ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã«ã€Excelã‚’ä½¿ã„ã¾ã™ï¼ - atsuoishimoto's diary
ã¿ã‚“ãªã€Excelä½¿ã£ã¦ã¾ã™ã‹ï¼ï¼Ÿã‚‚ã¡ã‚ã‚“ä½¿ã£ã¦ã¾ã™ãï¼ï¼Ÿä¼‘æš‡å±Šã‚‚ã€ä½œæ¥æ—¥å ±ã‚‚ã€è¦‹ç©æ›¸ã‚‚ã€ã‚¹ã‚±ã‚¸ãƒ¥ãƒ¼ãƒ«è¡¨ã‚‚ã€ã¿ãƒ¼ã‚“ãªExcelã§ã™ãï¼ï¼Ÿ ã‚‚ã¡ã‚ã‚“ã€ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã ã£ã¦Excelã§ã™ãï¼ï¼Ÿ å½“ç„¶ã§ã™ï¼ã¿ã‚“ãªãã†ã‚„ã£ã¦ä»•äº‹ã—ã¦ã‚‹ã‚“ã§ã™ï¼ Excelç‰ˆã®Twitterå…¬å¼ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã¯ã¾ã ãƒªãƒªãƒ¼ã‚¹ã•ã‚Œãªã„ã‚“ã§ã—ã‚‡ã†ã‹ï¼ï¼Ÿ ã ã‘ã©ã€Excelã§ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã—ã¦ã‚‹ã¨ã€ã¨ãã©ãã¡ã‚‡ã£ã¨ã ã‘ä¸ä¾¿ã«æ„Ÿã˜ã‚‹ã“ã¨ãŒã‚ã‚Šã¾ã™ãï¼ã„ã¡ã„ã¡ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ã«è½ã¨ã—ã¦ã‹ã‚‰å®Ÿè¡Œã—ãªã‘ã‚Œã°ãªã‚‰ãªã„ã‹ã‚‰ã§ã™ï¼ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ãªã‚“ã¦ä½Žç´šãªãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã«ã¯é–¢ã‚ã‚ŠãŸããªã„ã§ã™ãï¼ ã§ã‚‚Pythonãªã‚‰ï¼Pythonãªã‚‰å¤§ä¸ˆå¤«ï¼Pythonãªã‚‰ç›´æŽ¥Excelãƒ•ã‚¡ã‚¤ãƒ«ã‚’å®Ÿè¡Œã§ãã¾ã™ï¼Pythonã«ã¯ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã®é…å¸ƒãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã¨ã—ã¦eggã¨ã„ã†å½¢å¼ãŒæ™®åŠã—ã¦ã„ã¾ã™ãŒã€eggã¯ã‚‚ã†å¤ã„ã§ã™ã! ã“ã‚Œã‹ã‚‰ã¯xlså½¢å¼ã‚’ä½¿ã„ã¾ã—ã‚‡ã†!x
drillbits 2011/12/26
python

neta

excel
ãƒªãƒ³ã‚¯
æœ¬å½“ã«ã‚ã£ãŸã‚³ãƒ¯ã‚¤Excel
å½“ãƒ–ãƒã‚°ã¯amazon.co.jpã‚’å®£ä¼ã—ãƒªãƒ³ã‚¯ã™ã‚‹ã“ã¨ã«ã‚ˆã£ã¦ã‚µã‚¤ãƒˆãŒç´¹ä»‹æ–™ã‚’ç²å¾—ã§ãã‚‹æ‰‹æ®µã‚’æä¾›ã™ã‚‹ã“ã¨ã‚’ç›®çš„ã«è¨å®šã•ã‚ŒãŸã‚¢ãƒ•ã‚£ãƒªã‚¨ã‚¤ãƒˆå®£ä¼ãƒ—ãƒã‚°ãƒ©ãƒ ã§ã‚ã‚‹ã€ Amazonã‚¢ã‚½ã‚·ã‚¨ã‚¤ãƒˆãƒ»ãƒ—ãƒã‚°ãƒ©ãƒ ã®å‚åŠ è€…ã§ã™ã€‚ æˆ‘ã€…SEã¨ã„ã†è·ç¨®ã¯ã€ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºã®ç¾å ´ã§å®Ÿã«æ§˜ã€…ãªãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’ä½œã‚‰ã•ã‚Œã‚‹ã€‚ Wordã ã£ãŸã‚Šã€Excelã ã£ãŸã‚Šã€è¥¿æš¦2000å¹´ä»£ã¨ã„ã†æ™‚ä»£ã«ãŠã„ã¦å¯Œå£«é€šã®OASYSã§è¨è¨ˆæ›¸ã‚’æ›¸ã‹ã•ã‚ŒãŸã“ã¨ã‚‚ã‚ã‚‹ã€‚ ãã‚“ãªä¸ã€ã‚‚ã£ã¨ã‚‚å¥‡ã£æ€ªãªã®ã¯ã€ã‚„ã¯ã‚ŠExcelã§è¨˜è¿°ã•ã‚ŒãŸãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã§ã‚ã‚ã†ã€‚ æœ¬æ¥ã€è¡¨è¨ˆç®—ã‚½ãƒ•ãƒˆã§ã‚ã‚‹ã¯ãšã®ExcelãŒã€ç¾å ´ã§ã©ã®ã‚ˆã†ãªä½¿ã‚ã‚Œæ–¹ã‚’ã•ã‚Œã¦ã„ã‚‹ã®ã‹ã€‚ç†è€…ã®çµŒé¨“ã—ãŸã€å¥‡å¦™ãªExcelãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã®ã„ãã¤ã‹ã‚’ã”ç´¹ä»‹ã—ãŸã„ã¨æ€ã†ã€‚ â– Excelæ–¹çœ¼ç´™ ã„ã‚ãšã¨ã—ã‚ŒãŸã€SIæ¥ç•Œã®ä¼çµ±çš„æ‰‹æ³•ã€‚Excelæ–¹çœ¼ç´™ã§ã‚ã‚‹ã€‚ ã„ã¾ã‚„ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆã®å…¬å¼Tipsã«ã‚‚ç™»å ´ã—ã€M
drillbits 2011/05/31
excel

neta
ãƒªãƒ³ã‚¯
çŸ¥ã£ã¦ã„ã‚‹ã¨ä¾¿åˆ©ãªã‚¨ã‚¯ã‚»ãƒ«ã®11ã®ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆ | ã‚³ãƒªã‚¹
Pointy Haired Dilbertã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã‹ã‚‰ã€çŸ¥ã£ã¦ã„ã‚‹ã¨ä¾¿åˆ©ãªã‚¨ã‚¯ã‚»ãƒ«ã®11ã®ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ 11 very useful excel keyboard shortcuts you may not know [F4] or [Ctrl] + [Y] ç›´å‰ã®ä½œæ¥ã‚’ç¹°ã‚Šè¿”ã—ã¾ã™ã€‚ [Ctrl] + [;] ç¾åœ¨ã®æ—¥ä»˜ã‚’å…¥åŠ›ã—ã¾ã™ã€‚ [Ctrl] + [Shift] + [:] ç¾åœ¨ã®æ™‚åˆ»ã‚’å…¥åŠ›ã—ã¾ã™ã€‚ [Ctrl] + ['] ä¸Šã®ã‚»ãƒ«ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’ã‚³ãƒ”ãƒ¼ã—ã¾ã™ã€‚ [Shift] + [F2] ã‚»ãƒ«ã«ã‚³ãƒ¡ãƒ³ãƒˆã‚’æŒ¿å…¥ã—ã¾ã™ã€‚ [Alt] + [F8] ãƒžã‚¯ãƒãƒ€ã‚¤ã‚¢ãƒã‚°ã‚’è¡¨ç¤ºã—ã¾ã™ã€‚ [Alt] + [=] ã‚ªãƒ¼ãƒˆSUMæ•°å¼ã‚’æŒ¿å…¥ã—ã¾ã™ã€‚ [Ctrl] + [Shift] + [$] æ•°å—ã®è¡¨ç¤ºå½¢å¼ã‚’é€šè²¨ã«è¨å®šã—ã¾ã™ã€‚ [Ctrl] + [Shift] + [&] é¸æŠž
drillbits 2008/08/04
excel

tips
ãƒªãƒ³ã‚¯
EXCELãƒžã‚¯ãƒã§ã‚¬ãƒ³ãƒˆãƒãƒ£ãƒ¼ãƒˆã‚’ä½œã£ã¦ã¿ãŸ - ITãƒ¬ã‚·ãƒ”
2007-2-18 Japanese/English ã‚¹ã‚¯ãƒªãƒ¼ãƒ³ã‚·ãƒ§ãƒƒãƒˆ ã‚¹ãƒˆãƒ¼ãƒªãƒ¼ EXCELã§ã‚¬ãƒ³ãƒˆãƒãƒ£ãƒ¼ãƒˆä½œã‚‹ã®ã¯ã„ã„ã‘ã©ã€ã‚¤ãƒŠã‚ºãƒžç·šã‚’æ‰‹ã§å¼•ãã®ã¯ãªããƒ»ãƒ»ãƒ»ãƒ»ã€‚ ã£ã¦ã“ã¨ã§ã€ã‚¬ãƒ³ãƒˆãƒãƒ£ãƒ¼ãƒˆï¼ˆè©¦ä½œç‰ˆï¼‰ã‚’EXCELã§ä½œæˆã—ã¾ã—ãŸã€‚ ç·šã¯ã‚·ã‚§ã‚¤ãƒ—ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã§å¼•ãã‚ˆã†ã«ã—ã¾ã—ãŸã€‚ æ„Ÿæƒ³ï¼†è¦æœ›ãŒã‚ã£ãŸã‚‰ã‚³ãƒ¡ãƒ³ãƒˆãã ã•ã„ã€‚ 11/25(æ—¥)è¿½åŠ æ“ä½œèª¬æ˜Žã®å‹•ç”»ã‚’ä½œæˆã—ã¾ã—ãŸã€‚ã“ã¡ã‚‰ã‚’å‚ç…§ãã ã•ã„ã€‚ http://mizhiro.mitelog.jp/taskline/taskline.htm â€»å‹•ä½œç¢ºèª â—‹Excel2000 â—‹Excel2003 â—‹Excel2007 ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰(ä½œæˆã—ãŸEXCELã‚·ãƒ¼ãƒˆã¯ã‚³ãƒãƒ©ã€‚) è‹±èªžç‰ˆ(English Version)ã‚‚ä½œæˆã—ã¾ã—ãŸ(2008-07-14) Newï¼ tasklineV22.zip(10) 2008-07-1
drillbits 2008/07/23
excel

tool

vba

programming
ãƒªãƒ³ã‚¯
Webã‚¢ãƒ—ãƒªã‹ã‚‰ï¼’è¡Œã§Excelãƒ•ã‚¡ã‚¤ãƒ«ã‚’å‡ºåŠ›ã™ã‚‹æ–¹æ³• - bricklife.weblog.*
Webã‚¢ãƒ—ãƒªã‹ã‚‰ï¼’è¡Œã§Excelãƒ•ã‚¡ã‚¤ãƒ«ã‚’å‡ºåŠ›ã™ã‚‹æ–¹æ³• Webã‚¢ãƒ—ãƒªã‹ã‚‰ Excel ã‚„ Word ã®ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ãŸã£ãŸï¼’è¡Œã§ç”Ÿæˆã™ã‚‹æ–¹æ³•ã§ã™ã€‚ ã“ã®æ–¹æ³•ã‚’ä½¿ãˆã°ã€Spreadsheet::WriteExcel/ParseExcel ãªã©ã‚’ä½¿ã‚ãšã«ã€ã‹ã¤ã©ã‚“ãªç’°å¢ƒã®ã©ã‚“ãªè¨€èªžã§è¨˜è¿°ã•ã‚Œã¦ã„ã‚‹Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã§ã‚‚ã€Excelæ–‡ç« ã‚’å‡ºåŠ›ã§ãã¾ã™ã€‚åŽ³å¯†ã«è¨€ã†ã¨ã€ã€ŒExcelã‚„Wordã§ã‚‚é–‹ã‘ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ã€ãªã‚“ã§ã™ã‘ã©ã(^^; ã¯ã˜ã‚ã¦æ•™ãˆã¦ã‚‚ã‚‰ã£ãŸæ™‚ã«ã€æ„Ÿå‹•ã¨ã„ã†ã‹æ‹åæŠœã‘ã—ãŸã®ã§ã€ã¿ãªã•ã‚“ã‚‚åŒã˜æ°—æŒã¡ã‚’å‘³ã‚ã£ã¦ä¸‹ã•ã„(^^ ã‚‚ã£ãŸã„ã¶ã£ã¦èƒŒæ™¯ã‹ã‚‰ã€‚ ä¼šç¤¾ã«ãŠå‹¤ã‚ã®ã¿ãªã•ã‚“ã«ã¯å…±æ„Ÿã—ã¦ã„ãŸã ã‘ã‚‹ã¨æ€ã„ã¾ã™ãŒã€ä¸–ã®ä¸ã«ã¯ã™ã¹ã¦ã®ä½œæ¥ã‚’ Officeç³»ã‚¢ãƒ—ãƒªã§è¡Œã†æ–¹ãŒã„ã‚‰ã£ã—ã‚ƒã„ã¾ã™ã€‚ãã†ã„ã†æ–¹ãŒã€Œä»Šå¾Œâ—‹â—‹ã®ãƒ‡ãƒ¼ã‚¿ã¯ã‚µãƒ¼ãƒã§ç®¡ç†ã—ã‚ˆã†ã€ãªã©ã¨ãŠã£ã—ã‚ƒã‚Šã¯ã˜ã‚ãŸã‚‰ã€ã€ŒãŠã€ã©ã‚“ãªã‚·ã‚¹ãƒ†ãƒ ã ï¼Ÿã€ã¨æœŸå¾…
drillbits 2008/07/04
excel

html

programming

tips

web
ãƒªãƒ³ã‚¯
Rubyã§Windowsã®ExcelãŒå‹•ãã€ã™ã’ãˆã‡ï¼ : abgy
- 3 users
- abgy.jp
- å¦ã³
Rubyã§Windowsã®ExcelãŒå‹•ãã€ã™ã’ãˆã‡ï¼ abgy (2008å¹´2æœˆ10æ—¥ 15:35) å€‹åˆ¥ãƒšãƒ¼ã‚¸ ã‚³ãƒ¡ãƒ³ãƒˆ(0) ãƒˆãƒ©ãƒƒã‚¯ãƒãƒƒã‚¯(0) ã¾ãšã¯å‹•ç”» ä»¥ä¸‹ã®è¨˜è¿°ã‚’ã—ãŸRubyãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä¿å˜ã—ã¦ã€ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã‹ã‚‰å‘¼ã³å‡ºã—ã¦ã„ã¾ã™ã€‚ ã‚¨ã‚¯ã‚»ãƒ«ç«‹ã¡ä¸Šã’ã‚‹ ã‚°ãƒ©ãƒ•ã‚’æ›¸ã ã‚°ãƒ©ãƒ•ã‚’å‹•ã‹ã™ ã‚¨ã‚¯ã‚»ãƒ«è½ã¨ã™ ã‚¨ã‚¯ã‚»ãƒ«ã¯ç›´æŽ¥è§¦ã£ã¦ã„ã¾ã›ã‚“ã€‚ ä»¥ä¸‹ã€èª¬æ˜Žã€‚ WIN32OLEãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã™ã‚‹ Windowsã§ã€ExcelãŒå…¥ã£ã¦ã„ã‚‹ã“ã¨ãŒå‰æã§ã™ã€‚ WIN32OLEãƒ©ã‚¤ãƒ–ãƒ©ãƒªã¯Rubyã®æ¨™æº–ãƒ‡ã‚£ã‚¹ã¨ãƒªãƒ¼ãƒ“ãƒ¥ãƒ¼ã‚·ãƒ§ãƒ³ã§ã¤ã„ã¦ã„ã‚‹ã‚‰ã—ã„ã§ã™ãŒã€ç§ã®ç’°å¢ƒã«ã¯å…¥ã£ã¦ã„ã¾ã›ã‚“ã§ã—ãŸã€‚ãªã®ã§ã¾ãšãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã™ã‚‹ã€‚ ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã§Rubyã®ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã«ç§»å‹•ã—ãŸã‚ã¨ã€ä»¥ä¸‹ã®ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ã£ã¦ã€gemã‹ã‚‰win32oleãƒ©ã‚¤ãƒ–ãƒ©ãƒªãƒ¼ã‚’æŽ¢ã™ã€‚ gem query -rn win32ole ã“ã‚Œã§w
drillbits 2008/07/04
excel

ruby

programming

development
ãƒªãƒ³ã‚¯
http://d.hatena.ne.jp/pogostep/20080623
drillbits 2008/06/25
lifehack

neta

excel
ãƒªãƒ³ã‚¯
ExcelVBAãƒ¡ãƒ‹ãƒ¥ãƒ¼
ãƒ‰ãƒ©ã‚¤ãƒ–ãƒ»ãƒ•ã‚©ãƒ«ãƒ€ã®æ“ä½œã€ãƒ•ã‚¡ã‚¤ãƒ«ã®æ–°è¦ä½œæˆãƒ»å±•é–‹ãƒ»æ¤œç´¢ã€å±žæ€§ã®å–å¾—ãƒ»è¨å®šã€ãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä¿å˜ãƒ»é–‰ã˜ã‚‹ã€ãƒ•ã‚¡ã‚¤ãƒ«ã®å¤‰æ›´ãƒ»è¤‡å†™ãƒ»ç§»å‹•ãƒ»ä¿è·ãƒ»å‰Šé™¤
drillbits 2008/04/02
excel

vba

tips
ãƒªãƒ³ã‚¯
Excelã§ãŠä»•äº‹ï¼ã€ŒVBAåŸºæœ¬ã€ãƒ¡ãƒ‹ãƒ¥ãƒ¼
drillbits 2008/04/02
excel

vba

tips
ãƒªãƒ³ã‚¯
Office TANAKA - VBA Tips
VBAã‚³ãƒ³ãƒ†ãƒ³ãƒ„ Home Excel VBA Excel VBA Tips ã‚»ãƒ« ã‚»ãƒ«ãŒé¸æŠžã•ã‚Œã¦ã„ã‚‹ã‹åˆ¤å®šã™ã‚‹ ã‚¢ã‚¯ãƒ†ã‚£ãƒ–ã§ãªã„ã‚·ãƒ¼ãƒˆã®ã‚¢ã‚¯ãƒ†ã‚£ãƒ–ã‚»ãƒ« çµåˆã‚»ãƒ«ã‚’èª¿ã¹ã‚‹ ç°¡å˜ã«ç½«ç·šã‚’å¼•ã ã‚»ãƒ«ã®Value2ãƒ—ãƒãƒ‘ãƒ†ã‚£ ã‚ã‚‹ã‚»ãƒ«ãŒã‚»ãƒ«ç¯„å›²ã«å«ã¾ã‚Œã‚‹ã‹ã©ã†ã‹ ã‚»ãƒ«ç¯„å›²ã®æ“ä½œ ç¢ºå®Ÿã«é¸æŠžã•ã‚Œã¦ã„ã‚‹ã‚»ãƒ«ã‚’æ“ä½œã™ã‚‹ å…¥åŠ›ã•ã‚Œã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ã®æœ€çµ‚ã‚»ãƒ«ã‚’å–å¾—ã™ã‚‹ è¤‡æ•°ã®ã‚»ãƒ«ã‚’é¸æŠžã™ã‚‹ ç‰¹å®šã®ã‚»ãƒ«ç¯„å›²å†…ã‚’æ¤œç´¢ã™ã‚‹ éžè¡¨ç¤ºã®ã‚»ãƒ«ã‚’æ¤œç´¢ã™ã‚‹ ã™ã¹ã¦æ¤œç´¢ã™ã‚‹ æ—¥ä»˜ã‚’æ¤œç´¢ã™ã‚‹ 1ã¨001ã®å•é¡Œ Range(å·¦ä¸Šã‚»ãƒ«, å³ä¸‹ã‚»ãƒ«)ã®ä½¿ã„æ–¹ ã‚»ãƒ«ã®ç½«ç·šã«é–¢ã™ã‚‹ã“ã¨ new ã‚ªãƒ¼ãƒˆãƒ•ã‚£ãƒ«ã‚¿ æ›¸ãæ–¹ã®åŸºæœ¬ æ–‡å—åˆ—ã§çµžã‚Šè¾¼ã‚€ æ•°å€¤ã§çµžã‚Šè¾¼ã‚€ æ—¥ä»˜ã§çµžã‚Šè¾¼ã‚€ è‰²ã§çµžã‚Šè¾¼ã‚€ ä½œæ¥åˆ—ã§çµžã‚Šè¾¼ã‚€ çµžã‚Šè¾¼ã‚“ã çµæžœã‚’ã‚³ãƒ”ãƒ¼ã™ã‚‹ çµžã‚Šè¾¼ã‚“ã çµæžœã‚’é›†è¨ˆã™ã‚‹ çµžã‚Šè¾¼ã‚“ã çµæžœã®è¡Œã‚’æ“ä½œã™ã‚‹ ã‚ªãƒ¼ãƒˆãƒ•ã‚£ãƒ«ã‚¿ã®çŠ¶æ³ã‚’åˆ¤å®šã™ã‚‹ æ•°å¼ã®ã‚¨ãƒ©ãƒ¼ã§çµžã‚Š
drillbits 2008/04/02
excel

vba

tips
ãƒªãƒ³ã‚¯
å¤§ãã„ï¼é‡ã„ï¼ã‚¨ã‚¯ã‚»ãƒ«ãƒ•ã‚¡ã‚¤ãƒ«ã®ç›´ã—æ–¹ - ãŠã¨ã†ã•ã‚“ã®ã¤ã‚Œã¥ã‚ŒLifehackï¼ˆãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ï¼‰
å¦™ã«ã‚µã‚¤ã‚ºãŒå¤§ãã„ã‚¨ã‚¯ã‚»ãƒ«ãƒ•ã‚¡ã‚¤ãƒ«ã£ã¦ã‚ã‚Šã¾ã™ãã€‚ãƒ•ã‚¡ã‚¤ãƒ«ã‚’é–‹ãã®ã«æ™‚é–“ã‚‚ã‹ã‹ã‚‹ã—ã€ä¸‹æ‰‹ã™ã‚Šã‚ƒãƒ•ãƒªãƒ¼ã‚ºã™ã‚‹ã“ã¨ã‚‚ã‚ã‚‹ã€‚ãƒ¡ãƒ¼ãƒ«ã§é€ã‚ã†ã¨ã—ã¦ã‚‚ç¤¾å†…ã®ã‚µã‚¤ã‚ºåˆ¶é™ã«ã²ã£ã‹ã‹ã£ã¦ã—ã¾ã†ã€‚ã˜ã‚ƒã‚åœ§ç¸®ã—ã¦é€ã‚ã†ã¨æ€ã£ã¦ã‚‚ã€ç°¡å˜ã«ãƒ•ã‚¡ã‚¤ãƒ«ã‚’è¦‹ã¦ã‚‚ã‚‰ã„ã«ãããªã‚‹ã®ã§ã‚ã¾ã‚Šåœ§ç¸®ã¯ã—ãŸããªã„ã€‚ ãã‚“ãªãƒ•ã‚¡ã‚¤ãƒ«ã‚µã‚¤ã‚ºãŒå¤§ããã¦é‡ã„ã‚¨ã‚¯ã‚»ãƒ«ãƒ•ã‚¡ã‚¤ãƒ«ã«éé‡ã—ãŸã‚‰ã©ã†ã™ã‚‹ã®ã‹ã€‚è‡ªåˆ†ã¯ã“ã‚“ãªæ–¹æ³•ã§ã‚¨ã‚¯ã‚»ãƒ«ãƒ•ã‚¡ã‚¤ãƒ«ã‚’å°ã•ãã—ã¦ã„ã¾ã™ã€‚ è²¼ã‚Šä»˜ã‘ã®å›³ã‚„å†™çœŸã‚’åœ§ç¸®ã™ã‚‹ ãƒ‡ã‚¸ã‚«ãƒ¡å†™çœŸã‚’ãã®ã¾ã¾ãºã‚¿ãƒªã¨è²¼ã£ã¦ã‚ã‚‹å ´åˆãªã©ã¯ã€å·¨å¤§ãªã‚¨ã‚¯ã‚»ãƒ«ãƒ•ã‚¡ã‚¤ãƒ«ã«ãªã‚ŠãŒã¡ã§ã™ã€‚ã¾ãšã¯ãã‚“ãªç”»åƒã‚’å°ã•ãã—ã¾ã™ã€‚ å•é¡Œã®å†™çœŸã‚„å›³ã‚’å³ã‚¯ãƒªãƒƒã‚¯ å›³ã®æ›¸å¼è¨å®šâ†’å›³ï¼ˆã‚¿ãƒ–ï¼‰â†’åœ§ç¸® è§£åƒåº¦ã‚’ï¼·ï½…ï½‚/ç”»é¢ è§£åƒåº¦96ï½„ï½ï½‰ ãƒˆãƒªãƒŸãƒ³ã‚°ãªã©ã®ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã«ã‚‚ãƒã‚§ãƒƒã‚¯ ã“ã†ã™ã‚‹ã“ã¨ã§ç”»åƒãŒå°ã•ããªã‚Šã¾ã™ã€‚ å›³ã‚„å†™çœŸã‚’ãƒ•ã‚¡ã‚¤ãƒ«ã‹ã‚‰æŒ¿å…¥ã™ã‚‹ å•é¡Œã®å›³ã‚„å†™çœŸãŒå°‘ãªã„ã‚ˆã†ãª
drillbits 2008/04/02
excel

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

programming

vba

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

tips

business
ãƒªãƒ³ã‚¯
ã¡ã‚‡ã£ã¨è¦šãˆã¦ãŠãã¨ä¾¿åˆ©ãªExcelã®ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆ5ã¤ | P O P * P O P
Excelã‚’ã‚ˆãåˆ©ç”¨ã™ã‚‹æ–¹ã¯è¦šãˆã¦ãŠãã¨ä¾¿åˆ©ãªã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã®ã”ç´¹ä»‹ã€‚ã¡ã‚‡ã£ã¨çŸ¥ã£ã¦ã„ã‚‹ã ã‘ã§æ ¼æ®µã«ä½œæ¥ã‚¹ãƒ”ãƒ¼ãƒ‰ãŒé€Ÿããªã‚‹ã“ã¨ã‚‚ã€‚TechJiveã‹ã‚‰ã®æƒ…å ±ã§ã™ã€‚ Â» Excel Keystrokes ï¼ˆvia TechJiveï¼‰ ã€ŒCtrl+Spaceã€ :ãã®åˆ—å…¨ä½“ã‚’é¸æŠžã€‚ ã€ŒShift+Spaceã€ :ãã®è¡Œå…¨ä½“ã‚’é¸æŠžã€‚ ã€ŒCtrl+çŸ¢å°ã‚ãƒ¼ã€ :ãƒ‡ãƒ¼ã‚¿ãŒå…¥åŠ›ã•ã‚Œã¦ã„ã‚‹ç¯„å›²ã®å…ˆé è¡Œï¼ˆâ†‘ ï¼‰ã€æœ«å°¾è¡Œï¼ˆâ†“ï¼‰ã€å³ç«¯åˆ—ï¼ˆâ†’ï¼‰ã€å·¦ç«¯åˆ—ï¼ˆâ†ï¼‰ã«ç§»å‹•ã€‚ ã€ŒCtrl+Page Up/Page Downã€ :ãƒ¯ãƒ¼ã‚¯ã‚·ãƒ¼ãƒˆé–“ã®ç§»å‹•ã€‚ ã€ŒCtrl+Homeã€ :ãã®ã‚·ãƒ¼ãƒˆã®A1ã®ã‚»ãƒ«ã¸ç§»å‹•ï¼ˆã‚¦ã‚£ãƒ³ãƒ‰ã‚¦æž ã‚’å›ºå®šã—ã¦ã„ã‚‹å ´åˆã¯ã€ãã®ä¸‹ã®ã‚»ãƒ«ï¼‰ã€‚ ã¡ãªã¿ã«å€‹äººçš„ã«ã‚ˆãä½¿ã†ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã¯ä»¥ä¸‹ã®ã‚ˆã†ãªã‚‚ã®ã§ã—ã‚‡ã†ã‹ã€‚ ã€ŒCtrl+1ã€ :ã‚»ãƒ«ã®æ›¸å¼è¨å®šã‚’é¸æŠžã€‚ ã€ŒShift+Enterã€ :ä¸Šã®è¡Œ/å·¦ã®åˆ—ã«ç§»å‹•ï¼ˆ
drillbits 2008/03/14
excel

shortcut

business
ãƒªãƒ³ã‚¯
1