![](https://andrewmoss.me/wp-content/uploads/2024/06/andrew-moss-06.png)
Andrew Moss
Excel Aficionado
At the backend of last year, I was honoured to be asked by Microsoft MVP John Michaloudis to participate in his podcast, The Best Microsoft Excel Tips & Tricks in…
Does anybody remember Nelly’s 2002 hit ‘Dilemma’ ft. Kelly Rowland? Was that really twenty-two years ago?! 😳 Having amassed an astonishing 1.5B+ views and 8M+ likes, it’s one of the…
It was only last year when I first realised that LinkedIn had a copyright infringement issue after discovering a slew of users regularly publishing popular Instagram and TikTok videos as fresh uploads…
LED status lights — why are they so annoying at night? Whether it’s televisions, computers, game consoles, USB hubs or WiFi extenders — you name it — it’s very common…
Days like today don’t come around very often, so it’s an appropriate time to remind everyone of the dreaded ‘leap year bug’. What is the ‘leap year bug’? Ever since…
Have a look at these Excel buttons: Increase Font Size | Decrease Font Size Decrease Indent | Increase Indent Increase Decimal | Decrease Decimal Zoom Out | Zoom In What…
I’ve been to all four Global Excel Summits now, stretching back to the inaugural edition in 2021. I wasn’t an employee for the first two. However, I was delighted to become…
Switching a cell reference from relative to absolute is ideal when you don’t want it shifting in a formula after you copy and paste elsewhere or use the fill handle…
Quick gripe to start the morning with: pillows. It doesn’t seem to matter whether I’m in a budget Travelodge or an expensive hotel in West London — the pillows are…
Excel has options allowing you to restrict cell entry so data is kept accurate and consistent. The Data Validation button is found on the Data tab. Selecting it brings…
In a new Excel worksheet, I enter this formula in A1: =SEQUENCE(3276,16384) After waiting 12 seconds, a spilled sequence is generated from 1 in A1 to 53673984 in XFD3276. XFD…
English is an ever-evolving language, with most dictionaries welcoming 500–1,500 new words every year. The job of a lexicographer is to compile dictionaries, adding and editing entries as they monitor…