Study with the several resources on Docsity
Earn points by helping other students or get them with a premium plan
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Finally learn Google Sheets without watching a single boring video. This complete beginner-to-intermediate workbook includes 100+ formulas, 80 shortcuts, a live bar chart, a working budget tracker, and 20 practice exercises that check your answers automatically. Instant download — works in Google Sheets and Excel. One file. Everything you need. 📊 #googlesheets #spreadsheet #learnexcel #googlesheetstips #spreadsheetskills #instantdownload #digitaldownload #productivity #workfromhome #beginnerguide
Typology: Cheat Sheet
1 / 26
This page cannot be seen from the preview
Don't miss anything!
🌸 What's inside this workbook — click any tab below to jump in!
Made with love by Petal & Plan · petalandplan.com · © 2026 · Free to use & share!
ide this workbook — click any tab below to jump in!
Welcome & guide map (you are here!)
Interface, navigation, data types & shortcuts
50 essential formulas with live examples
Build bar, line & pie charts from real data
Fully working monthly budget — try it yourself!
Track tasks with status, priority & due dates
30-day habit tracker with auto progress count
20 questions to test what you have learned
Print-ready: 50 formulas, shortcuts & pro tips
Petal & Plan · petalandplan.com · © 2026 · Free to use & share!
Number 1000, 3.14, -50, 0.
Date 2026-05-17, May 17 2026
Boolean TRUE or FALSE
Formula 0
Error #REF!, #DIV/0!, #N/A, #VALUE!
Need to Know to Get Started
Any box on the grid
A1, B3, Z999, etc.
Long bar above the sheet
Bottom of the screen
Row of buttons above the sheet
1, 2, 3 … up to 10 million
Top-left corner, shows A
Very top of the screen
Top-right, blue button
Cmd + C
Cmd + V
Cmd + X
Cmd + Z
Cmd + Y
Cmd + B
Cmd + F
Cmd + Home
Cmd + End
Cmd + Shift + L
Cmd + D
Ctrl + Enter
Tab
Ctrl + Space
Left-aligned in cell
🌸 50 Essential Google Sheets Formulas — With Live E
05/17/
05/17/26 04:51 PM
1899
12
30
#VALUE!
7
05/17/
TEXT (date) Dec 30
13
IFNA Err:
IF No
Creates a date from year/month/day Err:
Formats a date as readable text 5ay 17
Date 10 working days from now 46171
Looks up value in a table (vertical) #N/A
Modern replacement for VLOOKUP #NAME?
Returns value at a given position Err:
Finds position of a value in range #N/A
Most powerful lookup combination Better than VLOOKUP!
Reference a cell from a text string #REF!
Returns cell offset from reference Err:
Picks from a list by index number Blue
Shows fallback if formula errors Err:
Catches only #N/A errors #N/A
Makes a true/false decision OK
Multiple IF conditions at once #NAME?
TRUE only if ALL conditions are true
TRUE if ANY condition is true
Reverses the true/false result Negative!
Sum only rows that match a condition 0
Count rows that match a condition 0
Sum with multiple conditions More powerful than SUMIF
Count with multiple conditions More powerful than COUNTIF
Cleaner alternative to nested IFS #NAME?
Jan $320 $180 $80 $
Feb $415 $220 $120 $
Mar $380 $195 $110 $
Apr $450 $280 $160 $
May $520 $310 $190 $1,
Jun $490 $295 $175 $
Jul $600 $380 $230 $1,
Aug $580 $420 $280 $1,
Sep $720 $460 $310 $1,
Oct $680 $490 $350 $1,
Nov $800 $520 $400 $1,
Dec $950 $610 $480 $2,
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Planne
Templa
eBooks
Month
Revenue
t Nov Dec
Planners ($)
Templates ($)
eBooks ($)
→ Chart → Column chart
→ Chart → Line chart
→ Chart → Pie chart
→ Chart → Area chart
→ Chart → Scatter chart
→ Chart → Combo chart
t Nov Dec
track your money!
Gumroad + Etsy
Fixed
Variable
Variable
Variable
Fixed
Fixed
Variable
Discretionary
Discretionary
Variable
Investment
Saving
Business
Variable
🌸 Task Manager — Plan Your Work, Track Your Pro
Create first digital product Business 🌸 High
Set up Gumroad account Business 🌸 High
Design 8 planner PDFs Business 🌸 High
Write product descriptions Business 🌸 Medium
Create Pinterest account Marketing 🌸 Medium
Post first 5 Pinterest pins Marketing 🌸 Medium
Join 3 Facebook seller groups Marketing 🌸 Low
Build Faith & Plan bundle Business 🌸 High
Set up email list (Mailchimp) Business 🌸 Medium
Launch course website Business 🌸 High
Reply to all customer reviews Customer 🌸 Medium
Design social media kit Marketing 🌸 Medium
Research Etsy keywords Marketing 🌸 Low
Write remote work eBook Business 🌸 High
Create Notion templates Business 🌸 Medium
Total Tasks 15
5
In Progress 2
8
Completion Rate 33%
✓ 30-Day Habit Tracker — Type 🌸 in each c
🌸 Morning routine Daily
🌸 Drink 8 glasses water Daily
🌸 Read 20 minutes Daily
🌸 Exercise / walk Daily
🌸 Prayer / meditation Daily
🌸 Update my planner Daily
🌸 No phone before 9am Daily
🌸 Sleep before midnight Daily
🌸 Eat a healthy meal Daily
🌸 Post content online 15x/month
ker — Type 🌸 in each cell to mark your habit done for that day!
12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 ✓ Done
automatically!
