Excel & Sheets

Create drop-down lists in Excel with data validation: from typed items, from a range, from a table that grows automatically, plus dependent lists, error messages and common fixes.

Build a simple, clean sales dashboard in Excel step by step: prepare the data, create pivot tables, add KPI tiles, charts and slicers, and refresh it with one click.

Four easy ways to find and remove duplicates in Excel: the Remove Duplicates button, highlighting first, the UNIQUE function and Power Query, plus how to avoid deleting the wrong rows.

Google Sheets vs Excel compared: price, collaboration, size limits, formulas, Power Query, automation, AI and offline use, plus which one to choose for your work.

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.

Learn Excel conditional formatting with 10 practical examples: highlight values, duplicates, overdue dates, whole rows, top 10, data bars, colour scales and more.

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.

The 25 Excel formulas that cover most office work: totals, counting, IF logic, lookups, cleaning text and dates, each with a copy-ready example.

Learn XLOOKUP in Excel with 5 practical examples: find prices, look left, return several columns, show a not-found message and fix common errors.