Excel 2000 MOS Expert
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.
Importing and Exporting Data
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 and 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.
Working with Templates, Links, and 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 and 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.
Formatting, Sorting, and Filtering 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 and 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.
Naming Ranges, Working with Macros, and Customizing Toolbars
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 and 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.
Validating and Auditing Data
This course shows users how validate data, trace and fix errors, trace precedents for a formula, and trace dependents for a specific cell and 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).
Analyzing Data and Using PivotTables
This course shows how to use data analysis tools such as Goal Seek, Solver, and Scenarios, and PivotTables and PivotCharts and 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.
Sharing Work and Adding Security
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 and 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.