Briefcase Series: Microsoft Excel 2002 - Level 1 (book/disk)

Level 1: Basic Formatting, Absolute References, Formulas, Functions, Charts

Table of Contents
Contents v
About This Book vii
Excel 2002 Keyboard Summary Sheet xi
Quick Reference Index xiii
Visual Conventions xv
MOUS Program xvii
LESSON 1: CREATING AND
EDITING A SIMPLE WORKSHEET 2
What Is Microsoft Excel? 4
Starting Excel 4
Worksheets
and Workbooks 6
The Highlight 6
The Task Pane 6
Entering Data 8
Undo and Redo 9
Repeat 10
Number Entries 12
Save Concepts 14
Editing Entries 16
Selecting Cells 18
Aligning Cell Entries 20
AutoSum 21
AutoCalculate 23
Print Preview 24
Printing 24
Closing Workbooks 25
Opening Workbooks 26
Exiting from Excel 27
LESSON 2:
EXPANDING ON THE BASICS 38
Managing Toolbars 40
The Fill Handle 41
Formulas 43
Number Formats 47
Merging and Splitting
Cells 52
Indenting Entries 54
Formatting Entries 54
The Format Painter 55
Clearing Cell Contents
and Formats 57
LESSON 3: POWERFUL FEATURES
AND AUTOMATED TOOLS 70
The Ofoce Assistant 72
Online Help 74
AutoCorrect 76
AutoComplete 77
Functions 79
Cut, Copy, and Paste 83
Drag and Drop 85
Right Dragging 86
Cell Borders 88
Fill Colors and Patterns 89
AutoFormat 91
Zooming 93
Hiding Rows and
Columns 94
Unhiding Rows and
Columns 94
LESSON 4:
DATES, TEXT FEATURES, AND
RESTRUCTURING WORKSHEETS 106
Working with Dates 108
Date and Time Functions 110
Line Breaks 111
Vertical Alignment 113
Rotating Text 114
Column Widths and Row Heights 116
Inserting and Deleting
Rows and Columns 118
Error Checking Tools 122
Find and Replace 123
Contents
LESSON 5:
FINANCIAL MODELING AND
ABSOLUTE CELL REFERENCES 140
Absolute References 142
Revising Formulas 142
Displaying Formulas 148
Printing Selections 149
Print Areas 150
LESSON 6:
CREATING AN IMPACT
WITH CHARTS 164
Managing Worksheets 166
Chart Concepts 167
Column Charts and Bar
Charts 168
Previewing and
Printing Charts 171
Moving and Sizing
Embedded Charts 172
Line Charts 174
Pie Charts 176
Modifying Charts 177
LESSON 7:
WORKING WITH
LARGE WORKSHEETS 198
Sorting 200
Freezing Header Rows
and Columns 202
Splitting Window Panes 203
Printing large Worksheets 206
Inserting Page Breaks 214
Page Break Preview 216
Index 226
vi Contents