Google Workspace Productivity
Get productive fast in Gmail, Docs, and Sheets — the tools most remote and office jobs actually run on. By the end you'll manage email efficiently, write and format documents cleanly, and build simple spreadsheets without fumbling through menus.
Every lesson comes with written notes, a practice task and a knowledge check.
Watch the first lesson free
Complete Google Workspace Tutorial — A former Microsoft product manager tours Google Drive, Docs, Sheets, and Slides for someone brand new to the suite.
Create a free account to watch it. No payment needed.
On a limited data plan? Tap the gear icon (⚙️) in the video player and choose 480p or lower — standard-definition video uses a fraction of the data HD does and still looks fine on a phone.
Level 1 — Foundations
Start from zero: what this skill is, the tools you need, and your first hands-on practice.
Module 1 — Getting Started: Meet Google Workspace
- Lesson 1 — Complete Google Workspace Tutorial· 1h 53m· ~812 MB
A former Microsoft product manager tours Google Drive, Docs, Sheets, and Slides for someone brand new to the suite.
- Know what each Workspace app is for and which to open for a given job
- Understand that everything saves to Drive, and what that changes
- Set yourself up so the rest of this course works on your machine and your bundle
- Lesson 2 — Work Smarter with Google's Productivity Tools
Google's own productivity expert shares practical habits for getting more done with Workspace tools.
- Find any file in seconds instead of browsing folders
- Build the small habits that make the tools genuinely fast
- Stop the version-by-email habit that wastes whole offices' time
Module 2 — Core Skills in Practice
- Lesson 1 — Gmail Tutorial for Beginners - 2026 Update· 13 min· ~92 MB
Covers composing emails, attachments, and signatures — everyday Gmail use from the ground up.
- Get an inbox to empty and keep it there
- Use labels, filters and search instead of reading everything twice
- Write mail that actually gets a reply, and spot the mail that is trying to rob you
- Lesson 2 — Google Sheets Tutorial for Beginners· 49 min· ~354 MB
Shows how to create a spreadsheet, format cells, and start entering and organizing real data.
- Build a sheet that stays usable as it grows
- Use the handful of functions that do most real work
- Avoid the layout mistakes that make a sheet impossible to analyse later
Module 3 — Drive, Sharing and Permissions
- Lesson 1 — Organising Drive So You Can Find Things· 17 min· ~121 MB
A practical tour of Google Drive — uploading, folders, the New menu, search and Quick Access. About 17 minutes.
- Tell the difference between My Drive, Shared drives and Shared with me
- Find a file in seconds using search operators rather than folder-digging
- Explain why Shared with me is not storage you control
- Lesson 2 — Sharing Correctly — Viewer, Commenter and Editor· 3 min· ~23 MB
A short, focused look at the Share button and the choice between edit, comment and view access, including link sharing to a wider group. Just over 3 minutes.
- Choose the right permission level for what you actually want someone to do
- Explain the risk of "Anyone with the link"
- Understand what transferring ownership does and does not let you undo
Module 4 — Real Collaboration in Google Docs
- Lesson 1 — Comments, Suggesting Mode and @-mentions· 52 min· ~375 MB
From the full Google Docs walkthrough — watch the Share, Comments and Suggesting chapters. The whole video runs about 52 minutes, so use the chapter list to jump straight to those three.
- Switch between Editing, Suggesting and Viewing mode and know when each is right
- Accept and reject suggestions on your own document
- Use comments and @-mentions to assign work rather than to chat
- Lesson 2 — Version History — Getting Back What You Lost· 52 min· ~375 MB
From the same Google Docs walkthrough — this time watch the Version history chapter. Docs saves continuously, so version history is the only real undo for anything older than this session.
- Open version history and read what changed and who changed it
- Recover content from an old version without restoring the whole document
- Name versions at the moments that actually matter
Level 2 — Intermediate Skills
Move past the basics into the techniques that separate a beginner from someone genuinely useful.
Module 5 — Advanced Sheets & Automation with Apps Script
- Lesson 1 — Google Sheets QUERY Function for Pivot-Style Reports· 19 min· ~135 MB
Use the QUERY function to build pivot-table-style reports that group and summarize data by month/year automatically.
- Pull a filtered, sorted, summarised table out of raw data with one formula
- Read QUERY well enough to change it confidently rather than copying it
- Know when QUERY is the right tool and when a pivot table is
- Lesson 2 — Google Apps Script for Beginners: Automating Sheets, Docs & Gmail· 24 min· ~172 MB
Write your first Apps Script automations to handle repetitive Google Workspace tasks without manual clicking.
- Understand what Apps Script is and what it can reach in your account
- Write and run a first small script safely
- Judge which office chores are actually worth scripting
Level 3 — Professional Practice
Work the way professionals do, then apply everything to a complete real-world project.
Module 6 — Working Like a Pro
- Lesson 1 — Google Docs Tutorial for Beginners - EVERYTHING You Need To Know· 52 min· ~375 MB
A complete walkthrough of creating polished, professional documents in Google Docs.
- Structure a long document with headings so it navigates itself
- Produce a document that looks professional without fiddling
- Send it in the form the recipient actually wants
- Lesson 2 — 30 Time-Saving G Suite Tips to Help Your Employees be More Productive· 31 min· ~220 MB
A Google Cloud conference talk packed with real time-saving tips for everyday Workspace use.
- Choose the few tips that fit how you actually work
- Turn a chosen tip into a habit rather than a memory
- Avoid collecting productivity advice you never use
Module 7 — Applied Project: Build a Working Tracker/Dashboard
- Lesson 1 — Building a Complete Budget Tracker in Google Sheets· 18 min· ~129 MB
Construct a fully functional budget tracker from a blank sheet, including formulas and category breakdowns.
- Build a tracker somebody will actually keep using
- Set up categories and entry so the data stays consistent
- Handle the messy real input a budget here actually has
- Lesson 2 — Building a Project/Event Expense Tracker Dashboard· 35 min· ~248 MB
Step-by-step build of a real expense-tracking dashboard usable for a business or event budget, with live totals.
- Turn a tracker into one screen that answers a question
- Choose charts that say something rather than decorate
- Build it so a client can use it without you
Level 4 — Freelance & Career
Turn the skill into income: finding clients, pricing your work, and building a career around it.
Module 8 — Freelance & Career: Becoming a Virtual Assistant
- Lesson 1 — Virtual Assistant Skills Clients Actually Pay For· 10 min· ~70 MB
The specific Google Workspace and admin skills that get freelance VAs hired, not generic advice.
- Know which of these skills people genuinely pay for
- Describe what you do as an outcome rather than a tool list
- Choose the two things to be genuinely good at
- Lesson 2 — Getting Your First VA Clients Without Cold Pitching· 11 min· ~81 MB
A concrete, non-spammy client-acquisition method for new virtual assistants to land their first paying client.
- Find a first client through people who already know you
- Make an approach specific enough that somebody can answer it
- Run that first job so it produces a testimonial and a second job
Spin for a discount
One spin, one discount on this Learning Path.
Reviews
No reviews yet.