Free Google Sheets tutorials for small business
Updated
Google Sheets. These 2 free modules teach it by building real projects, not by reading about features: Google Sheets: Fill a Research Column with Gemini and Check Its Sources and Google Sheets: Build a Job Tracker That Totals Itself.
The Google Sheets modules cover Gemini for Google Workspace and Google Workspace. Every module runs in a practice copy of Google Sheets, so you can learn it without an account, then set it up for real.
2 modules
Select empty cells, click Fill and let Gemini look up where six companies are headquartered, then open one cell's web sources before the list goes to a client. A 7-step…
Free · Live ~4 min Beginner
A beginner Google Sheets walkthrough on real screens: freeze the header, make Status a drop-down, total each status with SUMIF, highlight finished-but-unbilled jobs and…
Free · Live ~15 min Beginner
What you do in each module
- Google Sheets: Fill a Research Column with Gemini and Check Its Sources (about 4 minutes, 7 steps, beginner). You work through: Pick the empty cells, Tell Gemini what to fill and Check the sources.
- Google Sheets: Build a Job Tracker That Totals Itself (about 15 minutes, 36 steps, beginner). You work through: Name the sheet and add the jobs, Freeze the header row, Make Status a drop-down, Totals by status with SUMIF, Highlight done-but-not-billed and A filter view for each crew.
Common questions
How long will this take?
The 2 modules take about 19 minutes in total, and you can do them in separate sittings.
Do I need experience first?
No. These modules are beginner level, and each step tells you exactly where to click.
Do I need a Google Sheets account to start?
No. The practice runs in a copy of Google Sheets inside your browser, and nothing touches your real accounts. When you are ready, you repeat the steps in your own account.
Is it free?
Yes. All 2 modules are free.
Where should I start?
Start with Google Sheets: Fill a Research Column with Gemini and Check Its Sources, then continue with Google Sheets: Build a Job Tracker That Totals Itself.
Compare tools
Side-by-side comparisons, with prices and features checked against the vendors’ own pages.
Frequently asked questions
- Are these Google Sheets tutorials free?
- Yes. All 2 live Google Sheets lessons here are free, and you can start without signing up. Each one is a real project you build step by step in a practice copy of Google Sheets that checks your work.
- Where should a beginner start with Google Sheets?
- Start with Google Sheets: Fill a Research Column with Gemini and Check Its Sources, about 4 minutes. Every step shows you where to click, and "Do it for me" finishes any step you get stuck on.
- Do I need my own Google Sheets account to practice?
- No. The lessons run in a practice copy of Google Sheets in your browser, so nothing touches your real accounts. To build the same workflow for real afterwards you need your own Google Sheets account; check Google Sheets's current pricing first.
Related
How every module works
Each step is shown on the left, with a cursor pointing to exactly where to click. You do the same thing on the right, in a practice copy of the real tool. Get it right and it moves on. Nothing touches your real accounts until you're ready to build it for real.
Start learning free