Getting started with Excel 2007: Course 5425

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.

This course is 1 hour long.

Objectives:

At the end of this course, students will be able to:

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

System Requirements:

Pentium II 400 MHz;
256MB RAM;
Microsoft Internet Explorer 6.0 or higher;
256k connection (broadband recommended);
Windows XP, 2000 or higher;
Flash Player 7.0 or higher;
Speakers and soundcard.

Subscription: 1 year

You will need Excel 2007 installed on your machine to use some of the local labs in this course.

Course 5425: Getting Started with Microsoft® Office Excel® 2007

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