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

m_hatayama id:m_hatayama

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

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

IDEA * IDEA
ãƒ‰ãƒƒãƒˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä»£è¡¨ã®ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ãƒ–ãƒã‚°
m_hatayama 2009/06/13
excel
ãƒªãƒ³ã‚¯
ç¬¬97å›ž ã“ã‚Œã ã‘ã¯æŠ¼ã•ãˆã¦ãŠããŸã„ã‚¨ã‚¯ã‚»ãƒ«ã®çŸ¥è˜ã€€ã€€å‰ç·¨ - bingo_nakanishiã®ä»–è¨€èªžå‡ºèº«è€…ã®ãŸã‚ã®Perlå…¥é–€
æ–°ç¤¾ä¼šäººã«ãªã£ã¦ã€æ¥å‹™ã‚’ä¸Žãˆã‚‰ã‚Œã‚‹ã‚ˆã†ã«ãªã‚‹ã¨ ã‚¨ã‚¯ã‚»ãƒ«ã‚’ã‚¬ã‚·ã‚¬ã‚·ä½¿ã£ã¦ã„ãã“ã¨ã«ãªã‚‹ã¨æ€ã„ã¾ã™ã€‚ ä»Šå›žã¯ã€ã“ã‚Œã ã‘ã¯æŠ¼ã•ãˆã¦ãŠããŸã„ã‚¨ã‚¯ã‚»ãƒ«ã®çŸ¥è˜ã§ã™ã€‚ ãã®1.ã€€çµ¶å¯¾å‚ç…§ã€€ã¨ã€€ç›¸å¯¾å‚ç…§ çµ¶å¯¾å‚ç…§ã¨ç›¸å¯¾å‚ç…§ã‚’ç†è§£ã™ã‚‹ã«ã¯ã€ ä¹ä¹ã®è¡¨ã‚’ã¤ãã£ã¦ã¿ã‚‹ã¨è‰¯ã„ã§ã—ã‚‡ã†ã€‚ 1*1 = 1 ... 9*9 = 81ã¨å°å¦ç”Ÿã®ã¨ãã«å¿…æ»ã«è¦šãˆãŸã‚¢ãƒ¬ã§ã™ã€‚ å³ä¸Šã®ã€æ•°å¼ãƒãƒ¼ã«æ³¨ç›®ã—ã¦ãã ã•ã„ã€‚ =C$2*$B3ã¨ãªã£ã¦ã„ã¾ã™ã€‚$ã¯ã€å›ºå®šã‚’ã‚ã‚‰ã‚ã—ã¦ã„ã¾ã™ã€‚ ãªã‚“ã§ã€€$ ãªã®?? ã€ŒSã«ç¸¦æ£’ãŒåˆºã•ã£ã¦ã€å›ºå®šã—ã¦ã„ã‚‹ã¿ãŸã„ã«è¦‹ãˆã‚‹ã‹ã‚‰$ã€ ã¨ã€ç§ã¯å¼·å¼•ã«è¦šãˆã¦ã¿ã¾ã—ãŸã€‚ ã“ã®$ãŒä½¿ã„ã“ãªã›ã‚‹ã¨ã‚¨ã‚¯ã‚»ãƒ«ã‚’ä½¿ã†ã®ãŒæ¥½ã«ãªã‚Šã¾ã™ã€‚ çµ¶å¯¾å‚ç…§ã¨ã¯ ã‚»ãƒ«ã‚’ãƒ•ã‚£ãƒ«ã§é¸æŠžã—ã¦ã‚³ãƒ”ãƒ¼ã—ã¦ã‚‚ã€åŒã˜å ´æ‰€ã‚’æŒ‡ã—ã¦ã„ã‚‹ã“ã¨ ç›¸å¯¾å‚ç…§ã¨ã¯ ã‚»ãƒ«ã‚’ãƒ•ã‚£ãƒ«ã§é¸æŠžã—ã¦ã‚³ãƒ”ãƒ¼ã™ã‚‹ã¨ã€æŒ‡ã—ã¦ã„ã‚‹ã¨ã“ã‚ãŒå¤‰ã‚ã£ã¡ã‚ƒã†ã“ã¨ï¼ˆã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ã‚¿ãƒ«ã€ãƒ‡ã‚¯
m_hatayama 2009/05/21
excel
ãƒªãƒ³ã‚¯
VBAå¿œç”¨(çµ¶å¯¾ãƒ‘ã‚¹æŒ‡å®šã¨ç›¸å¯¾ãƒ‘ã‚¹æŒ‡å®š)
æŽ²ç¤ºæ¿ã«æ™‚ã€…æŒ™ã’ã‚‰ã‚Œã‚‹è©±é¡Œã§ã™ã€‚ ã€Œã‚«ãƒ¬ãƒ³ãƒˆãƒ•ã‚©ãƒ«ãƒ€ã€ã¨ã‹ã€Œã‚«ãƒ¬ãƒ³ãƒˆãƒ‘ã‚¹ã€ãŒã€è¨€è‘‰ã ã‘ãã®ã¾ã¾ä¸€äººæ©ãã™ã‚‹ãŸã‚ã€çµæ§‹ã€èª¤è§£ã•ã‚ŒãŸã¾ã¾ã§æ¸ˆã¾ã•ã‚Œã¦ã„ã‚‹ã®ã§ã¯ï¼Ÿã€ã¨ç–‘å•ã«ãªã‚Šã¾ã—ãŸã€‚ ã€Œç›¸å¯¾ãƒ‘ã‚¹æŒ‡å®šã€ã‚’ä½¿ã†é™ã‚Šã¯ã€Œã‚«ãƒ¬ãƒ³ãƒˆãƒ•ã‚©ãƒ«ãƒ€ã€ãŒèµ·ç‚¹ã«ãªã‚‹ã®ã§ãã®æ‰€åœ¨ã¯é‡è¦ãªã®ã§ã™ãŒã€Excelã®å ´åˆã¯ã€å‰å¾Œã«è¡Œãªã†ã€Œãƒ•ã‚¡ã‚¤ãƒ«ã‚’é–‹ãã€ã®æ“ä½œãªã©ã§ã€Œã‚«ãƒ¬ãƒ³ãƒˆãƒ•ã‚©ãƒ«ãƒ€ã€ã¯ä¸€å®šã—ã¾ã›ã‚“ã€‚ ã“ã®çŠ¶æ³ã‚’çŸ¥ã‚‰ãªã„ã§ã€ã€Œã‚«ãƒ¬ãƒ³ãƒˆãƒ•ã‚©ãƒ«ãƒ€ã€ã¨ã¯ã€Œãã®ãƒ–ãƒƒã‚¯ã‚’é–‹ã„ãŸãƒ•ã‚©ãƒ«ãƒ€ã®ã“ã¨ã€ã¨ä¿¡ã˜ã¦ã—ã¾ã£ã¦ã„ã‚‹äººãŒå¤šã„ã‚ˆã†ãªæ°—ãŒã—ã¾ã™ã€‚ ã€Œã‚«ãƒ¬ãƒ³ãƒˆãƒ•ã‚©ãƒ«ãƒ€ã€ã¨ã¯ã©ã“ï¼Ÿ ã€Œã‚«ãƒ¬ãƒ³ãƒˆãƒ•ã‚©ãƒ«ãƒ€ã€ã¯ã€ã€ŒCurDiré–¢æ•°ã€ã§å–å¾—ã§ãã¾ã™ã€‚ã“ã‚ŒãŒã©ã“ã®ãƒ•ã‚©ãƒ«ãƒ€ã‚’æŒ‡ã—ã¦ã„ã‚‹ã®ã‹ç¢ºèªã—ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ ã¾ãšã€ã‚¹ã‚¿ãƒ¼ãƒˆãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‹ã‚‰å˜ç´”ã«ã€ŒMicrosoft Excelã€ã‚’é–‹ãã¾ã™ã€‚ ç¶šã„ã¦ã€ã€ŒVisual Basic Editorã€ã‚’é–‹ãã¾ã™ã€‚ï¼ˆAlt
m_hatayama 2008/04/03
excel

vba
ãƒªãƒ³ã‚¯
ã‚»ãƒ«ã‚’çµåˆã—ã¦ä¸å¤®æƒãˆã®ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã‚ãƒ¼:Excel(ã‚¨ã‚¯ã‚»ãƒ«)ã®ä½¿ã„æ–¹/ã‚ãƒ¼ãƒœãƒ¼ãƒ‰æ“ä½œ
â–¼æ“ä½œæ‰‹é †ï¼šã‚»ãƒ«ã‚’çµåˆã—ã¦ä¸å¤®æƒãˆãƒœã‚¿ãƒ³ã®ã‚¢ã‚¯ã‚»ã‚¹ã‚ãƒ¼ã‚’è¡¨ç¤ºã™ã‚‹ ãƒ¡ãƒ‹ãƒ¥ãƒ¼ï¼»ãƒ„ãƒ¼ãƒ«ï¼½âˆ’ï¼»ãƒ¦ãƒ¼ã‚¶ãƒ¼è¨å®šï¼½ã‚’ã‚¯ãƒªãƒƒã‚¯ â†“ ï¼»æ›¸å¼è¨å®šï¼½ãƒ„ãƒ¼ãƒ«ãƒãƒ¼âˆ’ï¼»ã‚»ãƒ«ã‚’çµåˆã—ã¦ä¸å¤®æƒãˆï¼½ãƒœã‚¿ãƒ³ä¸Šã§å³ã‚¯ãƒªãƒƒã‚¯ â†“ ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆãƒ¡ãƒ‹ãƒ¥ãƒ¼ï¼»ã‚¤ãƒ¡ãƒ¼ã‚¸ã¨ãƒ†ã‚ã‚¹ãƒˆã‚’è¡¨ç¤ºï¼½ã‚’ã‚¯ãƒªãƒƒã‚¯ â†“ ï¼»ãƒ¦ãƒ¼ã‚¶ãƒ¼è¨å®šï¼½ãƒ€ã‚¤ã‚¢ãƒã‚°âˆ’ï¼»é–‰ã˜ã‚‹ï¼½ãƒœã‚¿ãƒ³ã‚’ã‚¯ãƒªãƒƒã‚¯ ä¸Šè¨˜ã®æ“ä½œã‚’ã™ã‚‹ã¨ã€é€šå¸¸ã‚¤ãƒ¡ãƒ¼ã‚¸ã ã‘ãŒè¡¨ç¤ºã•ã‚Œã¦ã„ã‚‹ï¼»ã‚»ãƒ«ã‚’çµåˆã—ã¦ä¸å¤®æƒãˆï¼½ãƒœã‚¿ãƒ³ã«ã€ã€Œã‚»ãƒ«ã‚’çµåˆã—ã¦ä¸å¤®æƒãˆ(M)ã€ã¨ã„ã†æ–‡å—ã‚‚è¡¨ç¤ºã•ã‚ŒãŸçŠ¶æ…‹ã¨ãªã‚Šã¾ã™ã€‚ ã€Œ(M)ã€ã¨è¡¨ç¤ºã•ã‚Œã¦ã„ã‚‹ã¨ã„ã†ã“ã¨ã¯ã€ï¼»Mï¼½ã‚ãƒ¼ãŒï¼»ã‚»ãƒ«ã‚’çµåˆã—ã¦ä¸å¤®æƒãˆï¼½ã‚³ãƒžãƒ³ãƒ‰ã®ã‚¢ã‚¯ã‚»ã‚¹ã‚ãƒ¼ã§ã‚ã‚‹ã“ã¨ã‚’è¡¨ã—ã¦ã„ã¾ã™ã€‚ ã§ã™ã‹ã‚‰ã€è¤‡æ•°ã®ã‚»ãƒ«ã‚’é¸æŠžã—ã¦ãŠã„ã¦ï¼»Altï¼½ï¼‹ï¼»Mï¼½ã‚ãƒ¼ã‚’æŠ¼ã›ã°ã€ï¼»ã‚»ãƒ«ã‚’çµåˆã—ã¦ä¸å¤®æƒãˆï¼½ãŒè¡Œã‚ã‚Œã¾ã™ã€‚ ãªãŠã€ï¼»ã‚»ãƒ«ã‚’çµåˆã—ã¦ä¸å¤®æƒãˆï¼½ãƒœã‚¿ãƒ³ã§ã€Excel 2002ã‹ã‚‰ã¯è§£é™¤ã‚‚ã§ãã‚‹ã‚ˆã†ã«
m_hatayama 2008/03/24
Alt + Mã§ã€‚å‰²ã‚Šå½“ã¦ã‚‹æ–¹æ³•

excel

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

excel
ãƒªãƒ³ã‚¯
ç„¡æ–™æ›¸å¼ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã€€ã„ãŸã ãå›ï¼ˆA ç”Ÿç”£ãƒ»è£½é€ ï¼ç ”ç©¶é–‹ç™ºãƒ»è¨è¨ˆï¼‰
ç„¡æ–™æ›¸å¼ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆ å·¥å ´ç”Ÿç”£ãƒ»è£½é€ äººäº‹ãƒ»è³ƒé‡‘ çµŒå–¶æˆ¦ç•¥ãƒ»çµŒå–¶ä¼ç”» ç·å‹™ãƒ»çµŒç†ãƒ»ç§˜æ›¸ å–¶æ¥ãƒ»è²©å£² ç¤¾å“¡æ•™è‚²ãƒ»ç ”ä¿® ç ”ç©¶é–‹ç™ºãƒ»è¨è¨ˆ æƒ…å ±ã‚·ã‚¹ãƒ†ãƒ éƒ¨é–€ å»ºè¨æ¥ ç—…åŒ»é™¢ â— æ›¸å¼ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã„ãŸã ãå›ã¯ã™ã¹ã¦ç„¡æ–™ã§ãŠä½¿ã„é ‚ã‘ã¾ã™ã€‚ â— ç™»éŒ²ãªã©ã®é¢å€’ãªæ‰‹ç¶šãã¯ä¸€åˆ‡ã‚ã‚Šã¾ã›ã‚“ã€ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ã™ããŠä½¿ã„é ‚ã‘ã¾ã™ã€‚ â— å„åˆ†é‡Žã”ã¨ã«æ§˜ã€…ãªãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆãŒã‚ã‚Šã¾ã™ã®ã§ã€ãŠä»•äº‹ã«æ˜¯éžãŠå½¹ç«‹ã¦ãã ã•ã„ã€‚
m_hatayama 2007/04/10
ä»•äº‹ã§ä½¿ãˆã‚‹ã‚¨ã‚¯ã‚»ãƒ«ã‚„ãƒ¯ãƒ¼ãƒ‰ã®ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆé›†

excel

lifehack
ãƒªãƒ³ã‚¯
personal.xls å¼·åŒ–è¬›åº§ ãã®ï¼’
EXCELã«ã¯æ¨™æº–ã§ã•ã¾ã–ã¾ãªã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã‚ãƒ¼ãŒç”¨æ„ã•ã‚Œã¦ã„ã¾ã™ã€‚ï¼ˆæ¨™æº–ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã‚ãƒ¼ã¯ã“ã¡ã‚‰ï¼‰ ã“ã®ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã‚ãƒ¼ã‚’ä½¿ã„ã“ãªã›ã‚‹ã‚ˆã†ã«ãªã‚‹ã¨ã€ ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‹ã‚‰æ‰‹ã‚’é›¢ã—ã¦ãƒžã‚¦ã‚¹ã‚’æ“ä½œã™ã‚‹ã“ã¨ç„¡ã—ã«ã€ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã ã‘ã§ã„ã‚ã„ã‚ãªæ“ä½œãŒå‡ºæ¥ã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã®ã§ã€ä½œæ¥åŠ¹çŽ‡ãŒå¤§å¤‰å‘ä¸Šã—ã¾ã™ã€‚ ã—ã‹ã—ã€EXCELã®æ©Ÿèƒ½ã®ä¸ã«ã¯ãƒžã‚¦ã‚¹ã‚’æ“ä½œã—ãªã„ã¨ã„ã‘ãªã„æ©Ÿèƒ½ï¼ˆã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆãŒç”¨æ„ã•ã‚Œã¦ã„ãªã„æ©Ÿèƒ½ï¼‰ã‚‚æ•°å¤šãå˜åœ¨ã—ã¾ã™ã€‚ EXCELæ“ä½œã®ç”Ÿç”£æ€§ã‚’å‘ä¸Šã•ã›ã‚‹ãŸã‚ã«ã¯ã€æ¨™æº–ã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã‚„ãƒ•ã‚¡ãƒ³ã‚¯ã‚·ãƒ§ãƒ³ã‚ãƒ¼ã‚’æ´»ç”¨ã—ã¦ãªã‚‹ã¹ãã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‹ã‚‰æ‰‹ã‚’é›¢ã•ãšã«ä½œæ¥ã§ãã‚‹ã‚ˆã†ã«ãªã‚‹ã“ã¨ãŒé‡è¦ã§ã™ãŒã€ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‹ã‚‰æ“ä½œã™ã‚‹ã‚ˆã†ãªæ©Ÿèƒ½ã¯ã©ã†ã—ã¦ã‚‚ãƒžã‚¦ã‚¹ã‚’ä½¿ã†ã“ã¨ã«ãªã‚Šã€ä½œæ¥ãŒé€”åˆ‡ã‚Œã‚‹ã¨åŒæ™‚ã«ã€æ€è€ƒã‚‚ä¸æ–ã•ã‚Œã¦ã—ã¾ã„ã¾ã™ã€‚ ã“ã“ã§ã¯ã€ç§ãŒæ™®æ®µEXCELã‚’ä½¿ã£ã¦ã„ã¦ä¸ä¾¿ã«æ„Ÿã˜ã¦ã„ãŸå•é¡Œã‚’è§£æ¶ˆã™ã‚‹ãŸã‚ã«é–‹ç™ºã—
m_hatayama 2007/03/28
ã‚»ãƒ«ã®çµåˆã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆ*ç™»éŒ²ã®ä»•æ–¹ãŒã¾ã åˆ†ã‹ã‚‰ãš

excel
ãƒªãƒ³ã‚¯
ITmedia Biz.IDï¼šExcelãŒãŠã‹ã—ã„ã¨ãã®å¯¾å‡¦æ³•
ã‚ã‚Œï¼Ÿ Excelã®å‹•ä½œãŒãŠã‹ã—ã„ã€‚ãã‚“ãªæ™‚ã¯ã€ã„ã¤ã®é–“ã«ã‹è¨å®šãŒå¤‰æ›´ã•ã‚Œã¦ã„ãªã„ã‹ç¢ºèªã—ã‚ˆã†ã€‚ã‚«ãƒ¼ã‚½ãƒ«ã‚ãƒ¼ã§ã‚¹ã‚¯ãƒãƒ¼ãƒ«ã—ã¦ã—ã¾ã£ãŸã‚Šã€åˆ—ã®è¦‹å‡ºã—ãŒ1234â€¦â€¦ã«ãªã£ã¦ã„ãŸã‚Šã—ãŸã‚‰è¦ãƒã‚§ãƒƒã‚¯ã€‚ã¾ãŸè¤‡æ•°ã®ãƒã‚¤ãƒ‘ãƒ¼ãƒªãƒ³ã‚¯ã‚’ã¾ã¨ã‚ã¦æ¶ˆã™æ–¹æ³•ã‚‚ã€‚ ãƒ“ã‚¸ãƒã‚¹ãƒ‘ãƒ¼ã‚½ãƒ³ã®å¿…æºãƒ„ãƒ¼ãƒ«ã€ŒExcelã€ã€‚ã—ã‹ã—ä½¿ã£ã¦ã„ã‚‹ã†ã¡ã«ã€ã€Œã‚ã‚Œ!?ã€ã¨æ€ã†ã‚ˆã†ãªä¸æ€è°ãªå‹•ä½œã‚’ã—ã¦ã—ã¾ã†ã“ã¨ãŒãªã„ã ã‚ã†ã‹ã€‚Excelã®å‹•ä½œãŒãŠã‹ã—ããªã£ã¦ã—ã¾ã£ãŸã¨ãã®å¯¾å‡¦æ³•ã‚’ç´¹ä»‹ã™ã‚‹ã€‚ ã‚«ãƒ¼ã‚½ãƒ«ã‚ãƒ¼ã§ã‚¹ã‚¯ãƒãƒ¼ãƒ«ã—ã¦ã—ã¾ã† ã‚«ãƒ¼ã‚½ãƒ«ã‚ãƒ¼ï¼ˆçŸ¢å°ã‚ãƒ¼ï¼‰ã§é¸æŠžã™ã‚‹ã‚»ãƒ«ã‚’å‹•ã‹ãã†ã¨ã—ãŸã‚‰ã€ã‚ã‚Œï¼Ÿ ã‚·ãƒ¼ãƒˆè‡ªä½“ãŒã‚¹ã‚¯ãƒãƒ¼ãƒ«ã—ã¦ã—ã¾ã†â€¦â€¦ã€‚ãƒžã‚¦ã‚¹ã¨ã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã‚’ä½µç”¨ã—ã¦Excelã‚’ä½¿ã†äººã¯ã€å¸Œã«ã“ã†ã—ãŸè‡ªä½“ã«é™¥ã£ã¦ã—ã¾ã†ã“ã¨ãŒã‚ã‚‹ã€‚ ã“ã†ãªã£ãŸç†ç”±ã¯ï¼»ScrLkï¼½ï¼ˆã‚¹ã‚¯ãƒãƒ¼ãƒ«ãƒãƒƒã‚¯ï¼‰ã‚ãƒ¼ãŒã‚ªãƒ³ã«ãªã£ã¦ã„ã‚‹ã›ã„ã ã€‚æ…Œã¦ãšã‚ãƒ¼ãƒœãƒ¼ãƒ‰ã®ï¼»ScrLkï¼½ã‚’æŠ¼ã—ã¦è§£é™¤
m_hatayama 2007/03/28
ã€Œæ–‡æ›¸æ§‹æˆã€ï¼ã€Œã‚ªãƒ¼ãƒˆã‚³ãƒ¬ã‚¯ãƒˆã®ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã€ã‚’é–‹ãã€ã€Œ2æ–‡å—ç›®ã‚’å°æ–‡å—ã«ã™ã‚‹ã€ã¨ã€Œæ–‡ã®å…ˆé æ–‡å—ã‚’å¤§æ–‡å—ã«ã™ã‚‹ã€ã®ãƒã‚§ãƒƒã‚¯ã‚’å¤–ã™

excel
ãƒªãƒ³ã‚¯
i d e a * i d e a - Excelã§ã‚¦ãƒ«ãƒˆãƒ©ã‚·ãƒ³ãƒ—ãƒ«ãªã‚°ãƒ©ãƒ•ã‚’ä½œæˆã™ã‚‹æ–¹æ³•
ãƒ‰ãƒƒãƒˆã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ä»£è¡¨ã®ãƒ©ã‚¤ãƒ•ãƒãƒƒã‚¯ãƒ–ãƒã‚°
m_hatayama 2006/08/12
excel

tips
ãƒªãƒ³ã‚¯
1