Excel 2007 Formulas and Functions

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

Prerequisite
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
120 minutes

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.

Objective

Working with Formulas in Excel 2007

  • 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

Using Formulas with Functions in Excel 2007

  • 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

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.