Microsoft Office Excel 2007 Level 1

DSOC0271—One Day Training Class

Elements of this syllabus are subject to change.

Overview

This course takes the student through the fundamentals of creating and working with workbooks, using formulas and basic functions, applying formatting and setting printing options. This course will introduce absolute references, three-dimensional formulas and the Insert Function tool.

Audience

This course is designed for students who are not new to computers but have limited Excel skills, if any. Those who use Excel primarily for data entry will benefit as will those who have never used the product.

Prerequisites

Before taking this course, the student should be familiar with working with Windows and be comfortable using a mouse. The student should have at least minimal typing skills (be able to find keys without much delay).

At Course Completion

After completing this course, students will be able to:

• Work with the interface
• Customize the Quick Access toolbar
• Understand the importance of the Formula bar
• Create basic spreadsheets
• Build formulas using operators and using Excel’s build-in functions
• Navigate in Excel
• Change the structure of a worksheet
• Move and copy data
• Copy formulas
• Create three-dimensional formulas
• Format text, dates and numbers
• Print a wide worksheet
• Print portions of a worksheet

Training Course Content

Module 1: The Microsoft Office Excel 2007 Interface

After completing this module, you will be familiar with the Microsoft Office 2007 interface, workbooks and worksheets. You will learn to customize a toolbar and the status bar.

• The Excel 2007 Environment
• The Microsoft Office Button
• The Ribbon
• The Quick Access Toolbar
• Formula bar
• Name box
• Sheet Tabs
• The Mini Toolbar
• Excel 2007 Status Bar and Views

Module 2: Creating a Spreadsheet and Entering Data

After completing this module, you will understand the primary benefits of an electronic spreadsheet. You will recognize the steps necessary for creating a spreadsheet, have the ability to enter and correct data, create simple formulas, and follow the order of operations. You will be aware of the importance of the Formula bar.

• The Benefits of an Electronic Spreadsheet
• Suggested High-Level Steps for Creating a Spreadsheet
• Entering Data
• Saving Files
• Formulas

Module 3: Navigating in a Worksheet

After completing this module, you will be able to navigate a workbook. You will be able to lock rows to the top (or columns to the left) of a worksheet so they don’t scroll. You will be able to edit cells using the keyboard and the mouse.

• Changing Which Cell is Active
• Viewing a Worksheet

Module 4: Ranges and Functions

After completing this module, you will be able to select a range of cells on a worksheet. You will be able to create formulas using Excel’s built-in functions.

• Ranges
• Functions

Module 5: Moving and Copying Data

After completing this module, you will be able to move data, copy data, and create formulas that contain references that do not change when copied. You will use the Fill handle to fill in a series of numbers, text, and dates.

• Inserting and Deleting Cells, Columns and Rows
• Methods for Moving Data
• Methods for Copying Data
• Creating Formulas That Don’t Change When Copied
• Using the Fill Series Feature

Module 6: Working with Multiple Worksheets

After completing this module, you will be able to rename worksheets, insert and delete worksheets, and move and copy worksheets. You will also create formulas that reference cells on other worksheets.

• Changing the Workbook Structure
• Creating Formulas that Refer to Cells on Other Worksheets

Module 7: Formatting a Worksheet

After completing this module, you will be able to format text, dates, and numbers. You will be able to remove formatting. You will be able to format using cell styles and you will be able to modify cell styles.

• Formatting Changes Appearances
• Changing the Fonts, Fills, Borders and Alignments
• Formatting Numbers
• Resizing Rows and Columns
• Hiding and Unhiding Columns and Rows
• Format Painter
• Cell Styles
• Themes

Module 8: Printing a Worksheet

After completing this module, you will be able to print a wide worksheet, cause rows to repeat at the top of each page, create headers and footers, print a portion of a worksheet, and set a default print area. You will be able to set manual page breaks.

• Print Preview
• Page Layout View
• Page Break Preview
• Printing a Wide Worksheet
• Headers and Footers
• Page Breaks
• Print Titles
• Print a Portion of the Worksheet