Microsoft Excel for Mac 2011: Using Basic Formulas


Overview/Description
Target Audience
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description
Formulas are the building blocks of data calculation in Excel for Mac 2011. Being able to use formulas to perform everything from easy to complicated calculations not only simplifies your work but also helps to reduce the number of errors that can arise in such complex tasks. This course introduces formulas, demonstrates how to create and edit them, copy and paste them, and how to check for errors that can arise when using formulas in Excel for Mac 2011.

Target Audience
Any individuals and business users with basic Mac computer literacy.

Expected Duration (hours)
1.0

Lesson Objectives

Microsoft Excel for Mac 2011: Using Basic Formulas

  • identify elements of a formula
  • recognize how Excel calculates precedence in a formula
  • recognize examples of reference types used in Excel formulas
  • create and insert formulas
  • create a name and use in a formula
  • edit formulas
  • correct common error values
  • create a formula
  • correct and edit a formula
  • use a name in a formula
  • copy and paste a formula between cells
  • Course Number:
    om_bemc_a05_dt_enus

    Expertise Level
    Beginner