{"id":84955,"date":"2017-05-18T12:56:48","date_gmt":"2017-05-18T10:56:48","guid":{"rendered":"https:\/\/www.deskmodder.de\/blog\/?p=84955"},"modified":"2017-05-18T12:56:48","modified_gmt":"2017-05-18T10:56:48","slug":"excel-add-in-transform-data-by-example-aus-der-microsoft-garage","status":"publish","type":"post","link":"https:\/\/www.deskmodder.de\/blog\/2017\/05\/18\/excel-add-in-transform-data-by-example-aus-der-microsoft-garage\/","title":{"rendered":"Excel Add-In &#8211; Transform Data by Example aus der Microsoft Garage"},"content":{"rendered":"<p>Kurz notiert f\u00fcr alle diejenigen unter euch die Excel nutzen. Microsoft hat ein Add-in im Office Store bereitgestellt, mit dem man schnell Datumsangaben, Uhrzeit Adressen, Telefonnummern und auch URLs standardisieren und transformieren kann. Es nennt sich Transform Data by Example und stammt aus der Microsoft Garage.<\/p>\n<p>Man kennt es ja sicherlich. Man legt eine neue Tabelle an hat in der einen Spalten das Datum angelegt und m\u00f6chte nun in der n\u00e4chsten Spalte den Wochentag extrahieren. Diese Funktion \u00fcbernimmt dann das Add-In. Aber das ist nat\u00fcrlich noch nicht alles. Schaut euch einfach mal das Video dazu an.<\/p>\n<p><a href=\"https:\/\/www.deskmodder.de\/blog\/wp-content\/uploads\/2017\/05\/transform-data-by-example.jpg\" rel=\"lightbox[84955]\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.deskmodder.de\/blog\/wp-content\/uploads\/2017\/05\/transform-data-by-example-496x360.jpg\" alt=\"\" width=\"496\" height=\"360\" class=\"aligncenter size-medium wp-image-84957\" srcset=\"https:\/\/www.deskmodder.de\/blog\/wp-content\/uploads\/2017\/05\/transform-data-by-example-496x360.jpg 496w, https:\/\/www.deskmodder.de\/blog\/wp-content\/uploads\/2017\/05\/transform-data-by-example-282x205.jpg 282w, https:\/\/www.deskmodder.de\/blog\/wp-content\/uploads\/2017\/05\/transform-data-by-example-803x583.jpg 803w, https:\/\/www.deskmodder.de\/blog\/wp-content\/uploads\/2017\/05\/transform-data-by-example.jpg 1608w\" sizes=\"auto, (max-width: 496px) 100vw, 496px\" \/><\/a><\/p>\n<p>Voraussetzung f\u00fcr das kostenlose Add-In ist Excel Online, Excel 2016 oder h\u00f6her und auch Excel 2016 f\u00fcr Mac. Ich selber bin nicht so der Excel-Experte. Aber dass was dort im Video gezeigt wird, erspart eine Menge an Arbeit und Arbeitsschritten.<\/p>\n<p>Download: <a href=\"https:\/\/store.office.com\/en-us\/app.aspx?assetid=WA104380727&#038;sourcecorrid=6f0375cc-e1d7-42ae-98ce-e6fbdf96949e&#038;searchapppos=0&#038;ui=en-US&#038;rs=en-US&#038;ad=US&#038;appredirect=false\" target=\"_blank\">Office Store &#8211; Transform Data by Example<\/a><\/p>\n<div class=\"video-container\"><div style=\"position:relative;width:100%;max-width:810px;height:456px;background-color:black;color:white;padding:0px;\" data-video-id=\"cl7RXSHdsyo\">\n\t\t\t\t\t\t<div style=\"text-align: center;\">\n\t\t\t\t\t\t\t<span class=\"hint-text\">Erst durch Klick auf den Button werden Daten an Youtube \u00fcbermittelt und dir das Video angezeigt.<br\/>Mehr dazu in unserer <a href=\"https:\/\/www.deskmodder.de\/blog\/datenschutz-auf-deskmodder-de\/\" target=\"_blank\">Datenschutzrichtlinie<\/a><\/span>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<div style=\"text-align: center; margin-top: 10px;\">\n\t\t\t\t\t\t\t<button onclick=\"showVideo(this)\">Verstanden!<\/button>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"video-container\" style=\"display:none;\">\n\t\t\t\t\t\t\t<img decoding=\"async\" src=\"https:\/\/img.youtube.com\/vi\/cl7RXSHdsyo\/hqdefault.jpg\" alt=\"Vorschaubild\" style=\"width:100%; max-width:810px;\" \/>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t<script>\n\t\t\t\t\t\tfunction showVideo(button) {\n\t\t\t\t\t\t\tconst videoID = button.parentElement.parentElement.getAttribute(\"data-video-id\");\n\t\t\t\t\t\t\tconsole.log(\"Video ID:\", videoID); \/\/ Debugging\n\t\t\t\t\t\t\tconst iframeHTML = \"<iframe width='810' height='456' src='https:\/\/www.youtube-nocookie.com\/embed\/\" + videoID + \"?feature=oembed' frameborder='0' allow='accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture' allowfullscreen><\/iframe>\";\n\n\t\t\t\t\t\t\tbutton.parentElement.parentElement.querySelector(\".video-container\").innerHTML = iframeHTML;\n\n\t\t\t\t\t\t\t\/\/ Video-Container sichtbar machen\n\t\t\t\t\t\t\tbutton.parentElement.parentElement.querySelector(\".video-container\").style.display = \"block\";\n\t\t\t\t\t\t\tbutton.parentElement.parentElement.querySelector(\".hint-text\").style.display = \"none\";\n\t\t\t\t\t\t\tbutton.remove();\n\t\t\t\t\t\t}\n\t\t\t\t\t<\/script><\/div>\n<p><strong>Quelle:<\/strong> <a href=\"https:\/\/www.microsoft.com\/en-us\/garage\/stories\/2017-05-16-Transform-Data.aspx\" target=\"_blank\">microsoft\/garage\/<\/a> via: WalkingCat<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kurz notiert f\u00fcr alle diejenigen unter euch die Excel nutzen. Microsoft hat ein Add-in im Office Store bereitgestellt, mit dem man schnell Datumsangaben, Uhrzeit Adressen, Telefonnummern und auch URLs standardisieren und transformieren kann. Es nennt sich Transform Data by Example&hellip; <\/p>\n","protected":false},"author":134,"featured_media":84957,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[152],"tags":[10299,17145,9739,17144,1081],"class_list":["post-84955","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-software","tag-downlaod","tag-excel-2016","tag-mac","tag-neues-add-in","tag-video"],"wp_featured_image":{"id":84957,"alt_text":"","description":"","media_type":"image","media_details":{"width":1608,"height":1168,"file":"2017\/05\/transform-data-by-example.jpg","sizes":{"thumbnail":{"file":"transform-data-by-example-282x205.jpg","width":282,"height":205,"mime-type":"image\/jpeg","source_url":"https:\/\/www.deskmodder.de\/blog\/wp-content\/uploads\/2017\/05\/transform-data-by-example-282x205.jpg"},"medium":{"file":"transform-data-by-example-496x360.jpg","width":496,"height":360,"mime-type":"image\/jpeg","source_url":"https:\/\/www.deskmodder.de\/blog\/wp-content\/uploads\/2017\/05\/transform-data-by-example-496x360.jpg"},"large":{"file":"transform-data-by-example-803x583.jpg","width":803,"height":583,"mime-type":"image\/jpeg","source_url":"https:\/\/www.deskmodder.de\/blog\/wp-content\/uploads\/2017\/05\/transform-data-by-example-803x583.jpg"},"wp_review_large":{"file":"transform-data-by-example-320x200.jpg","width":320,"height":200,"mime-type":"image\/jpeg","source_url":"https:\/\/www.deskmodder.de\/blog\/wp-content\/uploads\/2017\/05\/transform-data-by-example-320x200.jpg"},"wp_review_small":{"file":"transform-data-by-example-65x65.jpg","width":65,"height":65,"mime-type":"image\/jpeg","source_url":"https:\/\/www.deskmodder.de\/blog\/wp-content\/uploads\/2017\/05\/transform-data-by-example-65x65.jpg"},"blog-large":{"file":"transform-data-by-example-642x300.jpg","width":642,"height":300,"mime-type":"image\/jpeg","source_url":"https:\/\/www.deskmodder.de\/blog\/wp-content\/uploads\/2017\/05\/transform-data-by-example-642x300.jpg"},"blog-medium":{"file":"transform-data-by-example-306x205.jpg","width":306,"height":205,"mime-type":"image\/jpeg","source_url":"https:\/\/www.deskmodder.de\/blog\/wp-content\/uploads\/2017\/05\/transform-data-by-example-306x205.jpg"},"recent-thumb":{"file":"transform-data-by-example-350x316.jpg","width":350,"height":316,"mime-type":"image\/jpeg","source_url":"https:\/\/www.deskmodder.de\/blog\/wp-content\/uploads\/2017\/05\/transform-data-by-example-350x316.jpg"},"service-featured":{"file":"transform-data-by-example-600x330.jpg","width":600,"height":330,"mime-type":"image\/jpeg","source_url":"https:\/\/www.deskmodder.de\/blog\/wp-content\/uploads\/2017\/05\/transform-data-by-example-600x330.jpg"},"wp_rp_thumbnail":{"file":"transform-data-by-example-150x150.jpg","width":150,"height":150,"mime-type":"image\/jpeg","source_url":"https:\/\/www.deskmodder.de\/blog\/wp-content\/uploads\/2017\/05\/transform-data-by-example-150x150.jpg"}},"image_meta":{"aperture":"0","credit":"","camera":"","caption":"","created_timestamp":"0","copyright":"","focal_length":"0","iso":"0","shutter_speed":"0","title":"","orientation":"0","keywords":[]}},"post":84955,"source_url":"https:\/\/www.deskmodder.de\/blog\/wp-content\/uploads\/2017\/05\/transform-data-by-example.jpg"},"commentcount":0,"wp_comments":[],"wp_author":{"id":134,"name":"moinmoin","description":"Ich bin nicht allwissend, was <a href=\"https:\/\/www.deskmodder.de\/wiki\/index.php?title=Kategorie:Windows_11\">Windows<\/a> angeht. Aber genau deshalb nehme ich Windows gerne auseinander und unter die Lupe, um all mein Wissen zu erweitern. <i>J\u00fcrgen<\/i>","author_avatar_urls":{"24":"https:\/\/secure.gravatar.com\/avatar\/fab96769102f8886245ab411df9a42a235be79261e4b44aa7ab2a555da8b86b4?s=24&d=mm&r=g","48":"https:\/\/secure.gravatar.com\/avatar\/fab96769102f8886245ab411df9a42a235be79261e4b44aa7ab2a555da8b86b4?s=48&d=mm&r=g","96":"https:\/\/secure.gravatar.com\/avatar\/fab96769102f8886245ab411df9a42a235be79261e4b44aa7ab2a555da8b86b4?s=96&d=mm&r=g"}},"cld_nonce":"e39ac60dc6","yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.6 (Yoast SEO v27.6) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Excel Add-In - Transform Data by Example aus der Microsoft Garage - Deskmodder.de<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.deskmodder.de\/blog\/2017\/05\/18\/excel-add-in-transform-data-by-example-aus-der-microsoft-garage\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Add-In - Transform Data by Example aus der Microsoft Garage\" \/>\n<meta property=\"og:description\" content=\"Kurz notiert f\u00fcr alle diejenigen unter euch die Excel nutzen. Microsoft hat ein Add-in im Office Store bereitgestellt, mit dem man schnell Datumsangaben, Uhrzeit Adressen, Telefonnummern und auch URLs standardisieren und transformieren kann. Es nennt sich Transform Data by Example&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.deskmodder.de\/blog\/2017\/05\/18\/excel-add-in-transform-data-by-example-aus-der-microsoft-garage\/\" \/>\n<meta property=\"og:site_name\" content=\"Deskmodder.de\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/Deskmodder\" \/>\n<meta property=\"article:published_time\" content=\"2017-05-18T10:56:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.deskmodder.de\/blog\/wp-content\/uploads\/2017\/05\/transform-data-by-example.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1608\" \/>\n\t<meta property=\"og:image:height\" content=\"1168\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"moinmoin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@Deskmodder\" \/>\n<meta name=\"twitter:site\" content=\"@Deskmodder\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/2017\\\/05\\\/18\\\/excel-add-in-transform-data-by-example-aus-der-microsoft-garage\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/2017\\\/05\\\/18\\\/excel-add-in-transform-data-by-example-aus-der-microsoft-garage\\\/\"},\"author\":{\"name\":\"moinmoin\",\"@id\":\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/#\\\/schema\\\/person\\\/a40b17a9503c4a1568ac4073bb54182a\"},\"headline\":\"Excel Add-In &#8211; Transform Data by Example aus der Microsoft Garage\",\"datePublished\":\"2017-05-18T10:56:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/2017\\\/05\\\/18\\\/excel-add-in-transform-data-by-example-aus-der-microsoft-garage\\\/\"},\"wordCount\":170,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/2017\\\/05\\\/18\\\/excel-add-in-transform-data-by-example-aus-der-microsoft-garage\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/05\\\/transform-data-by-example.jpg\",\"keywords\":[\"downlaod\",\"Excel 2016\",\"Mac\",\"Neues Add-In\",\"Video\"],\"articleSection\":[\"Software &amp; Updates\"],\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/2017\\\/05\\\/18\\\/excel-add-in-transform-data-by-example-aus-der-microsoft-garage\\\/#respond\"]}],\"copyrightYear\":\"2017\",\"copyrightHolder\":{\"@id\":\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/2017\\\/05\\\/18\\\/excel-add-in-transform-data-by-example-aus-der-microsoft-garage\\\/\",\"url\":\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/2017\\\/05\\\/18\\\/excel-add-in-transform-data-by-example-aus-der-microsoft-garage\\\/\",\"name\":\"Excel Add-In - Transform Data by Example aus der Microsoft Garage - Deskmodder.de\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/2017\\\/05\\\/18\\\/excel-add-in-transform-data-by-example-aus-der-microsoft-garage\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/2017\\\/05\\\/18\\\/excel-add-in-transform-data-by-example-aus-der-microsoft-garage\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/05\\\/transform-data-by-example.jpg\",\"datePublished\":\"2017-05-18T10:56:48+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/2017\\\/05\\\/18\\\/excel-add-in-transform-data-by-example-aus-der-microsoft-garage\\\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/2017\\\/05\\\/18\\\/excel-add-in-transform-data-by-example-aus-der-microsoft-garage\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/2017\\\/05\\\/18\\\/excel-add-in-transform-data-by-example-aus-der-microsoft-garage\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/05\\\/transform-data-by-example.jpg\",\"contentUrl\":\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/wp-content\\\/uploads\\\/2017\\\/05\\\/transform-data-by-example.jpg\",\"width\":1608,\"height\":1168},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/2017\\\/05\\\/18\\\/excel-add-in-transform-data-by-example-aus-der-microsoft-garage\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Add-In &#8211; Transform Data by Example aus der Microsoft Garage\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/\",\"name\":\"Deskmodder.de\",\"description\":\"News zum Thema Microsoft, Windows 11 \\\/ 10, sowie anderen Neuigkeiten aus dem Netz, viele Tipps und individuelle Hilfe bei Problemen in unserem Forum \u25cf Deskmodder - seit 2003\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"de\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/#organization\",\"name\":\"Deskmodder\",\"url\":\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/01\\\/deskmodder-logo-app.png\",\"contentUrl\":\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/01\\\/deskmodder-logo-app.png\",\"width\":281,\"height\":286,\"caption\":\"Deskmodder\"},\"image\":{\"@id\":\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/Deskmodder\",\"https:\\\/\\\/x.com\\\/Deskmodder\",\"https:\\\/\\\/mastodontech.de\\\/@Deskmodder\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/deskmodder\",\"https:\\\/\\\/mewe.com\\\/group\\\/5c83b5231add826fc80cdae1\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/#\\\/schema\\\/person\\\/a40b17a9503c4a1568ac4073bb54182a\",\"name\":\"moinmoin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fab96769102f8886245ab411df9a42a235be79261e4b44aa7ab2a555da8b86b4?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fab96769102f8886245ab411df9a42a235be79261e4b44aa7ab2a555da8b86b4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/fab96769102f8886245ab411df9a42a235be79261e4b44aa7ab2a555da8b86b4?s=96&d=mm&r=g\",\"caption\":\"moinmoin\"},\"description\":\"Ich bin nicht allwissend, was Windows angeht. Aber genau deshalb nehme ich Windows gerne auseinander und unter die Lupe, um all mein Wissen zu erweitern. J\u00fcrgen\",\"url\":\"https:\\\/\\\/www.deskmodder.de\\\/blog\\\/author\\\/moinmoin\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Excel Add-In - Transform Data by Example aus der Microsoft Garage - Deskmodder.de","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.deskmodder.de\/blog\/2017\/05\/18\/excel-add-in-transform-data-by-example-aus-der-microsoft-garage\/","og_locale":"de_DE","og_type":"article","og_title":"Excel Add-In - Transform Data by Example aus der Microsoft Garage","og_description":"Kurz notiert f\u00fcr alle diejenigen unter euch die Excel nutzen. Microsoft hat ein Add-in im Office Store bereitgestellt, mit dem man schnell Datumsangaben, Uhrzeit Adressen, Telefonnummern und auch URLs standardisieren und transformieren kann. Es nennt sich Transform Data by Example&hellip;","og_url":"https:\/\/www.deskmodder.de\/blog\/2017\/05\/18\/excel-add-in-transform-data-by-example-aus-der-microsoft-garage\/","og_site_name":"Deskmodder.de","article_publisher":"https:\/\/www.facebook.com\/Deskmodder","article_published_time":"2017-05-18T10:56:48+00:00","og_image":[{"width":1608,"height":1168,"url":"https:\/\/www.deskmodder.de\/blog\/wp-content\/uploads\/2017\/05\/transform-data-by-example.jpg","type":"image\/jpeg"}],"author":"moinmoin","twitter_card":"summary_large_image","twitter_creator":"@Deskmodder","twitter_site":"@Deskmodder","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.deskmodder.de\/blog\/2017\/05\/18\/excel-add-in-transform-data-by-example-aus-der-microsoft-garage\/#article","isPartOf":{"@id":"https:\/\/www.deskmodder.de\/blog\/2017\/05\/18\/excel-add-in-transform-data-by-example-aus-der-microsoft-garage\/"},"author":{"name":"moinmoin","@id":"https:\/\/www.deskmodder.de\/blog\/#\/schema\/person\/a40b17a9503c4a1568ac4073bb54182a"},"headline":"Excel Add-In &#8211; Transform Data by Example aus der Microsoft Garage","datePublished":"2017-05-18T10:56:48+00:00","mainEntityOfPage":{"@id":"https:\/\/www.deskmodder.de\/blog\/2017\/05\/18\/excel-add-in-transform-data-by-example-aus-der-microsoft-garage\/"},"wordCount":170,"commentCount":0,"publisher":{"@id":"https:\/\/www.deskmodder.de\/blog\/#organization"},"image":{"@id":"https:\/\/www.deskmodder.de\/blog\/2017\/05\/18\/excel-add-in-transform-data-by-example-aus-der-microsoft-garage\/#primaryimage"},"thumbnailUrl":"https:\/\/www.deskmodder.de\/blog\/wp-content\/uploads\/2017\/05\/transform-data-by-example.jpg","keywords":["downlaod","Excel 2016","Mac","Neues Add-In","Video"],"articleSection":["Software &amp; Updates"],"inLanguage":"de","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.deskmodder.de\/blog\/2017\/05\/18\/excel-add-in-transform-data-by-example-aus-der-microsoft-garage\/#respond"]}],"copyrightYear":"2017","copyrightHolder":{"@id":"https:\/\/www.deskmodder.de\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/www.deskmodder.de\/blog\/2017\/05\/18\/excel-add-in-transform-data-by-example-aus-der-microsoft-garage\/","url":"https:\/\/www.deskmodder.de\/blog\/2017\/05\/18\/excel-add-in-transform-data-by-example-aus-der-microsoft-garage\/","name":"Excel Add-In - Transform Data by Example aus der Microsoft Garage - Deskmodder.de","isPartOf":{"@id":"https:\/\/www.deskmodder.de\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.deskmodder.de\/blog\/2017\/05\/18\/excel-add-in-transform-data-by-example-aus-der-microsoft-garage\/#primaryimage"},"image":{"@id":"https:\/\/www.deskmodder.de\/blog\/2017\/05\/18\/excel-add-in-transform-data-by-example-aus-der-microsoft-garage\/#primaryimage"},"thumbnailUrl":"https:\/\/www.deskmodder.de\/blog\/wp-content\/uploads\/2017\/05\/transform-data-by-example.jpg","datePublished":"2017-05-18T10:56:48+00:00","breadcrumb":{"@id":"https:\/\/www.deskmodder.de\/blog\/2017\/05\/18\/excel-add-in-transform-data-by-example-aus-der-microsoft-garage\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.deskmodder.de\/blog\/2017\/05\/18\/excel-add-in-transform-data-by-example-aus-der-microsoft-garage\/"]}]},{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/www.deskmodder.de\/blog\/2017\/05\/18\/excel-add-in-transform-data-by-example-aus-der-microsoft-garage\/#primaryimage","url":"https:\/\/www.deskmodder.de\/blog\/wp-content\/uploads\/2017\/05\/transform-data-by-example.jpg","contentUrl":"https:\/\/www.deskmodder.de\/blog\/wp-content\/uploads\/2017\/05\/transform-data-by-example.jpg","width":1608,"height":1168},{"@type":"BreadcrumbList","@id":"https:\/\/www.deskmodder.de\/blog\/2017\/05\/18\/excel-add-in-transform-data-by-example-aus-der-microsoft-garage\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/www.deskmodder.de\/blog\/"},{"@type":"ListItem","position":2,"name":"Excel Add-In &#8211; Transform Data by Example aus der Microsoft Garage"}]},{"@type":"WebSite","@id":"https:\/\/www.deskmodder.de\/blog\/#website","url":"https:\/\/www.deskmodder.de\/blog\/","name":"Deskmodder.de","description":"News zum Thema Microsoft, Windows 11 \/ 10, sowie anderen Neuigkeiten aus dem Netz, viele Tipps und individuelle Hilfe bei Problemen in unserem Forum \u25cf Deskmodder - seit 2003","publisher":{"@id":"https:\/\/www.deskmodder.de\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.deskmodder.de\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"de"},{"@type":"Organization","@id":"https:\/\/www.deskmodder.de\/blog\/#organization","name":"Deskmodder","url":"https:\/\/www.deskmodder.de\/blog\/","logo":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/www.deskmodder.de\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.deskmodder.de\/blog\/wp-content\/uploads\/2019\/01\/deskmodder-logo-app.png","contentUrl":"https:\/\/www.deskmodder.de\/blog\/wp-content\/uploads\/2019\/01\/deskmodder-logo-app.png","width":281,"height":286,"caption":"Deskmodder"},"image":{"@id":"https:\/\/www.deskmodder.de\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/Deskmodder","https:\/\/x.com\/Deskmodder","https:\/\/mastodontech.de\/@Deskmodder","https:\/\/www.youtube.com\/user\/deskmodder","https:\/\/mewe.com\/group\/5c83b5231add826fc80cdae1"]},{"@type":"Person","@id":"https:\/\/www.deskmodder.de\/blog\/#\/schema\/person\/a40b17a9503c4a1568ac4073bb54182a","name":"moinmoin","image":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/secure.gravatar.com\/avatar\/fab96769102f8886245ab411df9a42a235be79261e4b44aa7ab2a555da8b86b4?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/fab96769102f8886245ab411df9a42a235be79261e4b44aa7ab2a555da8b86b4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/fab96769102f8886245ab411df9a42a235be79261e4b44aa7ab2a555da8b86b4?s=96&d=mm&r=g","caption":"moinmoin"},"description":"Ich bin nicht allwissend, was Windows angeht. Aber genau deshalb nehme ich Windows gerne auseinander und unter die Lupe, um all mein Wissen zu erweitern. J\u00fcrgen","url":"https:\/\/www.deskmodder.de\/blog\/author\/moinmoin\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.deskmodder.de\/blog\/wp-content\/uploads\/2017\/05\/transform-data-by-example.jpg","_links":{"self":[{"href":"https:\/\/www.deskmodder.de\/blog\/wp-json\/wp\/v2\/posts\/84955","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.deskmodder.de\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.deskmodder.de\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.deskmodder.de\/blog\/wp-json\/wp\/v2\/users\/134"}],"replies":[{"embeddable":true,"href":"https:\/\/www.deskmodder.de\/blog\/wp-json\/wp\/v2\/comments?post=84955"}],"version-history":[{"count":0,"href":"https:\/\/www.deskmodder.de\/blog\/wp-json\/wp\/v2\/posts\/84955\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.deskmodder.de\/blog\/wp-json\/wp\/v2\/media\/84957"}],"wp:attachment":[{"href":"https:\/\/www.deskmodder.de\/blog\/wp-json\/wp\/v2\/media?parent=84955"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.deskmodder.de\/blog\/wp-json\/wp\/v2\/categories?post=84955"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.deskmodder.de\/blog\/wp-json\/wp\/v2\/tags?post=84955"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}