01Row 1 headers, one thing per column
Date | Item | Amount | Category. No merged title row inside the data. Put the title in the tab name or above with a blank row, then freeze headers.
Merged cells break sorts. Don't.
Career Skills
Google Sheets Essentials
SUM, IF, freeze, and a table that doesn't break when you sort
40 min4 photographed stepsBeginner
A working sheet for real life: a spend tracker or simple list. You will type formulas, freeze a header, sort safely, and stop merging cells like it's 2004.
What you'll learn
- Headers in row 1, data below, no merged cells in the table
- SUM, AVERAGE, IF
- Freeze row 1
- Sort with the header row selected correctly
Inside this course
- A real tableStructure first.
- FormulasType them once.
- Freeze and sortWhere people destroy their sheet.
- SharePeople will type in it.
Full step-by-step lessons with photos unlock with a subscription.
Free preview
First steps from A real table
See how every step looks — photo, checklist, and pro tips included.
Full library access
Unlock every course
Subscribe for $9/month or $79/year — every category, every guide.
View plansFree tips from this course
Each tip has its own step photo — browse free, then unlock the full course.
More Career Skills tips →
More in Career Skills
Related courses with photographed steps — browse before you subscribe.
Land a Remote Job in 30 Days
Target roles, rewrite your LinkedIn and resume for remote, apply with a system, and interview from home
STAR Method Interview Answers
Situation, Task, Action, Result — stories that get callbacks
Goal Setting and Habit Stack for Success
90-day goals, habit stacking, and weekly review — a system that survives busy weeks
Write a Cover Letter That Gets Replies
Hook, three proof bullets, clear ask — tailor in 20 minutes (pairs with your resume)
Unlock Google Sheets Essentials + the full library
$9/month · Cancel anytime · All courses included
Sign up to unlock