EXCEL 2000 FUNDAMENTALS

COURSE OUTLINE

SECTION 1 - INTRODUCTION

· STARTING EXCEL

· THE APPLICATION WINDOW

· WORKING WITH MENUS

· WORKING WITH TOOLBARS

· THE WORKBOOK WINDOW

· SELECTING AREAS WITHIN A SHEET

SECTION 2 - CREATING WORKBOOKS AND ENTERING DATA

· ENTERING DATA INTO A CELL

· AUTOCOMPLETE

· EDITING A CELL

· CLOSING A WORKBOOK

· STARTING A NEW WORKBOOK

· BUILT-IN FUNCTIONS

· AUTO CALCULATE

· USING THE FORMULA PALETTE AND PASTE FUNCTION

· USING THE RANGE FINDER

· SAVING A WORKBOOK

· OPENING A WORKBOOK

SECTION 3 - EDITING AND FORMATTING THE WORKBOOK

· SUMMING WITH THE TOOL BAR

· USING FILL COMMANDS

· COPYING AND PASTING CELLS

· ABOUT COLLECTING AND PASTING MULTIPLE ITEMS

· COLLECTING AND PASTING MULTIPLE ITEMS

· PASTING SPECIFIC ITEMS FROM THE OFFICE CLIPBOARD

· INSERTING ROWS AND COLUMNS

· DELETING ROWS/COLUMNS

· AUTOFILL

· MOVING ENTRIES

· CLEARING CELLS

· UNDO/REDO

· FORMATTING A WORKBOOK

· FORMATTING NUMBERS

· COLUMN WIDTHS

· FONTS & FONT STYLES

· USING BORDERS

· USING PATTERNS

SECTION 4 - ABSOLUTE REFERENCING

· ABSOLUTE VS. RELATIVE REFERENCING

SECTION 5 - PRINTING

· PRINTING IN EXCEL

· PRINT SETTINGS

· PAGE SETUP DIALOG BOX

· PREVIEWING THE PRINTOUT

· HEADERS AND FOOTERS

· SETTING PRINT TITLES & PRINT AREAS

· PAGE BREAK PREVIEW

SECTION 6 - CHARTING WITH CHARTWIZARD

· CHARTWIZARD

· DIALOG BOX COMMAND BUTTONS

ACTION

· MODIFYING THE CHART

Course Length: 1 day

Prerequisites: Windows 2000