Microsoft Excel 2000 Tutorial

These Microsoft Excel 2000 tutorials are designed to help users prepare for the MOS Excel Core examination. The Microsoft Excel 2000 training series begins with basic Excel tasks tutorial, such as entering and editing data, using Find, Replace, and AutoFill, and creating hyperlinks. It also covers locating, opening, and saving files, and using the help function, Office Assistant. Formatting worksheets is covered in detail, including cell and number formatting, adjusting rows and columns, and the use of AutoFormat, styles, and Format Painter. More advanced topics covered include page setup, managing worksheets and data, and creating formulas and functions. An overview of charts and objects, including the Chart Wizard, is also provided.

Microsoft Excel Cells

Excel 2000 Files

Formatting Worksheets

Page Setup and Printing

Worksheets & Workbooks

Formulas and Functions

Charts and Objects

Importing and Exporting Data

Templates Links Report Manager

Formatting Sorting Filtering Data

Naming Ranges, Working with Macros, and Customizing Toolbars

Validating and Auditing Data

Analyzing Data and Using PivotTables

Sharing Work and Adding Security

These are self-paced, internet-based Microsoft Excel 2000 tutorials -- there are no books to purchase and no scheduled classes to attend.

The following Microsoft Excel 2000 courses are available online:

• Working with Cells shows how to enter and edit data in worksheet cells and how to create hyperlinks.
• Working with Files shows how to locate, open, and save files.
• Formatting Worksheets shows how to format and adjust cells, adjust rows and columns, and apply formatting and styles in an worksheet.
• Page Setup and Printing shows how to preview and print worksheets and workbooks; add headers, footers, and titles, and adjust page settings in worksheets.
• Worksheets & Workbooks shows how to work with worksheet rows and columns, manage worksheets, and consolidate data in worksheets.
• Formulas and Functions shows how to work with formulas and functions in worksheets.
• Charts and Objects shows how to create, modify, and print charts; insert, move and delete pictures, and draw lines and shapes in worksheets.
• Importing and Exporting Data shows users how to import data from other applications, query a database application to extract data, and export data to other applications.
• Working with Templates, Links, and Report Manager shows the user how to work with templates, link workbooks, and use Report Manager.
• Formatting, Sorting, and Filtering Data shows users how to format numeric data, create custom and conditional formats, sort and group data, use data forms for data entry and retrieval, and use filters to extract data.
• Naming Ranges, Working with Macros, and Customizing Toolbars shows users how to create and use named ranges, and how to use lookup functions. It also shows how to record, run, and edit a macro, as well as hide, display, and customize toolbars.
• Validating and Auditing Data shows users how to validate data, trace and fix errors, trace precedents for a formula, and trace dependents for a specific cell.
• Analyzing Data and Using PivotTables shows users how to use data analysis tools such as Goal Seek, Solver, and scenarios. It also shows how to use PivotTables and PivotCharts.
• Sharing Work and Adding Security shows users how to work with cell comments, apply workbook protection, and share and merge workbooks.

Sign up for our courses right now