Course of the Day: 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

Key Concepts:
Microsoft Excel 2007, Microsoft Excel 2007 Formulas, Microsoft Certified Application Specialist Certification, 77-602 Using Microsoft Office Excel 2007, Microsoft Office 2007

Course Appears in these Categories:
• Desktop Certifications >> Microsoft >> Microsoft Certified Application Specialist Certification
• Desktop Skills >> Microsoft Office 2007 >> Microsoft Excel 2007: Basics
• Continuing Professional Education >> National Association of State Boards of Accountancy (NASBA)

Courses you might be interested in:
• Programmability and Administration in Access 2007
• Database Administration in Access 2007
• Importing and Exporting Data and Data Presentation in Access 2007
• Advanced Data Management in Access 2007
• Advanced Formatting in Excel 2007
• Advanced Data Management in Excel 2007
• Advanced Customization in Excel 2007
• Customizing Outlook 2007 and Using the Journal
• Configuring Rules, Alerts, and Junk E-mail Settings in Outlook 2007
• Working with SharePoint, Calendars, and Forms in Outlook 2007
• Creating Custom Slide Shows in PowerPoint 2007