{"id":3526,"date":"2015-09-20T23:00:18","date_gmt":"2015-09-20T21:00:18","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=3526"},"modified":"2023-11-30T21:29:08","modified_gmt":"2023-11-30T20:29:08","slug":"data-cleansing-training-clean-extract-data-using-formulas-excels-analytical-tools","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/data-cleansing-training-clean-extract-data-using-formulas-excels-analytical-tools\/","title":{"rendered":"Data Cleansing Training &#8211; Clean &#038; Extract Data Using Formulas &#038; Excel&#8217;s Analytical Tools"},"content":{"rendered":"<div class=\"ddio_countdown_wrap\"><\/div>\n<h2 style=\"text-align: center;\"><\/h2>\n<h2 style=\"text-align: center;\"><\/h2>\n<div class='content-column one_half'><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\/data-cleansing-training-clean-extract-data-using-formulas-excels-analytical-tools\/#Video_1\" title=\"Video #1:\">Video #1:<\/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\/data-cleansing-training-clean-extract-data-using-formulas-excels-analytical-tools\/#Watch_Now\" title=\"Watch Now\n\">Watch Now\n<\/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\/data-cleansing-training-clean-extract-data-using-formulas-excels-analytical-tools\/#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\/data-cleansing-training-clean-extract-data-using-formulas-excels-analytical-tools\/#Coming_Soon\" 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\/data-cleansing-training-clean-extract-data-using-formulas-excels-analytical-tools\/#VIDEO_2\" title=\"VIDEO\u00a0#2:\">VIDEO\u00a0#2:<\/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\/data-cleansing-training-clean-extract-data-using-formulas-excels-analytical-tools\/#Clean_Extract_Data_Using_Formulas_Excels_Analytical_Tools\" title=\"Clean &amp; Extract Data Using Formulas &amp; Excel&#8217;s Analytical Tools\">Clean &amp; Extract Data Using Formulas &amp; Excel&#8217;s Analytical Tools<\/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\/data-cleansing-training-clean-extract-data-using-formulas-excels-analytical-tools\/#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-8\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/data-cleansing-training-clean-extract-data-using-formulas-excels-analytical-tools\/#and_we_will_reply_back_with_a_fix\" title=\"and we will reply back with a fix ?\">and we will reply back with a fix ?<\/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\/data-cleansing-training-clean-extract-data-using-formulas-excels-analytical-tools\/#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_1\"><\/span><span style=\"text-decoration: underline; color: #0000ff;\"><a style=\"color: #0000ff; text-decoration: underline;\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-training-different-ways-to-format-data-using-power-query\/\" target=\"_blank\">Video #1:<\/a><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Watch_Now\"><\/span><span style=\"color: #339966;\">Watch Now<\/span><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/data-cleansing-training-clean-extract-data-using-formulas-excels-analytical-tools\/\"><br \/>\n<\/a><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-training-different-ways-to-format-data-using-power-query\/\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Data Cleansing Training - Clean &amp; Extract Data Using Formulas &amp; Excel&#039;s Analytical Tools\"  class=\"aligncenter wp-image-3530 size-medium\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/PQ-VIDEO-1-THUMBNAIL-WITH-VIDEO-PLAYER-300x169.png\" alt=\"Data Cleansing Training - Clean &amp; Extract Data Using Formulas &amp; Excel&#039;s Analytical Tools\" width=\"300\" height=\"169\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/PQ-VIDEO-1-THUMBNAIL-WITH-VIDEO-PLAYER-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/PQ-VIDEO-1-THUMBNAIL-WITH-VIDEO-PLAYER-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/PQ-VIDEO-1-THUMBNAIL-WITH-VIDEO-PLAYER-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/06\/PQ-VIDEO-1-THUMBNAIL-WITH-VIDEO-PLAYER.png 1280w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><span class=\"ez-toc-section-end\"><\/span><\/h2><\/div>\n<div class='content-column one_half last_column'><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<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<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<h2><\/h2><\/div><div class='clear_column'><\/div>\n<h3 style=\"text-align: center;\"><\/h3>\n<p>&nbsp;<\/p>\n<hr \/>\n<h3><\/h3>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"VIDEO_2\"><\/span><span style=\"color: #0000ff;\">VIDEO\u00a0#2:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"Clean_Extract_Data_Using_Formulas_Excels_Analytical_Tools\"><\/span><span style=\"color: #ff0000;\">Clean &amp; Extract Data Using Formulas &amp; Excel&#8217;s Analytical Tools<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>&nbsp;<\/p>\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\/hbv40nz7tm?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><center><em>In this training you are going to learn the following:<\/em><\/center><center><\/center><center><\/center><center>Intro\u00a0from John Michaloudis\u00a0<\/center><center><strong>03:55<\/strong> &#8211; Proper Function<br \/>\n<strong>05:00<\/strong> &#8211; Trim Function<br \/>\n<strong>08:55<\/strong> &#8211; Text Function<br \/>\n<strong>13:30<\/strong> &#8211; Left Function<br \/>\n<strong>15:05<\/strong> &#8211; Right Function<br \/>\n<strong>17:00<\/strong> &#8211; Substitute Function<br \/>\n<strong>18:55<\/strong> &#8211; Replace Function<br \/>\n<strong>20:45<\/strong> &#8211; Convert Text to Numbers &#8211; TIP!!!<br \/>\n<strong>22:50<\/strong> &#8211; Number Formats<br \/>\n<strong>24:00<\/strong> &#8211; Find Blank Cells With Color<br \/>\n<strong>25:35<\/strong> &#8211; Remove Duplicates<br \/>\n<strong>27:30<\/strong> &#8211; Text to Column &#8211; Split Names<br \/>\n<strong>28:30<\/strong> &#8211; Flash Fill<\/center>&nbsp;<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\"><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Data-Cleansing-Training-Video-2-Workbooks.zip\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/09\/Data-Cleansing-Training-Video-2-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\">Data-Cleansing-Training-Video-2-Workbooks.zip<\/span><\/a><\/p>\n<\/div>\n<p>&nbsp;<\/p>\n<hr \/>\n<p>&nbsp;<\/p>\n<h2 style=\"text-align: center;\"><\/h2>\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<h2 style=\"text-align: center;\"><span class=\"ez-toc-section\" id=\"and_we_will_reply_back_with_a_fix\"><\/span><span style=\"color: #000000;\">and we will reply back with a fix ?<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\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","protected":false},"excerpt":{"rendered":"<p>&nbsp; VIDEO\u00a0#2: Clean &amp; Extract Data Using Formulas &amp; Excel&#8217;s Analytical Tools &nbsp; &nbsp; &nbsp; In this training you are going to learn the following:Intro\u00a0from John Michaloudis\u00a003:55 &#8211; Proper Function 05:00 &#8211; Trim Function 08:55 &#8211; Text Function 13:30 &#8211; Left Function 15:05 &#8211; Right Function 17:00 &#8211; Substitute Function 18:55 &#8211; Replace Function 20:45 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":4589,"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\/3526"}],"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=3526"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/3526\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/4589"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=3526"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=3526"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=3526"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}