Skills Grid
A small Excel file to show how we can create a chart-like Excel sheet Used in my Resume to show different skill sets and the...
Text-to-Columns, dynamically using formulas
I often use the technique of concatenating columns into 1 cell with separators. Something like the CSV, 1 line that has all values for a...
IFS (and IFNA) to avoid nested IFs
I tend to see more and more the usage of nested IF functions recently Now, do not get me wrong, IF is great, but come...
Highlight dates dynamically
Conditional formatting is another powerful feature in Excel, especially when you combine it with functions A simple function as in below if you set it...
IF with AND and IF with OR
The powerful function If can already do a lot of tricks, but we can for sure do more when we use it with AND or...
New function IFERROR, finally
We have already gotten used to use VLOOKUP, MATCH and other functions that generates errors inside an IF But, we do not need that anymore...
Calculate hours between two cells
We needed that several times in the past Then I found it in an old file in my laptop, thought to share it for others...