{"id":676,"date":"2016-01-30T21:53:28","date_gmt":"2016-01-30T20:53:28","guid":{"rendered":"\/\/www.myexcelonline.com\/podcast\/?p=676"},"modified":"2023-11-30T20:49:34","modified_gmt":"2023-11-30T19:49:34","slug":"007-data-cleansing-analysis-with-oz-du-soleil-excel-podcast","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/007-data-cleansing-analysis-with-oz-du-soleil-excel-podcast\/","title":{"rendered":"007: Data Cleansing &#038; Analysis with Oz du Soleil"},"content":{"rendered":"<div class=\"smart-track-player-container stp-color-f77223-EEEEEE spp-stp-desktop\" data-uid=\"ff3cb9c3\"><\/div><div class=\"spp-shsp-form spp-shsp-form-ff3cb9c3\"><\/div>\n<p><a href=\"\/\/traffic.libsyn.com\/myexcelonline\/007_Data__Cleansing__Analysis_With_Oz_du_Soleil.mp3.mp3\" target=\"_blank\" rel=\"noopener noreferrer\">Listen on Web Browser &gt;&gt;<\/a><\/p>\n<p>Oz du Soleil is an Excel MVP since 2015 and is an expert in data cleansing &amp; analysis.<\/p>\n<p>He has an Excel blog over at <a href=\"http:\/\/ozdusoleil.com\/\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">OzDuSoleil.com<\/a> which is his commitment to data literacy.<\/p>\n<p>He&#8217;s the leading author on the revised version of <a href=\"http:\/\/amzn.to\/1SHnAxb\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Guerrilla Data Analysis Using Microsoft Excel<\/a> and is working on a new book called <strong><em>Full Contact Data Management<\/em><\/strong><\/p>\n<p>In this episode Oz shares his passion on data cleansing, talks about his books and his favourite Excel features.<\/p>\n<p><em>You can subscribe to the show on\u00a0<strong><a href=\"\/\/www.myexcelonline.com\/meo-staging\/podcast\/itune\" target=\"_blank\" rel=\"noopener noreferrer\">iTunes<\/a><\/strong>\u00a0to get automatic\u00a0updates so you don&#8217;t miss out on these awesome interviews and Excel insights!<\/em><\/p>\n<p>You can read my blog post on\u00a0the <strong>Top Excel Data Cleansing Techniques<\/strong> by clicking on the image below:<\/p>\n<p><a href=\"\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-data-cleansing-techniques\/\" target=\"_blank\" rel=\"attachment wp-att-708 noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-708 size-medium\" src=\"\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2016\/02\/Data-Cleansing-300x169.png\" alt=\"Data Cleansing\" width=\"300\" height=\"169\" title=\"\"><\/a><\/p>\n<p>&nbsp;<\/p>\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 class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/007-data-cleansing-analysis-with-oz-du-soleil-excel-podcast\/#Oz%C2%B4s_new_Excel_book\" title=\"Oz\u00b4s new Excel book\n\">Oz\u00b4s new Excel book\n<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/007-data-cleansing-analysis-with-oz-du-soleil-excel-podcast\/#Oz%C2%B4s_Excel_Favorites\" title=\"Oz\u00b4s Excel Favorites\n\">Oz\u00b4s Excel Favorites\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\/podcast\/007-data-cleansing-analysis-with-oz-du-soleil-excel-podcast\/#Interview_Links\" title=\"Interview Links\">Interview Links<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/007-data-cleansing-analysis-with-oz-du-soleil-excel-podcast\/#Oz%C2%B4s_Products\" title=\"Oz\u00b4s Products\">Oz\u00b4s Products<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/007-data-cleansing-analysis-with-oz-du-soleil-excel-podcast\/#Connect_with_Oz\" title=\"Connect with\u00a0Oz\">Connect with\u00a0Oz<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/007-data-cleansing-analysis-with-oz-du-soleil-excel-podcast\/#Listen_to_the_MyExcelOnline_Podcast_on_your_favorite_platform\" title=\"Listen to the MyExcelOnline Podcast on your favorite platform!\">Listen to the MyExcelOnline Podcast on your favorite platform!<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/007-data-cleansing-analysis-with-oz-du-soleil-excel-podcast\/#Free_Resources\" title=\"Free Resources!\">Free Resources!<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/007-data-cleansing-analysis-with-oz-du-soleil-excel-podcast\/#Thanks_for_Listening\" title=\"Thanks for Listening!\">Thanks for Listening!<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Oz%C2%B4s_new_Excel_book\"><\/span><strong>Oz\u00b4s new Excel book<br \/>\n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><a href=\"http:\/\/amzn.to\/1SHnAxb\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Guerrilla Data Analysis Using Microsoft Excel<\/a> on Amazon<\/li>\n<li><a href=\"http:\/\/www.e-junkie.com\/211017\/product\/504939.php#Guerrilla+Data+Analysis+2nd+Edition&amp;aff=277028\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Guerrilla Data Analysis Using Microsoft Excel<\/a> eBook on the MrExcel store<\/li>\n<li><a href=\"http:\/\/www.mrexcel.com\/store\/index.php?l=product_detail&amp;p=311\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Guerrilla Data Analysis Using Microsoft Excel<\/a> Print Edition on the MrExcel store<\/li>\n<li>Co\u00a0Authored by:\n<ul>\n<li><a href=\"\/\/www.myexcelonline.com\/meo-staging\/podcast\/004-excel-with-mrexcel-bill-jelen-podcast\/\" target=\"_blank\" rel=\"noopener noreferrer\">Bill Jelen<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Oz%C2%B4s_Excel_Favorites\"><\/span><strong>Oz\u00b4s Excel Favorites<br \/>\n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><strong>Keyboard Shortcut:<\/strong>\n<ul>\n<li>CTRL + C<\/li>\n<li>CTRL + V<\/li>\n<\/ul>\n<\/li>\n<li><strong>Excel Tip: <\/strong>Play with\u00a0it! \u00a0Trial &amp; error is your best teacher \ud83d\ude42<\/li>\n<li><strong>Function: <\/strong><a href=\"\/\/www.myexcelonline.com\/meo-staging\/blog\/?s=vlookup\" target=\"_blank\" rel=\"noopener noreferrer\">Vlookup functions<\/a><\/li>\n<li><strong>Excel Add-In:\u00a0<\/strong>\n<ul>\n<li><a href=\"http:\/\/www.microsoft.com\/en-us\/download\/details.aspx?id=39379\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Power Query<\/a> via Microsft`s website<\/li>\n<li><a href=\"http:\/\/www.powerquery.training\/course\/?ref=4\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Power Query Live Workshop<\/a><\/li>\n<\/ul>\n<\/li>\n<li><strong>Online Learning Resource:<\/strong>\n<ul>\n<li><a href=\"http:\/\/Chandoo.org\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Chandoo.org<\/a> blog by Chandoo<\/li>\n<li><a href=\"http:\/\/Contextures.com\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Contextures.com<\/a> blog by Debra Dalgleish<\/li>\n<li><a href=\"https:\/\/www.youtube.com\/channel\/UCkndrGoNpUDV-uia6a9jwVg\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Mike Girvin\u00b4s ExcelIsFun<\/a> YouTube channel<\/li>\n<\/ul>\n<\/li>\n<li><strong>Excel Book:<\/strong>\n<ul>\n<li><a href=\"\/\/www.myexcelonline.com\/meo-staging\/podcast\/006-excel-tables-with-zack-barresse-excel-podcast\/\" target=\"_blank\" rel=\"noopener noreferrer\">Excel Tables<\/a> by Zack Barresse &amp; Kevin Jones<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Interview_Links\"><\/span><strong>Interview Links<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/www.youtube.com\/watch?v=Eq7Wua2M9qk\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Cussin&#8217; (Cursing) Calculator<\/a> YouTube\u00a0tutorial<\/li>\n<li><a href=\"http:\/\/datascopic.net\/cussin-calc\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Cussin&#8217; (Cursing) Calculator<\/a>\u00a0Excel Workbook<\/li>\n<li><a href=\"https:\/\/www.youtube.com\/watch?v=KhoO8KVid2s\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Using Excel to visualize a bass-line and song arrangement<\/a> YouTube\u00a0tutorial<\/li>\n<li><a href=\"http:\/\/www.myonlinetraininghub.com\/excel-designed-minecraft-cake\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Minecraft Birthday Cake Pattern<\/a>\u00a0by Mynda Treacy<\/li>\n<li><a href=\"https:\/\/www.youtube.com\/watch?v=QFCV_JbHJL4\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Unpivot<\/a> YouTube\u00a0tutorial<\/li>\n<li><a href=\"https:\/\/www.youtube.com\/watch?v=hOEWMgLkrhw\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">My Kid&#8217;s ruined birthday party<\/a> YouTube tutorial<\/li>\n<li><a href=\"http:\/\/www.modeloff.com\/\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">ModelOff<\/a> financial modelers<\/li>\n<li><a href=\"https:\/\/www.youtube.com\/watch?v=hFoX2SjWfkY\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Szilvia Juhasz&#8217;s Excel sound tracks<\/a><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Oz%C2%B4s_Products\"><\/span><strong>Oz\u00b4s Products<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><strong>Guerrilla Data Analysis Using Microsoft Excel <\/strong>on <a href=\"http:\/\/amzn.to\/1SHnAxb\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Amazon<\/a>, <a href=\"http:\/\/www.e-junkie.com\/211017\/product\/504939.php#Guerrilla+Data+Analysis+2nd+Edition&amp;aff=277028\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">ebook <\/a>and <a href=\"http:\/\/www.mrexcel.com\/store\/index.php?l=product_detail&amp;p=311\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Print Edition<\/a> on the MrExcel store<\/li>\n<li><strong>Full Contact Data Management &#8211;<em> Coming Soon<\/em><\/strong><\/li>\n<li><a href=\"http:\/\/datascopic.net\/\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Datascopic.net<\/a>\u00a0website<\/li>\n<li><a href=\"https:\/\/www.youtube.com\/channel\/UCZgOVykPoRbSZQfY9YysiRQ\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Oz\u00b4s YouTube channel<\/a><\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Connect_with_Oz\"><\/span><strong>Connect with\u00a0Oz<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li><a href=\"https:\/\/www.linkedin.com\/in\/ozdata\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">LinkedIn<\/a><\/li>\n<li><a href=\"http:\/\/datascopic.net\/about\/oz-du-soleil\/\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Website<\/a><\/li>\n<li><a href=\"https:\/\/twitter.com\/OzExcel\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Twitter<\/a><\/li>\n<li><a href=\"http:\/\/oz1.depot@gmail.com\" target=\"_blank\" rel=\"noopener noreferrer nofollow\">Gmail<\/a><\/li>\n<\/ul>\n<h2 class=\"text-center\"><span class=\"ez-toc-section\" id=\"Listen_to_the_MyExcelOnline_Podcast_on_your_favorite_platform\"><\/span><strong>Listen to the MyExcelOnline Podcast on your favorite platform!<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><a href=\"https:\/\/itunes.apple.com\/us\/podcast\/my-excel-online-podcast\/id1019164720?l=en\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1057 size-medium aligncenter\" src=\"\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/available-on-itunes-logo-300x112.jpg\" alt=\"\" width=\"300\" height=\"112\" title=\"\"><\/a><\/p>\n<p><a href=\"http:\/\/www.stitcher.com\/s?fid=69832&amp;refid=stpr\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" title=\"000: My Excel Story - MyExcelOnline Podcast\"  class=\"wp-image-1051 size-full aligncenter\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/Stitcher-button.png\" alt=\"000: My Excel Story - MyExcelOnline Podcast\" width=\"300\" height=\"150\" \/><\/a><\/p>\n<p><a href=\"https:\/\/play.google.com\/music\/m\/I5hjkav2s3dgtv72ovqol3qbgre?t=My_Excel_Online_Podcast&amp;pcampaignid=MKT-na-all-co-pr-mu-pod-16\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1052 size-medium aligncenter\" src=\"\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/google-300x116.png\" alt=\"\" width=\"300\" height=\"116\" title=\"\"><\/a><\/p>\n<p><a href=\"https:\/\/www.iheart.com\/show\/263-my-excel-online-podc\/\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1064 size-medium aligncenter\" src=\"\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2015\/07\/iheart-300x80.png\" alt=\"\" width=\"300\" height=\"80\" title=\"\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Free_Resources\"><\/span><strong>Free Resources!<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ol>\n<ol>\n<li><strong>Excel Tutorial <\/strong><strong>Blog<\/strong><strong>:<\/strong> Learn all the essential tips to get you up and running and using Excel to its full potential.\u00a0 Choose from Formulas, Pivot Tables, Charts, Analysis, Shortcuts, Macros plus more &gt;&gt;\u00a0<a href=\"\/\/www.myexcelonline.com\/meo-staging\/blog\/\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>CLICK HERE TO VIEW<\/strong><\/a><\/li>\n<\/ol>\n<\/ol>\n<p>&nbsp;<\/p>\n<ol>\n<li><strong>Free Excel Webinars:<\/strong> Learn the power of Pivot Tables and Power Query with our free webinars. <strong>\u00a0<a href=\"\/\/www.myexcelonline.com\/meo-staging\/115-23.html\" target=\"_blank\" rel=\"noopener noreferrer\">CLICK HERE TO VIEW NOW<\/a><\/strong><\/li>\n<\/ol>\n<p><a href=\"\/\/www.myexcelonline.com\/meo-staging\/115-23.html\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1015 size-large\" src=\"\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/06\/Free-Webinars-1024x512.jpg\" alt=\"\" width=\"1024\" height=\"512\" title=\"\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Thanks_for_Listening\"><\/span><strong>Thanks for Listening!<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Thank you for joining me this week. If you have some feedback that you\u2019d like to share, then please leave a note in the comment section below!<\/p>\n<p>If you enjoyed this episode, please\u00a0<strong>share<\/strong>\u00a0it using the social media buttons you see at the bottom of the post.<\/p>\n<p>Also,\u00a0<strong><a href=\"\/\/www.myexcelonline.com\/meo-staging\/podcast\/itune\" target=\"_blank\" rel=\"noopener noreferrer\">please leave an honest review for The MyExcelOnline Podcast on iTunes<\/a>!<\/strong>\u00a0Ratings and reviews\u00a0are\u00a0<strong>extremely<\/strong>\u00a0<strong>helpful<\/strong>\u00a0and greatly appreciated! They do matter in the rankings of the show, and I read each and every one of them.<\/p>\n<p>If you have any questions you can send me an email to <strong><a href=\"mailto:podcast@myexcelonline.com\" target=\"_blank\" rel=\"noopener noreferrer\">podcast@myexcelonline.com<\/a><\/strong><\/p>\n<p>Don\u2019t forget to subscribe to the show on\u00a0<strong><a href=\"\/\/www.myexcelonline.com\/meo-staging\/podcast\/itune\" target=\"_blank\" rel=\"noopener noreferrer\">iTunes<\/a><\/strong>\u00a0to get automatic\u00a0updates so you don&#8217;t miss out on these awesome interviews and Excel insights!<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Listen on Web Browser &gt;&gt; Oz du Soleil is an Excel MVP since 2015 and is an expert in data cleansing &amp; analysis. He has an Excel blog over at OzDuSoleil.com which is his commitment to data literacy. He&#8217;s the leading author on the revised version of Guerrilla Data Analysis Using Microsoft Excel and is [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":7696,"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":[334],"tags":[],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/676"}],"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=676"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/676\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/7696"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=676"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=676"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=676"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}