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.

Referencing can become difficult, especially if you’re using structured referencing. Instead, reference a spill range so you can use the hashtag shortcut.

This column introduces PIVOTBY, a new Excel function that may let you say bye-bye to PivotTables.

You can sum a series of numbers in Microsoft Excel manually by typing in a simple formula, or automatically with a tool.