COUNTIF is one of those Excel functions that sounds simple but turns out to be useful in dozens of situations. At its most basic, it counts how many cells in a range match a condition you set. That mi...
If you need to add up values in a spreadsheet only when they meet a certain condition — for example, total sales for one product, or all expenses in a specific category — SUMIF is the function you nee...
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 orders, exp...
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 ...
Microsoft Word is the world’s most widely used word processor, and for good reason — it handles everything from a one-page letter to a hundred-page report with footnotes, tables of contents and ...
Getting your writing right matters — whether you’re sending a business proposal, a complaint letter or a report to your manager. Microsoft Word already has built-in tools that catch basic errors...