Excel 2000:
Intermediate

Topic-Level Outline

Days: 1

Prerequisites: Excel 2000: Basic or equivalent experience

Unit 1 : Working with large worksheets

Topic A: 0 Viewing options

A-1: Zooming in and out on a large worksheet

A-2: Unhiding columns

Topic B: 0 Hiding/displaying data

B-1: Hiding columns

B-2: Unhiding columns

B-3: Creating an outline

Topic C: 0 Printing large worksheets

C-1: Viewing page breaks

C-2: Setting page breaks

Unit 2 : Multiple worksheets and workbooks

Topic A: 0 Linking worksheets using 3-D formulas

A-1: Navigating multiple worksheets

A-2: Working with multiple worksheets

Topic B: 0 Linking worksheets using 3-D formulas

B-1: Examining 3-D formulas

B-2: Creating 3-D formulas

Topic C: 0 Consolidating data

C-1: Using the Data, Consolidate command

Topic D: 0 Linking workbooks

D-1: Switching between workbooks

D-2: Examining external links in a worksheet

D-3: Creating external links in a worksheet

D-4: Changing links

Unit 3 : Customizing Excel

Topic A: 0 Changing options

A-1: Changing view options

A-2: Changing general options

A-3: Changing calculation options

Topic B: 0 Customizing toolbars and menus

B-1: Showing and hiding toolbars

B-2: Moving and docking toolbars

B-3: Customizing and restoring toolbars

B-4: Customizing menus

B-5: Customizing short and smart menus

Unit 4 : Advanced charting

Topic A: 0 Formatting chart options

A-1: Adjusting the scale of a chart

A-2: Formatting data points

Topic B: 0 Creating combination charts

B-1: Creating a combination chart

B-2: Creating a trendline

Topic C: 0 Adding graphic elements

C-1: Adding graphic elements

C-2: Formatting graphic elements

C-3: Adding a picture to a worksheet

Unit 5 : Advanced formatting

Topic A: 0 Borders and shading

A-1: Adding borders to a cell or range

A-2: Adding shading to a cell or range

Topic B: 0 Special number formats

B-1: Using special formats

B-2: Controlling the display of zero values

B-3: Creating custom formats

Topic C: 0 Dates

C-1: Using date and time formats

C-2: Using NOW and DATE

C-3: Performing calculations on dates

Topic D: 0 Styles

D-1: Observing built-in styles

D-2: Creating and applying styles

D-3: Modifying styles

Topic E: 0 Other advanced formatting

E-1: Merging cells

E-2: Changing a cell's orientation

Unit 6 : List management

Topic A: 0 Creating lists

A-1: Examining the structure of a list

Topic B: 0 Sorting and filtering lists

B-1: Sorting lists using the sort buttons

B-2: Sorting a list using the Data, Sort command

B-3: Filtering a list using AutoFilter

Topic C: 0 Advanced filtering

C-1: Using custom AutoFilter criteria

C-2: Creating a criteria range using Advanced AutoFilter

C-3: Copying filtered results to another range

Unit 7 : Documenting and auditing

Topic A: 0 Comments and text boxes

A-1: Viewing comments in a worksheet

A-2: Adding a comment

A-3: Managing comments

A-4: Creating a text box

Topic B: 0 Auditing features

B-1: Tracing errors

B-2: Tracing precedent and dependent cells

Topic C: 0 Protection

C-1: Password protecting a worksheet

C-2: Protecting a worksheet by locking cells

Unit 8 : Using templates

Topic A: 0 Built-in templates

A-1: Using the Invoice template

A-2: Using the Purchase Order template

Topic B: 0 Creating and managing templates

B-1: Creating and using a template

B-2: Modifying a template

Appendix A : Collaborating with a workgroup

Topic A: 0 Sharing workbooks

A-1: Discussing shared workbooks

Topic B: 0 Managing changes

B-1: Discussing change history

B-2: Understanding changes and conflicts

Topic C: 0 Merging a shared workbook

Appendix B : Additional functions

Topic A: 0 IF, PMT, and FV

A-1: Understanding merging workbooks