Having a title in each of your Excel worksheets is often a good idea to help distinguish between them. Typically, you’ll want the title to be the same as the tab name. However, if you change the tab name, the…
More than ever in this heavily commercialised world, companies feel compelled to jump on special events with marketing gimmicks and flash-in-the-pan campaigns. Whether it’s limited-edition packaging, novelty products, or cheeky ads, they see it as a great way to wrap…
Lists in Excel often need to be reshaped depending on the task at hand. Sometimes you’ll have a flat list, where each value appears in its own row without any grouping or hierarchy. If a value occurs multiple times, it…
Five years ago (almost to the day), I published my first-ever blog post. It also happened to be on my birthday, funnily enough. What did I decide to write about? Well, what better place to start than the very thing that…
Here’s my Vanilla Iced Matcha Latte. I purchased it today from Cafe Nero for £4.50. What do you notice? That’s right, it’s full of big blocky ice cubes. There’s about 15 of them filling half the cup that could have…
If you copy a set of hyperlinks with friendly text from a website and paste them into Excel, each URL is embedded as part of the cell’s metadata. This poses a challenge if you want to extract them, as there’s…
