Excel-related articles.
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….
Word clouds are a clever way to visualise text data, but they’ve always been tricky to build in Excel without relying on add-ins or VBA. However, since Python integration landed, it’s become a lot easier. In the example, a collection…
