Get & Transform PowerQuery Online Course

$64

An online course that will help you with all your data clean up issues using PowerQuery (Get & Transform) including:

  • Reformatting 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 https://online-excel-training.auditexcel.co.za/course/get-and-transform-excels-data-cleanup-tool/

SKU: Online Data Cleanup Course-1
Categories: , .

Description

Data Cleanup in Excel

This online courses addresses the following problems when dealing with data in Excel using the new PowerQuery tool (Get & Transform)

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

remove-unnecessary-rows

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.

Filling-in-Gaps

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.

Numbers-as-text

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.

convert-dates

Identify and Remove Duplicates

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

Introduction-to-identify-and-remove-duplicates-in-excel

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.

introduction-to-text-to-columns