Excel 2007 Formulas and Functions Online Course Available

Sept. 15, 2009 - PRLog -- Latitude has made available SkillSoft's Excel 2007 Formulas and Functions online course available on its www.LatitudeU.com training site.

This Excel 2007 course 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

# # #

LatitudeU is an online elearning community with over 3,000 online courses from leading elearning publishers. Career training and preparation for certifications is available for management, sales, IT, business, human resources, and other areas.