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

bongkura id:bongkura

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

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

ä»•äº‹ãŒæ—ã‚‹ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆæ´»ç”¨è¡“5ã¤ï¼‹ç¥žé–¢æ•°3ã¤ - ãƒ‘ãƒ‘ãƒ‘ãƒ‘
Tokyo Otaku Modeã®å®‰å®…ã§ã™ã€‚ã€Œæœ€è¿‘æ³¨ç›®ã—ã¦ã„ã‚‹ãƒ—ãƒãƒ€ã‚¯ãƒˆã¯ï¼Ÿã€ã¨èžã‹ã‚ŒãŸã‚‰ã€è¿·ã‚ãšã€ŒGoogleã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã€ã¨ç”ãˆã¾ã™ã€‚Googleã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã®æœ€è¿‘ã®é€²åŒ–ã¯æœ¬å½“ã«é©å‘½çš„ã§ã™ã€‚ã‚ã¾ã‚Šè©±é¡Œã«ãªã£ã¦ã„ãªã„ã®ã§ã™ãŒã€Googleã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã¯æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ãªã£ã¦ã€ä½“æ„Ÿã§ã¯å¾“æ¥ã®3å€é€Ÿã¨æ€ãˆã‚‹ã»ã©é«˜é€Ÿã«ãªã‚Šã¾ã—ãŸã€‚ã‹ã¤ã€1ã¤ã®ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã«æ›¸ãè¾¼ã‚ã‚‹ã‚»ãƒ«æ•°ã‚‚200ä¸‡ã‚»ãƒ«ã¨å¤§å¹…ã«å¢—ãˆã¾ã—ãŸã€‚ ä»¥å‰ã ã¨ä¸€å®šè¡Œæ•°ã‚’è¶…ãˆãŸCSVãƒ•ã‚¡ã‚¤ãƒ«ã¯ã‚¤ãƒ³ãƒãƒ¼ãƒˆãŒã§ããªã‹ã£ãŸã®ã§ã™ãŒã€æ–°ã‚¹ãƒ—ãƒ¬ãƒƒãƒ‰ã‚·ãƒ¼ãƒˆã§ã¯ã‚ˆã»ã©å¤§ãã™ãŽãªã„é™ã‚Šã¯ã‚¹ãƒ ãƒ¼ã‚ºã«ã‚¤ãƒ³ãƒãƒ¼ãƒˆã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ ãƒ‡ãƒ¼ã‚¿ã®é›†è¨ˆæ™‚ã«ã‚ˆãä½¿ã†SUMIFé–¢æ•°ã¯ã€ä»¥å‰ãªã‚‰å¤‰å‰‡çš„ãªä½¿ã„æ–¹ã‚’ã—ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã§ã—ãŸã€‚ã—ã‹ã—ã€æ–°ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã§ã¯ãã®ã¾ã¾ä½¿ãˆã‚‹ã‚ˆã†ã«ãªã£ãŸã‚Šã¨ã€ã¾ã•ã«ç—’ã„ã¨ã“ã‚ã«æ‰‹ãŒå±Šããƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚¢ãƒƒãƒ—ãŒãªã•ã‚Œã¦ã€ã¾ã™ã¾ã™G
bongkura 2014/04/23
google

excel

csv
ãƒªãƒ³ã‚¯
excel2011(mac)ã§ä½¿ãˆãªããªã£ã¦ã—ã¾ã£ãŸã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆé¸æŠžçŸ¢å°ã®ä»£ã‚ã‚Šã®VBA
PowerMacG5ã‹ã‚‰MacPro(Intel)ã«ä¹—ã‚Šæ›ãˆãŸã®ã«ä¼´ã„ãƒã‚¤ãƒ†ã‚£ãƒ–ã§å‹•ä½œã™ã‚‹excel2011(mac)ã‚’è³¼å…¥ã—ãŸã®ã§ã™ãŒã€excel2004ã¾ã§æ™®é€šã«ä½¿ãˆã¦ã„ãŸã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆé¸æŠžçŸ¢å°ãŒç„¡ããªã£ã¦ã—ã¾ã„ã€å›³å½¢ç·¨é›†ãŒãŸã„ã¸ã‚“ã‚„ã‚Šé›£ããªã£ã¦ã—ã¾ã„ã¾ã—ãŸ(å›³å½¢ã®èƒŒé¢ã«éš ã‚ŒãŸå›³å½¢ã‚’é¸æŠžã§ããªã„)ã€‚ãã“ã§ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆé¸æŠžçŸ¢å°ã®ä»£ã‚ã‚Šã«ãªã‚‹ãƒžã‚¯ãƒã‚’ä½œã‚ã†ã¨è€ƒãˆã€æ·»ä»˜ã®VBAã‚’ä½œã£ã¦ã¿ã¾ã—ãŸã€‚ä¼¼ãŸã‚ˆã†ã«æ©Ÿèƒ½ã™ã‚‹ã‚‚ã®(èƒŒæ™¯ã«éš ã‚ŒãŸå›³ã‚’å«ã‚ã¦ä¸€æ‹¬é¸æŠžã™ã‚‹)ã‚’ä½œã‚‹ã“ã¨ã¯ã§ãã¾ã—ãŸãŒã€ã‚ªãƒªã‚¸ãƒŠãƒ«ã®(excel2004ã¾ã§ä½¿ãˆã¦ã„ãŸ)ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆé¸æŠžçŸ¢å°ã¨åŒã˜ãã‚‰ã„ä½¿ã„æ˜“ã„â€¦ã¨ã„ã†ã‚ã‘ã«ã¯è¡Œãã¾ã›ã‚“ã€‚ 1) ã“ã®ã‚ˆã†ãªãƒ—ãƒã‚°ãƒ©ãƒ ã‚’ã€ä½•å‡¦ã«ç½®ã„ãŸã‚‰ã‚ˆã‚Šä½¿ã„æ˜“ã„ã‹ã€ãŠå‹§ã‚ã‚’æ•™ãˆã¦ä¸‹ã•ã„ã€‚ 2) ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’æ”¹è‰¯ã—ã¦ã€ã‚‚ã£ã¨ã‚ªãƒªã‚¸ãƒŠãƒ«ã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆé¸æŠžçŸ¢å°ã«è¿‘ã„æ©Ÿèƒ½ã«ã™ã‚‹ã“ã¨ã¯ã§ããªã„ã‚‚ã®ã§ã—ã‚‡ã†ã‹ã€‚ãƒžã‚¦ã‚¹
bongkura 2013/08/08
microsoftã‚ˆã‚Šä»•äº‹ã—ã¦ãã‚Œã¦ã‚‹ã€‚ã‚ã‚ŠãŒãŸã‚„

excel
ãƒªãƒ³ã‚¯
Google App Engineã‚’ä½¿ã£ãŸå¸³ç¥¨å‡ºåŠ›ã‚·ã‚¹ãƒ†ãƒ Â·don-gabacho MOONGIFT
don-gabachoã¯GAE/Jã«ã‚ˆã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã€‚åŸºå¹¹ã‚·ã‚¹ãƒ†ãƒ ã«ãŠã‘ã‚‹æœ€å¤§ã®ç›®çš„ã¯å¸³ç¥¨ã®å‡ºåŠ›ã«ã‚ã‚‹ã€‚ãªã®ã§ã‚·ã‚¹ãƒ†ãƒ ã‚’é–‹ç™ºã™ã‚‹éš›ã«ã¯å¸³ç¥¨ã¸å‡ºåŠ›ã™ã‚‹é …ç›®ã‚„ä»–ã‚·ã‚¹ãƒ†ãƒ ã¸å—ã‘æ¸¡ã™é …ç›®ã‹ã‚‰è€ƒãˆã‚‹ã¨åˆ†ã‹ã‚Šã‚„ã™ã„ï¼ˆå€‹äººçš„ãªçµŒé¨“ã¨ã—ã¦ï¼‰ã€‚ å‡ºåŠ›ã•ã‚ŒãŸå¸³ç¥¨ ã—ã‹ã—å¸³ç¥¨ã‚’å‡ºåŠ›ã™ã‚‹ã‚·ã‚¹ãƒ†ãƒ ã‚’è€ƒãˆã‚‹ã¨ãªã‚‹ã¨è©±ã¯é•ã†ã€‚ç‰¹ã«Webã‚·ã‚¹ãƒ†ãƒ ã¯å¸³ç¥¨å‡ºåŠ›ãŒè‹¦æ‰‹ã ã€‚é€šå¸¸ã®HTMLã‚„ãƒ†ã‚ã‚¹ãƒˆãƒ•ã‚¡ã‚¤ãƒ«ã‚’å‡ºåŠ›ã™ã‚‹ã®ã«æ¯”ã¹ã‚‹ã¨ç•°ãªã‚‹ãƒ©ã‚¤ãƒ–ãƒ©ãƒªãŒå¿…è¦ã«ãªã£ãŸã‚Šã™ã‚‹ã€‚ãã“ã§è©¦ã—ãŸã„ã®ãŒdon-gabachoã ã€‚ don-gabachoã¯åå‰ã¯ãƒ¦ãƒ‹ãƒ¼ã‚¯ã ãŒã€ãã®å®Ÿæ…‹ã¯æœ‰ç›Šãªå¸³ç¥¨å‡ºåŠ›ã‚·ã‚¹ãƒ†ãƒ ã¨ãªã£ã¦ã„ã‚‹ã€‚è‡ªåˆ†ã§å¸³ç¥¨ã®è¨è¨ˆãŒå¯èƒ½ã§ã€ã•ã‚‰ã«é …ç›®ã‚’è¨å®šã™ã‚‹ã“ã¨ã§å‡ºåŠ›ã•ã‚Œã‚‹å€¤ã‚’ä»»æ„ã«å¤‰æ›´ãŒã§ãã‚‹ã€‚ç”Ÿæˆã•ã‚ŒãŸå¸³ç¥¨ã¯Excelãƒ•ã‚¡ã‚¤ãƒ«ã¨ã—ã¦ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ãŒã§ãã‚‹ã€‚ å…¥åŠ›ç”»é¢ PDFã§ã¯ãªã„ãŒã€Excelã®æ–¹ãŒç´°ã‹ãªèª¿æ•´ã‚‚ã§ãã‚‹ã®ã§ä¾¿åˆ©
bongkura 2010/05/07
gae

Excel

å¸³ç¥¨
ãƒªãƒ³ã‚¯
http://excelstatistics.mathlab.info/
bongkura 2009/04/13
ã¾ã¨ã‚

excel
ãƒªãƒ³ã‚¯
ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã§ä¿è·ã•ã‚ŒãŸExcelã‚·ãƒ¼ãƒˆã‚’è§£é™¤ã™ã‚‹ãƒ•ãƒªãƒ¼ã®ã‚¢ãƒ‰ã‚¤ãƒ³ã€ŒExcel Password Remover 2008ã€ - GIGAZINE
Excelã®ã‚·ãƒ¼ãƒˆã‚„ãƒ¯ãƒ¼ã‚¯ãƒ–ãƒƒã‚¯å˜ä½ã§ã‹ã‘ã‚‰ã‚ŒãŸä¿è·ï¼ˆãƒãƒƒã‚¯ï¼‰ã‚’è§£é™¤ã™ã‚‹ãŸã‚ã«å¿…è¦ãªãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’æŽ¢ã‚Šå½“ã¦ã‚‹ç„¡æ–™ã®ã‚¨ã‚¯ã‚»ãƒ«ã‚¢ãƒ‰ã‚¤ãƒ³ã§ã™ã€‚ç·¨é›†ã—ã‚ˆã†ã¨ã—ãŸã‚‰ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ãŒå¿…è¦ã ã£ãŸãŒã€å‰ä»»è€…ãªã©ãŒé€€è·ã—ã¦ã‚‚ã†ã„ãªã„ã®ã§ã©ã†ã—ã‚ˆã†ã‚‚ãªã„ã¨ã„ã†å ´åˆã«éžå¸¸ã«å½¹ç«‹ã¡ã¾ã™ã€‚ ä½¿ç”¨ã§ãã‚‹Excelã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯Excel 2000/XP/2003ã§ã™ã€‚ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã¨ä½¿ã„æ–¹ã¯ä»¥ä¸‹ã‹ã‚‰ã€‚ Excel password: Excel password remover http://www.straxx.com/excel/password.html ä¸Šè¨˜ãƒšãƒ¼ã‚¸ã‹ã‚‰ã€Œpassword.xlaã€ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ã¦ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã€é©å½“ãªå ´æ‰€ã«ä¿å˜ã—ã¾ã™ã€‚ æ¬¡ã«Excelã‚’èµ·å‹•ã—ã€ã€Œãƒ„ãƒ¼ãƒ«ã€ã‹ã‚‰ã€Œã‚¢ãƒ‰ã‚¤ãƒ³ã€ã‚’ã‚¯ãƒªãƒƒã‚¯ ã€Œå‚ç…§ã€ã‚’ã‚¯ãƒªãƒƒã‚¯ å…ˆã»ã©ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ãŸã€Œpassword.xlaã€ã‚’é¸ã‚“ã§ã€ŒOKã€ã‚’ã‚¯ãƒªãƒƒã‚¯ ã€ŒPas
bongkura 2008/10/30
excel

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

ã¾ã¨ã‚
ãƒªãƒ³ã‚¯
ã¡ã‚‡ã£ã¨è¦šãˆã¦ãŠãã¨ä¾¿åˆ©ãª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ã€ :ä¸Šã®è¡Œ/å·¦ã®åˆ—ã«ç§»å‹•ï¼ˆ
bongkura 2007/02/23
excel
ãƒªãƒ³ã‚¯
1