Remove Duplicate Rows with UNIQUE
Create a separate list of unique rows while preserving your source data.
LEARN IT · TRY IT · USE IT
Google Sheets tutorials. Practice included.
Pick a problem, watch the available tutorial, then try it with the matching data. Every guide includes steps, formulas and a free download.
14 guides · free practice data · no sign-up
Find Overdue Unpaid Invoices Automatically in Google Sheets
Find unpaid invoices whose due date is before today.
Fix Messy Names in Google Sheets with One Formula (TRIM + PROPER)
Clean extra spaces and inconsistent capitalization in imported names.
Find Any Product Price in Google Sheets with XLOOKUP
Enter a product ID and return its price with an exact match.
Build a Checkbox Progress Tracker in Google Sheets (with a Live Bar)
Turn six checkboxes into a completed count, percentage and progress bar.
Highlight Duplicate Emails in Google Sheets Without Deleting Rows
Color every repeated email without deleting any customer orders.
Total Expenses by Category Automatically in Google Sheets (SUMIFS)
Group expenses into category totals that update when values change.
How to Reference a Cell from Another Tab in Google Sheets
Link a dashboard to a source cell in another tab of the same file.
How to Autofill Dates in Google Sheets (Daily Date Series)
Continue two real dates into a complete seven-day series.
How to Resize Multiple Columns in Google Sheets (Fit to Data)
Make clipped product names readable by fitting columns to their data.
Count a Specific Status in Google Sheets with COUNTIF
Compare exact status counts with contains-text matches.
How to Divide One Column by Another in Google Sheets
Divide matching rows and flag zero-unit inputs for review.
How to Create a Dropdown List in Google Sheets for Task Status
Use a dropdown to keep task status labels consistent.
Duplicate Emails: Keep the First Contact
Keep the first complete contact for each email, even when plans differ.
No tutorials match your search.
Get every exercise
The bundle includes 14 CSV files and an import readme. Add formatting and formulas using each guide.
Download all practice files · ZIP