Beginning Microsoft Excel 2010

Introduction to Excel - Page 17
Introduction to Excel - Page 18
Introduction to Excel - Page 19
The Pep Talk - Page 20
Interacting with the Interface - Page 21
Interacting with the Interface - Page 22
Tab Talk - Page 23
Tab Talk - Page 24
Something New, Something Old - Page 25
Keeping Tabs…on a New One - Page 26
Keeping Tabs…on a New One - Page 27
Cool QAT - Page 28
Understood in Context - Page 29
Alt-ered Consciousness - Page 30
Alt-ered Consciousness - Page 31
Alt-ered Consciousness - Page 32
Getting Started and Getting Around the Worksheet - Page 33
Getting Started and Getting Around the Worksheet - Page 34
Getting Around - Page 35
Getting Around - Page 36
Key Points - Page 37
Key Points - Page 38
Key Points - Page 39
Ranges: A Select Tool - Page 40
Ranges: A Select Tool - Page 41
Ranges: A Select Tool - Page 42
Ranges: A Select Tool - Page 43
Ranges: A Select Tool - Page 44
Data Entry: Getting Started - Page 45
Entering Text: Trespassing Allowed - Page 46
Entering Text: Trespassing Allowed - Page 47
Entering Text: Trespassing Allowed - Page 48
Entering Text: Trespassing Allowed - Page 49
Entering Text: Trespassing Allowed - Page 50
Entering Text: Trespassing Allowed - Page 51
Numbers are (a little) Different - Page 52
Relocating the Data: Copying and Moving - Page 53
Relocating the Data: Copying and Moving - Page 54
Relocating the Data: Copying and Moving - Page 55
Relocating the Data: Copying and Moving - Page 56
Having Your Fill - Page 57
Having Your Fill - Page 58
Having Your Fill - Page 59
Having Your Fill - Page 60
Having Your Fill - Page 61
There’ll Be Some Changes Made—Editing Cells - Page 62
There’ll Be Some Changes Made—Editing Cells - Page 63
There’ll Be Some Changes Made—Editing Cells - Page 64
There’ll Be Some Changes Made—Editing Cells - Page 65
There’ll Be Some Changes Made—Editing Cells - Page 66
From Data Entry to Data Creation: Formula Basics and Beyond - Page 67
Cell references explained - Page 68
Cell references explained - Page 69
Ordering Up Your Results - Page 70
Ordering Up Your Results - Page 71
Ordering Up Your Results - Page 72
Ordering Up Your Results - Page 73
Ordering Up Your Results - Page 74
Ordering Up Your Results - Page 75
Ordering Up Your Results - Page 76
Ordering Up Your Results - Page 77
Not Just Your Average Function - Page 78
Making Range Values COUNT - Page 79
MAX and MIN—Recording Highs and Lows - Page 80
MAX and MIN—Recording Highs and Lows - Page 81
MAX and MIN—Recording Highs and Lows - Page 82
MAX and MIN—Recording Highs and Lows - Page 83
MAX and MIN—Recording Highs and Lows - Page 84
MAX and MIN—Recording Highs and Lows - Page 85
MAX and MIN—Recording Highs and Lows - Page 86
MAX and MIN—Recording Highs and Lows - Page 87
Absolute References: Absolutely Important - Page 88
More of the Same - Page 89
More of the Same - Page 90
More of the Same - Page 91
More of the Same - Page 92
More of the Same - Page 93
More of the Same - Page 94
You Could Look It Up - Page 95
You Could Look It Up - Page 96
You Could Look It Up - Page 97
You Could Look It Up - Page 98
If: Worth Knowing—No Ifs, Ands, or Buts - Page 99
If: Worth Knowing—No Ifs, Ands, or Buts - Page 100
In Conclusion… - Page 101
In Conclusion… - Page 102
Keeping Up Appearances— Formatting the Worksheet - Page 103
Keeping Up Appearances— Formatting the Worksheet - Page 104
The Font Button Group: A Closer Look - Page 105
The Font Button Group: A Closer Look - Page 106
The Font Button Group: A Closer Look - Page 107
The Font Button Group: A Closer Look - Page 108
Borderline Command - Page 109
Borderline Command - Page 110
Borderline Command - Page 111
Borderline Command - Page 112
Borderline Command - Page 113
Borderline Command - Page 114
Borderline Command - Page 115
Borderline Command - Page 116
Borderline Command - Page 117
Borderline Command - Page 118
Borderline Command - Page 119
Getting Oriented - Page 120
Getting Oriented - Page 121
Getting Oriented - Page 122
Getting Oriented - Page 123
Getting Oriented - Page 124
Getting Oriented - Page 125
Getting Oriented - Page 126
Getting Oriented - Page 127
Getting Oriented - Page 128
Getting Oriented - Page 129
Getting Oriented - Page 130
Getting Oriented - Page 131
Getting Oriented - Page 132
Getting Oriented - Page 133
Excel Has Got Your Number(s) - Page 134
Excel Has Got Your Number(s) - Page 135
Excel Has Got Your Number(s) - Page 136
Excel Has Got Your Number(s) - Page 137
Excel Has Got Your Number(s) - Page 138
Excel Has Got Your Number(s) - Page 139
Dates—The Long and the Short of It - Page 140
Time Is On Your Side—Yes It Is - Page 141
Time Is On Your Side—Yes It Is - Page 142
Time Is On Your Side—Yes It Is - Page 143
Time Is On Your Side—Yes It Is - Page 144
Time Is On Your Side—Yes It Is - Page 145
Time Is On Your Side—Yes It Is - Page 146
A New Kind of Copy—and Paste - Page 147
A New Kind of Copy—and Paste - Page 148
A New Kind of Copy—and Paste - Page 149
A New Kind of Copy—and Paste - Page 150
A New Kind of Copy—and Paste - Page 151
A New Kind of Copy—and Paste - Page 152
Style Setter - Page 153
Style Setter - Page 154
Formatting—With Conditions - Page 155
Formatting—With Conditions - Page 156
Formatting—With Conditions - Page 157
Formatting—With Conditions - Page 158
Formatting—With Conditions - Page 159
Formatting—With Conditions - Page 160
Formatting—With Conditions - Page 161
Formatting—With Conditions - Page 162
Formatting—With Conditions - Page 163
Formatting—With Conditions - Page 164
Formatting—With Conditions - Page 165
Formatting—With Conditions - Page 166
Formatting—With Conditions - Page 167
Just a Bit More… - Page 168
Just a Bit More… - Page 169
P. S. - Page 170
The Stuff Of Legend— Charting in Excel - Page 171
The Stuff Of Legend— Charting in Excel - Page 172
The Stuff Of Legend— Charting in Excel - Page 173
Making a Chart of Our Own - Page 174
Making a Chart of Our Own - Page 175
Evaluating the Chart - Page 176
Resizing the Chart - Page 177
Resizing the Chart - Page 178
Flipping the Data Series - Page 179
Changing The Chart—It’s Your Call - Page 180
Changing The Chart—It’s Your Call - Page 181
The Line Chart - Page 182
The Line Chart - Page 183
The Pie Chart - Page 184
The Pie Chart - Page 185
The Bar Chart - Page 186
The Area Chart - Page 187
The Design Tab—A Closer Look - Page 188
Save As Template - Page 189
Switch Row/Column - Page 190
Select Data - Page 191
Chart Layouts - Page 192
Chart Styles - Page 193
Move Chart - Page 194
The Layout Tab - Page 195
The Layout Tab - Page 196
The Layout Tab - Page 197
The Layout Tab - Page 198
The Layout Tab - Page 199
Working with Chart Labels - Page 200
Working with Chart Labels - Page 201
Working with Chart Labels - Page 202
Axes to Grind - Page 203
Axes to Grind - Page 204
Axes to Grind - Page 205
Axes to Grind - Page 206
Axes to Grind - Page 207
Axes to Grind - Page 208
The Format Tab—Getting Your Objects in Shape - Page 209
Sparklines: Mini-Charts with Big Impact - Page 210
Sparklines: Mini-Charts with Big Impact - Page 211
Sparklines: Mini-Charts with Big Impact - Page 212
Sparklines: Mini-Charts with Big Impact - Page 213
You Win Some, You Lose Some - Page 214
You Win Some, You Lose Some - Page 215
In Conclusion… - Page 216
Setting the Table: Database Features of Excel 2010 - Page 217
Sorting—Sort Of Easy - Page 218
Sorting—Sort Of Easy - Page 219
Using Header Rows - Page 220
Sorting by More than One Field - Page 221
Sorting by More than One Field - Page 222
Sorting by More than One Field - Page 223
Sorting by More than One Field - Page 224
The AutoFilter: Picking and Choosing Your Data - Page 225
The AutoFilter: Picking and Choosing Your Data - Page 226
The AutoFilter: Picking and Choosing Your Data - Page 227
The AutoFilter: Picking and Choosing Your Data - Page 228
Playing—or Plying—the Numbers - Page 229
Playing—or Plying—the Numbers - Page 230
The Advanced Filter—Setting Your Data Aside - Page 231
The Advanced Filter—Setting Your Data Aside - Page 232
The Advanced Filter—Setting Your Data Aside - Page 233
Table Talk - Page 234
Creating a Table - Page 235
Using Table Styles - Page 236
Adding a Total Row - Page 237
Adding a Total Row - Page 238
Examining the other Table Style Options - Page 239
Examining the other Table Style Options - Page 240
Examining the other Table Style Options - Page 241
At the Risk of Repeating Yourself: The Remove Duplicates Option - Page 242
At the Risk of Repeating Yourself: The Remove Duplicates Option - Page 243
Data Validation: Improving Your Entrée to Data Entry - Page 244
Data Validation: Improving Your Entrée to Data Entry - Page 245
Data Validation: Improving Your Entrée to Data Entry - Page 246
Adding Data Entry Rules - Page 247
Adding Data Entry Rules - Page 248
Adding Data Entry Rules - Page 249
Adding an Input Message - Page 250
Adding an Input Message - Page 251
Adding a Validation Rule to Existing Data - Page 252
In Conclusion… - Page 253
In Conclusion… - Page 254
Working With Multiple Sheets - Page 255
Adding To Sheets—Inserting Rows, Columns and Cells - Page 256
Inserting a Row - Page 257
Hiding - Page 258
Multiple Worksheet Basics - Page 259
Inserting a New Worksheet - Page 260
Busting a (Sheet) Move - Page 261
Hiding Worksheets - Page 262
Grouping Worksheets - Page 263
Doing a Multi-sheet Calculation - Page 264
Doing a Multi-sheet Calculation - Page 265
Extending Your Reach: Referring to Cells in Different Workbooks - Page 266
The Watch Window—Spying On Your Own Data - Page 267
The Watch Window—Spying On Your Own Data - Page 268
Protect Your Cells From Unwanted Intruders—Even Yourself - Page 269
Locking Cells - Page 270
Locking Cells - Page 271
Unlocking Cells - Page 272
Unlocking Cells - Page 273
Protecting a Whole Workbook - Page 274
Consolidating Your Data—Getting It All Together - Page 275
Consolidating Your Data—Getting It All Together - Page 276
Consolidating Your Data—Getting It All Together - Page 277
Consolidating Your Data—Getting It All Together - Page 278
Consolidating Your Data—Getting It All Together - Page 279
In Conclusion… - Page 280
PivotTables and Pivot Charts - Page 281
PivotTables and Pivot Charts - Page 282
What’s in a Name? - Page 283
Constructing a PivotTable: Let’s Go - Page 284
Inserting the Table - Page 285
Inserting the Table - Page 286
Setting Up the PivotTable - Page 287
Setting Up the PivotTable - Page 288
Setting Up the PivotTable - Page 289
Updating the Pivot Report - Page 290
Comparing the Data - Page 291
Moving and Removing Fields - Page 292
Adding Data Fields - Page 293
Adding Data Fields - Page 294
Adding Data Fields - Page 295
Changing Field Settings - Page 296
Changing Field Settings - Page 297
Pivoting the Table - Page 298
Pivoting the Table - Page 299
Using the Same Field Twice - Page 300
Filters Again-PivotTable Style - Page 301
Filters Again-PivotTable Style - Page 302
Filters Again-PivotTable Style - Page 303
Your Very Own Top 10 List - Page 304
The Report Filter—Getting on Top of the PivotTable - Page 305
The Report Filter—Getting on Top of the PivotTable - Page 306
The Report Filter—Getting on Top of the PivotTable - Page 307
The Report Filter—Getting on Top of the PivotTable - Page 308
The Slicer—Filter Deluxe - Page 309
The Slicer—Filter Deluxe - Page 310
The Slicer—Filter Deluxe - Page 311
Grouping the Data - Page 312
Grouping the Data - Page 313
Grouping the Data - Page 314
Grouping the Data - Page 315
Formatting the Pivot Report—Values and All - Page 316
Formatting the Pivot Report—Values and All - Page 317
Pivot Charts - Page 318
Pivot Charts - Page 319
Pivot Charts - Page 320
Pivot Charts - Page 321
Pivot Charts - Page 322
In Conclusion… - Page 323
In Conclusion… - Page 324
Getting It On Paper— Printing in Excel 2010 - Page 325
Getting It On Paper— Printing in Excel 2010 - Page 326
The Print Area Option - Page 327
The Print Area Option - Page 328
The Print Area Option - Page 329
Margin-al Utility - Page 330
Margin-al Utility - Page 331
Printing As You See Fit - Page 332
Printing As You See Fit - Page 333
Headers and Footers—Getting to the Bottom (and the Top) of Your Printout - Page 334
Headers and Footers—Getting to the Bottom (and the Top) of Your Printout - Page 335
Headers and Footers—Getting to the Bottom (and the Top) of Your Printout - Page 336
Headers and Footers—Getting to the Bottom (and the Top) of Your Printout - Page 337
Headers and Footers—Getting to the Bottom (and the Top) of Your Printout - Page 338
Title Search - Page 339
Title Search - Page 340
Title Search - Page 341
Title Search - Page 342
There’s More Than One Way to View A Worksheet - Page 343
There’s More Than One Way to View A Worksheet - Page 344
There’s More Than One Way to View A Worksheet - Page 345
Gimme a (Page) Break—Another View - Page 346
Gimme a (Page) Break—Another View - Page 347
Gimme a (Page) Break—Another View - Page 348
Gimme a (Page) Break—Another View - Page 349
Customize Your View, Too - Page 350
Customize Your View, Too - Page 351
In Conclusion… - Page 352
Taking it to the Cloud: Sharing and Collaborating on the Internet - Page 353
Getting There - Page 354
Getting There - Page 355
Getting There - Page 356
Getting There - Page 357
Getting There - Page 358
Getting There - Page 359
Getting There - Page 360
Permission Granted: Sharing Your Workbooks - Page 361
Permission Granted: Sharing Your Workbooks - Page 362
Permission Granted: Sharing Your Workbooks - Page 363
Hey—You! Get Onto My Cloud! - Page 364
In Conclusion… - Page 365
In Conclusion… - Page 366
Working With Range Names - Page 367
Working With Range Names - Page 368
Working With Range Names - Page 369
Working With Range Names - Page 370
Working With Range Names - Page 371
Working With Range Names - Page 372
Naming Many Ranges – at the Same Time - Page 373
Naming Many Ranges – at the Same Time - Page 374
The Name Manager – Tracking Your Ranges - Page 375
In Conclusion... - Page 376
Keyboard Shortcuts - Page 377
Keyboard Shortcuts - Page 378
Function keys - Page 379
Function keys - Page 380
Other shortcut keys - Page 381
Other shortcut keys - Page 382
Other shortcut keys - Page 383
Other shortcut keys - Page 384
Error Messages - Page 385
Error Messages - Page 386
Error Messages - Page 387
Error Messages - Page 388
Error Messages - Page 389
Error Messages - Page 390