[B! microsoft] teddy-gã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

teddy-g id:teddy-g

microsoftã«é–¢ã™ã‚‹teddy-gã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (30)

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

Left hand navigation disappeared for one user? How to collapse and expand? | Microsoft Community Hub
teddy-g 2023/12/23
Teamsã®ã‚µã‚¤ãƒ‰ãƒãƒ¼ãŒå‹æ‰‹ã«éš ã‚Œã‚‹ã‚ˆã†ã«ãªã£ã¦ã—ã¾ã£ã¦ã©ã†ã—ã‚ˆã†ï¼ã¨æ€ã£ã¦ã‚°ã‚°ã‚Šã¾ãã£ã¦è¾¿ã‚Šç€ã„ãŸã€‚CTRLï¼‹ãƒžã‚¦ã‚¹ãƒ›ã‚¤ãƒ¼ãƒ«ã§ã‚ºãƒ¼ãƒ ã•ã‚Œã¦ã—ã¾ã„ã€ã¯ã¿ã ã—ãŸã‚µã‚¤ãƒ‰ãƒãƒ¼ãŒéš ã‚Œã‚‹ã‚ˆã†ã«ãªã£ã¦ãŸã‚‰ã—ã„ã€‚å•é¡Œè§£æ±ºã€‚

microsoft

office365

teams

tips

neta
ãƒªãƒ³ã‚¯
å¼é–¢æ•°ã®ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ ã‚¬ã‚¤ãƒ‰ - Azure Logic Apps
é©ç”¨å¯¾è±¡: Azure Logic Apps (å¾“é‡èª²é‡‘ãƒ—ãƒ©ãƒ³ + Standard) Azure Logic Apps ãŠã‚ˆã³ Power Automate ã®ãƒ¯ãƒ¼ã‚¯ãƒ•ãƒãƒ¼å®šç¾©ã§ã¯ã€ãƒ¯ãƒ¼ã‚¯ãƒ•ãƒãƒ¼ã®å®Ÿè¡Œé–‹å§‹æ™‚ã«ã¾ã å˜åœ¨ã—ãªã„å¯èƒ½æ€§ã®ã‚ã‚‹å®Ÿè¡Œæ™‚ã‚¢ã‚¯ã‚·ãƒ§ãƒ³ã‹ã‚‰å€¤ã‚’å–å¾—ã™ã‚‹å¼ãŒã‚ã‚Šã¾ã™ã€‚ ã“ã‚Œã‚‰ã®å¼ã§å€¤ã‚’å‚ç…§ã¾ãŸã¯å‡¦ç†ã™ã‚‹ã«ã¯ã€ãƒ¯ãƒ¼ã‚¯ãƒ•ãƒãƒ¼å®šç¾©è¨€èªžã«ã‚ˆã£ã¦æä¾›ã•ã‚Œã‚‹å¼é–¢æ•°ã‚’ä½¿ç”¨ã§ãã¾ã™ã€‚ æ³¨æ„ ã“ã®ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ ãƒšãƒ¼ã‚¸ã¯ã€Azure Logic Apps ã¨ Power Automate ã®ä¸¡æ–¹ã«é©ç”¨ã•ã‚Œã¾ã™ãŒã€Azure Logic Apps ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã«è¨˜è¼‰ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã“ã®ãƒšãƒ¼ã‚¸ã§ã¯ç‰¹ã«ãƒã‚¸ãƒƒã‚¯ ã‚¢ãƒ—ãƒª ãƒ¯ãƒ¼ã‚¯ãƒ•ãƒãƒ¼ã«ã¤ã„ã¦å‚ç…§ã•ã‚Œã¦ã„ã¾ã™ãŒã€ã“ã‚Œã‚‰ã®é–¢æ•°ã¯ãƒ•ãƒãƒ¼ã¨ãƒã‚¸ãƒƒã‚¯ ã‚¢ãƒ—ãƒª ãƒ¯ãƒ¼ã‚¯ãƒ•ãƒãƒ¼ã®ä¸¡æ–¹ã§å‹•ä½œã—ã¾ã™ã€‚ Power Automate ã§ã®é–¢æ•°ã¨å¼ã«ã¤ã„ã¦è©³ã—ãã¯ã€æ¡ä»¶ã®ã‚
teddy-g 2021/05/04
ãƒ¡ãƒ¼ãƒ«å—ä¿¡ã—ãŸæ™‚é–“ã§å‡¦ç†åˆ†å²ã—ã‚ˆã†ã¨ã—ã¦ãƒ¡ãƒ¼ãƒ«ã®å—ä¿¡æ—¥æ™‚ã‚’ä½¿ãŠã†ã¨ã—ãŸãŒã†ã¾ãã„ã‹ãšã€formatDateTime(convertFromUtc(utcNow(),'Tokyo Standard Time'),'hh:MM')ã§è§£æ±ºã—ãŸã€‚

tips

microsoft

office365

powerautomate
ãƒªãƒ³ã‚¯
Postfixã§ã€Œqueue file size limit exceededã€ã®ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ãŒå‡ºãŸå ´åˆã®å¯¾å‡¦ â€“ Cloud Steady | ãƒ‘ãƒ¼ã‚½ãƒ«ã‚¯ãƒã‚¹ãƒ†ã‚¯ãƒŽãƒã‚¸ãƒ¼æ ªå¼ä¼šç¤¾
TOP >Â Â æŠ€è¡“FAQ >Â Â MSè£½å“ä»¥å¤– >Â Â Postfixã§ã€Œqueue file size limit exceededã€ã®ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ãŒå‡ºãŸå ´åˆã®å¯¾å‡¦ ã€Œqueue file size limit exceededã€ã¯Postfixã§å—ã‘å–ã£ãŸãƒ¡ãƒ¼ãƒ«ã®ã‚µã‚¤ã‚ºãŒè¨å®šå€¤ã‚’è¶…éŽã—ã¦ã„ã‚‹ã“ã¨ã‚’ç¤ºã—ã¦ã„ã¾ã™ã€‚ Postfixã®ãƒ¡ãƒ¼ãƒ«ã‚µã‚¤ã‚ºã®ä¸Šé™è¨å®šã¯ä¸‹è¨˜ã‚³ãƒžãƒ³ãƒ‰ã§ç¢ºèªã§ãã¾ã™ã€‚ postconf -d | grep message_size_limit è¨å®šå€¤ä»¥ä¸Šã®ãƒ¡ãƒ¼ãƒ«ãƒ‡ãƒ¼ã‚¿ã®é€ä¿¡ãŒå¿…è¦ãªå ´åˆã¯ã€Postfixã®è¨å®šå¤‰æ›´ãŒå¿…è¦ã¨ãªã‚Šã¾ã™ã€‚ /etc/postfix/main.cf å†…ã€Œmessage_size_limitã€ã®å€¤ã‚’å¤‰æ›´ã—ã¾ã™ã€‚ å¤‰æ›´å¾Œã€è¨å®šã‚’å†èªã¿è¾¼ã¿ã™ã‚‹ãŸã‚Postfixã‚’ãƒªãƒãƒ¼ãƒ‰ã—ã¾ã™ã€‚ å¤‰æ›´ãŒé›£ã—ã„å ´åˆã¯ã€ãƒ¡ãƒ¼ãƒ«ãƒ‡ãƒ¼ã‚¿ã®ã‚µã‚¤ã‚ºãŒè¨å®šå€¤ã‚’è¶…ãˆãªã„ã‚ˆã†ã«åˆ†å‰²ã—ã¦é€ä»˜ã™ã‚‹ç‰
teddy-g 2021/05/04
PowerAutomateã§ãƒ¡ãƒ¼ãƒ«ã‚’hogeã‚‹ã¨æ—¥æ™‚ãŒUTCãƒ™ãƒ¼ã‚¹ã«ãªã£ã¦ã—ã¾ã†ã®ã§ã€Œã‚¿ã‚¤ãƒ ã‚¾ãƒ¼ãƒ³ã®å¤‰æ›ã€ã§èª¿æ•´ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚

tips

microsoft

office365

powerautomate
ãƒªãƒ³ã‚¯
Azure Cognitive Service Speech to Text API ã‚’èª¿æŸ»ã—ã€Google Cloud Speech-to-Text APIã¨æ¯”è¼ƒã—ã¦ã„ã - OPTiM TECH BLOG
ã“ã‚“ã«ã¡ã¯ã€å¼•è¶Šã—ãªã©ã®ä¸€é€£ã®ã‚´ã‚¿ã‚´ã‚¿ãŒæ¸ˆã‚“ã 2020å¹´æ–°å’å…¥ç¤¾äºˆå®šã®å±±å£ã§ã™ã€‚ ä»Šå›žã¯Azure Cognitive Service Speech to Text API(ä»¥ä¸‹AST)ã«ã¤ã„ã¦èª¿æŸ»ã‚’è¡Œã£ãŸã®ã§ã€ãã®çµæžœãªã©ã‚’å ±å‘Šã—ã¾ã™ã€‚ã¾ãŸGoogle Cloud Speech-to-Text API(ä»¥ä¸‹GST)ã¨æ¯”è¼ƒã‚‚è¡Œã£ãŸã®ã§ã€ãã‚Œã«ã¤ã„ã¦ã‚‚è¨˜è¿°ã—ã¦ã„ãã¾ã™ã€‚ ASTã®å°Žå…¥ ASTã®å¯¾å¿œãƒ•ã‚¡ã‚¤ãƒ«å½¢å¼ãªã©ã®èª¿æŸ» éŸ³å£°ãƒ•ã‚¡ã‚¤ãƒ«æ–‡å—èµ·ã“ã—ãƒ—ãƒã‚°ãƒ©ãƒ ã®ä½œæˆ ASTã¨GSTã®æ¯”è¼ƒ 1. å®Ÿè¡Œçµæžœã®æ¯”è¼ƒ 2. å‡¦ç†é€Ÿåº¦ã®æ¯”è¼ƒ 3. æ–™é‡‘é¢ã§ã®æ¯”è¼ƒ ã¾ã¨ã‚ ASTã®å°Žå…¥ ä»Šå›žã¯ã“ã®ãƒªãƒ³ã‚¯ã®èª¬æ˜Žã‚’å…ƒã«å°Žå…¥ã‚’ã—ã¦ã„ãã¾ã™ã€‚ Azureå´ã®è¨å®š èª¬æ˜Žãƒªãƒ³ã‚¯ Azureã‚¢ã‚«ã‚¦ãƒ³ãƒˆã®ä½œæˆ(microsoftã‚¢ã‚«ã‚¦ãƒ³ãƒˆãŒå¿…è¦) ãƒªã‚½ãƒ¼ã‚¹ã®ä½œæˆ ä»Šå›žã¯ä»¥ä¸‹ã®ç”»åƒã®ã‚ˆã†ã«ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã‚’ä½œæˆã—ã¾ã—ãŸã€‚ ãƒªã‚½ãƒ¼ã‚¹ã‚’
teddy-g 2020/05/05
Azure Cognitive Servicesã®éŸ³å£°èªè˜ã®ä½¿ã„æ–¹ã¨GCPã¨ã®æ¯”è¼ƒçµæžœã€‚Azureè©¦ç”¨ã™ã‚‹ã‹æ‚©ã‚€ã€‚

azure

microsoft

office365

speech-to-text

cloud

api

python
ãƒªãƒ³ã‚¯
Microsoft Flow ã§ Cognitive Service ã®æ´»ç”¨æ–¹æ³•ã‚’è€ƒãˆã¦ã¿ã‚‹ - Oh! 365 blog
ä¸€ã¤å‰ã®è¨˜äº‹ã‚’å…¬é–‹ã—ãŸã¨ã“ã‚ã€Microsoft Flow ã‚’æ¥å‹™ã§åˆ©ç”¨ã—ã¦ã„ã‚‹ä½¿ã£ã¦ã„ã‚‹å‹äººã‹ã‚‰ã‚³ãƒ¡ãƒ³ãƒˆã‚’ã‚‚ã‚‰ã†ã“ã¨ãŒã§ãã€ã‚¢ã‚¤ãƒ‡ã‚¢ãŒè†¨ã‚‰ã‚“ã§ããŸã®ã§è‰²ã€…è©¦ã—ã¦ã¿ã¾ã—ãŸã€‚ å‰å›žã®è¨˜äº‹ã¯ã“ã¡ã‚‰ Microsoft Flow ã¨ SharePoint Online ã§è‡ªå‹•æŽ¡ç•ªæ©Ÿèƒ½ã‚’å®Ÿè£…ã—ã¦ã¿ãŸ ç›®çš„ã‚’æŒã£ã¦å®Ÿè£…ã™ã‚‹ã»ã†ãŒå¦ã³ã‚‚å¤šã„ã¨æ€ã†ã®ã§ã€ä»Šå¾Œã¯ä»¥ä¸‹ã®ã‚ˆã†ãªã‚·ãƒŠãƒªã‚ªã‚’ä»®å®šã—ã€Flow ã‚’ä½¿ã£ã¦å¯¾å¿œã§ããªã„ã‹ã‚’è€ƒãˆã¦ã¿ã¾ã™ã€‚ï¼ˆä½•ã‹ã‚¢ã‚¤ãƒ‡ã‚¢ãŒã‚ã‚Œã°ã‚„ã£ã¦ã¿ã‚‹ã®ã§æ•™ãˆã¦ã»ã—ã„ã§ã™ï¼ï¼‰ åˆ©ç”¨ã‚·ãƒŠãƒªã‚ª : ã‚«ã‚¹ã‚¿ãƒžãƒ¼ã‚µãƒãƒ¼ãƒˆ ãŠå®¢æ§˜ã‹ã‚‰å•ã„åˆã‚ã›ãƒ¡ãƒ¼ãƒ«ã‚’å—ä¿¡ã™ã‚‹ å•ã„åˆã‚ã›ãƒ¡ãƒ¼ãƒ«ã®è¨˜è¼‰å†…å®¹ã‚’ã‚‚ã¨ã«ã€Q&A ã‚µã‚¤ãƒˆã‚„è‡ªç¤¾ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‹ã‚‰é–¢é€£ã™ã‚‹æƒ…å ±ã‚’å–å¾—ã™ã‚‹ å–å¾—ã—ãŸæƒ…å ±ã‚’ã€è‡ªå‹•è¿”ä¿¡ãƒ¡ãƒ¼ãƒ«ã®æœ¬æ–‡ã«è¨˜è¼‰ã™ã‚‹ ä½œæˆã—ãŸè‡ªå‹•è¿”ä¿¡ãƒ¡ãƒ¼ãƒ«ã‚’ãŠå®¢æ§˜ã¸è¿”ä¿¡ã™ã‚‹ ä¸Šè¨˜ã®ã‚ˆã†ã«ã€ç¬¬ä¸€æ¬¡å—ä»˜ã‚’å®Œäº†ã—ã¾ã—ãŸã¨ã„ã†ã‚ˆã†ãªè‡ªå‹•
teddy-g 2019/09/07
Microsoft Flowã®Cognitive Serviceã§ãƒ¡ãƒ¼ãƒ«ã®å½¢æ…‹ç´ è§£æžã‚„ã£ã¦ã¿ãŸã€çš„ãªã€‚ã¡ã‚‡ã¨é¢ç™½ã„ã€‚

api

API

machine learning

machinelearning

NaturalLanguage

NLP

microsoft

office365

flow
ãƒªãƒ³ã‚¯
ã‚¨ã‚¯ã‚»ãƒ«é–¢æ•°ã§ã©ã‚“ãªæ–‡å—åˆ—ã‹ã‚‰ã§ã‚‚æ•°å—ã ã‘ã‚’æŠ½å‡ºã§ãã‚‹æ–¹æ³•ï¼è£æŠ€ | ãƒ›ãƒ¯ã‚¤ãƒˆãƒ¬ã‚¤ã‚¢
ã‚¨ã‚¯ã‚»ãƒ«é–¢æ•°ã§ã€æ–‡å—åˆ—ã‹ã‚‰æ•°å—ã ã‘ã‚’æŠ½å‡ºã™ã‚‹æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¦ã„ã¾ã™ã€‚ã‚¨ã‚¯ã‚»ãƒ«ã§ã€ã‚»ãƒ«ã«æ–‡å—åˆ—ã¨æ•°å€¤ãŒæ··åœ¨ã—ã¦å…¥åŠ›ã•ã‚Œã¦ã„ã‚‹å ´åˆã€æ–‡å—åˆ—ã®ä¸ã‹ã‚‰æ•°å—ã®ã¿å–ã‚Šå‡ºã—ãŸã„ã¨ã„ã†ã“ã¨ãŒã‚ã‚Šã¾ã™ã€‚ãã®ã‚ˆã†ãªå ´åˆã€ã©ã®ã‚ˆã†ã«ã—ã¦ã‚»ãƒ«ã®æ–‡å—åˆ—ã‹ã‚‰æ•°å—ã®ã¿ã‚’å–ã‚Šå‡ºã›ã°ã‚ˆã„ã®ã§ã—ã‚‡ã†ã€‚æ–‡å—åˆ—ã®ä¸ã«ã€æ•°å€¤ãŒè¦å‰‡çš„ã«å…¥åŠ›ã•ã‚Œã¦ã„ã‚‹ã¨ç°¡å˜ã«æŠ½å‡ºã§ãã¾ã™ãŒã€ä¸è¦å‰‡ã§æ•°å—ã®æ•°ã‚‚ä¸€å®šã§ã¯ãªã„ã¨ã€æŠ½å‡ºã™ã‚‹ã®ã¯é›£ã—ããªã‚Šã¾ã™ã€‚ã“ã“ã§ã¯ã€ã‚»ãƒ«ã®æ–‡å—åˆ—ã‹ã‚‰ã€æ•°å—ãŒã©ã®ä½ç½®ã«ã‚ã£ã¦ã‚‚ã€æ•°å—ã®æ•°ãŒå¹¾ã¤ã‚ã£ã¦ã‚‚ã€æ•°å—ã ã‘ã‚’ç°¡å˜ã«æŠ½å‡ºã™ã‚‹æ–¹æ³•ã‚’èª¬æ˜Žã—ã¦ã„ãã¾ã™ã€‚æ–‡å—åˆ—ã®å·¦ç«¯ã€ä¸ã€å³ç«¯ã§ã‚‚ç°¡å˜ã«æ•°å€¤ã®ã¿æŠ½å‡ºã§ãã¾ã™ã€‚ æ•°å—ï¼‹æ–‡å—åˆ—ã‹ã‚‰æ•°å—ã‚’æŠ½å‡ºã™ã‚‹æ–¹æ³•æ•°å—ï¼‹æ–‡å—åˆ—ã‹ã‚‰æ•°å—ã‚’æŠ½å‡ºã—ã¾ã™ã€‚ B1ã«ã€ã€Œ325ANï½± å“å·ã€ã®æ–‡å—åˆ—ã‹ã‚‰æ•°å—ã®ã¿æŠ½å‡ºã™ã‚‹å¼ã‚’å…¥åŠ›ã—ã¾ã—ã‚‡ã†ã€‚ æ•°å—ãŒæ–‡å—åˆ—ã®ä¸€ç•ªå·¦ç«¯ã«ã‚ã‚‹æ™‚ã€ã‚¨ã‚¯ã‚»ãƒ«é–¢æ•°LEFTãŒåŸºæœ¬ã¨ãªã‚Šã¾ã™ã€‚ LE
teddy-g 2019/05/09
ã‚°ã‚°ã‚‹ã¨ã‚ˆããƒ’ãƒƒãƒˆã™ã‚‹LOOKUPã¨LEFTã€COLUMNã‚’ä½¿ã†ã‚„ã¤ã‚ˆã‚Šä½¿ãˆã‚‹ã€‚æ•°å—ãŒæ–‡å—åˆ—ã®ã©ã“ã«å…¥ã£ã¦ã¦ã‚‚æŠ½å‡ºã§ãã‚‹ã€‚

microsoft

excel

tips
ãƒªãƒ³ã‚¯
EXCEL findã‚’å³ã‹ã‚‰(å¾Œã‚ã‹ã‚‰)æ¤œç´¢ã™ã‚‹æ–¹æ³•
EXCEL findã‚’å³ã‹ã‚‰(å¾Œã‚ã‹ã‚‰)æ¤œç´¢ã™ã‚‹æ–¹æ³•ã¯ãŠãã‚‰ãã“ã‚Œã—ã‹ãªã„ï¼ æ–‡å—åˆ—é–¢æ•°ã®é‰„æ¿ã§ã‚ã‚‹findã§ã™ãŒã€é€šå¸¸ã¯å·¦ã‹ã‚‰ã®æ¤œç´¢ã—ã‹ã§ããªã„ã§ã™ã‚ˆãã€‚ ã“ã‚Œã‚’å³ã‹ã‚‰(å¾Œã‚ã‹ã‚‰)æ¤œç´¢ã€æ™®é€šã«ã‚„ã‚‹ã¨ã§ããªã„ã‚“ã§ã™ãŒ ã‚ã‚‹é–¢æ•°ã‚’çµ„ã¿åˆã‚ã›ã‚Œã°å³ç«¯ã®æ–‡å—æ¤œç´¢ãŒã§ãã‚‹ã‚“ã§ã™ï¼ Find ã¾ãšã¯é€šå¸¸ã®å·¦ã‹ã‚‰ã ã¨ ä»Šå›žã®ä¾‹ã¨ã—ã¦ã€A3ã®æ–‡å—åˆ—ã€Œaaa-bbb-ccc-dddã€ã®æ–‡å—åˆ—ã‹ã‚‰ãƒã‚¤ãƒ•ãƒ³ã€Œ-ã€ã®æ–‡å—ä½ç½®ã‚’å–å¾—ã—ã¾ã™ã€‚ é€šå¸¸ã®Findã§å·¦ã‹ã‚‰æ¤œç´¢ã‚’è¡Œã£ãŸã¨ãã«æ•°å¼ãƒ»çµæžœã¯ã“ã†ãªã‚Šã¾ã™ã€‚ æ•°å¼ï¼š=FIND("-",A3) çµæžœï¼š4 Findã§å³ã‹ã‚‰æ¤œç´¢ã¯ã©ã†ã‚„ã‚‹ã®ï¼Ÿ æ–‡å—åˆ—ã‹ã‚‰ãƒã‚¤ãƒ•ãƒ³ã€Œ-ã€ã®ä¸€ç•ªå³ã®ä½ç½®ã‚’å–å¾—ã—ãŸã„ã¨ãçµæžœãŒ12ã«ãªã‚Šã¾ã™ã€‚ ã“ã‚Œã‚’Findã§å–å¾—ã—ãŸã„ã¨ãã€ã‚ã‚‹é–¢æ•°ã¨çµ„ã¿åˆã‚ã›ã‚‹ã“ã¨ã§å¯èƒ½ã«ãªã‚Šã¾ã™ã€‚ SUBSTITUTEé–¢æ•°ã¨LENé–¢æ•°ã‚’ä½¿ã£ã¦ã€å³ã‹ã‚‰æ¤œç´¢ã‚’å¯èƒ½ã« æ•°å¼ï¼š=
teddy-g 2019/05/09
SUBSTITUTEã®ç¬¬4ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã¯ä½•ç•ªç›®ã«ãƒ’ãƒƒãƒˆã—ãŸã‚‚ã®ã‚’ç½®ãæ›ãˆã‚‹ã‹ã‚’æŒ‡å®šã™ã‚‹ã€‚ã“ã‚Œã‚’ä½¿ã£ã¦æœ€å¾Œã«ãƒžãƒƒãƒã—ãŸæ¤œç´¢å¯¾è±¡ã‚’ç‰¹å®šã®æ–‡å—ã«ç½®ãæ›ãˆã¦ä½ç½®ã‚’èª¿ã¹ã‚‹ã¨ã„ã†ã®ãŒãƒŸã‚½ã€‚

microsoft

excel

tips
ãƒªãƒ³ã‚¯
MS Flowã§ã‚ã‚‹ç‰¹å®šæ¡ä»¶ã®ãƒ¡ãƒ¼ãƒ«å—ä¿¡ã—ãŸã‚‰Boxã®ä¸ã®EXCELãƒ†ãƒ¼ãƒ–ãƒ«ã«ãƒ‡ãƒ¼ã‚¿ã‚’1è¡ŒæŒ¿å…¥ã™ã‚‹ - Qiita
#èƒŒæ™¯ ç¤¾å†…ã®æ´¾é£ã•ã‚“ã‚„ç¤¾å“¡ï¼ˆéžã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ï¼‰ãŒã€ä»¶åã‚„å·®å‡ºäººã¨ã‹ç‰¹å®šæ¡ä»¶ã®ãƒ¡ãƒ¼ãƒ«æƒ…å ±ã‚’æ‰‹ã§EXCELã®ä¸€è¦§ã«ã‚³ãƒ”ãƒšã™ã‚‹ã¨ã„ã†ä½œæ¥ã‚’æ—¥ã€…ã‚„ã£ã¦ã„ã‚‹ã¨ã„ã†é©šæ„•ã®äº‹å®Ÿã‚’çŸ¥ã‚Šã€ãã‚Œç°¡å˜ã«è‡ªå‹•åŒ–ã§ãã¡ã‚ƒã†ã‚ˆã£ã¦æ•™ãˆã¦ã‚ã’ãŸæ‰€å–œã‚“ã§ãã‚Œã¾ã—ãŸã€‚ Flowã¯è‡ªåˆ†ã§ç°¡å˜ã«ä½œã£ã¦è‡ªåˆ†ã®ä»•äº‹æ”¹å–„ã—ã¦ã„ã‘ã‚‹ã£ã¦ã®ãŒæ¥½ã—ã„ã‚ˆãã€‚ #æ¡ä»¶ ä»Šå›žã®æ‰‹é †ã¯ä»¥ä¸‹å‰æã«ã—ã¦ã¾ã™ã€‚ Office365ã®Flowï¼ˆãƒ•ãƒªãƒ¼ã§ä½œã‚Œã‚‹Microsoftã‚¢ã‚«ã‚¦ãƒ³ãƒˆã‚„AzureLogicAppsã§ã‚‚ä½¿ãˆã‚‹ï¼‰ Boxï¼ˆOneDriveã¨ã‹DropBoxã¨ã‹ä»–ã®ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã‚µãƒ¼ãƒ“ã‚¹ã§ã‚‚ã§ãã‚‹ï¼‰ #æ‰‹é † ##Flowã‚·ãƒŠãƒªã‚ªã§ãƒˆãƒªã‚¬ã‚’ä½œã‚‹ Office365ç”»é¢é–‹ã[Flow]ã‚’ã‚¯ãƒªãƒƒã‚¯ã€ã‚‚ã—ãã¯ã‚¿ã‚¤ãƒ«ãŒãªã„å ´åˆã«ã¯[ã™ã¹ã¦ã®ã‚¢ãƒ—ãƒªã‹ã‚‰æŽ¢ã™]ã‹ã‚‰æŽ¢ã—ã¾ã™ã€‚ã‚‚ã—ãã¯Flowç›´æŽ¥é–‹ã„ã¦ãƒã‚°ã‚¤ãƒ³ã—ã¦ã‚‚OKã€‚ [ãƒžã‚¤ãƒ•ãƒãƒ¼] ï¼ž [ä¸€ã‹ã‚‰ä½œæˆ]ã‚’ã‚¯ãƒªãƒƒ
teddy-g 2019/05/09
ã“ã‚Œèªã‚“ã§å—ä¿¡ãƒ¡ãƒ¼ãƒ«ã®è‡ªå‹•è¨˜éŒ²ã‚’Flowã§ä½œã£ã¦ã¿ãŸã€‚ãã‚Œãªã‚Šã«è‹¦åŠ´ã—ãŸã€‚

Excel

excel

microsoft

office

flow

office365
ãƒªãƒ³ã‚¯
Outlook VBA ãƒžã‚¯ãƒã€ã¯ã˜ã‚ã®ä¸€æ©
Outlook ã«ã¯ Word ã‚„ Excel ã¨åŒæ§˜ã€VBA ã«ã‚ˆã‚‹ãƒžã‚¯ãƒæ©Ÿèƒ½ãŒã‚ã‚Šã¾ã™ãŒã€Word ã‚„ Excel ã¨ã¯ç•°ãªã‚Šã€ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®æ“ä½œã‚’ãƒžã‚¯ãƒã¨ã—ã¦è¨˜æ†¶ã™ã‚‹æ©Ÿèƒ½ãŒã‚ã‚Šã¾ã›ã‚“ã€‚ ãã®ãŸã‚ã€Outlook ã§ VBA ãƒžã‚¯ãƒã‚’ä½¿ã†ã«ã¯ã€Outlook ã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆ ãƒ¢ãƒ‡ãƒ«ã¨ã„ã†ã‚‚ã®ã‚’ç†è§£ã™ã‚‹ã“ã¨ãŒå¿…è¦ã¨ãªã‚Šã€ã¨ã£ã¤ãã«ãã„ã‚‚ã®ã¨ãªã£ã¦ã—ã¾ã£ã¦ã„ã‚‹ã‚ˆã†ã«æ€ã„ã¾ã™ã€‚ ã—ã‹ã—ã€ä½¿ã„ã“ãªã›ã‚‹ã‚ˆã†ã«ãªã‚Œã°è‰²ã€…ã¨ä¾¿åˆ©ã§ã™ã€‚ ãã“ã§ã€ã“ã®ãƒšãƒ¼ã‚¸ã§ã¯ Outlook 2010 ä»¥é™ã§ VBA ãƒžã‚¯ãƒã‚’ä½œæˆã™ã‚‹æ‰‹é †ã‚’ã‚¹ãƒ†ãƒƒãƒ— ãƒã‚¤ ã‚¹ãƒ†ãƒƒãƒ—ã§èª¬æ˜Žã—ã¾ã™ã€‚ 1. ãƒžã‚¯ãƒã®ä½œæˆ ãƒžã‚¯ãƒã‚’ä½œæˆã™ã‚‹ã«ã¯ã€Visual Basic Editor ã‚’ä½¿ç”¨ã—ã¾ã™ã€‚ ä»Šå›žã¯ç°¡å˜ãªã‚µãƒ³ãƒ—ãƒ«ã¨ã—ã¦ã€Œâ€Hello Worldâ€ ã¨ã„ã†ãƒ€ã‚¤ã‚¢ãƒã‚° ãƒ¡ãƒƒã‚»ãƒ¼ã‚¸ã‚’è¡¨ç¤ºã™ã‚‹ã€ã¨ã„ã†ãƒžã‚¯ãƒã‚’ä½œã‚Šã¾ã™ã€‚ æ‰‹é †ã¯ä»¥ä¸‹ã®é€šã‚Šã§ã™ã€‚ O
teddy-g 2019/04/28
Outlookã®ãƒžã‚¯ãƒã®ä½œã‚Šæ–¹ã€ä½†ã—Outlook 2007&2010ã€‚ã¾ãšè‡ªå·±è¨¼æ˜Žæ›¸ã‹ã‚‰ã€‚

outlook

vba

microsoft
ãƒªãƒ³ã‚¯
äºˆå®šè¡¨ã‚’ Excel ãƒ•ã‚¡ã‚¤ãƒ«ã«ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã—ã€Excel ãƒ•ã‚¡ã‚¤ãƒ«ã®å¤‰æ›´ã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹ãƒžã‚¯ãƒ
ã‚³ãƒ¡ãƒ³ãƒˆã«ã¦ä»¥ä¸‹ã®ã”è¦æœ›ã‚’ã„ãŸã ãã¾ã—ãŸã€‚ ã„ã¤ã‚‚ãŠä¸–è©±ã«ãªã‚Šã¾ã™ã€‚ ä¼šç¤¾ã§ã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆå´(windows7 &Outlook2013) & Exchangeã‚µãƒ¼ãƒãƒ¼ç’°å¢ƒã§ä½¿ç”¨ã—ã¦ã„ã¾ã™ï½¡ è²´ã‚µã‚¤ãƒˆã®ï½¢è¤‡æ•°ãƒ•ã‚©ãƒ«ãƒ€ãƒ¼ã«æ ¼ç´ã•ã‚Œã¦ã„ã‚‹ç‰¹å®šã®ä»¶åã®ãƒ¡ãƒ¼ãƒ«ã®æƒ…å ±ã‚’ Excel ãƒ•ã‚¡ã‚¤ãƒ«ã«ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆã™ã‚‹ãƒžã‚¯ãƒï½£, ï½¢ãƒ¡ãƒ¼ãƒ«ã®å†…å®¹ã‚’ Excel ãƒ•ã‚¡ã‚¤ãƒ«ã«ã‹ãå‡ºã™ãƒžã‚¯ãƒï½£ ãªã©ã§ç´¹ä»‹ã•ã‚Œã¦ã„ã‚‹ãƒžã‚¯ãƒã‚’ã‚¢ãƒ¬ãƒ³ã‚¸ã—ã€ã‚«ãƒ¬ãƒ³ãƒ€ãƒ¼ã‚¢ã‚¤ãƒ†ãƒ ã‚„ToDoã‚¢ã‚¤ãƒ†ãƒ ã®æƒ…å ±ã‚’Excelã«ä¸€è¦§è¡¨å½¢å¼ã«ã—ã¦å‡ºåŠ›ã•ã‚‹ãƒžã‚¯ãƒã‚’è©¦ä½œã—ã¾ã—ãŸ(å‡ºåŠ›ã•ã›ã‚‹æƒ…å ±ã«Coversation ID, Entry IDãŒå«ã¾ã‚Œã¾ã™)ã€‚ Excelã«æ›¸ãå‡ºã•ã›ã‚‹ã ã‘ãªã®ã§ã€æƒ…å ±ã‚’ä¿®æ£ã™ã‚‹ã¨ãã¯Outlookã«æˆ»ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ï½¡ ã›ã‚ã¦ã€Message ID, Coversation ID, Entry IDãªã©ã€ãƒ¦ãƒ‹ãƒ¼ã‚¯ã«å‰²ã‚Šå½“ã¦ã‚‰ã‚Œã‚‹ID
teddy-g 2019/04/28
Outlookã®äºˆå®šè¡¨ã‚’EXCELã«ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆ/ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹ãƒžã‚¯ãƒ

outlook

vba

microsoft
ãƒªãƒ³ã‚¯
[Power BI / Excel] è¤‡æ•°ã«ã¾ãŸãŒã‚‹ Web ãƒšãƒ¼ã‚¸ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã™ã‚‹
Excel ã‚„ Power BI Desktop ã®ãƒ‡ãƒ¼ã‚¿å–å¾—ã®æ©Ÿèƒ½ã§ã‚ã‚‹ Power Query ï¼ˆãƒ‡ãƒ¼ã‚¿ã®å–å¾—ã¨å¤‰æ›ï¼‰ ã®è©±é¡Œã§ã™ã€‚ åœ°éœ‡ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã™ã‚‹ æœ€è¿‘ã€ã¾ãŸåœ°éœ‡ãŒå¤šã„ã®ãŒæ°—ã«ãªã‚Šã¾ã™ã‚ˆãã€‚åœ°éœ‡ãƒ‡ãƒ¼ã‚¿ã¯æ°—è±¡åºã®ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã§éšæ™‚å…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ã—ã‹ã—ãªãŒã‚‰ã€ã“ã®å…¬é–‹ãƒ‡ãƒ¼ã‚¿ã¯ã€è‰¯ã„æ„å‘³ã§ãƒ‡ãƒ¼ã‚¿ ã‚¯ãƒ¬ãƒ³ã‚¸ãƒ³ã‚°ã®ã‚µãƒ³ãƒ—ãƒ«ã«ãªã‚Šã€é•ã†æ„å‘³ã§ã¯ã€Œé›†è¨ˆã€ã‚„ã€Œãƒ¬ãƒãƒ¼ãƒˆä½œæˆã€ãªã©ã®å¾Œå·¥ç¨‹ã‚’ã‚ã¾ã‚Šè€ƒæ…®ã—ã¦ã„ãªã„ãƒ‡ãƒ¼ã‚¿ã‹ã‚‚ã—ã‚Œãªã„ã€ã¨æ„•ç„¶ã¨ã—ã¾ã™ã€‚ ä»Šå›žã®ãŠé¡Œã¨ã¯é›¢ã‚ŒãŸè©±é¡Œãªã®ã§ã™ãŒã€ã¡ã‚‡ã£ã¨ã ã‘ã”ç´¹ä»‹ã—ã¾ã™ã€‚ http://www.jma.go.jp/jp/quake/quake_local_index.html ã™ã¹ã¦ã®æ•°å—ãŒã€Œå…¨è§’ã€ã§ã™ã€‚å¤§ãã„ã€å°ã•ã„ã®åˆ¤æ–ã‚’ã™ã‚‹ãŸã‚ã«ã¯æ•°å€¤ã«ã—ãªã„ã¨æ¯”è¼ƒã§ããªã„ã®ã§ã€ã¾ãšã¯ã“ã‚Œã‚’åŠè§’ã«å¤‰æ›ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚åŒã˜ãæ—¥ä»˜ã«ä½¿ã‚ã‚Œã¦ã„ã‚‹æ•°å—ã‚‚å…¨è§’ã§ã™ã€‚è‰¯ã„ã‹
teddy-g 2019/02/11
Power Queryã§ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿æŒ‡å®šã™ã‚‹ã‚ˆã†ã«ã™ã‚‹ã¨é©å½“ã«è¡¨ã¨ã‹ã¨ã£ã¦ãã‚‹ã®ã«ä¾¿åˆ©

tips

Excel

microsoft

office
ãƒªãƒ³ã‚¯
How to select a machine learning algorithm - Azure Machine Learning
If you're wondering which machine learning algorithm to use, the answer depends primarily on two aspects of your data science scenario: What do you want to do with your data? Specifically, what's the business question you want to answer by learning from your past data? What are the requirements of your data science scenario? What are the features, accuracy, training time, linearity, and parameters
teddy-g 2015/12/11
ã©ã®æ©Ÿæ¢°å¦ç¿’ã‚’é¸ã¹ã°ã„ã„ã®ï¼Ÿã£ã¦ã„ã†ãƒãƒ¥ãƒ¼ãƒˆãƒªã‚¢ãƒ«ã€‚cheat sheetã¨åˆã‚ã›ã¦èªã‚€ã¨åˆ†ã‹ã‚Šã‚„ã™ã„ã€‚åˆå¿ƒè€…ã«ã‚‚ã‚ã‹ã‚Šã‚„ã™ã„ã¨æ€ã†ã‚“ã ã‘ã©ã€ã“ã‚Œã§ã‚‚ãƒãƒ¼ãƒ‰ãƒ«é«˜ã„ã‚“ã ã‚ãªâ€¦ã€‚

advancedanalytics

analytics

bigdata

microsoft

azure

machinelearning
ãƒªãƒ³ã‚¯
Bing Search API ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°è§£èª¬
è©³ç´° - Bing Search API | Microsoft Azure Marketplace ãŸã¨ãˆã°ã‚¦ã‚§ãƒ–æ¤œç´¢ã§ã€ãƒ¬ã‚¹ãƒãƒ³ã‚¹ã‚’JSONã€ã‚ãƒ¼ãƒ¯ãƒ¼ãƒ‰ã‚’ã€Œsushiã€ã¨ã™ã‚‹ã«ã¯ã€ https://api.datamarket.azure.com/Bing/Search/v1/Web?$format=json&Query=%27sushi%27 ã¨ã—ã¾ã™ã€‚ã¾ãŸQueryã«ã¯Bingæ¤œç´¢ã®æ¼”ç®—åã‚’ç”¨ã„ã‚‰ã‚Œã€Œsushi site:example.comã€ã®ã‚ˆã†ãªæŒ‡å®šã‚‚å¯èƒ½ã§ã™ã€‚ ãƒ–ãƒ©ã‚¦ã‚¶ã‹ã‚‰APIã®URLã¸ãƒªã‚¯ã‚¨ã‚¹ãƒˆã™ã‚‹ã¨ãƒ¦ãƒ¼ã‚¶ãƒ¼åã¨ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã‚’è¦æ±‚ã•ã‚Œã¾ã™ãŒã€ãƒ¦ãƒ¼ã‚¶ãƒ¼åã¯çœç•¥ã—ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ã«ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã‚ãƒ¼ã‚’æŒ‡å®šã™ã‚Œã°ã€ãƒ¬ã‚¹ãƒãƒ³ã‚¹ã‚’å¾—ã‚‰ã‚Œã¾ã™ã€‚ åˆ¶é™ APIã®åˆ©ç”¨ã¯1æœˆã‚ãŸã‚Š5000ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ (5000ãƒšãƒ¼ã‚¸åˆ†ã®ãƒªã‚¯ã‚¨ã‚¹ãƒˆ) ã«åˆ¶é™ã•ã‚Œã¦ãŠã‚Šã€ãã‚Œã‚’è¶Šãˆã¦åˆ©ç”¨ã™ã‚‹ã«ã¯æ–™é‡‘ã®æ”¯æ‰•ãŒå¿…è¦
teddy-g 2014/11/18
Bing Search APIã¯ä½¿ç”¨ãŒå¤‰ã‚ã£ãŸã¯ãšãªã‚“ã ãŒã“ã®URIã§ã‚‚ã‚¤ã‚±ã‚‹ã€‚ã—ã‹ã‚‚BASICèªè¨¼ãªãã¦ã‚‚é€šã‚‹ã€‚æ€ªã—ã„ã€‚

web

api

searchengine

bing

microsoft

azure

webservices
ãƒªãƒ³ã‚¯
Microsoft Translator APIã§ç¿»è¨³ ï¼ˆæ”¹ï¼‰ãã®ï¼‘
ä»¥å‰ã®æŠ•ç¨¿ã§ç¿»è¨³ã‚µãƒ¼ãƒ“ã‚¹ã®Microsoft Translator APIã®ä½¿ã„æ–¹ã‚’æ›¸ã„ãŸã®ã ãŒã€æ›¸ã„ãŸç›´å¾Œã«APIã®åˆ©ç”¨æ–¹æ³•ãŒå¤‰ã‚ã£ã¦ã—ã¾ã£ã¦ã„ãŸã€‚ä¹…ã€…ã«ä½¿ã†æ©Ÿä¼šãŒã‚ã£ãŸã®ã§å†åº¦èª¿æŸ»ã—ä½¿ã„æ–¹ã‚’ã¾ã¨ã‚ã¦ã¿ãŸã€‚ ã¾ãšã¯Windows Azure Marketplaceã¸ã®ç™»éŒ²ãŒå¿…è¦ã¨ãªã‚‹ã€‚ ä»¥ä¸‹ã®URLã‚ˆã‚Šã€ŒMicrosoft ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã€ã§ã‚µã‚¤ãƒ³ã‚¤ãƒ³ã‚’ã™ã‚‹ã€‚ ã“ã®ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã¯ã€ä»¥å‰ã¯Windows Live IDã¨å‘¼ã°ã‚Œã¦ã„ãŸã‚‚ã®ã¨åŒã˜ã§ã¯ãªã„ã‹ã¨æ€ã†ã€‚è‡ªåˆ†ã¯ãã®IDã§ãƒã‚°ã‚¤ãƒ³ã§ããŸã€‚æŒã£ã¦ã„ãªã‘ã‚Œã°ãƒã‚°ã‚¤ãƒ³ç”»é¢ã®æ–°è¦ç™»éŒ²ã®ãƒªãƒ³ã‚¯ã‚’ãŸã©ã£ã¦ä½œæˆã—ã™ã‚‹ã€‚ Windows Azure Marketplaceã‚’åˆã‚ã¦ä½¿ã†ã®ã§ã‚ã‚Œã°ã„ã‚ã„ã‚èžã‹ã‚Œã‚‹ã®ã§å¿…è¦ãªæƒ…å ±ã‚’å…¥åŠ›ã—ã¦ç™»éŒ²ã‚’å®Œäº†ã•ã›ã‚‹ã€‚ Windows Azure Marketplace http://datamarket.azure.com/
teddy-g 2014/11/16
MS Translator APIã®å…·ä½“çš„ãªå®Ÿè£…æ–¹æ³•ãã®â‘

api

webservices

English

translation

microsoft

bing
ãƒªãƒ³ã‚¯
MySQLåˆå¿ƒè€…å…¥é–€è¬›åº§
ãƒ»æœ¬æ ¼çš„ãªãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã‚’å¦ã³ãŸã„å ´åˆã¯ Javaåˆå¿ƒè€…å…¥é–€è¬›åº§ ã‚’æ¬¡ã®ã‚¹ãƒ†ãƒƒãƒ—ã¨ã—ã¦ã”æ´»ç”¨ãã ã•ã„ã€‚ ãƒ»Webç³»ã®ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã‚’å¦ã³ãŸã„å ´åˆã¯ PHPåˆå¿ƒè€…å…¥é–€è¬›åº§ ã‚’æ¬¡ã®ã‚¹ãƒ†ãƒƒãƒ—ã¨ã—ã¦ã”æ´»ç”¨ãã ã•ã„ã€‚ ä»Šå›žã¯MySQLã«ä½œæˆæ¸ˆã¿ã®ã€ŒSampleDB040ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã€ODBCãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹ã«ç™»éŒ²ã—ã¾ã™ã€‚ç™»éŒ²ã™ã‚‹ã¨Accessãªã©ã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‹ã‚‰MySQLã«æŽ¥ç¶šã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ ODBCãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹ã¸ã®ç™»éŒ²ã¯ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã”ã¨ã«ãªã‚Šã¾ã™ã€‚ã‚‚ã—MySQLã«æ–°ã—ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œæˆã—ã¦ODBCã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ã€æ–°ãŸã«ç™»éŒ²ãŒå¿…è¦ã§ã™ã€‚ ï¼Šä»¥ä¸‹ã®ç™»éŒ²ä½œæ¥ã‚’è¡Œãªã†ã«ã¯ã€MySQLãŒé–‹å§‹ã—ã¦ã„ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã®ã§ã€ã”æ³¨æ„ãã ã•ã„ã€‚ ã€1ã€‘ã‚ã‚‰ã‹ã˜ã‚MySQLã‚’é–‹å§‹ã—ã¦ãŠãã¾ã™ã€‚ 1.ã‚³ãƒžãƒ³ãƒ‰ãƒ—ãƒãƒ³ãƒ—ãƒˆã‚’èµ·å‹•ã—ã¾ã™ã€‚ 2.ã€Œnet start mysqlã€ã¨å…¥åŠ›ã—ã€ã€ŒEnterã‚ãƒ¼ã€ã‚’æŠ¼
teddy-g 2014/02/04
MySQLã‚’EXCELã§ä½¿ã†ã«å½“ãŸã£ã¦ODBCãƒ‰ãƒ©ã‚¤ãƒã‚’ã¶ã¡è¾¼ã‚€æ–¹æ³•ã«å°±ã„ã¦

mysql

excel

windows

microsoft

office
ãƒªãƒ³ã‚¯
Datamensional - Analytics Consulting, Weather Data, Data Management
Add weather, gain a competitive edge If you still donâ€™t have a weather strategy in place, youâ€™re missing a golden opportunity.
teddy-g 2014/02/04
Excelã‹ã‚‰MySQLä½¿ã†ã¨ãã®ç´°ã‹ã„èª¬æ˜Ž

excel

database

mysql

office

microsoft
ãƒªãƒ³ã‚¯
PowerPivot for Excel 2010 å…¥é–€ç·¨ æ“ä½œã®åŸºç¤Ž
PowerPivot for Excel is anÂ add-in toÂ Excel 2010 that is used forÂ adding and integrating large amounts of data in Excel workbooks. The data that you add to the workbook is stored internally, as an embedded PowerPivot database inside the .xlsx file. You can use this database in Excel or in Power View reports. In Excel, the workbook provides all of the data visualization and interaction features. Usi
teddy-g 2014/02/04
Excelã‹ã‚‰MySQLä½¿ã†æ–¹æ³•ã€‚ä½¿ã„ã“ãªã›ãŸã‚‰ä¾¿åˆ©ãã†ã ãŒã€çµå±€ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã‹ã‚‰CSVåãå‡ºã•ã›ã¡ã‚ƒã†

microsoft

office

excel

access

database

mysql
ãƒªãƒ³ã‚¯
https://jp.techcrunch.com/2009/07/14/20090713the-complete-guide-to-microsofts-office-2010/
teddy-g 2009/07/14
ä¹…ã€…ã«ãƒžã‚¤ã‚¯ãƒã‚½ãƒ•ãƒˆè£½å“ã«èŒãˆãŸã€‚

microsoft

office

excel

powerpoint

word
ãƒªãƒ³ã‚¯
ãƒ•ã‚£ãƒ«ã‚¿ã‚ªãƒ—ã‚·ãƒ§ãƒ³(AdvancedFilter)ã§ã®ãƒ‡ãƒ¼ã‚¿æŠ½å‡º:Excel VBAå…¥é–€
ãƒ•ã‚£ãƒ«ã‚¿ã‚ªãƒ—ã‚·ãƒ§ãƒ³(AdvancedFilter)ã§ã®ãƒ‡ãƒ¼ã‚¿æŠ½å‡ºã€€ã€€ã€€Topã¸ ãƒ‡ãƒ¼ã‚¿ãƒªã‚¹ãƒˆã‹ã‚‰å¿…è¦ãªãƒ‡ãƒ¼ã‚¿ã‚’æŠ½å‡ºã—ã¾ã™ã€‚ æŠ½å‡ºæ¡ä»¶ã‚’ã‚»ãƒ«ã«æ›¸ãå‡ºã—ã¦ãŠãå¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ æŠ½å‡ºæ¡ä»¶ã®æ›¸ãæ–¹ã¯Excelã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã‚ˆã£ã¦ç•°ãªã‚‹ã®ã§æ³¨æ„ãŒå¿…è¦ã§ã™ã€‚ Excel2002ã¯å®Œå…¨ä¸€è‡´ã€ãã‚Œä»¥å¤–ã¯å‰æ–¹ä¸€è‡´ã«ãªã‚Šã¾ã™ã€‚ è©³ã—ãã¯ãƒ‡ãƒ¼ã‚¿æŠ½å‡ºã®æ¡ä»¶è¨å®šãŒãƒãƒ¼ã‚¸ãƒ§ãƒ³ã«ã‚ˆã£ã¦ç•°ãªã‚‹ã‚’ã”è¦§ãã ã•ã„ã€‚ expression.AdvancedFilter(Action, CriteriaRange, CopyToRange, Unique)
teddy-g 2009/02/05
ãƒ•ã‚£ãƒ«ã‚¿ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’VBAã§æ›¸ãã¨ãã®ç´°ã‹ã„è¨å®šã€‚çµæ§‹ä½¿ã†ã®ã§å‚™å¿˜ç”¨ã«ã€‚

vb

vba

excel

microsoft
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
teddy-g 2009/01/16
WORDã¸ã®ãƒ„ãƒ¼ãƒ«ãƒãƒ¼ã®ã‚¢ãƒ‰ã‚¤ãƒ³æ–¹æ³•ã€‚dotãƒ•ã‚¡ã‚¤ãƒ«ã«ã—ã¦startupãƒ•ã‚©ãƒ«ãƒ€ã«å…¥ã‚Œã¦å®Œæˆã€‚

vba

word

microsoft

office
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸