Google Sheets & Google Workspace Course
Run your shop, class or small office on free Google tools: learn Sheets formulas, QUERY, drop-downs and pivots, collect data with Forms and share safely with your team.
Frequently bought together
Google Sheets is free, works on any phone and lets your whole team edit one live file. Used well, it replaces most paper registers and the twenty copies of one Excel file going around on WhatsApp.
What you learn
- Sheets basics, the Google way: Drive folders, safe sharing, version history, open ranges like B2:B
- Formulas: UNIQUE, FILTER, SORT, SPLIT, ARRAYFORMULA and QUERY, explained with examples
- Tidy data: coloured drop-downs, checkboxes, smart chips, conditional formatting, pivots and charts
- Team work: Google Forms into Sheets, protected ranges, filter views, comments, IMPORTRANGE between branch files
- Around Sheets: Docs voice typing, Drive scanning, simple macros, a sample Apps Script, working on a phone, and when Excel is the better tool
Everything you get
Course book
14 lessons in 2 modules, PDF
Practice file
Orders, sales, tasks and a team register
Answers
Formula answers and a sample script
Comparison
Sheets vs Excel table
Files in your download
- PDFGoogle_Sheets_Course.pdf439 KB
- XLSXGoogle_Sheets_Practice.xlsx15 KB
Start in 5 simple steps
A step-by-step guide is also included inside your download.
- 1
Upload the practice file
Save as Google Sheets
- 2
Do one lesson a day
Each has a sheet
- 3
Build a form
Link it to a sheet
- 4
Share with your team
With the right access
- 5
Set up your office
Follow the last lesson
Questions about this product
Do I need to pay for Google Workspace?
No. Everything in the course works with a free Gmail account. A paid plan only adds your own email domain and more storage.
Can I learn it on my phone?
Most lessons, yes. Pivot editing, Apps Script and some menus are easier in a computer browser.
I know Excel. Is this useful?
Yes. The course focuses on what is different and better in Sheets: QUERY, ARRAYFORMULA, Forms, live sharing and IMPORTRANGE.
Is coding needed?
No. One optional lesson shows a five-line Apps Script for a daily email, with the code ready to paste.
Is it a video course?
No. It is a PDF course book with a practice file and answers.
How do I get the files after payment?
A download button appears on screen right after payment, and the link is emailed to you. You can also download again any time from My account.
Can I use it on my phone?
Yes. It works with Any phone, tablet or computer, Print-ready A4, Google Sheets (free) on phone or computer. Free mobile apps are enough.
What if something does not work?
Write to us within 7 days with your order number. We will fix it, send a working file, or refund you.
