Excel 2007 Formulas and Functions

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