{"id":178749,"date":"2024-04-02T21:28:45","date_gmt":"2024-04-02T20:28:45","guid":{"rendered":"https:\/\/datascientest.com\/en\/?p=178749"},"modified":"2024-02-15T11:49:35","modified_gmt":"2024-02-15T10:49:35","slug":"excel-powerquery-how-can-you-boost-your-excel-productivity","status":"publish","type":"post","link":"https:\/\/datascientest.com\/en\/excel-powerquery-how-can-you-boost-your-excel-productivity","title":{"rendered":"How can you boost your Excel productivity with PowerQuery?"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"178749\" class=\"elementor elementor-178749\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-b434dc3 e-flex e-con-boxed e-con\" data-id=\"b434dc3\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-027edc7 e-con-full e-flex e-con\" data-id=\"027edc7\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-f67b523 elementor-widget elementor-widget-heading\" data-id=\"f67b523\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Excel PowerQuery: Data analysis and preparation often account for almost 80% of the work of a data analyst or data scientist. It is therefore a bottleneck that considerably slows down the work of exploiting the data. Fortunately, there are a number of tools available to reduce this time-consuming activity! PowerQuery is one of the most powerful, and we're going to introduce it to you in this article.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dee1aa5 elementor-widget elementor-widget-heading\" data-id=\"dee1aa5\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">What is PowerQuery?\n<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-77068cb elementor-widget elementor-widget-text-editor\" data-id=\"77068cb\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p><a href=\"https:\/\/datascientest.com\/en\/power-query-what-is-it-whats-it-for\">PowerQuery<\/a> is a tool developed by Microsoft and directly integrated into some of its applications, in particular Excel and Power BI\/ <strong>Excel PowerQuery.<\/strong><\/p><p>It solves many of the challenges faced by professionals when preparing data.<\/p><p>These include:<\/p><ul><li>Data comes from a variety of non-standardised sources<\/li><li>Each data source requires specific and often complex processing.<\/li><li>The use of macros is slow to programme and not very adaptable or reproducible.<\/li><li>The volume of data is too great to be processed by Excel.<\/li><\/ul><p>\u00a0<\/p><p>By addressing these various difficulties, PowerQuery provides a practical way of boosting your <a href=\"https:\/\/datascientest.com\/en\/etl-or-extract-transform-load-definition-and-use\">ETL (Extract &#8211; Transform &#8211; Load) process.<\/a><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-3c79ca7 e-con-full e-flex e-con\" data-id=\"3c79ca7\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-4e44edb elementor-widget elementor-widget-heading\" data-id=\"4e44edb\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">PowerQuery features \n<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-a47bf5e e-flex e-con-boxed e-con\" data-id=\"a47bf5e\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-bf91c39 e-con-full e-flex e-con\" data-id=\"bf91c39\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-c544ce6 elementor-widget elementor-widget-text-editor\" data-id=\"c544ce6\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Firstly, <strong>PowerQuery<\/strong> allows you to use a variety of data sources. Using the tool, you can connect multiple data sources to the same Excel file. This data can come from databases (<a href=\"https:\/\/datascientest.com\/en\/sql-tutorial-top-5-most-useful-methods\">SQL<\/a>, Azure, Oracle, Salesforce), but also from text or csv files or directly from web pages. (small visual if possible)<\/p><p>You can access this option from the Data tab, then in the Recover and transform data section.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-79bfdc0 elementor-widget elementor-widget-image\" data-id=\"79bfdc0\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"238\" height=\"161\" src=\"https:\/\/datascientest.com\/en\/files\/2021\/02\/powerquery1.png\" class=\"attachment-large size-large wp-image-47993\" alt=\"Power query\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cf4d8ee elementor-widget elementor-widget-text-editor\" data-id=\"cf4d8ee\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>Once a data source has been selected, a query is opened to load the data. The Transform button then opens a <strong>PowerQuery Editor<\/strong> window.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-c73ffce elementor-widget elementor-widget-image\" data-id=\"c73ffce\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"512\" height=\"90\" src=\"https:\/\/datascientest.com\/en\/files\/2021\/02\/Powerquery2.png\" class=\"attachment-large size-large wp-image-47992\" alt=\"Power query\" srcset=\"https:\/\/datascientest.com\/en\/files\/2021\/02\/Powerquery2.png 512w, https:\/\/datascientest.com\/en\/files\/2021\/02\/Powerquery2-300x53.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/>\t\t\t\t\t\t\t\t\t\t\t<figcaption class=\"widget-image-caption wp-caption-text\"><\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9461bd3 elementor-widget elementor-widget-text-editor\" data-id=\"9461bd3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>This editor makes it possible to perform numerous data processing operations that were previously carried out by macros that were slow to program and inflexible.<\/p><p>For example, you can :<\/p><ul><li>Rearrange rows and columns<\/li><li>Delete missing values<\/li><li>Filter rows<\/li><li>Use the first row as a header<\/li><li>Merge, split or group columns<\/li><li>And much, much more!<\/li><\/ul><p>\u00a0<\/p><p>Once this treatment has been defined, the data is converted directly into a table, ready to be used for pivot tables!<\/p><p>What&#8217;s more, once the query has been run, it can be saved and reused many times, just like a macro. However, no <a href=\"https:\/\/datascientest.com\/en\/excel-vba-how-to-automate-tasks-with-this-language\">knowledge of VBA is required for this tool.<\/a><\/p><p>It is therefore possible to completely automate the data processing workflow by combining different queries.<\/p><p>One of the final advantages of<strong> PowerQuery<\/strong> is that it doesn&#8217;t weigh down your Excel file. In fact, it simply imports data from different sources and transforms it without recopying it in its entirety. This option means you can work with databases containing several million lines!<\/p><p>IF you are planning to use PowerQuery with your database, we recommend that you organise your database properly beforehand to avoid unnecessary effort. To do this, take a look at our article: SQL Tutorial : TOP 5 most useful functions<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-81772d2 e-flex e-con-boxed e-con\" data-id=\"81772d2\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t<div class=\"elementor-element elementor-element-7630e75 e-con-full e-flex e-con\" data-id=\"7630e75\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;full&quot;}\">\n\t\t\t\t<div class=\"elementor-element elementor-element-6f7b851 elementor-widget elementor-widget-heading\" data-id=\"6f7b851\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Conclusion \n<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6fe39ee elementor-widget elementor-widget-text-editor\" data-id=\"6fe39ee\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><a href=\"https:\/\/datascientest.com\/en\/formulas-in-power-query-formulas-the-best-of-them\">PowerQuery<\/a> is a powerful and indispensable tool when working with Excel and Power BI. It is complemented by Power Pivot, a new feature that enables rapid, automated analysis of data that has already been processed. If you&#8217;d like to find out more about automatic data acquisition and processing, take a look at our Data Engineer course!<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7c235af elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"7c235af\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/en\/data-courses\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Discover our training courses<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Excel PowerQuery: Data analysis and preparation often account for almost 80% of the work of a data analyst or data scientist. It is therefore a bottleneck that considerably slows down the work of exploiting the data. Fortunately, there are a number of tools available to reduce this time-consuming activity! PowerQuery is one of the most [&hellip;]<\/p>\n","protected":false},"author":67,"featured_media":178793,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2421],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How can you boost your Excel productivity with PowerQuery?<\/title>\n<meta name=\"description\" content=\"When you want to work with PowerQuery Excel, you should be aware that your tools and software that are deployed in...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/en\/excel-powerquery-how-can-you-boost-your-excel-productivity\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How can you boost your Excel productivity with PowerQuery?\" \/>\n<meta property=\"og:description\" content=\"Excel PowerQuery: Data analysis and preparation often account for almost 80% of the work of a data analyst or data scientist. It is therefore a bottleneck\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/en\/excel-powerquery-how-can-you-boost-your-excel-productivity\" \/>\n<meta property=\"og:site_name\" content=\"Data Science Courses | DataScientest\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataScientestEN\" \/>\n<meta property=\"article:published_time\" content=\"2024-04-02T20:28:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-15T10:49:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/en\/files\/2024\/04\/power-query-funktionen.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/webp\" \/>\n<meta name=\"author\" content=\"Melanie\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:site\" content=\"@DataScientest__\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Melanie\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/datascientest.com\/en\/excel-powerquery-how-can-you-boost-your-excel-productivity#article\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/excel-powerquery-how-can-you-boost-your-excel-productivity\"},\"author\":{\"name\":\"Melanie\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\"},\"headline\":\"How can you boost your Excel productivity with PowerQuery?\",\"datePublished\":\"2024-04-02T20:28:45+00:00\",\"dateModified\":\"2024-02-15T10:49:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/datascientest.com\/en\/excel-powerquery-how-can-you-boost-your-excel-productivity\"},\"wordCount\":537,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"articleSection\":[\"Dev\"],\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/datascientest.com\/en\/excel-powerquery-how-can-you-boost-your-excel-productivity#respond\"]}],\"copyrightYear\":\"2024\",\"copyrightHolder\":{\"@id\":\"https:\/\/datascientest.com\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/en\/excel-powerquery-how-can-you-boost-your-excel-productivity\",\"url\":\"https:\/\/datascientest.com\/en\/excel-powerquery-how-can-you-boost-your-excel-productivity\",\"name\":\"How can you boost your Excel productivity with PowerQuery?\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/en\/#website\"},\"datePublished\":\"2024-04-02T20:28:45+00:00\",\"dateModified\":\"2024-02-15T10:49:35+00:00\",\"description\":\"When you want to work with PowerQuery Excel, you should be aware that your tools and software that are deployed in...\",\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/en\/excel-powerquery-how-can-you-boost-your-excel-productivity\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/en\/#website\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"name\":\"Data Science Courses | DataScientest\",\"description\":\"Leader in Data Science Courses\",\"publisher\":{\"@id\":\"https:\/\/datascientest.com\/en\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/en\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/datascientest.com\/en\/#organization\",\"name\":\"DataScientest\",\"url\":\"https:\/\/datascientest.com\/en\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"contentUrl\":\"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png\",\"width\":301,\"height\":301,\"caption\":\"DataScientest\"},\"image\":{\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/DataScientestEN\",\"https:\/\/twitter.com\/DataScientest__\",\"https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/\",\"https:\/\/www.tiktok.com\/@datascientest\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d\",\"name\":\"Melanie\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g\",\"caption\":\"Melanie\"},\"url\":\"https:\/\/datascientest.com\/en\/author\/melaniekrause\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How can you boost your Excel productivity with PowerQuery?","description":"When you want to work with PowerQuery Excel, you should be aware that your tools and software that are deployed in...","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:\/\/datascientest.com\/en\/excel-powerquery-how-can-you-boost-your-excel-productivity","og_locale":"en_GB","og_type":"article","og_title":"How can you boost your Excel productivity with PowerQuery?","og_description":"Excel PowerQuery: Data analysis and preparation often account for almost 80% of the work of a data analyst or data scientist. It is therefore a bottleneck","og_url":"https:\/\/datascientest.com\/en\/excel-powerquery-how-can-you-boost-your-excel-productivity","og_site_name":"Data Science Courses | DataScientest","article_publisher":"https:\/\/www.facebook.com\/DataScientestEN","article_published_time":"2024-04-02T20:28:45+00:00","article_modified_time":"2024-02-15T10:49:35+00:00","og_image":[{"width":1024,"height":512,"url":"https:\/\/datascientest.com\/en\/files\/2024\/04\/power-query-funktionen.webp","type":"image\/webp"}],"author":"Melanie","twitter_card":"summary_large_image","twitter_creator":"@DataScientest__","twitter_site":"@DataScientest__","twitter_misc":{"Written by":"Melanie","Estimated reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/datascientest.com\/en\/excel-powerquery-how-can-you-boost-your-excel-productivity#article","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/excel-powerquery-how-can-you-boost-your-excel-productivity"},"author":{"name":"Melanie","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d"},"headline":"How can you boost your Excel productivity with PowerQuery?","datePublished":"2024-04-02T20:28:45+00:00","dateModified":"2024-02-15T10:49:35+00:00","mainEntityOfPage":{"@id":"https:\/\/datascientest.com\/en\/excel-powerquery-how-can-you-boost-your-excel-productivity"},"wordCount":537,"commentCount":0,"publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"articleSection":["Dev"],"inLanguage":"en-GB","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/datascientest.com\/en\/excel-powerquery-how-can-you-boost-your-excel-productivity#respond"]}],"copyrightYear":"2024","copyrightHolder":{"@id":"https:\/\/datascientest.com\/#organization"}},{"@type":"WebPage","@id":"https:\/\/datascientest.com\/en\/excel-powerquery-how-can-you-boost-your-excel-productivity","url":"https:\/\/datascientest.com\/en\/excel-powerquery-how-can-you-boost-your-excel-productivity","name":"How can you boost your Excel productivity with PowerQuery?","isPartOf":{"@id":"https:\/\/datascientest.com\/en\/#website"},"datePublished":"2024-04-02T20:28:45+00:00","dateModified":"2024-02-15T10:49:35+00:00","description":"When you want to work with PowerQuery Excel, you should be aware that your tools and software that are deployed in...","inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/en\/excel-powerquery-how-can-you-boost-your-excel-productivity"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/en\/#website","url":"https:\/\/datascientest.com\/en\/","name":"Data Science Courses | DataScientest","description":"Leader in Data Science Courses","publisher":{"@id":"https:\/\/datascientest.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/en\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/datascientest.com\/en\/#organization","name":"DataScientest","url":"https:\/\/datascientest.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","contentUrl":"https:\/\/datascientest.com\/en\/wp-content\/blogs.dir\/9\/files\/2024\/02\/DataScientest_icon_blue-2.png","width":301,"height":301,"caption":"DataScientest"},"image":{"@id":"https:\/\/datascientest.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataScientestEN","https:\/\/twitter.com\/DataScientest__","https:\/\/www.linkedin.com\/school\/datascientest\/mycompany\/","https:\/\/www.tiktok.com\/@datascientest"]},{"@type":"Person","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/19d5f7ade9407eb69af3bf6d1ae1731d","name":"Melanie","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/datascientest.com\/en\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/8d3d660a0698de06f13ecf4823519da1?s=96&d=mm&r=g","caption":"Melanie"},"url":"https:\/\/datascientest.com\/en\/author\/melaniekrause"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/178749"}],"collection":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/users\/67"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/comments?post=178749"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/posts\/178749\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media\/178793"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/media?parent=178749"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/categories?post=178749"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/en\/wp-json\/wp\/v2\/tags?post=178749"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}