Excel 2000 MOS Expert - Online Course

This series is designed to help users prepare for the MOS Excel 2000 Expert examination. It covers expert-level Excel topics such as importing and exporting data, working with templates, linking workbooks, and using the Report Manager. It also covers advanced worksheet formatting, including page setup and printing, and sorting and filtering data. More advanced topics covered include ranges, macros and customization, validating and auditing data, and creating and using charts, graphs, and pivot tables. Data analysis, file sharing, and security issues are also discussed.

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

Lesson 1: Importing and Exporting Data (4.0) hours

Importing and Exporting Data teaches you how to import data from a text file, import data from an application, import a table from an HTML file, query a database, and export data to an application. This course shows users how to import data from Excel to other applications, query a database application to extract data, and export data from other applications into Excel. Topics include Importing Data Using the Text Import Wizard, Importing Text by Other Methods, Importing Data from an Application or File, Querying a Database, and Exporting Data to an Application.

Lesson 2: Working with Templates, Links, and Report Manager (2.0) hours

Working with Templates, Links, and Report Manager teaches you how to create a template, apply a template to a workbook, edit a template, use a workspace, link workbooks, preview worksheets, print worksheets, and use the Report Manager. This course shows users how to create, apply, and edit templates; use a workspace; link workbooks; preview and print worksheets; and use the Report Manager. Topics include Working with Templates, Using a Workspace and Linking Workbooks, and Previewing, Printing, and Report Manager.

Lesson 3: Formatting, Sorting, and Filtering Data (3.0) hours

Formatting, Sorting, and Filtering Data teaches you how to apply accounting, currency, and number formats to data, create a custom number format, use and apply conditional formatting, sort data, generate subtotals, group and outline data, use a data form for data entry and retrieval, create a data filter, and extract data. This course 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. Topics include Formatting Numbers, Using and Applying Conditional Formats, Sorting and Grouping Data, Using a Data Form, and Using a Data Filter.

Lesson 4: Naming Ranges, Working with Macros, and Customizing Toolbars (5.0) hours

Naming Ranges, Working with Macros, and Customizing Toolbars teaches you how to add and delete a named range, use a named range in a formula, use lookup functions (HLOOKUP and VLOOKUP), record a macro, run a macro, edit a macro, assign a macro to a toolbar button, hide and display toolbars, and customize a toolbar. This course shows users how to add and delete a named range and use a named range in a formula; use the HLOOKUP and VLOOKUP functions; record, run, and edit a macro, assign a macro to a toolbar button; and hide, display, and customize toolbars. Topics include Adding, Using and Deleting a Named Range, Using Lookup Functions, Recording and Running a Macro, Editing a Macro, and Working with Toolbars.

Lesson 5: Validating and Auditing Data (2.0) hours

Validating and Auditing Data teaches you how to validate data, use the Auditing toolbar, trace cells referenced in a formula (precedents), and trace formulas that depend on contents of a cell (dependents). This course shows users how validate data, trace and fix errors, trace precedents for a formula, and trace dependents for a specific cell. Topics include Validating Data, Using the Auditing Toolbar, and Tracing Precedents and Dependents.

Lesson 6: Analyzing Data and Using PivotTables (3.0) hours

Analyzing Data and Using PivotTables teaches you how to use Goal Seek to backsolve from a solution to its values, use Solver, work with scenarios, use PivotTables for data analysis, use the PivotTable AutoFormat feature, create PivotChart reports, create an interactive PivotTable for the Web, and add fields to a PivotTable using the Web browser. This course shows how to use data analysis tools such as Goal Seek, Solver, and Scenarios, and PivotTables and PivotCharts. Topics include Using Goal Seek, Using Solver, Working with Scenarios, Using Data Analysis and PivotTables, Using PivotTables and PivotCharts, and Using a PivotTable with the Web.

Lesson 7: Sharing Work and Adding Security (3.0) hours

Sharing Work and Adding Security teaches you how to create, edit, and remove a cell comment, change workbook properties, apply and remove worksheet and workbook protection, apply and remove file passwords, track changes, create a shared workbook, and merge workbooks. This course shows users how to add comments to cells, change workbook properties, apply and remove worksheet and workbook protection and file passwords, track changes, create a shared workbook, and merge workbooks. Topics include Working with Comments and Properties, Adding Security, Tracking Changes, and Sharing Work.