{"id":3327,"date":"2015-09-21T23:00:55","date_gmt":"2015-09-21T21:00:55","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=3327"},"modified":"2024-02-06T16:08:50","modified_gmt":"2024-02-06T15:08:50","slug":"free-training-different-ways-to-format-data-using-power-query","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-training-different-ways-to-format-data-using-power-query\/","title":{"rendered":"Data Cleansing Training &#8211; Different Ways to Format Data Using Power Query"},"content":{"rendered":"<div class=\"ddio_countdown_wrap\"><\/div>\n<div style=\"text-align: center;\">\n<h2 style=\"text-align: center;\"><\/h2>\n<\/div>\n<div class='content-column one_half'><div style=\"text-align: center;\">\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-training-different-ways-to-format-data-using-power-query\/#Video_2\" title=\"Video #2: \">Video #2: <\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-training-different-ways-to-format-data-using-power-query\/#Coming_Soon\" title=\"Coming Soon\">Coming Soon<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-training-different-ways-to-format-data-using-power-query\/#Video_3\" title=\"Video #3: \">Video #3: <\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-training-different-ways-to-format-data-using-power-query\/#Coming_Soon-2\" title=\"Coming Soon\">Coming Soon<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-training-different-ways-to-format-data-using-power-query\/#VIDEO_1\" title=\"VIDEO #1:\u00a0\">VIDEO #1:\u00a0<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-training-different-ways-to-format-data-using-power-query\/#Different_Ways_to_Format_Data_Using_Power_Query\" title=\"Different Ways to Format Data Using Power Query\">Different Ways to Format Data Using Power Query<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-training-different-ways-to-format-data-using-power-query\/#Bonus_Video\" title=\"Bonus Video:\">Bonus Video:<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-training-different-ways-to-format-data-using-power-query\/#Install_Power_Query_Using_Excel_2010_Excel_2013\" title=\"Install Power Query Using Excel 2010 &amp; Excel 2013\">Install Power Query Using Excel 2010 &amp; Excel 2013<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-training-different-ways-to-format-data-using-power-query\/#Please_leave_a_comment_below_with_your_data_cleansing_issues\" title=\"Please leave a comment below with your data cleansing issues\">Please leave a comment below with your data cleansing issues<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-training-different-ways-to-format-data-using-power-query\/#and_we_will_reply_back_with_a_fix_%F0%9F%99%82\" title=\"and we will reply back with a fix \ud83d\ude42\">and we will reply back with a fix \ud83d\ude42<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-training-different-ways-to-format-data-using-power-query\/#make_sure_to_be_specific_and_attach_example_workbooks_if_possible\" title=\"(make sure to be specific and attach example workbooks if possible)\">(make sure to be specific and attach example workbooks if possible)<\/a><\/li><\/ul><\/nav><\/div>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Video_2\"><\/span><span style=\"text-decoration: underline; color: #0000ff;\">Video #2: <\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<div style=\"text-align: center;\">\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Coming_Soon\"><\/span><span style=\"color: #ff0000;\">Coming Soon<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" title=\"Data Cleansing Training - Consolidate Multiple Excel Workbooks &amp; Worksheets Using Power Query\"  class=\"aligncenter wp-image-4589 size-medium\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/PLC-VIDEO-2-THUMBNAIL-v2-300x169.png\" alt=\"Data Cleansing Training - Consolidate Multiple Excel Workbooks &amp; Worksheets Using Power Query\" width=\"300\" height=\"169\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/PLC-VIDEO-2-THUMBNAIL-v2-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/PLC-VIDEO-2-THUMBNAIL-v2-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/PLC-VIDEO-2-THUMBNAIL-v2-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/06\/PLC-VIDEO-2-THUMBNAIL-v2.png 1280w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<div style=\"text-align: center;\">\n<h2 style=\"text-align: center;\"><\/h2>\n<\/div><\/div>\n<div class='content-column one_half last_column'><div style=\"text-align: center;\">\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Video_3\"><\/span><span style=\"text-decoration: underline; color: #0000ff;\">Video #3: <\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<div style=\"text-align: center;\">\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Coming_Soon-2\"><\/span><span style=\"color: #ff0000;\">Coming Soon<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<p style=\"text-align: center;\"><img loading=\"lazy\" decoding=\"async\" title=\"Data Cleansing Training - Different Ways to Format Data Using Power Query\"  class=\"aligncenter wp-image-3596 size-medium\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/06\/PLC-VIDEO-3-THUMBNAIL-with-play-300x169.png\" alt=\"Data Cleansing Training - Different Ways to Format Data Using Power Query\" width=\"300\" height=\"169\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/06\/PLC-VIDEO-3-THUMBNAIL-with-play-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/06\/PLC-VIDEO-3-THUMBNAIL-with-play-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/06\/PLC-VIDEO-3-THUMBNAIL-with-play-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2014\/06\/PLC-VIDEO-3-THUMBNAIL-with-play.png 1280w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\n<div style=\"text-align: center;\">\n<h2 style=\"text-align: center;\"><\/h2>\n<\/div><\/div><div class='clear_column'><\/div>\n<h3 style=\"text-align: center;\"><\/h3>\n<p>&nbsp;<\/p>\n<hr \/>\n<div style=\"text-align: center;\">\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"VIDEO_1\"><\/span><span style=\"color: #0000ff;\">VIDEO #1:\u00a0<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<div style=\"text-align: center;\">\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Different_Ways_to_Format_Data_Using_Power_Query\"><\/span><span style=\"color: #ff0000;\">Different Ways to Format Data Using Power Query<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<p>&nbsp;<\/p>\n<div class=\"wistia_responsive_padding\" style=\"padding: 56.25% 0 0 0; position: relative;\">\n<div class=\"wistia_responsive_wrapper\" style=\"height: 100%; left: 0; position: absolute; top: 0; width: 100%;\"><iframe class=\"wistia_embed\" src=\"\/\/fast.wistia.net\/embed\/iframe\/q7vc71dell?videoFoam=true\" name=\"wistia_embed\" width=\"100%\" height=\"100%\" frameborder=\"0\" scrolling=\"no\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/div>\n<\/div>\n<p><script src=\"\/\/fast.wistia.net\/assets\/external\/E-v1.js\" async><\/script><\/p>\n<p><center><em>In this training you are going to learn the following:<\/em><\/center><center><\/center><center><\/center><center>Intro\u00a0from John Michaloudis &amp; Oz du Soleil<\/center><center><strong>12:10<\/strong>\u00a0&#8211; Intro to <a class=\"wpil_keyword_link\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/50-things-you-can-do-with-excel-power-query\/\" target=\"_blank\" rel=\"noopener\" title=\"Power Query\" data-wpil-keyword-link=\"linked\">Power Query<\/a> (Get &amp; Transform in Excel 2016)<br \/>\n<strong>16:30<\/strong>\u00a0&#8211; Trim leading &amp; trailing spaces<br \/>\n<strong>20:30<\/strong> &#8211;\u00a0Format &#8220;text&#8221; Dates &amp; Values using Excel v Power Query<br \/>\n<strong>24:15<\/strong> &#8211;\u00a0Parse URLs using Excel v Power Query<br \/>\n<strong>27:55<\/strong> &#8211;\u00a0Transform &amp; automate reports from an ERP system (e.g. Oracle, SAP, QuickBooks) into a flat Excel file<\/center>&nbsp;<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\" style=\"text-align: center;\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Power-Query-Data-Cleansing-Excel-Workbooks.zip\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/Power-Query-Data-Cleansing-Excel-Workbooks.zip\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\"> download the excel workbooks used in this video <i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Power-Query-Data-Cleansing-Excel-Workbooks.zip<\/span><\/a><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<hr \/>\n<h3 style=\"text-align: center;\"><\/h3>\n<div style=\"text-align: center;\">\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Bonus_Video\"><\/span><span style=\"color: #0000ff;\">Bonus Video:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<div style=\"text-align: center;\">\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Install_Power_Query_Using_Excel_2010_Excel_2013\"><\/span><span style=\"color: #ff0000;\">Install Power Query Using Excel 2010 &amp; Excel 2013<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<div class=\"wistia_responsive_padding\" style=\"padding: 56.25% 0 0 0; position: relative;\">\n<div class=\"wistia_responsive_wrapper\" style=\"height: 100%; left: 0; position: absolute; top: 0; width: 100%;\"><iframe class=\"wistia_embed\" src=\"\/\/fast.wistia.net\/embed\/iframe\/g5x4ydssx0?videoFoam=true\" name=\"wistia_embed\" width=\"100%\" height=\"100%\" frameborder=\"0\" scrolling=\"no\" allowfullscreen=\"allowfullscreen\"><\/iframe><\/div>\n<\/div>\n<p><script src=\"\/\/fast.wistia.net\/assets\/external\/E-v1.js\" async><\/script><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/installing-power-query-excel-2010\/\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/installing-power-query-excel-2010\/\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"> CLICK HERE TO READ HOW TO INSTALL POWER QUERY IN EXCEL 2010 <i class=\"fa fa-download\"><\/i><\/a><\/p>\n<\/div>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/install-power-query-with-excel-2013\/\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/install-power-query-with-excel-2013\/\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"> CLICK HERE TO READ HOW TO INSTALL POWER QUERY IN EXCEL 2013 <i class=\"fa fa-download\"><\/i><\/a><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<hr \/>\n<p>&nbsp;<\/p>\n<div style=\"text-align: center;\">\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Please_leave_a_comment_below_with_your_data_cleansing_issues\"><\/span><span style=\"color: #000000;\">Please leave a comment below with your data cleansing issues<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<div style=\"text-align: center;\">\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"and_we_will_reply_back_with_a_fix_%F0%9F%99%82\"><\/span><span style=\"color: #000000;\">and we will reply back with a fix \ud83d\ude42<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n<p>&nbsp;<\/p>\n<div style=\"text-align: center;\">\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"make_sure_to_be_specific_and_attach_example_workbooks_if_possible\"><\/span><span style=\"color: #000000;\">(<em>make sure to be specific and attach example workbooks if possible<\/em>)<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; VIDEO #1:\u00a0 Different Ways to Format Data Using Power Query &nbsp; In this training you are going to learn the following:Intro\u00a0from John Michaloudis &amp; Oz du Soleil12:10\u00a0&#8211; Intro to Power Query (Get &amp; Transform in Excel 2016) 16:30\u00a0&#8211; Trim leading &amp; trailing spaces 20:30 &#8211;\u00a0Format &#8220;text&#8221; Dates &amp; Values using Excel v Power Query [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3530,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[1],"tags":[],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/3327"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=3327"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/3327\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/3530"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=3327"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=3327"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=3327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}