See the build
Watch the finished product first. Know what you're building toward.
CoursesProject Course
Seth Kramer
Cleaning and working with data in Google Sheets
Learn more advanced formatting, formulas, and techniques in Google Sheets
Seth Kramer
Learn the stack
Follow the tools and the decisions, not just the clicks.
Ship your version
Use the course as a template for your own product.
What you'll get
Build the project. Keep the skill.
Every course ends with a shipped artifact and a reusable pattern. Faster builds, smarter decisions, real products.
Learn the exact stack used to ship the project
Understand the build decisions, not just the steps
Walk away with a pattern you can reuse on your own
Overview
Google Sheets is a powerful spreadsheet tool that allows you to store and analyze data in a variety of ways. In our course, Cleaning and Working with Data in Google Sheets, you'll learn how to use Google Sheets to clean and analyze your data effectively.
In this course, you'll learn how to clean up your data, remove duplicates, and perform data validation. Our expert instructors will guide you through every step of the process, from data import to data cleaning and analysis. You'll learn how to use Google Sheets' built-in functions to analyze and visualize your data, and how to create custom formulas to fit your own needs and preferences.
By the end of the course, you'll have a strong foundation in data cleaning and analysis using Google Sheets, which will help you make more informed decisions in your personal or professional life. Whether you're a data analyst, entrepreneur, or just someone who wants to improve their data management skills, our course will provide you with the skills and knowledge you need to succeed.
This course is perfect for anyone who wants to learn how to clean and work with data in Google Sheets. No prior coding experience is necessary – just a willingness to learn and create.
What you'll learn
- Importing data
- Concatenate / split
- Left,right, len
- Upper, lower, and proper functions
- Removing duplicates
- Import range
- Iferror
- Paste as value only
- Random function
Who this is for
- Intermediate Google Sheets users
- You want to automate at work
- You want to analyze data
More from this track
Formatting in Google Sheets
Format Google Sheets like a pro to create data-driven spreadsheets for any industry.
View course
Cleaning and working with data in Google Sheets
Learn more advanced formatting, formulas, and techniques in Google Sheets
View courseAdvanced Google Sheets
Learn essential Google Sheets skills with this beginner-friendly project. VLOOKUPs, macros, and more!
View courseReady to build?
Get Cleaning and working with data in Google Sheets and the rest of the library.
One membership. Every course. Every project. Less than a freelance dev hour.