Full-scale charts can clutter a worksheet, which is why in-cell charts are helpful — they save space while still letting you scan data quickly. Excel offers options like Sparklines and Data Bars, but they can clash with values and often…
On a mild yet wet, muddy, and sludgy early morning, my Saturday 12 km run turned into a bit of an obstacle course in places. However, I was doing fine up until the last couple of kilometres, when I unexpectedly…
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…
If you think Excel’s worksheet and workbook protection will truly keep your files secure — think again. Both are surprisingly easy to bypass. That’s bad news if you’re relying on them for security, but good news if you’ve ever forgotten…
Tech hygiene. Those are the words that accompany WHOOSH!, a brand of screen-cleaning products designed for a wide range of devices. Since the advent of touchscreen phones and tablets, smudginess and grubbiness have become very common. It doesn’t matter how…
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…
