Everything Desktop Training

Our curriculum combines proven instructional design techniques, realistic simulation and unparalleled interactivity with challenges, tests and feedback. Master the world's leading productivity tools today

Microsoft Excel 2002 Training

Microsoft Excel 2002 Training provides core skills necessary to effectively use Excel 2002. Learn how to create and format spreadsheets and use charts and functions with Microsoft's powerful spreadsheet program. Excel 2002 training is excellent preparation for the Microsoft Office User Specialist (MOUS) certification exam.

Microsoft Excel 2002 Training covers topics such as

Working with cells
Working with charts and graphics
Formatting and linking worksheets
Inserting and copying cells
Page setup and printing
Working with worksheets and workbooks
Working with functions and creating formulas

Unlock the world's leading spreadsheet application, Microsoft Excel 2002. Our in-depth, easy-to-follow courses lead you through common tasks using a clear, step-by-step approach. Microsoft Excel 2002 Training takes the guesswork out of using Excel 2002.

Learn exactly what you need to know with our interactive multimedia courseware. Our animations and simulations teach fundamental techniques and let you apply what you have learned in a realistic application environment. Microsoft Excel 2002 prepares you for the Microsoft Office User Specialist (MOUS) certification exam.

Microsoft Excel 2002 Training includes both basic and advanced Excel 2002 courses.
Course Objectives
After completing these Learning Objects, the learner will be able to perform tasks such as:
» Creating and saving workbooks
» Formatting numbers and worksheets
» Working with cell data, rows and columns
» Creating formulas and using functions
» Collaborating in workgroups
Media Selection
Contextual Simulations: 51 Audio: Yes
Graphics display the user interface and key concepts
Rollovers let users interact with and view supplemental information
Animations illustrate processes
Advanced simulation technology allows users to practice skills and gauge their proficiency
Course Description
Excel 2002 Core Training will provide the learner with the core skills necessary to efficiently use
Excel 2002, Microsoft's popular spreadsheet program. It is also excellent preparation for the
Microsoft Office User Specialist (MOUS) certification exam.
Audience Definition
Designed for learners who currently use or are beginning to use Microsoft Excel 2002.
Prerequisites
Familiarity with the Microsoft Windows environment, and ability to use a keyboard and mouse.
Estimated Length
Each Learning Object is approximately 15-20 minutes in duration with a total
approximate time of 5.5 hours.
Course Outline
Getting Started
Opening and Editing Workbooks
Creating and Saving Workbooks
Inserting, Deleting, and Moving Cells
Formatting Numbers
Formatting Worksheets
Working with Cell Data
Working with Rows and Columns
Setting Up Pages for Printing
Printing Worksheets
Working with Worksheets
Managing Lists
Creating Formulas
Using Functions
Linking Worksheets
Working with Charts and Graphics
Creating Web Pages and Sending E-mail
Collaborating in Workgroups

Assessment Description
Pre-assessment Challenge
(3-4 standard questions and a performance-based simulation)
Lesson Review
(2 standard questions)
Final Test
(3-4 standard questions and a performance-based simulation)
Detailed Course Outline and Objectives
The following learning objectives cover the Microsoft Office User Specialist (MOUS) requirements.
Getting Started
» Launch and exit Excel
» Identify components of Excel's user interface
» Understand worksheets and workbooks
» Use Excel Help
Opening and Editing Workbooks
» Locate and open existing workbooks
» Enter and edit text and numbers
» Clear cell content
Creating and Saving Workbooks
» Create folders for workbook storage
» Use Save As to change the name, location, or format of a workbook
» Create a workbook from a template
Inserting, Deleting, and Moving Cells
» Insert and delete cells
» Merge and split cells
» Move or copy cells
Formatting Numbers
» Apply number formats
» Adjust the decimal places
» Modify the alignment of cell content
Formatting Worksheets
» Format cells
» Create and apply a style
» Apply AutoFormats to worksheets
Working with Cell Data
» Find and replace cell data
» Find and replace cell formats
» Go to a specific cell
Working with Rows and Columns
» Modify row height and column width
» Insert and delete, and hide and unhide rows and columns
» Freeze and unfreeze rows and columns
Setting Up Pages for Printing
» Insert and remove a page break
» Modify worksheet orientation and paper size
» Set margins, headers and footers, and rows and columns to repeat
Printing Worksheets
» Check spelling on a worksheet
» Set a print area
» Preview and print selections of worksheet cells
Working with Worksheets
» Insert and rename worksheets
» Delete worksheets
» Move and copy worksheets
» Add color to your worksheet tabs
Managing Lists
» Sort data in a list
» Use AutoFilter to find values in a list
» Use data forms to assist data entry
Creating Formulas
» Create and edit formulas using the Formula Bar
» Enter a range within a formula by dragging
» Use absolute and relative references
Using Functions
» Create a formula that contains a function
» Use basic functions such as Sum, Min, and Max
» Use date and time functions, financial functions, and logical functions
Linking Worksheets
» Link worksheets using 3D references in formulas
» Create and edit hyperlinks
Working with Charts and Graphics
» Create charts
» Modify charts
» Insert graphics
Creating Web Pages and Sending E-mail
» Save worksheets as Web pages
» Use Web Page Preview
» Send a workbook or worksheet via e-mail
Collaborating in Workgroups
» Add and edit comments attached to worksheet cells
» Create and respond to discussion comments