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 →Office
Word, PowerPoint, Outlook and Google Workspace tips for faster everyday work.
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 →PowerPoint Slide Master: Fix Every Slide in One Place
PowerPoint Slide Master: Fix Every Slide in One Place
Stop formatting slides one by one. Use PowerPoint’s Slide Master to control fonts, colours, logos and layouts for the whole deck — and rescue…
Read article →Word Track Changes and Compare: Review Documents Like a Pro
Word Track Changes and Compare: Review Documents Like a Pro
Use Track Changes, comments, Accept/Reject and Compare Documents in Microsoft Word to review contracts and reports — plus how to remove hidden tracked changes…
Read article →Word Wildcard Find & Replace: 8 Patterns That Save Hours
Word Wildcard Find & Replace: 8 Patterns That Save Hours
Word’s wildcard search is a hidden power tool. Eight ready-to-use patterns to fix spaces, dates, phone numbers, brackets and formatting in long documents.
Read article →Word Styles and an Automatic Table of Contents (Step by Step)
Word Styles and an Automatic Table of Contents (Step by Step)
Use Word’s Heading styles to format long documents consistently, build an automatic table of contents, number headings and navigate with the Navigation Pane.
Read article →