Course Ilt Excel 2003: Intermediate

This ILT Series manual teaches intermediate-level features and functions of Excel 2003. Students will learn how to work with large worksheets, use 3-D formulas, customize Excel's toolbars and menus, and apply special cell formatting.

Introduction

iii

Topic A: About the manual

iv

Topic B: Setting your expectations

vii

Topic C: Re-keying the course

xi

Working with large worksheets

1

(1)

Topic A: Viewing options

2

(4)

Topic B: Hiding, displaying, and outlining data

6

(6)

Topic C: Printing large worksheets

12

Unit summary: Working with large worksheets

16

Using multiple worksheets and workbooks

1

(1)

Topic A: Using multiple worksheets

2

(7)

Topic B: Linking worksheets by using 3-D formulas

9

(3)

Topic C: Consolidating data

12

(3)

Topic D: Linking workbooks

15

(5)

Topic E: Managing workbooks

20

Unit summary: Using multiple worksheets and workbooks

22

Customizing Excel

1

(1)

Topic A: Using the Options dialog box

2

(8)

Topic B: Customizing toolbars and menus

10

Unit summary: Customizing Excel

19

Advanced formatting

1

(1)

Topic A: Borders and shading

2

(4)

Topic B: Using special number formats

6

(8)

Topic C: Working with dates

14

(5)

Topic D: Working with styles

19

(6)

Topic E: Other advanced formatting

25

Unit summary: Advanced formatting

28

List management

1

(1)

Topic A: Examining lists

2

(2)

Topic B: Sorting and filtering lists

4

(4)

Topic C: Advanced filtering

8

Unit summary: List management

14

Advanced charting

1

(1)

Topic A: Chart formatting options

2

(4)

Topic B: Using combination charts

6

(4)

Topic C: Using graphic elements

10

Unit summary: Advanced charting

17

Documenting and auditing

1

(1)

Topic A: Auditing features

2

(4)

Topic B: Comments and text boxes

6

(6)

Topic C: Protection

12

(4)

Topic D: Workgroup collaboration

16

Unit summary: Documenting and auditing

22

Using templates

1

(1)

Topic A: Built-in templates

2

(5)

Topic B: Creating and managing templates

7

Unit summary: Using templates

12

Web discussions

1

(1)

Topic A: Creating and responding to Web discussions

2

MOS exam objectives maps

1

(1)

Topic A: Core exam objectives

2

(3)

Topic B: Expert exam objectives

5

Course summary

1

(1)

Topic A: Course summary

2

(2)

Topic B: Continued learning after class

4

Quick reference

1

(1)

Index

1

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

FREE SHIPPING

Amazon no longer offers textbook rentals. We do!

Course Ilt Excel 2003: Intermediate

Summary

Table of Contents

Supplemental Materials