*** Proof of Product ***
Exploring the Essential Features of “Ben Collins – Data Cleaning in Google Sheets”
There’s a joke in the data community that goes:
“You’ll spend 90% of your time cleaning data, and the other 10% of your time complaining about cleaning your data.”
Do you deal with badly formatted data that takes you hours to tidy up, preventing you from making progress on your “real” work?
Do you ever find yourself repeating a process manually, like extracting a zip code from an address?
This course is designed to help you work with messy, real-world datasets, and it’s a fit for beginner-to-intermediate level Google Sheets users.
Through a series of video tutorials, you’ll learn techniques and best practices for cleaning data and preparing it for analysis and reporting — saving you hours of tedious, repetitive work, and helping you get accurate results for your company.
What is Data Cleaning?
Data cleaning is the process of identifying and correcting errors, fixing incomplete data or dealing with irrelevant data in your data sets.
The goal of data cleaning is to create a consistent, clean data set, which gives you the confidence that any subsequent analysis and conclusions you draw will be accurate and thorough.
Why should you care?
Data cleaning is a crucial first step in the data analysis pipeline, yet one that people often overlook.
If you start with “bad” data — if your data contains duplicate records for example — you’re inevitably going to end up with “bad” conclusions. You might end up double counting revenue, for example, which could have disastrous consequences for your business down the line.
This training course runs through professional techniques and best practices, using formulas and pivot tables, to clean your data, in a Google Sheets setting. Once you’ve grasped these concepts, you (and your boss!) will feel confident that your conclusions are based on sound data.
What this 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.
What this course does not cover:
- How to analyze your datasets or how to build dashboard reports (see my dashboard course if that’s what you want to learn).
- How to use the scripting language, Apps Script, to work with data.
- How to create data visualizations or charts from your data.
What you get with this course:
- Over 3 hours of video tutorials that walk you step-by-step through techniques for cleaning data and using formulas.
- Access to all the raw data files used in the examples, copies of the formulas and links to online documentation and other great resources.
Who is this course for?
- Anyone who works with data in Google Sheets — maybe you’re a data analyst, a marketer, an educator, a scientist or someone in between.
- Anyones curious to learn more about working with data.
- Anyone who wants to learn best practices and how to be efficient with data.
- Anyone who wants to add new skills that will help you advance your career.
What are the prerequisites?
- A Google account.
- Access to Google Sheets.
- Basic familiarity with Google Sheets and spreadsheets.
- No assumptions are made about prior knowledge of Google Sheets — all the topics are covered comprehensively from scratch, at a comfortable pace.
Your Instructor
Ben Collins
Hi! I’m an experienced data analytics instructor and freelance spreadsheet developer.
I help individuals and businesses better understand their data through analytical insights and visualizations.
Over 30,000 professionals from 1,000+ companies have enrolled in my training courses, including employees from PwC, Netflix, Verizon, Google, Capital One and other Fortune 500 companies.
My training has helped 1,000’s of people advance their careers. I’ve also helped small and large organizations migrate from Microsoft Excel and Office to Google Sheets and G Suite.
Google recognized me as a Google Developer Expert for G Suite Technology in 2019, one of only a handful worldwide.
I work primarily with Google Sheets and Apps Script, and also have extensive experience with Google Data Studio, Microsoft Excel, SQL and Tableau. I’ve previously taught data courses and workshops for General Assembly in Washington, D.C..
Course Curriculum
Introduction
Lesson 1: Introduction to the Course
Lesson 2: Join the Facebook group
Lesson 3: Introduction to Data Cleaning and Best Practices
Data Cleaning
Lesson 4: Data Types
Lesson 5: Handy Shortcuts for Data Tables
Lesson 6: Shortcut key reference
Lesson 7: Find and Replace
Lesson 8: Trim, Clean and Dealing with Spaces
Lesson 9: Lower, Upper and Proper functions to deal with Case
Lesson 10: Searching within data strings
Lesson 11: Extracting data with Left, Right and Mid functions
Lesson 12: Changing data with Substitute and Replace formulas
Lesson 13: Splitting Data with Text to Columns
Lesson 14: Bringing Data Together
Lesson 15: Sorting and Filtering Data
Advanced Data Cleaning Techniques
Lesson 16: Dealing with Null Values
Lesson 17: Duplicates
Lesson 18: Duplicates Formula Method
Lesson 19: Using the IF function and logic to clean data
Lesson 20: Using VLOOKUP to clean data
Lesson 21: Spelling Tools and Transposing Data
Data Cleaning Case Studies
Lesson 22: Case Study 1 Part I
Lesson 23: Case Study 1 Part II
Lesson 24: Case Study 2 Part I
Lesson 25: Case Study 2 Part II
Lesson 26: Case Study 2 Part III
Please see the full list of alternative group-buy courses available here: https://lunacourse.com/shop/
