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 from the dropdown in the Home ribbon tab. However, it…
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 to the UNIQUE function. Having said that, for many years…
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 on its competition since dethroning the now-defunct Lotus 1–2–3 in…
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 I dig beneath the surface, I know many of you…
Excel is so ubiquitous it can give many the false impression they are more adept with it than they actually are. Let’s face it: everyone has it on their computer — whether at home or the workplace. But how many users can…
It’s fair to say that Excel formulas are becoming like a programming language. Over the past couple of years, Microsoft has fundamentally changed Excel’s calculation engine and introduced a set of functions that allow us to construct formulas to do…
End of content
End of content
