Instead of typing a SUM formula, an easier way to go is to use the shortcut Alt + Equal sign (=)
But did you know that you can use this shortcut for a whole table?
If you have a table like the one below, select all the values plus one extra row and one extra column:
READ MOREExcel has built-in functionality to handle percent (%), but there is no automatic way to calculate parts per million, basis points, permyriad or per mille in Excel. It is easy to calculate though, but let’s start with the definitions:
And here’s how to apply it:
READ MORE
Have you ever imported data into Excel that won’t calculate? Look at this example where the earnings look like numbers to the human eye, but not to Excel. And when Excel is not able to identify any numbers, it can’t calculate any sums or averages either.
This happens all the time if you use data from other data sources: It could be a txt-file from a booking system, a copy-paste from a website or even a database export.
Enough about the problem. Let’s solve it, and let’s not spend more than 2 minutes doing it!
Wouldn’t it be cool if you could have a yellow info note that pops up when you select the cell in Excel? Actually you can! Let’s look at a little used feature of Data Validation.
It’s easy and you can do it in less than a minute!
READ MORE