Data cleanup in Excel

Or log in to access your purchased courses
excel-data-cleaning-fundamentals-Example
Typical messy data file. You need tools to delete unnecessary rows, fill in gaps, convert ‘text’ into numbers and get date formats correct (quickly)

The most common task Excel is used for is to ‘clean’ information received from other systems to be usable in the business.

Whether you are doing reconciliations or generating reports, you need data from external sources over which you have limited format and data type control.

By understanding all the tools and formula you can use to clean your data, you can half the time you spend on data and improve the accuracy of your work.

This course is an online training and reference guide. Work through it once to get an idea of what you can do, and when you come across a difficult situation use it to find the solution.

By the end of the course you will be able to:

  • Reformat data to be able run reports or reconciliations.
  • Split columns into names and surnames, product codes and product names
  • Delete rows that contains unnecessary headers, footers, subtotals and other unwanted information.
  • Change dates into any format even if Excel refuses to change the format.
  • Fill in gaps in reports

Whether it is deleting unnecessary lines, converting numbers that are treated as text, correcting date issues or handling duplicates and missing data items, you will spend hours and hours just getting the data into an acceptable condition.

This course will help you will all these data cleanup in Excel issues.

Modules

Identify and Remove duplicates in Excel

Various way to identify and remove duplicates in Excel. Learn how to work with duplicates either using some of the inbuilt tools or clever use of the formula and functions.

Lessons

Adrian
Course By

Adrian

Miricle Solutions was started in 2003 when Adrian Miric left KPMG to set up a consultancy focused on the safe and efficient use of excel in the corporate world. With this is mind the company has strived to provide the ultimate solution to all excel needs.

Lessons