|
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
|
|
 |
|
-
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
-
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
-
Entering Data
Types of Data
Defining Text Constants
Defining Number Constants
Defining Formulas
Validating an Entry
AutoComplete Feature
Multi-Line Text
-
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
-
Opening a Workbook
Opening a Workbook
Displaying a Recently Opened Workbook
Locating a Workbook
Performing an Advanced Search
|
-
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
-
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
-
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
-
Correction Tools
Checking Spelling
The Auto Correct Feature
Creating an Auto Correct Entry
Editing/Deleting an Auto Correct Entry
-
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.
|