 |
|
There are many excellent online courses. This has been hugely beneficial in my day to day work.
|
|
- Louise Nolan
|
|
|
|
|
Microsoft Excel 2002 (XP) Introduction
Course Aims
MS Excel 2002 (XP) is the latest version of the popular spreadsheet from Microsoft, designed for the networked office environment. This course is designed to let users get to grips with the main features of Excel and realise the advantages of using a powerful electronic spreadsheet. This course teaches you how to create, format and print a spreadsheet incorporating basic formulae and functions using the application MS Excel 2002 (XP). |
Assumed Knowledge
A basic understanding of using PCs, a keyboard and a mouse, plus knowledge of MS Windows 95/98 is required, gained either by previous experience or by reading our "MS Windows 95/98 User Introduction" course. |
Course Audience
New or intending users of MS Excel 2002 (XP) who want to gain a good understanding of how to use the software in a short space of time. |
|
Table of Contents
|
Getting Started with Excel 2002
|
Identify the different elements of the Excel screen
|
|
Display and select items from menus and toolbars
|
|
|
|
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
|
Move around the worksheet using the mouse and keyboard
|
|
Select cells using the mouse and the keyboard
|
|
Enter text, values and dates in cells
|
|
Work with series of data and custom lists
|
|
Work with AutoFill smart tag
|
|
Save an AutoRecover file automatically
|
|
Recover a workbook if Excel stops working
|
|
Locate and open an existing workbook
|
|
|
|
Editing a Worksheet
|
Go To a specific cell or named range
|
|
Move, copy and paste cells using the Windows or Office Clipboard
|
|
|
|
Creating a Formula
|
Understand what a formula is and how to create simple calculations
|
|
Enter a formula by typing or by using the Formula bar
|
|
Enter a range within a formula
|
|
Use basic functions (AVERAGE, SUM, COUNT, MIN, MAX)
|
|
Use relative and absolute cell references
|
|
Recognize common error messages
|
|
|
Formatting a Worksheet
|
Apply font styles (typeface, size, color and styles)
|
|
Modify the alignment and orientation of cell contents
|
|
Merge and unmerge cells (to center headings across columns)
|
|
Apply value formats (currency, percent, dates and comma)
|
|
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
|
|
Change the color of a worksheet tab
|
|
|
|
Printing a Worksheet
|
Preview and print a worksheet
|
|
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
|
|
|
|
|
