Course 5425: Getting Started with Microsoft Office Excel 2007

Introduction This online course covers many of the new features and functionality in Microsoft® Office Excel® 2007, including the new user interface, the improved formatting capabilities provided by galleries and mini toolbars, the new capabilities offered by data tables, the new color management scheme, and the improved charting engine. It also covers core skills such as creating and modifying workbooks, moving data within a workbook, and organizing data using tables. Objectives At the end of the course, students will be able to:

• Create and modify a workbook.
• Modify a worksheet.
• Enter data in a workbook.
• Edit data in a workbook.

Modules & Lessons Course Overview Module Introduction Navigation Overview Lab Information Course Information Getting Started with Excel 2007 Module Introduction Exploring the Excel 2007 Environment Lesson Introduction Elements of the Excel 2007 User Interface Features of Excel 2007 Self Test Creating and Modifying a Workbook Lesson Introduction Create a Workbook Lab: Setting up a Workbook Create and Rename a Worksheet in a Workbook Lab: Modifying a Workbook Customize a Workbook Self Test Modifying a Worksheet Lesson Introduction Modify Columns and Rows in a Worksheet Lab: Inserting and Modifying Columns and Rows Data Entry Options Lab: Entering a Data Series Self Test Editing Data in a Workbook Lesson Introduction List the Paste Options Available in Excel 2007 List the Find and Replace Dialog Box Controls Lab: Moving, Finding, and Replacing a Value in a Workbook Lab: Finding a Cell in the Workbook with a Particular Format Use the Dictionary and Thesaurus 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