By default, references in Excel use the A1 reference style, which means that it refers to the column first, and then the row number. However, the INDIRECT function enables you to switch these around.

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

Excel has a versatile If, Then function built right into it. We’ll show you how to use the IF function in Excel with a number of helpful examples.

Are you wondering how to use the Excel FILOTER function with multiple criteria? We have detailed guide on how to easily use the Filter function in Excel using the AND and OR operators.

If you work with a large dataset or usually query the same data in an Excel table, then you should use the VLOOKUP function to make your life easier – here's how.

DGET has only three arguments, making it much more straightforward to use than other Excel lookup functions. The DGET function is an old-school tool!