This online self-study course focuses on Excel 2007 formulas and functions.

Excel 2007 provides numerous Excel 2007 formulas and functions for performing simple and complex calculations on workbook data. Excel 2007 formulas are organized using the Ribbon's Formulas tab which 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 Excel 2007 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, Excel 2007 formulas or Excel 2007 functions.

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

Lesson Objectives

1. Basics of Excel 2007 Formulas and References
   - identify the elements of a formula
   - identify the default order in which calculations occur
   - match absolute, relative, mixed, and 3-D references with examples
2. Insert Excel 2007 Formulas
   - insert Excel 2007 formulas
   - use names to clarify Excel 2007 formulas
   - edit formulas
3. Entering Excel 2007 Formulas with References
4. Perform Excel 2007 AutoCalculate Functions
   - use the AutoCalculate feature to perform basic functions
5. Excel 2007 Logical, Financial, and Date Functions
   - use a logical function
   - use a financial function
   - use a date function
6. Inserting Excel 2007 Functions
7. Using Excel 2007 Formulas and Functions