Page 12 - Excel Timesaving Techniques for Dummies

00b_574272_ftoc.qxd 10/1/04 10:24 PM Page xi
xi
Table of Contents
Assigning Custom Number Formats to Styles Technique 26: Using Range Names 141
and Toolbars 107
Name That Range! 141
Applying Euro Currency Formats 109
Creating names from row and
Technique 21: Dazzling Alignments for column headings 142
Data Entries 111 Assigning range names that span
different sheets 143
Line Me Up 111
Assigning Range Names to Constants 144
Indenting data entries 112
Using Your Range Names in Formulas 144
Using nonstandard vertical alignment 113
Using range names in new formulas 145
Rotating text entries 113
Assigning range names to existing formulas 145
Getting Your Text under Control 114
Making text wrap within a cell 114 Technique 27: Smarter Formula
Shrinking the text to fit within a cell 115 Construction 148
Centering a heading across columns 116 Pointing Out Cell References in Formulas 148
Technique 22: Charting Data in a Snap 117 Putting the Insert Function Feature
at Your Service 150
Instant Charts 117
Using Labels Instead of Cell References
Chart Wizard Magic 119
in Formulas 152
Technique 23: Chart Customization Tricks 123
Technique 28: Trapping Those
Getting the Chart Titles and Headings Terrible Errors 154
in Balance 123
If I Were a Logical Function 154
Scaling and Formatting the Chart Axes 125
Trapping Division by Zero Errors 155
Tricks for Making the Plotted Data Easier
to Decipher 127 Trapping All Types of Error Values 156
Technique 29: Eliminating Errors with
Part IV: Worksheet Formula Error Tracing 158
Timesavers 129
Formula Auditing 101 158
Technique 24: Efficient Formula Copying 131 Tracing Formula Precedents 160
Going from Relative to Absolute 131 Tracing Formula Dependents 161
When It’s Copy Time 133 Finding the Original Error and Fixing Its
Formula 162
Making one-dimensional copies down
or across 134 Technique 30: Creating Efficient Date
Making two-dimensional copies both down and Time Formulas 164
and across 135
The Deal with Dates and Times 164
Technique 25: Speeding Up Table
You Do the Date Math! 165
Creation with Array Formulas 137
When Your Time Is Up 166
A Quick Look at Array Ranges 137
Hurray for Array Formulas! 138
Editing Array Formulas 140