Microsoft Excel 2007 Introduction

Target Audience

This course is for delegates who desire to gain the skills necessary to create, edit, format, and print basic Excel 2007 workbooks.

Prerequisites

Delegates must have a working knowledge of a Microsoft Windows operating system and have keyboard and mouse skills.

Introduction to Microsoft Excel

• What Is Excel?

• Excel File Types

• Excel Environment

• Toolbars

• Office Help

Workbooks and Worksheets

• Creating And Opening Workbooks

• Working With Workbooks

• Working With Worksheets

• Working With Cells

• Navigating Within A Worksheet

• Navigating The Workbook

Spreadsheet Data

• Entering Data

• Using Time Saving Features

• Checking The Spelling

Formatting and Customising Data

• Selecting Items In Excel

• Formatting Text

• Formatting Numbers

• Manipulating Data

• Formatting Columns And Rows

• Formatting With Colours And Patterns

• Adding And Editing Borders

• Using Autoformat

Editing Spreadsheets

• Cutting, Copying, And Pasting

• Inserting And Deleting

• Using Find And Replace

• Using Undo And Redo

Formulas and Functions

• Entering Formulas

• Entering Functions

• Using Named Cells And Ranges In Formulas

Printing

• Using Page Setup

• Printing a Spreadsheet

Drawing And Picture Objects

• Drawing Toolbar

• Working With Autoshapes

• Creating Text Boxes

• Adding Pictures

• Layering Objects

• Grouping And Ungrouping Objects