Many offices now run on Google Sheets, Docs and Drive, often alongside Excel. These six lessons are written for people who already know some Excel: what’s the same, what’s different, the formulas only Sheets has, sharing safely, Forms that feed a sheet, and your first Apps Script automation.

1. 1Google Workspace Lesson 1: Google Sheets for Excel UsersMove from Excel to Google Sheets without frustration: what works the same, what differs (shortcuts, menus, file types, recalculation), importing and exporting…
2. 2Google Workspace Lesson 2: Google Docs EssentialsUse Google Docs well: headings and outline, suggesting mode instead of track changes, comments and assignments, smart chips, templates, voice typing, and…
3. 3Google Workspace Lesson 3: Drive — Folders, Sharing and PermissionsOrganise Google Drive with shared drives and folders, share safely with Viewer/Commenter/Editor, avoid “anyone with the link” leaks, transfer ownership, use filter…
4. 4Google Workspace Lesson 4: Google Forms Into SheetsCollect data without retyping: build a Google Form with the right question types and validation, send responses to a Sheet, summarise them…
5. 5Google Workspace Lesson 5: Sheets Formulas Excel Doesn’t HaveThe Google Sheets functions that make it special: QUERY, ARRAYFORMULA, IMPORTRANGE, GOOGLETRANSLATE, SPARKLINE, SPLIT, IMAGE, GOOGLEFINANCE and checkboxes, with practical examples.
6. 6Google Workspace Lesson 6: Apps Script — Your First AutomationWrite your first Google Apps Script: open the editor, read a sheet, total by region, email yourself a summary, add a custom…

Related: Google Sheets vs Excel, QUERY for Excel users.