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.

Absolute and relative references in Excel formulas are two ways to refer to cells in your spreadsheet. They both have their purpose, and sometimes you may find yourself using them interchangeably.