Excel 2007 Level 1 Introduction

1 day

Overview

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.

Course Objective

You will create and edit basic Microsoft® Office Excel® 2007 worksheets and workbooks.

Target student

This course is designed for people who desire to gain the skills necessary to create, edit, format, and print basic Microsoft Office Excel 2007 worksheets.

Prerequisites

Windows Introduction or equivalent knowledge.

Creating a Basic Worksheet

Explore the User Interface and the Ribbon
Navigate and Select in Excel
Obtain Help
Enter Data and Save a Workbook
Customize the Quick Access Toolbar

Performing Calculations

Create Basic Formulas
Calculate with Functions
Copy Formulas and Functions

Modifying a Worksheet

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

Formatting a Worksheet

Modify Fonts
Add Borders and Color to Cells
Change Column Width and Row Height
Apply Number Formats
Position Cell Contents
Apply Cell Styles

Printing Workbook Contents

Print Workbook Contents Using Default Print Options
Set Print Options
Set Page Breaks

Managing Large Workbooks

Format Worksheet Tabs
Manage Worksheets in a Workbook