Resources

Learn

Bite-sized guides for real spreadsheet problems.

Complete Month and Sales source table in the _result workbook before creating the chart.

beginner-guides

Build your first chart

Turn the sample table (Month, Sales) into a chart whose categories and values can be checked directly against the visible source cells.

8 min readRead guide ↗

Google Sheets practice table before the conditional-formatting steps, with Task, Due and Status visible and no unrelated data on the sheet.

beginner-guides

Use conditional formatting

Complete “Use conditional formatting” using the visible Task, Due, Status, Expected match sample so each action and the final state can be checked against the source data.

9 min readRead guide ↗

Filter controls are visible in all three header cells, with the pointer on the Status filter control.

beginner-guides

Filter a spreadsheet

Complete “Filter a spreadsheet” using the visible Task, Owner, Status sample so each action and the final state can be checked against the source data.

11 min readRead guide ↗

Google Sheets showing the complete A1:C4 task table before a dropdown rule is added.

beginner-guides

Create a dropdown list

Create a controlled status dropdown for C2:C4 so task states stay consistent.

6 min readRead guide ↗

functions

COUNT and COUNTA

Compare COUNT and COUNTA on Qty values 2, blank, 0 and 5.

6 min readRead guide ↗

Google Sheets with H2 selected, the name box showing H2, the formula bar showing =AVERAGE(E2:E6), the result 184 visible in H2, and the complete source table A1:F6 visible in the same frame.

functions

AVERAGE function

Calculate the mean Amount of the five orders and return 184.

5 min readRead guide ↗

Google Sheets with H2 selected, the name box showing H2, the formula bar showing =SUM(E2:E6), the result 920 visible in H2, and the complete source table A1:F6 visible in the same frame.

functions

SUM function

Total the five Amount values and return 920.

5 min readRead guide ↗

Google Sheets Data menu with Protect sheets and ranges visible while preparing to protect D2:D3.

beginner-guides

Protect ranges and sheets

Protect a formula range so collaborators can update inputs without accidentally overwriting calculated costs.

7 min readRead guide ↗

Google Sheets showing the complete A1:C3 team tracker before the Share dialog is opened.

beginner-guides

Share a Google Sheet safely

Share a Google Sheet with specific people and understand link access without accidentally making a working file public.

7 min readRead guide ↗

beginner-guides

Freeze rows and columns

Keep headers and key labels visible while you scroll by freezing rows and columns in Google Sheets.

7 min readRead guide ↗

Google Sheets Data menu with Sort range expanded and Advanced range sorting options visible.

beginner-guides

Sort data in Google Sheets

Sort an order table without separating customers from their orders.

8 min readRead guide ↗

Full Google Sheets interface with the complete A1:D5 example, numeric prices, VND currency displays and formula-derived totals.

beginner-guides

Format numbers and currencies in Google Sheets

Format real numbers as Vietnamese đồng, calculate item totals and keep the underlying values numeric.

10 min readRead guide ↗

Google Sheets Example tab showing A1:D4 with headers Item, Qty, Unit price and Line total; the menu, formula bar and sheet tab are visible.

beginner-guides

Understand rows, columns and cells

Learn how to read Google Sheets cell addresses, select ranges and calculate line totals with a four-row practice table.

9 min readRead guide ↗

beginner-guides

Create your first spreadsheet

Build a real four-column task tracker with a frozen header, status dropdowns, valid due dates and a matching practice workbook.

11 min readRead guide ↗

Full Google Sheets interface with the file title, menus, toolbar, expense tracker, frozen header, filters, summary and sheet tab.

Beginner Guides

Google Sheets for Beginners

Create your first spreadsheet with a real expense tracker. Learn cells, formatting, filters, sharing, SUM, AVERAGE and COUNT with verified screenshots and results.

11 min readRead guide ↗