Microsoft Excel 2000 Advanced

Worksheets

Introduction
Working with Sheets
Sheet Groups
3-D Printing
Workspaces
Multiple Files
Linking Files
Linking and Embedding in Microsoft Office

Functions

Formula Palette and Paste Function
String Manipulation with Text Functions
Date and Time Functions
Lookup and Reference Functions
Maths Functions

Number Formats

Introduction
Creating Custom Number Formats
Conditional Formatting

Templates

Introduction
Standard Templates
Custom Templates
Template Properties
AutoTemplates
Storing Templates

Scenarios

What is the Scenario Manager?
Using the Scenario Manager

Custom Views and the Report Manager

Custom Views
Report Manager

Auditing

Auditing Features
Precedents and Dependants
Auditing Toolbar

Workbook Databases

Database Terms
Creating a Database
Sorting Tools
Sorting Data
Data Filtering
Grouping and Outlining
Subtotals
Consolidation
Data Template Wizard

Pivot Tables

Introduction
PivotTable Reports
Managing PivotTables
PivotChart Reports

External data

Introduction
Microsoft Query
Pivot Tables Using External Data

Charting

Chart Types
Adding and Deleting Data
Trend Lines
Picture Charts
Changing Values

Problem Solving

Goal Seek
Solver

Introduction To Macros

What is a Macro?
Recording a Macro
Running a Macro
Relative References