![](https://andrewmoss.me/wp-content/uploads/2024/06/andrew-moss-06.png)
Andrew Moss
Excel Aficionado
The TEXTJOIN function offers a convenient way of concatenating values whilst separating them according to a specific delimiter.
Perhaps you are carrying out an audit or keeping track of a project in Excel. Datestamps and timestamps are bound to come in handy. Instead of manually entering the current…
Still got that old copy of Excel installed? Uninstall it, bin it (if it’s a CD-ROM), and get with the times. STOP being an Excel dinosaur! You’re Missing Out on…
Italy clinched their second European Championship title last Sunday after beating England in the Euro 2020 final on penalties. It was the same old story for the Three Lions, who…
Euro 2020 reached its finale on Sunday, with Italy crowned winners after defeating England (my nation!) in a penalty shootout. It meant the Three Lions’ 55 barren years without a…
The use of data validation in spreadsheets is important as it keeps data accurate and consistent. Without it, data can become a mess and unmanageable. If you want to learn…
55 years of hurt did not end last night, but it could go a long way to doing so, as England beat Germany 2–0 in the biggest international match Wembley…
For all the great things about Excel, one of the most confusing things is how it stores and displays data. Every cell has a number format, which can be selected…
Extracting unique values from a range in Excel has always been possible, but not always easy. Only since the implementation of the new calculation engine has it become a doddle — thanks…
I wrote an article on Power Tech Tips about 20 functions in Google Sheets that are not present in Microsoft Excel. If you haven’t used Sheets before, you’ll be amazed…
Excel is the behemoth of the spreadsheet kingdom. Across the length and breadth of every nation, it reigns supreme. As the market leader, the program has enjoyed a long stranglehold…
Did you know your Excel calculations can be affected by filtering tables or hiding rows? It’s one of those questions you may well answer with an emphatic yes. But if…