Excel 2002 Introduction

This course is designed to let users get to grips with the main features of Excel 2002 and realize the advantages of using a powerful electronic spreadsheet. The course is entirely 'hands on', so those attending will get practice in creating and modifying actual spreadsheets.

Target audience

New or intending users of Excel 2002 who want to gain a good understanding of how to use the software in a short space of time. A basic understanding of PCs and familiarity with the layout of a PC style keyboard, mouse and Windows is required, gained either by previous experience or by attendance on a "PC Fundamentals" course.

Course content

Getting Started with Excel 2002 Start an Excel session • Identify the different elements of the Excel screen • Display and select items from menus and toolbars • Exit Excel

Getting Assistance with Excel 2002 Use the Office Assistant to get help • Use the Contents, Answer Wizard and Index to get help • Manipulate the Help window • Use the Ask a Question box • Display What's this? help

Creating a Workbook Create a new workbook • Move around the worksheet using the mouse and keyboard • Select cells using the mouse and the keyboard • Enter text, values and dates in cells • Edit cell contents, Use Undo and Redo • Work with series of data and custom lists • Work with AutoFill smart tag • Use Save and Save As • Save an AutoRecover file automatically • Recover a workbook if Excel stops working • Locate and open an existing workbook • Create a folder

Editing a Worksheet Go To a specific cell or named range • Move, copy and paste cells using the Windows or Office Clipboard • Use Find and Replace

Creating a Formula Understand what a formula is and how to create simple calculations • Use AutoSum • Enter a formula by typing or by using the Formula bar • Enter a range within a formula using the mouse • Revise a formula, Use Insert Function • Use basic functions (AVERAGE, SUM, COUNT, MIN, MAX) • Use relative and absolute cell references • Recognise common error messages

Formatting a Worksheet Apply font styles (typeface, size, colour and styles) • Modify the alignment and orientation of cell contents • Merge and unmerge cells (to centre headings across columns) • Apply value formats (currency, percent, dates and comma) • Adjust the decimal place • Modify the size of columns and rows • Clear cell content and formats

Working with Worksheets Insert and delete rows and columns • Insert and delete selected cells • Insert and delete worksheets • Move and copy a worksheet • Rename a worksheet • Change the colour of a worksheet tab

Printing a Worksheet Preview and print a worksheet • Print a selection • Change page orientation and scaling • Set page margins and centring • Setup headers and footers • Set, print and clear a print area • Insert and remove a page break • Print column and row titles and set other options

Glossary

Index

About Courseware Company:: Instructor-led training courseware :: Self-study solutions :: Buy online today