I’ve used Excel, even beyond spreadsheets, for quite some time, and over the years, I’ve naturally developed a few favorite features and shortcuts. They’re probably not the ones you’d expect, though.

Learn the difference between Excel COUNT and COUNTA, plus TEXTBEFORE and TEXTAFTER tricks, so you clean text and totals with ...

The BYROW function is a powerful tool that applies a Lambda function to each row in your dataset. This function is particularly useful when you need to perform operations on a row-by-row basis. For ...