Microsoft Office Excel 2007: Level 1

Course Description

You have basic computer skills such as using a mouse, navigating through windows, and surfing the Internet. You have also used paper-based systems to store data that you run calculations on. You now want to migrate that data to an electronic format. In this course, you will use Microsoft® Office Excel® 2007 to manage, edit, and print data.
1 days


To effectively understand this course, we recommend that you take the Microsoft Office Windows XP Introduction course or have equivalent knowledge.

Exploring the Excel Environment

Explore the User Interface
Explore the Ribbon
Obtain Help
Customize the Quick Access Toolbar

Working with an Excel Worksheet

Navigate in Excel
Select and Enter Data
Save a Workbook

Modifying a Worksheet

Manipulate Data
Insert and Delete Cells, Columns, and Rows
Search for Data in a Worksheet
Spell Check a Worksheet

Performing Calculations

Create Basic Formulas
Calculate with Functions
Copy Formulas and Functions
Create a Mixed Reference

Formatting a Worksheet

Convert Text to Columns
Modify Fonts
Add Borders and Color to Cells
Change Column Width and Row Height
Merge Cells
Apply Number Formats
Align Cell Contents
Find and Replace Formats
Apply AutoFormat
Apply Cell Styles
Apply Themes

Developing a Workbook

Format Worksheet Tabs
Reposition Worksheets in a Workbook
Insert and Delete Worksheets
Copy and Paste Worksheets

Printing Workbook Contents

Set Print Titles
Create a Header and a Footer
Set Page Margins
Change Page Orientation
Set Page Breaks
Print a Range

Customizing Layout

Split a Worksheet
Arrange Windows
Freeze and Unfreeze Rows and Columns
Hide and Unhide Worksheets

Excel 2007Microsoft Excel 2007