Power Query for Beginners: Clean Data Without Formulas
A beginner Power Query tutorial: import data into Excel, clean it with clicks (trim, split, remove duplicates, fill down), combine files from a folder and refresh in one click.
Excel Conditional Formatting: 10 Practical Examples
Learn Excel conditional formatting with 10 practical examples: highlight values, duplicates, overdue dates, whole rows, top 10, data bars, colour scales and more.
Free Monthly Budget Template for Excel and Google Sheets
Download a free monthly budget template for Excel and Google Sheets. Track planned vs actual income and expenses, see what is left over and your savings rate.
How to Build a Simple Business Website with WordPress
Build a professional small business website with WordPress in one weekend: domain, hosting, theme, essential pages, plugins, contact form and Google setup.
Notion for Beginners: Set Up Your First Workspace
A beginner guide to Notion: create pages, use blocks and the slash command, build your first database, and set up a simple task tracker and notes system.
50 ChatGPT and Claude Prompts for Office Work
50 copy-ready AI prompts for everyday office work: emails, meetings, reports, Excel, planning, presentations and career, for ChatGPT, Claude, Gemini or Copilot.
How to Use AI to Write Better Work Emails
Use ChatGPT, Claude, Gemini or Copilot to draft work emails in seconds: a simple 4-part prompt formula, 10 ready-to-use prompts and mistakes to avoid.
25 Excel Formulas Every Office Worker Should Know
The 25 Excel formulas that cover most office work: totals, counting, IF logic, lookups, cleaning text and dates, each with a copy-ready example.
How to Make a Pivot Table in Excel (Step by Step)
A step-by-step guide to pivot tables in Excel: prepare your data, build a summary, show percentages, group dates by month, add slicers and refresh.
XLOOKUP in Excel: The Complete Beginner Guide
Learn XLOOKUP in Excel with 5 practical examples: find prices, look left, return several columns, show a not-found message and fix common errors.