Excel 2002 - Online Course

This series is intended as preparation for the Excel 2002 Microsoft Office Specialist (MOS) 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.

This series is for anyone preparing for the MOS Excel 2002 Core certification exam. This online course contains 7 lessons and should take approximately 22 hours to complete.

Lesson 1: Working with Cells (4.0) hours

Working with Cells teaches you how to enter cell data including text, numbers, and formulas, edit cell data, insert, delete, and move cells, find and replace cell data and formats, and create hyperlinks. This course shows users how to enter and edit data in Excel 2002 worksheet cells and create hyperlinks. Topics include Entering Data, Editing a Cell, Editing Multiple Cells, Replacing Values and AutoFilling, and Creating Hyperlinks.

Lesson 2: Working with Files (3.0) hours

Working with Files teaches you how to manage workbook files and folders, create workbooks using templates, save workbooks using different names and file formats, convert worksheets to Web pages, and view and edit comments. This course shows users how to locate, open, and save files in Excel 2002. Topics include Opening Files, Saving Files, Files and the Internet, Working with Comments, and Using the Office Assistant.

Lesson 3: Formatting Worksheets (4.0) hours

Formatting Worksheets teaches you how to apply and modify cell formats, modify row and column settings, use automated tools to format worksheets, and apply styles. This course shows users how to format and adjust cells, adjust rows and columns, and apply formatting and styles in an Excel 2002 worksheet. Topics include Formatting Cells, Adjusting Cells, Formatting Numbers, Adjusting Rows and Columns, and Using AutoFormatting and Styles.

Lesson 4: Page Setup and Printing (2.0) hours

Page Setup and Printing teaches you how to preview and print worksheets and workbooks, and modify Page Setup options for worksheets. 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. Topics include Previewing, Printing, Page Setup, and Headers, Footers, and Titles.

Lesson 5: Worksheets and Workbooks (4.0) hours

Worksheets and Workbooks teaches you how to modify row and column formats, modify worksheet names and positions, insert and delete worksheets, use 3-D references, check spelling, and work with a subset of data by filtering lists. 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. Topics include Working with Rows and Columns, Working with Worksheets, Linking Worksheets and Consolidating Data, Zooming and Spell-Checking, and Using a Data Filter.

Lesson 6: Formulas and Functions (3.0) hours

Formulas and Functions teaches you how to work with formulas, use references and AutoSum, enter Functions, use basic and date functions, and use financial and logical functions. This course shows users how to work with formulas and functions in Excel 2002 worksheets. Topics include Working with Formulas, Using References and AutoSum, Entering Functions, Using Basic and Date Functions, and Using Financial and Logical Functions.

Lesson 7: Charts and Objects (2.0) hours

Charts and Objects teaches you how to create, modify, position, and print charts, and create, modify, and position objects. 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. Topics include Creating Charts, Modifying and Printing Charts, Working with Objects, and Drawing Lines and Shapes.