Course Outline

Excel 2003/2007/2010: Introduction

Days: 1

Prerequisites: Windows Introduction or equivalent experience.

Unit 1 : Excel Basics

· Spreadsheet terminology

· Exploring the Excel window

· Opening and navigating a workbook

· Closing a workbook

Unit 2 : Entering and editing data

· Creating a new Excel workbook

· Entering and editing labels and values

· Entering and editing formulas

· Saving and updating a workbook

Unit 3 : Modifying a worksheet

· Moving a copying data

· Moving and copying formulas

· Using absolute references

· Inserting and deleting ranges

Unit 4 : Using functions

· Entering functions

· Using AutoSum

· Using AVERAGE, MIN, MAX, and COUNT

Unit 5 : Formatting worksheets

· Formatting text

· Formatting rows and columns

· Number formatting

· Other formatting features

Unit 6 : Printing

· Preparing to print

· Page Setup options

· Printing

Unit 7 : Creating charts

· Creating a chart

· Modifying charts

· Printing charts

Unit 8 : Web features

· Saving a worksheet as a Web page

· Adding hyperlinks

· Sending a workbook via email