Course Details

Previous Page


Excel 2007 Formulas and Functions


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number



Overview/Description
Excel 2007 provides numerous functions and formulas for performing simple and complex calculations on workbook data. The Ribbon's Formulas tab provides convenient access to groups of data analysis and calculation tools, such as the Function Library, Named Cells, Formula Auditing, and Calculation groups. This course demonstrates how to create and edit formulas, use references and names, and work with tables in Excel 2007. Basic, logical, financial, and date functions are also covered.

Target Audience
Personnel at all levels of the enterprise; end-users seeking competency in the use of Microsoft Excel 2007.

Prerequisites
Some knowledge of basic word processing, computing, and spreadsheets; familiarity with the Microsoft Office work environment; an understanding of the Internet and web-page functionality

Expected Duration (hours)
2.0

Lesson Objectives

Excel 2007 Formulas and Functions

  • identify the elements of a formula
  • identify the default order in which calculations occur
  • match absolute, relative, mixed, and 3-D references with examples
  • insert an Excel 2007 formula
  • use names to clarify formulas
  • edit formulas
  • work with Excel 2007 formulas in given scenarios
  • use the AutoCalculate feature to perform basic functions
  • use a logical function
  • use a financial function
  • use a date function
  • use functions to perform calculations in Excel 2007
  • use formulas and functions to calculate data in a given scenario
  • Course Number:
    mo_bgex_a04_dt_enus