At the weekend, the clocks went back across Europe, allowing most of us to enjoy an extra hour in bed! In the UK, this occurred on 26 October at 02:00 BST, meaning the hour before was repeated. The issue is…
Are your columns and rows a bit of a mess? Too wide, too narrow, too tall, or too short for the data they hold? Here are three ways to optimise their size: Mouse method Click the top-left corner of the…
When a calculation goes wrong in your worksheet, it’s usually because of a faulty formula — so you spend seconds, minutes, or hours trying to correct it. But sometimes the issue is actually with your data, even if it’s not…
In a recent viral TikTok video, creator @frogtownmayor went on a lengthy rant about Excel’s default text overflow — where a cell’s contents spill into the empty cells beside it. While it might sound like a trivial complaint, it’s bugged…
Happy birthday to Excel! Check out my video reflecting on its beginnings and the path that led to where it is today. Watch the video Transcript Microsoft Excel is 40! That’s right. It was on 30th September 1985 when the…
There are numerous ways to find the highest value in a column and return one or more values in the matching row. In this example, a table called tblSales houses some monthly sales data. XLOOKUP is combined with MAX to…
