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 much more with less.
It doesn’t stop there.
If you…
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. …
Star rating systems are commonly used to rank things like films, TV shows, hotels, and shopping products. Typically, they are done on a scale of 1–5 (or 0–5), although you may have seen the odd six-star hotel or 10-star energy-rated home. …
It’s the first of January 2022, so let me start by wishing you all a Happy New Year!
Given how the past 1¾ years have panned out due to the COVID-19 pandemic, here’s hoping 2022 sees the gradual return of normality. (We can’t keep going on like this, right?)
…
Christmas Day is here, so what better way to celebrate the big day than creating something Chrimbo-themed (in Excel, of course). I am going to show you how to create a pixel art Christmas tree with flashing lights that switch on at the click of a button.
This won’t be…
In my previous article, Analysing 10 Million Rows in Excel, I showed you how to load a dataset into Power Query consisting of 10 million rows. …
Big data is a term used since the early 1990s to describe “huge, overwhelming, and uncontrollable amounts of information.” The rapid rise of the internet has meant the volume of data has increased exponentially over the past two decades.
There is no universal threshold determining where big data starts. However…
Staring at a worksheet with a plethora of errors is not sightly, but it can be your saving grace for diagnosing formula problems.
Over a dozen error types exist, and chances are you will have seen most of them at some point, but you wouldn’t necessarily be able to pinpoint…
Spreadsheet Day was celebrated this month—an occasion to mark 42 years of the tool that has enhanced the business world and our personal lives so dearly.
Their use has spanned across many industries and professions, including financial, scientific, medical, and engineering. Some have been fast adopters—others much slower. But no…
The standard way of storing data in Excel is to have one cell for one value. However, a value might be composed of multiple parts — making it harder to work with. …
Content Writer | Spreadsheet Creator | Excel Aficionado | LinkedIn: https://www.linkedin.com/in/andrewcharlesmoss/
