Course 5426: Performing Calculations on Data in Microsoft Office Excel 2007

Introduction This online course covers the skills and knowledge you will need to perform calculations on data using Microsoft® Office Excel® 2007. This includes naming data ranges and creating tables, creating formulas to calculate values, and creating conditional formulas. It also covers the tools available to identify errors in calculations, as well as auditing worksheets. Objectives At the end of the course, students will be able to:

• Manage groups of data.
• Use formulas for performing calculations on data.
• Identify errors in a formula.

Modules & Lessons Course Overview Module Introduction Navigation Overview Lab Information Course Information Performing Calculations on Data in Excel 2007 Module Introduction Managing Groups of Data Lesson Introduction Create and Rename a Table Lab: Adding and Modifying a Row in a Table Lab: Naming Groups of Data Self Test Using Formulas for Performing Calculations on Data Lesson Introduction Create and Edit a Formula Use the Function Library Lab: Using Relative and Absolute References to Create a Formula Create a Conditional Formula Self Test Identifying Errors in a Formula Lesson Introduction Identify Error Codes Trace the Precedents and Dependents of a Cell Evaluate Parts of a Formula Use the Watch Window Lab: Auditing a Worksheet Self Test Module Summary Glossary Module Introduction System Requirements To view this course, you need:

• A Pentium II, 256 MB RAM with a processor speed greater than or equal to 400 MHZ
• Microsoft® Windows® 2000 or higher
• Microsoft Internet Explorer 6.0 or higher
• Adobe Flash 7.0 or higher (1MB disk space needed to install)
• Microsoft Silverlight 4.0 or higher
• Microsoft Windows Media Player 7.0 or higher
• Microsoft XML Core Services 3.0 or higher
• A Super VGA monitor with minimum screen resolution 1024x768, with 16-bit color.
• A sound card, and either speakers or headphones (for multi-media audio).
• Internet bandwidth of 56K or faster. Broadband internet access is recommended.

For courses containing Virtual Server-based labs (courses in the IT Professional and Developer Catalog), you will need:

• Microsoft Virtual Server ActiveX control (1MB disk space needed to install)

Test your computer's capabilities to see if it supports this course. Accessibility Requirements The following software must be running on your computer in order to access this course with Screen Reader Software:

• Microsoft Internet Explorer 6.0 or higher
• Window-Eyes from GW Micro
• JAWS from Freedom Scientific
• MSAA enabled