{"id":9669,"date":"2021-11-02T07:01:14","date_gmt":"2021-11-02T07:01:14","guid":{"rendered":"https:\/\/2022.globalexcelsummit.com\/?post_type=product&#038;p=9669"},"modified":"2022-04-18T08:01:09","modified_gmt":"2022-04-18T08:01:09","slug":"messy-to-magnificent-cleansing-and-organizing-your-data-with-power-query","status":"publish","type":"product","link":"https:\/\/2022.globalexcelsummit.com\/ticket\/messy-to-magnificent-cleansing-and-organizing-your-data-with-power-query\/","title":{"rendered":"Messy to Magnificent: Cleansing and organizing your data with Power Query (with Oz du Soleil)"},"content":{"rendered":"<p><span style=\"font-family: stratos; font-size: 14pt; color: #000000;\"><strong>Masterclass Description: <\/strong><\/span><span style=\"color: #000000; font-family: stratos; font-size: 14pt;\">Too few people know about Power Query, an Excel feature that&#8217;s been around since Excel 2010. It is designed to help import, cleanse and reshape data so that the data is useful. Imagine &#8230; you finally got the data you wanted but, <\/span><\/p>\n<div>\n<ul>\n<li><span style=\"font-family: stratos; font-size: 14pt; color: #000000;\">it&#8217;s all stacked in a single column and needs to be unstacked<\/span><\/li>\n<li><span style=\"font-family: stratos; font-size: 14pt; color: #000000;\">the Name, Employee ID, Email and Address are all in the same cell<\/span><\/li>\n<li><span style=\"font-family: stratos; font-size: 14pt; color: #000000;\">you&#8217;ve got 15 worksheets&#8217; worth of data that need to be swept into one place before it can be useful. <\/span><\/li>\n<li><span style=\"font-family: stratos; font-size: 14pt; color: #000000;\">you need to compare datasets to identify what&#8217;s in Dataset A that&#8217;s not in Dataset B<\/span><\/li>\n<li><span style=\"font-family: stratos; font-size: 14pt; color: #000000;\">your data is in a report that was structured for another purpose, but needs to be rearranged for your needs<\/span><\/li>\n<\/ul>\n<\/div>\n<div><\/div>\n<div><span style=\"color: #000000;\"><span style=\"font-family: stratos; font-size: 14pt;\">STOP! Don&#8217;t copy-paste or start scrolling, eye-balling, dragging and typing. In this class, Oz will share methods for handling these (and other) common needs. You&#8217;ll also see how these tasks can be automated when you have to re-do them on a regular basis. <\/span><span style=\"font-family: stratos; font-size: 14pt;\">Excel&#8217;s Power Query simplifies these tasks through a robust interface &#8211; minimizing or even eliminating the need to write formulas or code.<\/span><\/span><\/div>\n<p>&nbsp;<\/p>\n<p><span style=\"font-family: stratos; font-size: 14pt; color: #000000;\"><strong>Skills requirements: <\/strong><\/span><span style=\"font-family: stratos; font-size: 14pt; color: #000000;\">This is an introductory Power Query Masterclass. No previous knowledge or experience with Power Query is required. However, you should be an intermediate Microsoft Excel user to follow along.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-family: stratos; font-size: 14pt; color: #000000;\"><strong>About your Instructor: <\/strong><\/span><span style=\"font-family: stratos; font-size: 14pt; color: #000000;\">Oz du Soleil is an Excel developer, trainer, videographer, author, LinkedIn instructor, and Microsoft Excel MVP. He is known for his brash, overly dramatic YouTube videos at Excel on Fire. Oz likes to go beyond Excel tips-&amp;-tricks to bring you the real world why, how and when. He wants you to get the most from Microsoft Excel. Oz is a US Navy veteran and lives in Portland Oregon.\u00a0 <\/span><span style=\"font-family: stratos; font-size: 14pt; color: #000000;\">Fun fact: Oz is in a documentary about sriracha hot sauce. <\/span><span style=\"font-family: stratos; font-size: 14pt; color: #000000;\">Full profile<\/span> <span style=\"font-family: stratos; font-size: 14pt;\"><a href=\"https:\/\/2022.globalexcelsummit.com\/team-member\/oz-du-soleil\/\">here<\/a><\/span><span style=\"font-family: stratos; font-size: 14pt; color: #000000;\">.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p><span style=\"font-family: stratos; font-size: 14pt; color: #000000;\">This is an introductory Power Query class that will teach you how to import, cleanse and reshape data so that it is useful, easy to work with and saves you tons of time.<\/span><\/p>\n<p>&nbsp;<\/p>\n<div style=\"padding-left: 40px;\"><em><span style=\"font-family: stratos; font-size: 14pt; color: #000000;\">Without clean, trustworthy data, you have nothing. No dashboards, no forecasts, no analysis &#8230; nothing.<\/span><\/em><\/div>\n<div style=\"padding-left: 40px;\"><span style=\"font-family: stratos; font-size: 14pt; color: #000000;\">&#8211; Oz du Soleil, Excel on Fire, Excel MVP &amp; LinkedIn Instructor<\/span><\/div>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"font-family: stratos; font-size: 14pt; color: #000000;\">Who is this for?<\/span><\/strong><\/p>\n<p><span style=\"font-family: stratos; font-size: 14pt; color: #000000;\">Anyone who regularly has to work with data that&#8217;s not immediately useful. Customer Service Reps, Sales Assistants, Marketers, Event Planners, Analysts, etc.<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #000000;\"><strong><span style=\"font-family: stratos; font-size: 14pt;\">What will you learn?<\/span><\/strong><\/span><\/p>\n<p><span style=\"font-family: stratos; font-size: 14pt; color: #000000;\">\u2714\ufe0e What Power Query is and how it can make your life easier and your data useful<\/span><\/p>\n<p><span style=\"font-family: stratos; font-size: 14pt; color: #000000;\">\u2714\ufe0e Methods for handling common data-cleansing tasks<\/span><\/p>\n<p><span style=\"font-family: stratos; font-size: 14pt; color: #000000;\">\u2714\ufe0e Merging datasets using Power Query&#8217;s joins<\/span><\/p>\n<p><span style=\"font-family: stratos; font-size: 14pt; color: #000000;\">\u2714\ufe0e Appending data from multiple sources<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-family: stratos; font-size: 14pt; color: #000000;\"><strong>What&#8217;s included?<\/strong><\/span><br \/>\n<span style=\"font-family: stratos; font-size: 14pt; color: #000000;\">\u25b6\ufe0f 4.5 hours on-demand class with Oz du Soleil, Microsoft MVP<\/span><br \/>\n<span style=\"font-family: stratos; font-size: 14pt; color: #000000;\">\ud83c\udf93 Claim up to 4.5 hours of CPD (Continuing Professional Development) hours \/ points<\/span><br \/>\n<span style=\"font-family: stratos; font-size: 14pt; color: #000000;\">\ud83d\uddc2 All presentation and spreadsheet files<\/span><br \/>\n<span style=\"font-family: stratos; font-size: 14pt; color: #000000;\">\ud83d\uddd3 Lifetime on-demand access<\/span><br \/>\n<span style=\"font-family: stratos; font-size: 14pt; color: #000000;\">\ud83c\udf10 Join from anywhere in the world<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #219365;\"><em><span style=\"font-family: stratos;\">*This Masterclass is also included in our <span style=\"text-decoration: underline;\"><a href=\"https:\/\/2022.globalexcelsummit.com\/ticket\/6-masterclass-bundle-recorded-content\/\">6x Masterclasses Bundle <\/a><\/span>, as well as, our all-inclusive <span style=\"text-decoration: underline;\"><a href=\"https:\/\/2022.globalexcelsummit.com\/ticket\/conference-6-masterclasses-recorded-content\/\">Conference + 6x Masterclasses<\/a><\/span> full event package.<\/span><\/em><\/span><\/p>\n","protected":false},"featured_media":11168,"comment_status":"closed","ping_status":"closed","template":"","meta":{"content-type":""},"product_cat":[122],"product_tag":[127,125,129],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v18.6 (Yoast SEO v20.12) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cleansing and organising your data with Power Query | Online Masterclass<\/title>\n<meta name=\"description\" content=\"Master Power Query with Oz du Soleil. It is designed to help you import, cleanse and reshape Microsoft Excel data so that it&#039;s useful.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/2022.globalexcelsummit.com\/ticket\/messy-to-magnificent-cleansing-and-organizing-your-data-with-power-query\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Messy to Magnificent: Cleansing and organizing your data with Power Query (with Oz du Soleil)\" \/>\n<meta property=\"og:description\" content=\"Master Power Query with Oz du Soleil. It is designed to help you import, cleanse and reshape Microsoft Excel data so that it&#039;s useful.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/2022.globalexcelsummit.com\/ticket\/messy-to-magnificent-cleansing-and-organizing-your-data-with-power-query\/\" \/>\n<meta property=\"og:site_name\" content=\"Global Excel Summit 2022\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/globalexcelsummit\/\" \/>\n<meta property=\"article:modified_time\" content=\"2022-04-18T08:01:09+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/2022.globalexcelsummit.com\/wp-content\/uploads\/2021\/10\/Masterclass-CPD-OnDemand-Oz.png\" \/>\n\t<meta property=\"og:image:width\" content=\"600\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@ExcelSummit\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/2022.globalexcelsummit.com\/ticket\/messy-to-magnificent-cleansing-and-organizing-your-data-with-power-query\/\",\"url\":\"https:\/\/2022.globalexcelsummit.com\/ticket\/messy-to-magnificent-cleansing-and-organizing-your-data-with-power-query\/\",\"name\":\"Cleansing and organising your data with Power Query | Online Masterclass\",\"isPartOf\":{\"@id\":\"https:\/\/2022.globalexcelsummit.com\/#website\"},\"datePublished\":\"2021-11-02T07:01:14+00:00\",\"dateModified\":\"2022-04-18T08:01:09+00:00\",\"description\":\"Master Power Query with Oz du Soleil. It is designed to help you import, cleanse and reshape Microsoft Excel data so that it's useful.\",\"breadcrumb\":{\"@id\":\"https:\/\/2022.globalexcelsummit.com\/ticket\/messy-to-magnificent-cleansing-and-organizing-your-data-with-power-query\/#breadcrumb\"},\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/2022.globalexcelsummit.com\/ticket\/messy-to-magnificent-cleansing-and-organizing-your-data-with-power-query\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/2022.globalexcelsummit.com\/ticket\/messy-to-magnificent-cleansing-and-organizing-your-data-with-power-query\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/2022.globalexcelsummit.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Online Store\",\"item\":\"https:\/\/2022.globalexcelsummit.com\/online-store\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Messy to Magnificent: Cleansing and organizing your data with Power Query (with Oz du Soleil)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/2022.globalexcelsummit.com\/#website\",\"url\":\"https:\/\/2022.globalexcelsummit.com\/\",\"name\":\"Global Excel Summit 2022\",\"description\":\"The Power to Excel\",\"publisher\":{\"@id\":\"https:\/\/2022.globalexcelsummit.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/2022.globalexcelsummit.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/2022.globalexcelsummit.com\/#organization\",\"name\":\"Global Excel Summit\",\"url\":\"https:\/\/2022.globalexcelsummit.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"https:\/\/2022.globalexcelsummit.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/2022.globalexcelsummit.com\/wp-content\/uploads\/2021\/09\/GES-Logo-01.png\",\"contentUrl\":\"https:\/\/2022.globalexcelsummit.com\/wp-content\/uploads\/2021\/09\/GES-Logo-01.png\",\"width\":380,\"height\":380,\"caption\":\"Global Excel Summit\"},\"image\":{\"@id\":\"https:\/\/2022.globalexcelsummit.com\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/globalexcelsummit\/\",\"https:\/\/twitter.com\/ExcelSummit\",\"https:\/\/www.instagram.com\/globalexcelsummit\/\",\"https:\/\/www.linkedin.com\/showcase\/global-excel-summit\/?viewAsMember=true\",\"https:\/\/www.youtube.com\/channel\/UCTfuBzwePfCBitahu5U00Yg\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Cleansing and organising your data with Power Query | Online Masterclass","description":"Master Power Query with Oz du Soleil. It is designed to help you import, cleanse and reshape Microsoft Excel data so that it's useful.","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:\/\/2022.globalexcelsummit.com\/ticket\/messy-to-magnificent-cleansing-and-organizing-your-data-with-power-query\/","og_locale":"en_US","og_type":"article","og_title":"Messy to Magnificent: Cleansing and organizing your data with Power Query (with Oz du Soleil)","og_description":"Master Power Query with Oz du Soleil. It is designed to help you import, cleanse and reshape Microsoft Excel data so that it's useful.","og_url":"https:\/\/2022.globalexcelsummit.com\/ticket\/messy-to-magnificent-cleansing-and-organizing-your-data-with-power-query\/","og_site_name":"Global Excel Summit 2022","article_publisher":"https:\/\/www.facebook.com\/globalexcelsummit\/","article_modified_time":"2022-04-18T08:01:09+00:00","og_image":[{"width":600,"height":600,"url":"https:\/\/2022.globalexcelsummit.com\/wp-content\/uploads\/2021\/10\/Masterclass-CPD-OnDemand-Oz.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_site":"@ExcelSummit","twitter_misc":{"Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/2022.globalexcelsummit.com\/ticket\/messy-to-magnificent-cleansing-and-organizing-your-data-with-power-query\/","url":"https:\/\/2022.globalexcelsummit.com\/ticket\/messy-to-magnificent-cleansing-and-organizing-your-data-with-power-query\/","name":"Cleansing and organising your data with Power Query | Online Masterclass","isPartOf":{"@id":"https:\/\/2022.globalexcelsummit.com\/#website"},"datePublished":"2021-11-02T07:01:14+00:00","dateModified":"2022-04-18T08:01:09+00:00","description":"Master Power Query with Oz du Soleil. It is designed to help you import, cleanse and reshape Microsoft Excel data so that it's useful.","breadcrumb":{"@id":"https:\/\/2022.globalexcelsummit.com\/ticket\/messy-to-magnificent-cleansing-and-organizing-your-data-with-power-query\/#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["https:\/\/2022.globalexcelsummit.com\/ticket\/messy-to-magnificent-cleansing-and-organizing-your-data-with-power-query\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/2022.globalexcelsummit.com\/ticket\/messy-to-magnificent-cleansing-and-organizing-your-data-with-power-query\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/2022.globalexcelsummit.com\/"},{"@type":"ListItem","position":2,"name":"Online Store","item":"https:\/\/2022.globalexcelsummit.com\/online-store\/"},{"@type":"ListItem","position":3,"name":"Messy to Magnificent: Cleansing and organizing your data with Power Query (with Oz du Soleil)"}]},{"@type":"WebSite","@id":"https:\/\/2022.globalexcelsummit.com\/#website","url":"https:\/\/2022.globalexcelsummit.com\/","name":"Global Excel Summit 2022","description":"The Power to Excel","publisher":{"@id":"https:\/\/2022.globalexcelsummit.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/2022.globalexcelsummit.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en"},{"@type":"Organization","@id":"https:\/\/2022.globalexcelsummit.com\/#organization","name":"Global Excel Summit","url":"https:\/\/2022.globalexcelsummit.com\/","logo":{"@type":"ImageObject","inLanguage":"en","@id":"https:\/\/2022.globalexcelsummit.com\/#\/schema\/logo\/image\/","url":"https:\/\/2022.globalexcelsummit.com\/wp-content\/uploads\/2021\/09\/GES-Logo-01.png","contentUrl":"https:\/\/2022.globalexcelsummit.com\/wp-content\/uploads\/2021\/09\/GES-Logo-01.png","width":380,"height":380,"caption":"Global Excel Summit"},"image":{"@id":"https:\/\/2022.globalexcelsummit.com\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/globalexcelsummit\/","https:\/\/twitter.com\/ExcelSummit","https:\/\/www.instagram.com\/globalexcelsummit\/","https:\/\/www.linkedin.com\/showcase\/global-excel-summit\/?viewAsMember=true","https:\/\/www.youtube.com\/channel\/UCTfuBzwePfCBitahu5U00Yg"]}]}},"_links":{"self":[{"href":"https:\/\/2022.globalexcelsummit.com\/wp-json\/wp\/v2\/product\/9669"}],"collection":[{"href":"https:\/\/2022.globalexcelsummit.com\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/2022.globalexcelsummit.com\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/2022.globalexcelsummit.com\/wp-json\/wp\/v2\/comments?post=9669"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/2022.globalexcelsummit.com\/wp-json\/wp\/v2\/media\/11168"}],"wp:attachment":[{"href":"https:\/\/2022.globalexcelsummit.com\/wp-json\/wp\/v2\/media?parent=9669"}],"wp:term":[{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/2022.globalexcelsummit.com\/wp-json\/wp\/v2\/product_cat?post=9669"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/2022.globalexcelsummit.com\/wp-json\/wp\/v2\/product_tag?post=9669"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}