Beginning Microsoft Excel 2010

Cover......Page 1
Contents at a Glance......Page 6
Contents......Page 7
About the Author......Page 13
About the Technical Reviewer......Page 14
Acknowledgments......Page 15
Introduction......Page 16
Unlocking Your Inner Worksheet......Page 17
The Pep Talk......Page 20
Interacting with the Interface......Page 21
Tab Talk......Page 23
Something New, Something Old......Page 25
Keeping Tabs…on a New One......Page 26
Cool QAT......Page 28
Understood in Context......Page 29
Alt-ered Consciousness......Page 30
More Addresses Than the Phone Book—Cells, and How to Get There......Page 33
Getting Around......Page 35
Key Points......Page 37
Ranges: A Select Tool......Page 40
Data Entry: Getting Started......Page 45
Entering Text: Trespassing Allowed......Page 46
Numbers are (a little) Different......Page 52
Relocating the Data: Copying and Moving......Page 53
Having Your Fill......Page 57
There’ll Be Some Changes Made—Editing Cells......Page 62
From Data Entry to Data Creation: Formula Basics and Beyond......Page 67
Cell references explained......Page 68
Ordering Up Your Results......Page 70
Not Just Your Average Function......Page 78
Making Range Values COUNT......Page 79
MAX and MIN—Recording Highs and Lows......Page 80
Absolute References: Absolutely Important......Page 88
More of the Same......Page 89
You Could Look It Up......Page 95
If: Worth Knowing—No Ifs, Ands, or Buts......Page 99
In Conclusion…......Page 101
You’ve Got Designs on Your Worksheet......Page 103
The Font Button Group: A Closer Look......Page 105
Borderline Command......Page 109
Getting Oriented......Page 120
Excel Has Got Your Number(s)......Page 134
Dates—The Long and the Short of It......Page 140
Time Is On Your Side—Yes It Is......Page 141
A New Kind of Copy—and Paste......Page 147
Style Setter......Page 153
Formatting—With Conditions......Page 155
Just a Bit More…......Page 168
IN CONCLUSION…......Page 170
Starting Charting......Page 171
Excluding Data......Page 174
Evaluating the Chart......Page 176
Resizing the Chart......Page 177
Flipping the Data Series......Page 179
The Column Chart......Page 180
The Line Chart......Page 182
The Pie Chart......Page 184
The Bar Chart......Page 186
The Scatter Chart......Page 187
Change Chart Type......Page 188
Save As Template......Page 189
Switch Row/Column......Page 190
Select Data......Page 191
Chart Layouts......Page 192
Chart Styles......Page 193
Changing the Chart Default—and the 2-Second Chart......Page 194
The Layout Tab......Page 195
Working with Chart Labels......Page 200
Axes to Grind......Page 203
The Format Tab—Getting Your Objects in Shape......Page 209
Sparklines: Mini-Charts with Big Impact......Page 210
You Win Some, You Lose Some......Page 214
In Conclusion…......Page 216
Setting the Table: Database Features of Excel 2010......Page 217
Sorting—Sort Of Easy......Page 218
Using Header Rows......Page 220
Sorting by More than One Field......Page 221
The AutoFilter: Picking and Choosing Your Data......Page 225
Playing—or Plying—the Numbers......Page 229
The Advanced Filter—Setting Your Data Aside......Page 231
Table Talk......Page 234
Creating a Table......Page 235
Using Table Styles......Page 236
Adding a Total Row......Page 237
Examining the other Table Style Options......Page 239
At the Risk of Repeating Yourself: The Remove Duplicates Option......Page 242
Using Data Validation......Page 244
Adding Data Entry Rules......Page 247
Using the Error Alert Option......Page 250
Adding a Validation Rule to Existing Data......Page 252
In Conclusion…......Page 253
Working With Multiple Sheets......Page 255
Inserting a Column......Page 256
Inserting and Deleting Cells......Page 257
Rows and Columns—and Getting them Back......Page 258
Multiple Worksheet Basics......Page 259
Inserting a New Worksheet......Page 260
Busting a (Sheet) Move......Page 261
Hiding Worksheets......Page 262
Far-Flung Formulas: Working with Multi-Sheet Cell References......Page 263
Doing a Multi-sheet Calculation......Page 264
Extending Your Reach: Referring to Cells in Different Workbooks......Page 266
The Watch Window—Spying On Your Own Data......Page 267
Protecting a Sheet......Page 269
Locking Cells......Page 270
Unlocking Cells......Page 272
Protecting a Whole Workbook......Page 274
Consolidating Your Data—Getting It All Together......Page 275
In Conclusion…......Page 280
Starting Out with PivotTables......Page 281
What’s in a Name?......Page 283
Constructing a PivotTable: Let’s Go......Page 284
Inserting the Table......Page 285
Setting Up the PivotTable......Page 287
Changing the Calculation......Page 290
Comparing the Data......Page 291
Moving and Removing Fields......Page 292
Adding Data Fields......Page 293
Changing Field Settings......Page 296
Counting Totals......Page 298
Using the Same Field Twice......Page 300
Filters Again-PivotTable Style......Page 301
Your Very Own Top 10 List......Page 304
The Report Filter—Getting on Top of the PivotTable......Page 305
The Slicer—Filter Deluxe......Page 309
Grouping the Data......Page 312
Formatting the Pivot Report—Values and All......Page 316
Pivot Charts......Page 318
In Conclusion…......Page 323
Hard Copy? Pretty Easy......Page 325
The Print Area Option......Page 327
Margin-al Utility......Page 330
Printing As You See Fit......Page 332
Headers and Footers—Getting to the Bottom (and the Top) of Your Printout......Page 334
Title Search......Page 339
There’s More Than One Way to View A Worksheet......Page 343
Gimme a (Page) Break—Another View......Page 346
Customize Your View, Too......Page 350
In Conclusion…......Page 352
Taking it to the Cloud: Sharing and Collaborating on the Internet......Page 353
Getting There......Page 354
Permission Granted: Sharing Your Workbooks......Page 361
Hey—You! Get Onto My Cloud!......Page 364
In Conclusion…......Page 365
What’s in a Name? Plenty, if it’s a Range......Page 367
Naming Many Ranges – at the Same Time......Page 373
The Name Manager – Tracking Your Ranges......Page 375
In Conclusion.........Page 376
Control Key Combinations......Page 377
Function keys......Page 379
Other shortcut keys......Page 381
Nobody’s Perfect......Page 385
¦ A......Page 391
¦ C......Page 392
¦ D......Page 394
¦ E......Page 395
¦ H......Page 397
¦ L......Page 398
¦ P......Page 399
¦......Page 400
¦ S......Page 401
¦ V......Page 403
¦ Z......Page 404