COURSE SEARCH
 
   HOME > COURSES > MICROSOFT EXCEL 2002 (XP) INTRODUCTION MEMBERS LOGIN 
UNLIMITED ACCESS TO OVER 575 ONLINE TRAINING COURSES FOR ONE ANNUAL PAYMENT OF ONLY $149 USD
BUY NOW
  HOME     COURSE LIBRARY     QUESTIONS & ANSWERS     CONTACT US
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.

This course can be found in the following categories:
Courses > Microsoft > Office XP
Courses > Microsoft > Excel
Courses > MOS

Table of Contents
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
  		• Revise a formula
  		• Use Insert Function
  		• 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)
  		• 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 color 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
  		• Glossary
    TRY BEFORE YOU BUY BECOME A RESELLER TERMS & PRIVACY
    Monday 15th March 2010  © COPYRIGHT 2010 - VISUALSOFT