Conditional formatting is one of the quickest ways to make a spreadsheet easier to read and act on. Instead of manually highlighting cells, you set rules that apply formatting automatically based on t...
The IF function is one of the most used formulas in Excel, and for good reason. It lets a cell display different values depending on whether a condition is true or false — for example, showing &...
A pivot table is one of the most powerful features in Excel, and it’s much easier to use than most people expect. It lets you take a large flat list of data — sales records, customer order...
XLOOKUP is the modern replacement for VLOOKUP in Excel, and it fixes almost every frustration that comes with using the older formula. It is simpler to write, more flexible, and doesn’t have the...
VLOOKUP is one of the most useful formulas in Excel, and once you understand how it works, it will save you hours of manual searching. It lets you look up a value in one column and automatically pull ...