Microsoft Excel

I first needed CONCATENATE when I had a spreadsheet with first names in one column and last names…

Whenever I’m reviewing a set of numbers — sales figures, test scores, expenses — one of the first…

When I was first learning Excel, I assumed there was only one way to count things — and…

SUM was the very first Excel function I ever learned, and I’d guess that’s true for a huge…

The IF function was the moment Excel stopped feeling like a calculator to me and started feeling like…

VLOOKUP was, without exaggeration, the function that changed how I worked with spreadsheets. Before I learned it, whenever…

If there’s one Excel feature that changed the way I look at raw data, it’s the pivot table.…

Every time I open a spreadsheet with hundreds or thousands of rows, filtering is usually the very first…

Sorting is one of the very first things I learned in Excel, and I still use it almost…

If you’ve ever scrolled down a huge spreadsheet and lost track of which column is which, you already…