{"id":2299,"date":"2021-04-01T09:41:05","date_gmt":"2021-04-01T07:41:05","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=2299"},"modified":"2024-02-06T16:19:00","modified_gmt":"2024-02-06T15:19:00","slug":"top-excel-data-cleansing-techniques","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-data-cleansing-techniques\/","title":{"rendered":"Top Excel Data Cleansing Techniques"},"content":{"rendered":"
\"Top<\/a><\/div>\n
\n

Data cleansing is an important activity within Excel and one that we find ourselves doing day in day out, sometimes without even knowing it.<\/p>\n

In this tutorial, you will learn the Top 8 Techniques on Data Cleaning in Excel!<\/h3>\n

So what is data cleansing?<\/p>\n

In the words of Oz du Soleil, Excel MVP, it is like “Hercules being sent out to capture the three-headed dog that guards the entrance to hell!”<\/em><\/strong><\/p>\n

So you can see that Oz sees that data cleansing is hard work but one that needs to be done in order to succeed in Excel.<\/p>\n\n

We get thrown data at us from external accounting systems, ERPs or downloads from the company server and most of the time it is not imported in an Excel friendly way. \u00a0This is where you and I come in to clean the data!
\n\u200bYou can listen to our\u00a0podcast\u00a0episode which was\u00a0highly\u00a0entertaining and full of golden nuggets\u00a0by clicking on below’s image and further down I will show you the My\u00a0Top\u00a0Data Cleansing Techniques, which include the ones that Oz uses:<\/p>\n<\/div>\n

https:\/\/www.myexcelonline.com\/meo-staging\/podcast\/007-data-cleansing-analysis-with-oz-du-soleil-excel-podcast\/<\/a><\/span><\/div>\n
\"Unpivot<\/a><\/div>\n
<\/div>\n
<\/div>\n
\n
\n
\n

Table of Contents<\/p>\n<\/span><\/div>\n