Data Cleanup in Excel


An online course that will help you with all your data clean up issues including

  • Reformating data to be able run reports or reconciliations.
  • Splitting columns into names and surnames, product codes and product names
  • Deleting rows that contains unnecessary headers, footers, subtotals and other unwanted information.
  • Changing dates into any format even if Excel refuses to change the format.
  • Filling in gaps in reports

To see some preview lessons and the detailed contents visit

SKU: Online Data Cleanup Course Categories: , Tag:


Data Cleanup in Excel

This online courses addresses the following problems when dealing with data in Excel

Removing Unnecessary Rows

In order to use data you need it to look like a database. But systems often export reports in ways that are not friendly to Excel use. In this section you will learn how to easily and quickly remove the rows that are unnecessary. So instead of spending a day manually deleting individual rows, click a few buttons and it is done.

You can go from the left side to the right side of the image below in a few clicks


Filling in the Gaps in Data Sets

Reports often look good with lots of white space, but this is not useful when you want to do some analysis in Excel. This section deals with quick and safe ways to fill in the gaps in a database. No more straining your eyes as you copy and paste each little section.


Converting numbers that are treated as text to numbers

There is nothing worse than finally getting some numbers into Excel and then realising that Excel is not treating them as a number. Whether it is a comma when there should be a space, unprintable characters or trailing spaces all these issues can be solved with some simple tools or formula.

So you won’t have to explain why the sum is showing zero even though there are numbers above.


Correct Date Issues

Dates are critical in the business world, yet Excel sometimes struggles to see cells that have dates in it as dates.

Some simple tools and formula allow you to easily convert cells that contain ‘dates’ into dates that Excel recognises and can use.


Identify and Remove Duplicates

Learn quick ways to identify duplicates in a dataset and where necessary quickly remove them,


Split Columns in Excel

Learn how to split text that appears in one column into multiple columns, whether it is nice and consistent or not.


Get the latest information from the S.A Health Department about COVID-19 - Learn More