Course Ilt Excel 2003: Intermediate

by COURSE TECHNOLOGY ILT/NIIT

• ISBN13: 9780619204044
• ISBN10: 0619204044
• Edition: 1st
• Format: Paperback
• Copyright: 2003-12-05
• Publisher: Instructor Led Training

Summary

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.

Table of Contents

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