Free Excel Tips
VideosQuick Excel tutorials you can follow along with in a couple of minutes. Click any video to play it, pause wherever you need to, and try it in your own spreadsheet.
XLOOKUP in 90 seconds
Look up anything in a list, like a price from a product code, plus the “Not found” trick.
SUMIFS in 90 seconds
Add up numbers that match more than one condition, like sales for one region and one product.
COUNTIFS in 90 seconds
Count the rows that match more than one condition.
IF with AND / OR in 90 seconds
Make Excel decide for you, like who qualifies for a bonus.
FILTER in 90 seconds
Pull every matching row out of a list with one formula.
UNIQUE + SORT in 90 seconds
Remove duplicates and sort a list A to Z with a formula that updates itself.
New videos are added regularly. Subscribe on YouTube so you don’t miss them, or watch the whole series as a playlist.
Skip the build
TemplatesRather not build it yourself? My ready-made Excel templates (from £7) do the work for you, or book a free 15-minute call and I’ll build something around your own data.
© 2026 Excel With Mark · Website by Willows Digital