Data Cleaning in Google Sheets

In this beginner-to-intermediate level course, Ben Collins teaches data cleaning in Google Sheets.

Save hours of repetitive work by learning techniques for cleaning and preparing your data for analysis.

Data cleaning is another name for finding and correcting errors in your spreadsheets. By fixing and removing irrelevant data you will be left with a clean data set which will make analysis easier to draw conclusions from, essential before the presentation.

Data cleaning is often overlooked but it is an essential first of data analysis.

For example, if your data contains duplicate records, you may end up with the wrong conclusions due to double counting revenue. This online video training course covers best practices for using formulas to clean up your data.

This data cleaning with Google Sheets course covers:

• Best practices for working with data in Google Sheets.
• All the formulas required for data cleaning.
• Tips and tricks, such as shortcut keys, to make your workflow more efficient.
• Professional techniques for turning messy real-world data into clean, orderly data sets for your analysis.
• Two in-depth case studies that show all these techniques being used together, in the wider context of a real-world problem.

With over 3 hours of video lessons, life long access and a private Facebook group membership where you can post questions and chat to other students, you will be an expert in no time.

This course assumes you have access to Google Sheets and a Google account. Familiarity with Google Sheets is also helpful before enrolling in this online course.