Microsoft Excel 2002

Annual Subscription
Total Items: 7
Total Time: 22 hour(s)

 $82.00
Buy Now!
Microsoft Excel 2002

Summary:

This series is intended as preparation for the Excel 2002 Microsoft Office User Specialist (MOUS) Core Proficiency exam. It introduces Excel's newest enhancements such as task panes for New Documents, Clipboard, Search, and Insert Clip Art; the Ask a Question box; enhancements to Find and Replace; and additional options for pasting and for inserting columns and rows. These new features, along with the productivity tools of previous versions, are taught within the context of working with cells and files, page setup and printing, worksheets and workbooks, formulas and functions, and charts and objects.

 

Audience:

This series is for anyone preparing for the MOS Excel 2002 Core certification exam.

Features:

  • Simulations teach learners to perform specific tasks in applications through guided, multi-step exercises.
  • Activities allow learners to apply course concepts in an interactive questioning environment.
  • Exercises allow learners to practice in the actual application being studied.
  • Supplied sample files include sample documents, application files, programs, and programming code that enable learners to practice with these files, enhancing the learning experience.
  • A Course Topics list contains active hyperlinks, permitting quick access to specific topics.
  • Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, or in a dictionary. In addition, it lets them find other occurrences of the term in the same course.
  • Search text enables learners to rapidly search all text within a course to easily retrieve information required.
  • Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
  • A skill assessment generates a customized learning path based on the results of a pre-test.
  • A glossary provides a reference for definitions of unfamiliar terms.
  • Bookmarking tracks the learner's progress in a course.

Certification:

MOS

 

Includes:

(Click each bar below for more information)
Excel 2002: Working with Cells

Summary:

This course shows users how to enter and edit data in Excel 2002 worksheet cells and create hyperlinks.

Objectives:

  • Enter cell data including text, numbers, and formulas
  • Edit cell data
  • Insert, delete, and move cells
  • Find and replace cell data and formats
  • Create hyperlinks

Topics:

  • Entering Data
  • Editing a Cell
  • Editing Multiple Cells
  • Replacing Values and AutoFilling
  • Creating Hyperlinks

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.
Excel 2002: Working with Files

Summary:

This course shows users how to locate, open, and save files in Excel 2002.

Objectives:

  • Manage workbook files and folders
  • Create workbooks using templates
  • Save workbooks using different names and file formats
  • Convert worksheets to Web pages
  • View and edit comments

Topics:

  • Opening Files
  • Saving Files
  • Files and the Internet
  • Working with Comments
  • Using the Office Assistant

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.
Excel 2002: Formatting Worksheets

Summary:

This course shows users how to format and adjust cells, adjust rows and columns, and apply formatting and styles in an Excel 2002 worksheet.

Objectives:

  • Apply and modify cell formats
  • Modify row and column settings
  • Use automated tools to format worksheets
  • Apply styles

Topics:

  • Formatting Cells
  • Adjusting Cells
  • Formatting Numbers
  • Adjusting Rows and Columns
  • Using AutoFormatting and Styles

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.
Excel 2002: Page Setup and Printing

Summary:

This course shows users how to preview and print worksheets and workbooks, add headers, footers, and titles, and adjust page settings in Excel 2002 worksheets.

Objectives:

  • Preview and print worksheets and workbooks
  • Modify Page Setup options for worksheets

Topics:

  • Previewing
  • Printing
  • Page Setup
  • Headers, Footers, and Titles

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.
Excel 2002: Worksheets and Workbooks

Summary:

This course shows users how to work with worksheet rows and columns, move between worksheets in a workbook, consolidate data, change the zoom setting, and check spelling in Excel 2002 worksheets.

Objectives:

  • Modify row and column formats
  • Modify worksheet names and positions
  • Insert and delete worksheets
  • Use 3-D references
  • Check spelling
  • Work with a subset of data by filtering lists

Topics:

  • Working with Rows and Columns
  • Working with Worksheets
  • Linking Worksheets and Consolidating Data
  • Zooming and Spell-Checking
  • Using a Data Filter

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

Excel 2002: Formulas and Functions

Summary:

This course shows users how to work with formulas and functions in Excel 2002 worksheets.

Objectives:

  • Work with formulas
  • Use references and AutoSum
  • Enter Functions
  • Use basic and date functions
  • Use financial and logical functions

Topics:

  • Working with Formulas
  • Using References and AutoSum
  • Entering Functions
  • Using Basic and Date Functions
  • Using Financial and Logical Functions

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.
Excel 2002: Charts and Objects

Summary:

This course shows users how to create, modify, and print charts, insert, move and delete pictures, and draw lines and shapes in Excel 2002 worksheets.

Objectives:

  • Create, modify, position, and print charts
  • Create, modify, and position objects

Topics:

  • Creating Charts
  • Modifying and Printing Charts
  • Working with Objects
  • Drawing Lines and Shapes

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

 

 

 

Add to Cart

Microsoft Excel 2002

Annual Subscription
Total Items: 7
Total Time: 22 hour(s)

 $82.00
Quantity: