Training for
Microsoft Excel 2002 - Module 1

It is our objective to provide you with a complete learning experience. This online course is designed to teach the skills required to effectively use the application. Our courseware, with its high level of interactivity, essentially simulates a classroom environment, and follows four fundamental principles of professional instruction: explanation, demonstration, practice, and evaluation.
 

Basic knowledge of Windows

Become familiar with the main concepts required to work effectively in Excel 2002


 

3 - 4 hours

 
 
  1. Exploring the Excel 2002 Screen
    Opening Excel 2002
    Exploring the Work Window
    Making Excel 2002 an Active Resource
    Using the Menu Bar
    Menus and Toolbars - Changing the Display Settings
    Exploring the Excel 2002 Toolbars
    Closing Excel 2002

  2. Getting Help in Excel 2002
    The 'What's This?' Feature
    The Office Assistant
    Using the 'Ask a Question' Box
    Hiding/Showing the Office Assistant
    The 'Microsoft Excel Help' Box
    Showing the Office Assistant
    Accessing the Microsoft Office Web Site

  3. Entering Data
    Types of Data
    Defining Text Constants
    Defining Number Constants
    Defining Formulas
    Validating an Entry
    AutoComplete Feature
    Multi-Line Text

  4. Creating and Saving a Workbook
    The 'Save As' Dialog Box
    Creating a Folder
    Naming a Workbook
    Saving a Document Under Another Name
    Opening a Blank Workbook

  5. Opening a Workbook
    Opening a Workbook
    Displaying a Recently Opened Workbook
    Locating a Workbook
    Performing an Advanced Search

  1. Moving Around on a Worksheet
    Using the Keyboard to Move Around
    Moving to the Last Column
    Moving to the Beginning of a Row
    Moving to Cell 'A1'
    Moving to the End of a Table
    Displaying the Next/Previous Screen
    Going to a Specific Cell
    Using the Mouse to Move Around

  2. Selecting Items
    Selecting a Range of Adjacent Cells
    Modifying a Selection
    Selecting Columns
    Selecting Rows
    Selecting Non-Adjacent Cells
    Selecting an Entire Sheet
    Selecting a Table

  3. Editing Cell Content
    Deleting a Cell's Content
    Reversing an Action
    Redoing an Action
    Using the Double-Click Technique for Editing
    Using the Formula Bar to Edit Cell Content
    Using the 'F2' Key to Edit Cell Content

  4. Correction Tools
    Checking Spelling
    The Auto Correct Feature
    Creating an Auto Correct Entry
    Editing/Deleting an Auto Correct Entry

  5. Printing a Worksheet
    Previewing a Workbook
    Using the 'Print' Toolbar Button
    The 'Print' Dialog Box
    Printing a Specific Page

 

Our courses are accessible from any computer with an Internet connection. Once learners have entered their personal identification information, the courses accessible to them are listed. A pre-course skills assessment is used to set up a customized instructional plan for the selected course. Each lesson includes a theoretical evaluation. A comprehensive post-course test is also accessible independently. A central folder groups the grades a learner has obtained in a course and offers an overview of training progress. A glossary, online help and other tools can be accessed at all times throughout a training session.

 

• No installation required
• IBM PC compatible, Pentium 133 MHz or more
• Video card that supports 800x600 or greater monitor resolution, and 16-bit color
• 32 MB RAM (more recommended)
• Microsoft compatible mouse

• Sound card, speakers or headphones
• Operating system: Windows 95, 98, 2000, NT 4.0, or more recent
• Netscape 4.5 or Internet Explorer 4.0 (or more recent)
• Modem (56 K or more)
• Internet connection
• AICC/SCORM Compliant
 

EDU-PERFORMANCE CANADA
7900 Taschereau Blvd. W.
Suite A-207
Brossard, Quebec J4X 1C2
Canada
Tel.: (450) 466-7275
Fax: (450) 466-4915
Toll free: 1-888-EDU-PERF
              1-888-338-7373
E-mail: info@eduperformance.com
Web site: www.eduperformance.com

EDU-PERFORMANCE EUROPE



International number: 1-450-466-7275
E-mail: infoepe@eduperformance.com
   

 

© 2006 Edu-Performance Canada Inc. All rights reserved. Duplication prohibited. All products and product names mentioned in this publication are trademarks or registered trademarks of their respective holders.