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 / 36
This page cannot be seen from the preview
Don't miss anything!
📋 What's Inside — Click Any Tab to Begin
Made with love by Petal & Plan · petalandplan.com · © 2026
What's Inside — Click Any Tab to Begin You are here — start here! Interface, data types, cell references & navigation 25 essential formulas with live working examples 80 shortcuts — Windows & Mac side by side VLOOKUP, XLOOKUP, INDEX+MATCH & reference formulas IFS, SUMIFS, COUNTIFS, FILTER, UNIQUE, ARRAYFORMULA 30 text cleaning, date math & formatting formulas Live charts, pivot tips, sorting, filtering & data tools 20 exercises with automatic answer checking Print-ready: 35 formulas + 35 shortcuts on one page ith love by Petal & Plan · petalandplan.com · © 2026
Types & Cell References
Any box on the grid A1, B3, Z Long bar above the sheet Top-left, shows A Bottom of the screen Row of icons above sheet A, B, C … Z, AA, AB… 1, 2, 3 … to 10 million Top of the screen Top-right, blue button
Left-aligned Right-aligned Right-aligned, date format Center-aligned Shows the result Red — something is wrong
Changes when copied — most common Stays fixed — press F4 to add $ signs Column locked, row changes Row locked, column changes Give a range a name for clarity Reference cell in another sheet
📋 25 Essential Beginner Formulas — With Live Examples
Jan $3, Feb $4, Mar $3, Apr $4, May $5, Jun $4, Jul $6, Aug $5, Sep $7, Oct $6, Nov $8, Dec $9,
IF Low AND FALSE OR FALSE IFERROR $71. LEN 7 UPPER PLANNER LOWER planner PROPER Hello World TRIM hello
Beginner Formulas — With Live Examples
45 Planner 58 Planner 52 eBook 63 Template 71 Planner 68 eBook 84 Template 80 Planner 98 eBook 94 Template 112 Planner 130 Template
Adds all numbers in range Total of all monthly sales Mean of a range Average monthly sales Smallest number Lowest sales month Largest number Highest sales month Count cells with numbers How many months recorded Count non-empty cells How many product names filled Round to N decimal places Round average to whole number Remove negative sign Err: Decision — true/false logic Flag months above target TRUE if ALL conditions met Sales high AND units high? TRUE if ANY condition met Either metric is high? Show fallback if error occurs Prevent #DIV/0! errors Count characters in text How long is product name? Convert to UPPERCASE PLANNER, EBOOK, TEMPLATE Convert to lowercase planner, ebook, template Title Case Every Word Hello World Remove extra spaces hello (clean)
Join text values (^) Jan - Planner First N chars from left (^) Err: Last N chars from right (^) Err: Today's date (updates daily) (^) Use for age & deadline math Extract year from date (^) → 2026 Extract month number (^) → 5 (May = 5th month) Sum rows matching condition (^) Total Planner sales only Count rows matching condition (^) How many eBook months?
Fill Down Ctrl+D Fill Right Ctrl+R Delete contents Delete Paste values only Ctrl+Shift+V Paste special Ctrl+Alt+V Repeat last action F Toggle $ in formula F4 (in formula) Insert row/col Ctrl+Shift++ Delete row/col Ctrl+Shift+- Add comment Ctrl+Alt+M Show all formulas Ctrl+` Sum selection Alt+= Copy formula down Ctrl+D Select non-contiguous Ctrl+Click
Format cells dialog Ctrl+ Currency format Ctrl+Shift+$ Percentage format Ctrl+Shift+% Number format Ctrl+Shift+! Date format Ctrl+Shift+# Time format Ctrl+Shift+@ Remove all formatting Ctrl+ Strikethrough Alt+Shift+ Align left Ctrl+Shift+L Align center Ctrl+Shift+E Align right Ctrl+Shift+R Hide row Ctrl+ Hide column Ctrl+ Unhide row Ctrl+Shift+
Add/remove filter Ctrl+Shift+L Start a formula =
Insert function Shift+F Recalculate F Name a range Ctrl+Shift+F Create chart Alt+F Version history Ctrl+Alt+Shift+H Print Ctrl+P Open Explore AI Alt+Shift+X New sheet Shift+F Full screen F Accessibility Ctrl+Alt+H Select current region Ctrl+Shift+* Trace precedents Ctrl+[ Trace dependents Ctrl+] Insert today's date Ctrl+;
Cmd+D Cmd+R Delete Cmd+Shift+V Cmd+Option+V Cmd+Y F4 (in formula) Cmd+Shift++ Cmd+Shift+- Cmd+Option+M Ctrl+` Cmd+Shift+T Cmd+D Cmd+Click
Cmd+ Cmd+Shift+$ Cmd+Shift+% Cmd+Shift+! Cmd+Shift+# Cmd+Shift+@ Cmd+ Cmd+Shift+X Cmd+Shift+L Cmd+Shift+E Cmd+Shift+R Cmd+ Cmd+ Cmd+Shift+
Shift+F Fn+F Cmd+Shift+F — Cmd+Option+Shift+H Cmd+P Option+Shift+X Shift+Fn+F Ctrl+Cmd+F Cmd+Option+H Cmd+Shift+* Cmd+[ Cmd+] Cmd+;
Why use vs XLOOKUP? Works in all Excel versions
INDIRECT Daily Planner OFFSET (^) Budget Sheet CHOOSE Mar ADDRESS (^) $C$ ROW 45 COLUMN (^) 3
mediate 1 — Lookup & Reference Formulas
Planner $3. Planner $2. Finance $2. Planner $2. Journal $2. Tracker $2. Journal $2. Health $2. Faith $3. Faith $2.
Look up P003 → return name (^) 4th arg FALSE = exact match required Look up P001 → return price (col 4) (^) Change col number to get different fields Approximate — finds closest value ≤ 2.
Find P005 → return its name Returns 'Not found' if lookup fails Returns LAST matching Planner 5th arg: 1=first, -1=last match Finds first ID starting with P (^) 5th arg 2 = wildcard — use * for any chars Works across rows too — HLOOKUP replaceme Same syntax, works both directions!
Returns POSITION of P006 in the list (^) → 6 (it's the 6th item). 0=exact match Returns 6th item from the name column → Goal Tracker (row 6 of C5:C14) Full lookup: find P006 → return name (^) MATCH finds position, INDEX returns value Return price for P002 — both row & col TRUE = approximate match — data must be sorted No column number — specify return range directly 4th arg = fallback message — much better than VLOOKUP! True 2-dimensional lookup — VLOOKUP can't do this
📋 Intermediate 2 — Advanced IF, Multi-Condition & Array Form
Jan Planner Jan eBook Feb Planner Feb Template Mar Planner Mar eBook Apr Template Apr Planner May Planner May eBook Jun Template Jun Planner
Nested IF B IF + AND (^) Normal IF + OR Normal SWITCH (^) #NAME? IF (blank check) Filled
