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

frsh_mt id:frsh_mt

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

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

VBAåŸºç¤Žæ–‡æ³•æœ€é€Ÿãƒžã‚¹ã‚¿ãƒ¼ - ã„ã‚ã„ã‚è§£æžæ—¥è¨˜
VBAã®æ–‡æ³•ä¸€è¦§ã§ã™ã€‚ä»–ã®è¨€èªžã‚’ã‚ã‚‹ç¨‹åº¦çŸ¥ã£ã¦ã„ã‚‹äººã¯ã“ã‚Œã‚’èªã‚ã°VBAã®åŸºç¤Žã‚’ãƒžã‚¹ã‚¿ãƒ¼ã—ã¦VBAã‚’æ›¸ãã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã¾ã™ã€‚ç°¡æ˜“ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã¨ã—ã¦ã‚‚åˆ©ç”¨ã§ãã‚‹ã¨æ€ã„ã¾ã™ã®ã§ã€ã“ã‚Œã¯è¶³ã‚Šãªã„ã¨æ€ã†ã‚‚ã®ãŒã‚ã‚Œã°æ•™ãˆã¦ãã ã•ã„ã€‚ 1. åŸºç¤Ž Visual Basic Editorã®èµ·å‹• VBAã¯Visual Basic Editorã§ç·¨é›†ãƒ»å®Ÿè¡Œã—ã¾ã™ã€‚Visual Basic Editorã¯æ¬¡ã®ã‚ˆã†ã«èµ·å‹•ã—ã¾ã™ã€‚ Excelã‚„Wordã®ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã§[ãƒ„ãƒ¼ãƒ«]-[ãƒžã‚¯ãƒ]-[Visual Basic Editor]ã‚’é¸æŠžã™ã‚‹ æ¨™æº–ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã®è¿½åŠ VBAã¯æ¨™æº–ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã«è¨˜è¿°ã—ã¾ã™ã€‚æ¨™æº–ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¯æ¬¡ã®ã‚ˆã†ã«è¿½åŠ ã—ã¾ã™ã€‚ Visual Basic Editorã®ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã§[æŒ¿å…¥]-[æ¨™æº–ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«]ã‚’é¸æŠžã™ã‚‹ã€‚ å¤‰æ•°å®£è¨€ã®å¼·åˆ¶ å¤‰æ•°å®£è¨€ã‚’å¼·åˆ¶ã™ã‚‹ãŸã‚ã€ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã®å…ˆé ã«å¿…ãšä»¥ä¸‹ã®è¡Œã‚’æ›¸ã
frsh_mt 2010/01/31
excel

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

office

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

excel

office

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

tips

excel

ã¾ã¨ã‚
ãƒªãƒ³ã‚¯
3åˆ†LifeHackingï¼šExcelã®ã€Œã‚»ãƒ«å†…æ”¹è¡Œã€ã‚’ã¾ã¨ã‚ã¦å–ã‚Šé™¤ã - ITmedia Biz.ID
Excelã§ã‚»ãƒ«å†…æ”¹è¡Œã‚’ã™ã‚‹ã«ã¯ï¼»Altï¼½ï¼‹ï¼»Enterï¼½ã€‚ã§ã¯ã€ã“ã®ã‚»ãƒ«å†…æ”¹è¡Œã‚’ã¾ã¨ã‚ã¦å–ã‚Šé™¤ãã«ã¯ï¼»Ctrlï¼½ï¼‹ï¼»Jï¼½ã‚’ä½¿ãŠã†ã€‚ã•ã‚‰ã«ã“ã®ï¼»Ctrlï¼½ï¼‹ï¼»Jï¼½ã«ã¯ä¾¿åˆ©ãªåˆ©ç”¨æ–¹æ³•ã‚‚ã‚ã‚‹ã®ã ã€‚ Excelã®ã‚»ãƒ«å†…ã§æ–‡å—åˆ—ã‚’æ”¹è¡Œã—ãŸã„å ´åˆï¼»Altï¼½ï¼‹ï¼»Enterï¼½ã‚’æŠ¼ã™ã¨ã„ã†ãƒ¯ã‚¶ã¯ã€Excelã‚’æ‰±ã†ä¸Šã§ãœã²çŸ¥ã£ã¦ãŠããŸã„ã€‚ã‚¹ãƒšãƒ¼ã‚¹ã‚’é€£ç¶šå…¥åŠ›ã—ã¦ç”»é¢ä¸Šã§ç„¡ç†ã‚„ã‚Šæ”¹è¡Œã™ã‚‹ã¨ã€ã‚»ãƒ«å¹…ã‚’å¤‰æ›´ã—ãŸéš›ã«ã‚ºãƒ¬ã¦ã—ã¾ã†ã—ã€è¦‹ãŸç›®ã¯ã¡ã‚ƒã‚“ã¨æ”¹è¡Œã§ãã¦ã„ã¦ã‚‚ã†ã¾ãå°åˆ·ã§ããªã„ã“ã¨ã‚‚å¤šã„ã€‚Officeã®äº’æ›ã‚½ãƒ•ãƒˆã§é–‹ã„ãŸå ´åˆã«ã‚ºãƒ¬ã‚‹åŽŸå› ã«ã‚‚ãªã‚‹ã€‚ ã§ã¯ã€ï¼»Altï¼½ï¼‹ï¼»Enterï¼½ã§æ”¹è¡Œã—ãŸãƒ†ã‚ã‚¹ãƒˆã‚’å…ƒã®1è¡Œã®ãƒ†ã‚ã‚¹ãƒˆã«æˆ»ã™ãŸã‚ã«ã¯ã©ã†ã™ã‚Œã°ã‚ˆã„ã ã‚ã†ã‹ã€‚ ã‚‚ã¡ã‚ã‚“ã€ï¼»Backspaceï¼½ã‚„ï¼»Deleteï¼½ã§æ”¹è¡Œã‚’1ã¤ãšã¤å‰Šé™¤ã—ã¦ã‚‚ã‚ˆã„ã®ã ãŒã€æ”¹è¡ŒãŒå¤šã„å ´åˆã¯é¢å€’ãã•ã„ã€‚ã“ã†ã—ãŸå ´åˆã¯ã€Excelã®ç½®æ›æ©Ÿèƒ½ã‚’ç”¨ã„ã‚‹
frsh_mt 2007/12/21
ITmedia

office

excel

tips
ãƒªãƒ³ã‚¯
ITmedia Biz.IDï¼šExcelã®ãŠç¯€ä»‹ã‚’ãªãã™10ã®æ–¹æ³•
ä½•ã‹ã¨ãŠç¯€ä»‹ãªå‹•ãã‚’ã™ã‚‹ã“ã¨ãŒå¤šã„Officeã€‚ã“ã‚Œã‚‰ã®è¨å®šã‚’å¤‰æ›´ã—ã€ç›´æ„Ÿçš„ã«ä½¿ã†ãŸã‚ã®Tipsã‚’ç´¹ä»‹ã™ã‚‹ã€‚ã¾ãšã¯Excelã‹ã‚‰ã€‚ Wordã‚„Excelã€PowerPointã¨ã„ã£ãŸOfficeã‚½ãƒ•ãƒˆã‚’æ“ä½œã—ã¦ã„ã‚‹ã¨ã€ã¾ã£ãŸãæ„å›³ã—ã¦ã„ãªã„â€œãŠç¯€ä»‹â€ãªå‹•ä½œã«ã‚¤ãƒ©ã‚¤ãƒ©ã™ã‚‹ã“ã¨ãŒã‚ã‚‹ã€‚ ã‚¢ãƒ«ãƒ•ã‚¡ãƒ™ãƒƒãƒˆã®1æ–‡å—ç›®ãŒå‹æ‰‹ã«å¤§æ–‡å—ã«æ›¸ãæ›ã‚ã£ãŸã‚Šã€URLã«è‡ªå‹•çš„ã«ãƒã‚¤ãƒ‘ãƒ¼ãƒªãƒ³ã‚¯ãŒå¼µã‚‰ã‚Œã‚‹ã®ãŒä»£è¡¨ä¾‹ã€‚æ–°è¦ã«Excelã®ãƒ–ãƒƒã‚¯ã‚’ä½œæˆã™ã‚‹ã¨ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§3æžšã®ãƒ¯ãƒ¼ã‚¯ã‚·ãƒ¼ãƒˆãŒç”¨æ„ã•ã‚Œã¦ã„ãŸã‚Šã€Wordã®æ–°è¦æ–‡æ›¸ã®ãƒ•ã‚©ãƒ³ãƒˆãŒã€ŒMS Pæ˜Žæœã€ã€Œ1Tips 0.5ã€ã¨ã„ã†å€¤ã§ã‚ã‚‹ãªã©ã€æ¯Žæ—¥åˆ©ç”¨ã™ã‚‹ãƒ¦ãƒ¼ã‚¶ãƒ¼ã‹ã‚‰ã™ã‚Œã°ã‚ã‚‹æ„å‘³â€œé¦´æŸ“ã¿æ·±ã„â€ã‚‚ã®ã ã£ãŸã‚Šã™ã‚‹ã€‚ ãã†ã—ãŸã€ŒãŠç¯€ä»‹ã€ãªæ©Ÿèƒ½ã‚’ã‚ªãƒ•ã«ã—ãŸã‚Šã€è¨å®šå€¤ã‚’æ›¸ãæ›ãˆã‚‹ãŸã‚ã®Tipsã‚’ç´¹ä»‹ã—ã‚ˆã†ã€‚ã¾ãšã¯Excelã ã€‚Excel 2002ï¼2003ã®ã»ã‹ã€Excel 200
frsh_mt 2007/09/25
ITmedia

microsoft office

excel

tips
ãƒªãƒ³ã‚¯
1