Google Sheets Dropdowns and Data Validation (With Coloured Chips)
Create dropdown lists in Google Sheets from a range or typed items, add colours, make dependent dropdowns, reject bad entries and keep shared sheets…
Read article →Google Workspace
Google Sheets and Docs for people who know Excel and Word.
🟢
← Office & Productivity
Google Workspace
Google Sheets and Docs for people who know Excel and Word.
📄 10 articles⬇️ 9 with practice files🕒 Updated 12 Nov 2026
Google Sheets vs Excel: What Each Is Actually Better At
Google Sheets vs Excel: What Each Is Actually Better At
An honest comparison from daily use: collaboration, formulas, data size, automation, offline use and cost — plus the functions that behave differently and how…
Read article →Google Workspace Lesson 4: Google Forms Into Sheets
Google Workspace Lesson 4: Google Forms Into Sheets
Collect data without retyping: build a Google Form with the right question types and validation, send responses to a Sheet, summarise them with formulas…
Read article →Google Workspace Lesson 6: Apps Script — Your First Automation
Google Workspace Lesson 6: Apps Script — Your First Automation
Write your first Google Apps Script: open the editor, read a sheet, total by region, email yourself a summary, add a custom menu, schedule…
Read article →Google Workspace Lesson 5: Sheets Formulas Excel Doesn’t Have
Google Workspace Lesson 5: Sheets Formulas Excel Doesn’t Have
The Google Sheets functions that make it special: QUERY, ARRAYFORMULA, IMPORTRANGE, GOOGLETRANSLATE, SPARKLINE, SPLIT, IMAGE, GOOGLEFINANCE and checkboxes, with practical examples.
Read article →Google Workspace Lesson 3: Drive — Folders, Sharing and Permissions
Google Workspace Lesson 3: Drive — Folders, Sharing and Permissions
Organise Google Drive with shared drives and folders, share safely with Viewer/Commenter/Editor, avoid “anyone with the link” leaks, transfer ownership, use filter views, and…
Read article →Google Workspace Lesson 1: Google Sheets for Excel Users
Google Workspace Lesson 1: Google Sheets for Excel Users
Move from Excel to Google Sheets without frustration: what works the same, what differs (shortcuts, menus, file types, recalculation), importing and exporting .xlsx, version…
Read article →Google Workspace Lesson 2: Google Docs Essentials
Google Workspace Lesson 2: Google Docs Essentials
Use Google Docs well: headings and outline, suggesting mode instead of track changes, comments and assignments, smart chips, templates, voice typing, and exporting to…
Read article →Google Sheets IMPORTRANGE: Pull Data From Another Sheet (and Filter It)
Google Sheets IMPORTRANGE: Pull Data From Another Sheet (and Filter It)
Link Google Sheets files with IMPORTRANGE, grant access once, and combine it with QUERY to pull only the rows and columns you need.
Read article →Google Sheets QUERY Function for Excel Users
Google Sheets QUERY Function for Excel Users
Google Sheets’ QUERY function lets you filter, group and sort with SQL-like syntax in one formula. Learn it with examples mapped to Excel features…
Read article →