Introduction

Getting Started

·         What is Excel?

·         Starting Excel

·         The Excel Application Window

·         Using the Excel Menu System

·         Using the Microsoft Office Button

·         Using the Quick Access Toolbar

·         Displaying Help Information

·         Exiting from Excel

 

Modifying an Existing Worksheet

·         Resetting the Working Folder

·         Moving the Cell Pointer

·         Changing Data in a Worksheet

·         Reversing an Edit Operation

·         Saving a Workbook

·         Adding Data to a Worksheet

·         Entering a Formula into a Worksheet

·         Adjusting Column Width in a Worksheet

·         Adjusting Row Height in a Worksheet

·         Printing a Worksheet

 

Building a New Worksheet

·       Opening a New Workbook

·       Using Spelling Checker

 

Editing a Worksheet

·       Working in Edit Mode

·       Selecting Ranges in a Worksheet

·       Using AutoFill

·       Copying Cells

·       Moving Cells

·       Clearing Cells

·       Using AutoSum

·       Inserting and Deleting Rows and Columns

·       Inserting and Deleting a Range of Cells

 

Formatting a Worksheet

·       Resetting the Alignment of Cell Entries

·       Resetting Font Options for Cell Entries

·       Resetting the Number Format and of Cell Entries

·       Adding Borders and Shading to a Worksheet

·       Using AutoFormat

 

Enhancing a Worksheet Printout

·         Changing the Page Setup for a Worksheet

·         Previewing a Worksheet

·         Inserting a Manual Page Break into a Worksheet

·         Printing Titles in a Printout

 

Using Excel Functions

·       What is a Function?

·       Using the SUM Function

·       Using the AVERAGE Function

·       Using the MAX and MIN Functions

·       Using the COUNT Function

·       Using the Insert Function Button

 

Final Case Study