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 →Office
Word, PowerPoint, Outlook and Google Workspace tips for faster everyday work.
📊
← Excel
Office
Word, PowerPoint, Outlook and Google Workspace tips for faster everyday work.
📄 71 articles⬇️ 70 with practice files🕒 Updated 11 Nov 2026
🎓 Start here: Excel for India Course → 🎓 Start here: Excel Course: Beginner → Expert → 🎓 Start here: Bank Statement Automation →PowerPoint Intermediate Lesson 8: Project – A Monthly Review Deck That Updates Itself
PowerPoint Intermediate Lesson 8: Project – A Monthly Review Deck That Updates Itself
Final project: brand template, Title + Chart layouts, Excel-linked or generated charts, a Summary Zoom menu and Morph for the headline, rebuilt every month…
Read article →PowerPoint Intermediate Lesson 7: Accessible Slides
PowerPoint Intermediate Lesson 7: Accessible Slides
Make decks work for everyone: the Accessibility Checker, alt text, reading order, unique slide titles, contrast and captions for recorded presentations.
Read article →PowerPoint Intermediate Lesson 6: Generate Slides From Data With Python
PowerPoint Intermediate Lesson 6: Generate Slides From Data With Python
Build one slide per region, product or branch automatically from an Excel file with python-pptx: titles, native charts and status text, ready to re-run…
Read article →PowerPoint Intermediate Lesson 5: Sections and Zoom Navigation
PowerPoint Intermediate Lesson 5: Sections and Zoom Navigation
Organise long decks with sections and use Summary Zoom and Section Zoom to jump to any part during a meeting and come back automatically.
Read article →PowerPoint Intermediate Lesson 4: Morph for Before-and-After Stories
PowerPoint Intermediate Lesson 4: Morph for Before-and-After Stories
Use the Morph transition to move, resize and recolour objects smoothly between two slides, and force matches with !! object names.
Read article →PowerPoint Intermediate Lesson 3: Charts Linked to Excel That Update
PowerPoint Intermediate Lesson 3: Charts Linked to Excel That Update
Paste charts as links so this month's numbers flow into the deck: paste link vs embed, updating, Edit Links, and what breaks links when…
Read article →PowerPoint Intermediate Lesson 2: A Brand Template (.potx) for the Whole Team
PowerPoint Intermediate Lesson 2: A Brand Template (.potx) for the Whole Team
Turn your master into a company template: theme colours and fonts, only the layouts people need, saved as .potx and shared so every new…
Read article →PowerPoint Intermediate Lesson 1: Slide Master and Custom Layouts
PowerPoint Intermediate Lesson 1: Slide Master and Custom Layouts
Stop formatting slide by slide: set fonts, colours and logo once in the Slide Master and create your own layouts such as "Title +…
Read article →Word Intermediate Lesson 8: Project – A Company Report Template (.dotx)
Word Intermediate Lesson 8: Project – A Company Report Template (.dotx)
Final project: a reusable company report template with styled headings, automatic numbering, a cover page with property fields, section-based page numbers and a TOC.
Read article →Word Intermediate Lesson 7: Compare Versions and Control Changes
Word Intermediate Lesson 7: Compare Versions and Control Changes
Find every change between two contract versions with Compare, accept or reject them one by one, combine reviewers' copies and limit who can edit…
Read article →Word Intermediate Lesson 6: Fill-In Forms With Content Controls
Word Intermediate Lesson 6: Fill-In Forms With Content Controls
Build a joining form people fill in without breaking the layout: text, date-picker, drop-down and checkbox content controls, then restrict editing to filling in…
Read article →