When writing formulas in Excel, SUM and VLOOKUP are staples for beginners. But since Excel has over 400 functions, it's helpful to know more of the extremely useful ones, especially when looking to ...

Microsoft's Excel program, widely used in business, comes with many built-in functions that perform mathematical and logical operations on spreadsheet data. In Excel, functions are simple formulas you ...

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

Learn a quick and easy straightforward method for creating dependent drop-down lists in Excel using range functions, without relying on complex formulas. By organizing data with dynamic ranges, each ...

Nest CHOOSECOLS inside UNIQUE to extract non-adjacent columns, and use INDIRECT for interactive header dropdowns.

If your business uses spreadsheets, you may find it necessary to count the number of cells containing data in a worksheet. You might also need to determine how many cells are empty or if the values of ...

Power users love to talk about how powerful and awesome Excel is, what with its Pivot Tables, nested formulas, and Boolean logic. But many of us barely know how to find the Autosum feature, let alone ...

How to return the last value in an Excel data range Your email has been sent When you need to see the last value in an Excel Table or data range, these formulas will get the job done. This ...

How to use VBA’s InputBox function to select a range on the fly in Excel Your email has been sent Often, you’ll want Excel users to specify a range that the app then uses in an automated way.