Microsoft's spreadsheet program can do way more than you might imagine. These are the hacks and tricks you need to know.

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

Tables, named ranges, line breaks, modern functions, and helper columns make Excel formulas easier to read, audit, and fix.

Have you ever found yourself wrestling with Excel formulas, wondering why your data retrieval isn’t working as expected? For years, Excel users have relied on VLOOKUP, a familiar and straightforward ...

Have you ever tried to drag the header columns in an Excel spreadsheet to make them fit the text? I have and just when I think I’ve got it right, a quick glimpse down the line of columns usually ...

When you link a cell in Excel to a cell from another worksheet, the cell that contains the link shows the same data as the cell from the other worksheet. The cell that contains the link is called a ...

If you want to learn how to use IF and VLOOKUP nested functions in Excel, you’ve come to the right place. The IF and VLOOKUP nested functions are two of the most powerful functions in Excel used by ...

If you want to know how to use column index number in VLOOKUP in Excel, you’ve come to the right place. Vertical Lookup, or VLOOKUP, is one of the most popular formulas used in Excel. While the ...

Comparing two columns in Excel doesn’t have to be a difficult task, and to get the job done, we suggest using VLOOKUP. You see, not always; the columns you want to compare are in the same workbook or ...