Excel-related articles.
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…
How do you reference a range in a formula? For decades, the answer has been simple: select multiple cells to create a reference with the starting cell on the left, a colon in the middle, and the ending cell on…
Percentages show up everywhere — in finance, business, and day-to-day life. In Excel, there are four straightforward ways to work with percentages. Each example below assumes the Percentage number format is applied, so you don’t have to multiply by 100….
