PowerPoint Lesson 1: Slide Layouts and the Slide Master
Use layouts instead of loose text boxes, change fonts, colours and logos once in the Slide Master, reset slides that drifted, and build a…
Read article →Office & Productivity
Microsoft Office apps (Word, PowerPoint, Outlook), Google Workspace, and productivity tools.
Word Lesson 4: Tables in Word
Word Lesson 4: Tables in Word
Insert and convert tables, apply table styles, repeat header rows, align numbers, merge and split cells, simple formulas like =SUM(ABOVE), sort a table, and…
Read article →Link Excel Charts to PowerPoint and Refresh Them Automatically
Link Excel Charts to PowerPoint and Refresh Them Automatically
Paste Excel charts into PowerPoint as linked objects so monthly decks update with one click — plus a VBA macro that refreshes every link…
Read article →Word Lesson 10: PDF, Sharing and Co-authoring
Word Lesson 10: PDF, Sharing and Co-authoring
Finish and share documents properly: inspect and remove hidden data, save as PDF with bookmarks, restrict editing, protect with a password, share OneDrive links…
Read article →Word Lesson 9: Word Shortcuts That Matter
Word Lesson 9: Word Shortcuts That Matter
The keyboard shortcuts that make a real difference in Word: selecting text, formatting, styles, Find and Replace, change case, repeat last action, navigation and…
Read article →Word Lesson 8: Templates and Quick Parts
Word Lesson 8: Templates and Quick Parts
Stop rebuilding the same letter: create a company letterhead template (.dotx), start new documents from it, save reusable blocks with Quick Parts and AutoText,…
Read article →Word Lesson 7: Track Changes and Comments
Word Lesson 7: Track Changes and Comments
Review documents without losing anyone’s edits: turn on Track Changes, choose markup views, accept or reject edits, reply to and resolve comments, lock tracking…
Read article →Word Lesson 5: Images, Shapes and Text Wrapping
Word Lesson 5: Images, Shapes and Text Wrapping
Insert pictures and icons, compress them, control text wrapping and position so images stop jumping around, anchor and lock them, add captions, and use…
Read article →Word Lesson 3: Page Layout — Margins, Orientation, Breaks and Sections
Word Lesson 3: Page Layout — Margins, Orientation, Breaks and Sections
Control how pages look: margins and paper size, page breaks instead of repeated Enter, section breaks for a landscape page in a portrait document,…
Read article →Word Lesson 2: Headings, Navigation Pane and Table of Contents
Word Lesson 2: Headings, Navigation Pane and Table of Contents
Use heading levels to structure a document, jump and reorganise sections with the Navigation Pane, insert an automatic table of contents, update it, and…
Read article →Word Lesson 1: Styles — The One Word Skill That Saves Hours
Word Lesson 1: Styles — The One Word Skill That Saves Hours
Stop formatting text by hand. Use Word styles for headings and body text, modify a style once to change the whole document, clear manual…
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 →