Excel 2000 MOUS Expert
Series
|
Excel 2000 MOUS Expert: Importing and Exporting Data shows
users how to import data from other applications into Excel, query a
database application to extract data, and export data from Excel to other
applications.
- Importing Data Using the Text Import Wizard
- Importing Text by Other Methods
- Importing Data from an Application or File
|
- Querying a Database
- Exporting Data to an Application
|
|
|
Excel 2000 MOUS Expert: Working with Templates, Links, and
Report Manager shows the user how to work with templates, link workbooks,
and use Report Manager.
- Working with Templates
- Using a Workspace and Linking Workbooks
|
- Previewing, Printing, and Report Manager
|
|
|
Excel 2000 MOUS Expert: 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.
- Formatting Numbers
- Using and Applying Conditional Formats
- Sorting and Grouping Data
|
- Using a Data Form
- Using a Data Filter
|
|
|
Excel 2000 MOUS Expert: 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.
- Adding, Using & Deleting a Named Range
- Using Lookup Functions
- Recording and Running a Macro
|
- Editing a Macro
- Working with Toolbars
|
|
|
Excel 2000 MOUS Expert: 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.
- Validating Data
- Using the Auditing Toolbar
|
- Tracing Precedents and Dependents
|
|
|
Excel 2000 MOUS Expert: 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.
- Using Goal Seek
- Using Solver
- Working with Scenarios
|
- Using Data Analysis and PivotTables
- Using PivotTables and PivotCharts
- Using a PivotTable with the Web
|
|
|
Excel 2000 MOUS Expert: Sharing Work and Adding Security shows
users how to work with cell comments, apply workbook protection, and share
and merge workbooks.
- Working with Comments and Properties
- Adding Security
|
- Tracking Changes
- Sharing Work
|
|
|
