Excel 2002:
Intermediate

Topic-Level Outline

Days: 1

Prerequisites: Excel 2002: 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: Using the Freeze Panes command

Topic B: 0 Hiding and displaying data

B-1: Hiding columns

B-2: Unhiding columns

B-3: Creating an outline

Topic C: 0 Printing large worksheets

C-1: Setting print titles

C-2: Setting page breaks

C-3: Using Page Break Preview

Unit 2 : Working with multiple worksheets and workbooks

Topic A: 0 Using multiple worksheets

A-1: Navigating multiple worksheets

A-2: Naming worksheets and coloring tabs

A-3: Working with multiple worksheets

A-4: Previewing and printing multiple worksheets

Topic B: 0 Linking worksheets by using 3-D formulas

B-1: Creating 3-D formulas

B-2: Adding a watch

Topic C: 0 Consolidating data

C-1: Using the 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: Editing links

Topic E: 0 Managing workbooks

E-1: Creating a workspace

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: Exploring short and smart menus

Unit 4 : Advanced charting

Topic A: 0 Chart formatting 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 Using 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 Using special number formats

B-1: Using special formats

B-2: Controlling the display of zero values

B-3: Creating custom formats

Topic C: 0 Working with dates

C-1: Using date and time formats

C-2: Using the NOW and DATE functions

C-3: Performing calculations on dates

Topic D: 0 Working with 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

E-3: Splitting cells

Unit 6 : List management

Topic A: 0 Working with lists

A-1: Examining the structure of a list

Topic B: 0 Sorting and filtering lists

B-1: Sorting a list by using the Standard toolbar

B-2: Sorting a list by using the Sort command

B-3: Filtering a list by using AutoFilter

Topic C: 0 Advanced filtering

C-1: Using the Custom AutoFilter criteria

C-2: Creating a criteria range by 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 part of a worksheet by unlocking cells

Topic D: 0 Workgroup collaboration

D-1: Sharing a workbook

D-2: Merging workbooks

D-3: Tracking changes in a workbook

Unit 8 : Using templates

Topic A: 0 Built-in templates

A-1: Using the Sales Invoice template

A-2: Using the Expense Statement template

Topic B: 0 Creating and managing templates

B-1: Creating a template

B-2: Modifying a template

Appendix A : Additional functions

Topic A: 0 IF, SUMIF, and PMT

Appendix B : Web discussions

Topic A: 0 Creating and responding to Web discussions

Appendix C : MOUS exam objectives map

Topic A: 0 Core exam objectives

Topic B: 0 Expert exam objectives