Microsoft Excel 2000 MOS Expert

Topics: 7

Length: 22 hours

Location: Online

This online Excel tutorial is designed to help you prepare for the MOS Excel 2000 Expert exam. You will learn expert-level Excel topics such as exporting and importing data, linking workbooks, working with templates, and using the Report Manager. You will also learn advanced worksheet formatting, including sorting and filtering data, and page setup and printing.

Excel 2000 MOS Expert: 1 Importing and Exporting Data

This tutorial shows users how to export data from Excel to other applications, query a database application, and import data from other applications into Excel.

Excel 2000 MOS Expert: 2 Working with Templates, Links, and Report Manager

This chapter shows users how to create, apply, and modify templates; link workbooks; use a workspace; print and preview worksheets; and use the Report Manager.

Excel 2000 MOS Expert: 3 Formatting, Sorting, and Filtering Data

This course shows users how to format numbers, create custom and conditional formats, group and sort data, use data forms for data input and retrieval, and use filters.

Excel 2000 MOS Expert: 4 Naming Ranges, Working with Macros, and Customizing Toolbars

This online course shows you how to create and delete a named range and use it in a formula; use the VLOOKUP and HLOOKUP functions; record, edit, and run a macro, assign a macro to a toolbar; and display, hide, and customize toolbars.

Excel 2000 MOS Expert: 5 Validating and Auditing Data

This topic will show you how validate data, trace and correct errors, find precedents for a formula, and get dependents for a specific cell.

Excel 2000 MOS Expert: 6 Analyzing Data and Using PivotTables

This chapter shows you how to use analysis tools such as Solver, Goal Seek, and Scenarios, and PivotCharts and PivotTables.

Excel 2000 MOS Expert: 7 Sharing Work and Adding Security

This tutorial shows you how to add comments, change workbook properties, apply and delete worksheet protection and file passwords, create a shared workbook, track changes, and merge workbooks.