Introduction and Unit Objectives

“Nobody sets out to create a mission critical spreadsheet, they ‘just happen’. ”  — Felienne Hermans in “Analyzing and visualizing spreadsheets”

Spreadsheets are great at storing information; for some, it has become a type of database. The real power in Excel can be found within the formulas and functions. With just a few clicks, Excel can do calculations that would make a math teacher jealous.

In this unit, we look at how we use functions and formulas, the proper time to switch between the two and some standards that you need to know.

Unit Objectives:

  • Name a cell and group
  • Describe the different types of cell references
  • Write a simple Excel formula
  • List some common functions and write out examples of each
  • Use common format functions to configure a cells