Excel function basics

The following section contains articles and tutorials to familiarize you with the basics of Excel, including file management, the formula bar, and functions.

  • Basic arithmetic in Excel. We'll start out our exploration of Excel formulas by learning how to perform basic arithmetic calculations.
  • What is a function in Excel?. What is a function in Excel? Our helpful tutorial will walk you through the basics of what a function is and how to use one in your spreadsheet.
  • Excel nested functions. Nested functions within Excel allow you to string together chains of functions to create larger, more complex formulas.
  • Absolute and relative cell references. Excel has two types of cell references: Relative and absolute. Relative references shift as you copy and paste cells. Absolute references do not.