Excel 2002
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.
Working with Cells
This course shows users how to enter and edit data in Excel 2002 worksheet cells and create hyperlinks and 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.
Working with Files
This course shows users how to locate, open, and save files in Excel 2002 and 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.
Formatting Worksheets
This course shows users how to format and adjust cells, adjust rows and columns, and apply formatting and styles in an Excel 2002 worksheet and teaches you how to apply and modify cell formats, modify row and column settings, use automated tools to format worksheets, and apply styles.
Page Setup and Printing
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 and teaches you how to preview and print worksheets and workbooks, and modify Page Setup options for worksheets.
Worksheets and Workbooks
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 and 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.
Formulas and Functions
This course shows users how to work with formulas and functions in Excel 2002 worksheets and teaches you how to work with formulas, use references and AutoSum, enter Functions, use basic and date functions, and use financial and logical functions.
Charts and 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 and teaches you how to create, modify, position, and print charts, and create, modify, and position objects.