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.

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.

Counting cells in Excel using the COUNT function is very easy, so if you want to learn how to do it, read this post to learn all about it.

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.

Learn how to easily set up your own search field in Excel to find and filter content within a table.