Microsoft Excel 2013

Part I: Getting Started with Excel 2013 - Page 23
Part I: Getting Started with Excel 2013 - Page 24
Chapter 1: The Excel 2013 User Experience - Page 25
Excel’s Ribbon User Interface - Page 26
Excel’s Ribbon User Interface - Page 27
Excel’s Ribbon User Interface - Page 28
Excel’s Ribbon User Interface - Page 29
Excel’s Ribbon User Interface - Page 30
Excel’s Ribbon User Interface - Page 31
Excel’s Ribbon User Interface - Page 32
Excel’s Ribbon User Interface - Page 33
Excel’s Ribbon User Interface - Page 34
Excel’s Ribbon User Interface - Page 35
Excel’s Ribbon User Interface - Page 36
Excel’s Ribbon User Interface - Page 37
Excel’s Ribbon User Interface - Page 38
Excel’s Ribbon User Interface - Page 39
Excel’s Ribbon User Interface - Page 40
Excel’s Ribbon User Interface - Page 41
Excel’s Ribbon User Interface - Page 42
Excel’s Ribbon User Interface - Page 43
Excel’s Ribbon User Interface - Page 44
Excel’s Ribbon User Interface - Page 45
Excel’s Ribbon User Interface - Page 46
Excel’s Ribbon User Interface - Page 47
Launching and Quitting Excel - Page 48
Launching and Quitting Excel - Page 49
Launching and Quitting Excel - Page 50
Launching and Quitting Excel - Page 51
Launching and Quitting Excel - Page 52
Help Is on the Way - Page 53
Help Is on the Way - Page 54
Chapter 2: Creating a Spreadsheet from Scratch - Page 55
So What Ya Gonna Put in That New Workbook of Yours? - Page 56
So What Ya Gonna Put in That New Workbook of Yours? - Page 57
So What Ya Gonna Put in That New Workbook of Yours? - Page 58
Doing the Data-Entry Thing - Page 59
Doing the Data-Entry Thing - Page 60
It Takes All Types - Page 61
It Takes All Types - Page 62
It Takes All Types - Page 63
It Takes All Types - Page 64
It Takes All Types - Page 65
It Takes All Types - Page 66
It Takes All Types - Page 67
It Takes All Types - Page 68
It Takes All Types - Page 69
It Takes All Types - Page 70
It Takes All Types - Page 71
It Takes All Types - Page 72
It Takes All Types - Page 73
It Takes All Types - Page 74
It Takes All Types - Page 75
Fixing Those Data Entry Flub-Ups - Page 76
Fixing Those Data Entry Flub-Ups - Page 77
Fixing Those Data Entry Flub-Ups - Page 78
Taking the Drudgery out of Data Entry - Page 79
Taking the Drudgery out of Data Entry - Page 80
Taking the Drudgery out of Data Entry - Page 81
Taking the Drudgery out of Data Entry - Page 82
Taking the Drudgery out of Data Entry - Page 83
Taking the Drudgery out of Data Entry - Page 84
Taking the Drudgery out of Data Entry - Page 85
Taking the Drudgery out of Data Entry - Page 86
Taking the Drudgery out of Data Entry - Page 87
Taking the Drudgery out of Data Entry - Page 88
Taking the Drudgery out of Data Entry - Page 89
Taking the Drudgery out of Data Entry - Page 90
Taking the Drudgery out of Data Entry - Page 91
How to Make Your Formulas Function Even Better - Page 92
How to Make Your Formulas Function Even Better - Page 93
How to Make Your Formulas Function Even Better - Page 94
How to Make Your Formulas Function Even Better - Page 95
How to Make Your Formulas Function Even Better - Page 96
How to Make Your Formulas Function Even Better - Page 97
How to Make Your Formulas Function Even Better - Page 98
How to Make Your Formulas Function Even Better - Page 99
How to Make Your Formulas Function Even Better - Page 100
Making Sure That the Data Is Safe and Sound - Page 101
Making Sure That the Data Is Safe and Sound - Page 102
Making Sure That the Data Is Safe and Sound - Page 103
Making Sure That the Data Is Safe and Sound - Page 104
Saving the Workbook as a PDF File - Page 105
Document Recovery to the Rescue - Page 106
Document Recovery to the Rescue - Page 107
Document Recovery to the Rescue - Page 108
Part II: Editing without Tears - Page 109
Part II: Editing without Tears - Page 110
Chapter 3: Making It All Look Pretty - Page 111
Choosing a Select Group of Cells - Page 112
Choosing a Select Group of Cells - Page 113
Choosing a Select Group of Cells - Page 114
Choosing a Select Group of Cells - Page 115
Choosing a Select Group of Cells - Page 116
Choosing a Select Group of Cells - Page 117
Choosing a Select Group of Cells - Page 118
Using the Format as Table Gallery - Page 119
Using the Format as Table Gallery - Page 120
Using the Format as Table Gallery - Page 121
Cell Formatting from the Home Tab - Page 122
Cell Formatting from the Home Tab - Page 123
Cell Formatting from the Home Tab - Page 124
Formatting Cells Close to the Source with the Mini-bar - Page 125
Using the Format Cells Dialog Box - Page 126
Using the Format Cells Dialog Box - Page 127
Using the Format Cells Dialog Box - Page 128
Using the Format Cells Dialog Box - Page 129
Using the Format Cells Dialog Box - Page 130
Using the Format Cells Dialog Box - Page 131
Using the Format Cells Dialog Box - Page 132
Using the Format Cells Dialog Box - Page 133
Using the Format Cells Dialog Box - Page 134
Calibrating Columns - Page 135
Calibrating Columns - Page 136
Calibrating Columns - Page 137
Calibrating Columns - Page 138
Futzing with the Fonts - Page 139
Altering the Alignment - Page 140
Altering the Alignment - Page 141
Altering the Alignment - Page 142
Altering the Alignment - Page 143
Altering the Alignment - Page 144
Altering the Alignment - Page 145
Altering the Alignment - Page 146
Altering the Alignment - Page 147
Altering the Alignment - Page 148
Doing It in Styles - Page 149
Doing It in Styles - Page 150
Fooling Around with the Format Painter - Page 151
Conditional Formatting - Page 152
Conditional Formatting - Page 153
Conditional Formatting - Page 154
Conditional Formatting - Page 155
Conditional Formatting - Page 156
Chapter 4: Going Through Changes - Page 157
Opening Your Workbooks for Editing - Page 158
Opening Your Workbooks for Editing - Page 159
Opening Your Workbooks for Editing - Page 160
Opening Your Workbooks for Editing - Page 161
Opening Your Workbooks for Editing - Page 162
Opening Your Workbooks for Editing - Page 163
Much Ado about Undo - Page 164
Much Ado about Undo - Page 165
Doing the Old Drag-and-Drop Thing - Page 166
Doing the Old Drag-and-Drop Thing - Page 167
Doing the Old Drag-and-Drop Thing - Page 168
Copying Formulas with AutoFill - Page 169
Copying Formulas with AutoFill - Page 170
Copying Formulas with AutoFill - Page 171
Copying Formulas with AutoFill - Page 172
Copying Formulas with AutoFill - Page 173
Cut and Paste, Digital Style - Page 174
Cut and Paste, Digital Style - Page 175
Cut and Paste, Digital Style - Page 176
Cut and Paste, Digital Style - Page 177
Cut and Paste, Digital Style - Page 178
Cut and Paste, Digital Style - Page 179
Cut and Paste, Digital Style - Page 180
Let’s Be Clear about Deleting Stuff - Page 181
Let’s Be Clear about Deleting Stuff - Page 182
Staying in Step with Insert - Page 183
Staying in Step with Insert - Page 184
Eliminating Errors with Text to Speech - Page 185
Eliminating Errors with Text to Speech - Page 186
Eliminating Errors with Text to Speech - Page 187
Eliminating Errors with Text to Speech - Page 188
Chapter 5: Printing the Masterpiece - Page 189
Previewing Pages in Page Layout View - Page 190
Using the Backstage Print Screen - Page 191
Using the Backstage Print Screen - Page 192
Using the Backstage Print Screen - Page 193
Printing the Current Worksheet - Page 194
Printing the Current Worksheet - Page 195
My Page Was Set Up! - Page 196
My Page Was Set Up! - Page 197
My Page Was Set Up! - Page 198
My Page Was Set Up! - Page 199
My Page Was Set Up! - Page 200
My Page Was Set Up! - Page 201
My Page Was Set Up! - Page 202
From Header to Footer - Page 203
From Header to Footer - Page 204
From Header to Footer - Page 205
From Header to Footer - Page 206
From Header to Footer - Page 207
From Header to Footer - Page 208
From Header to Footer - Page 209
Solving Page Break Problems - Page 210
Solving Page Break Problems - Page 211
Letting Your Formulas All Hang Out - Page 212
Letting Your Formulas All Hang Out - Page 213
Letting Your Formulas All Hang Out - Page 214
Part III: Getting Organized and Staying That Way - Page 215
Part III: Getting Organized and Staying That Way - Page 216
Chapter 6: Maintaining the Worksheet - Page 217
Zooming In and Out - Page 218
Zooming In and Out - Page 219
Splitting the Worksheet into Windows - Page 220
Splitting the Worksheet into Windows - Page 221
Fixed Headings with Freeze Panes - Page 222
Fixed Headings with Freeze Panes - Page 223
Fixed Headings with Freeze Panes - Page 224
Electronic Sticky Notes - Page 225
Electronic Sticky Notes - Page 226
Electronic Sticky Notes - Page 227
The Range Name Game - Page 228
The Range Name Game - Page 229
The Range Name Game - Page 230
The Range Name Game - Page 231
Seek and Ye Shall Find . . . - Page 232
Seek and Ye Shall Find . . . - Page 233
Seek and Ye Shall Find . . . - Page 234
Seek and Ye Shall Find . . . - Page 235
Replacing Cell Entries - Page 236
Doing Your Research - Page 237
Doing Your Research - Page 238
Controlling Recalculation - Page 239
Putting on the Protection - Page 240
Putting on the Protection - Page 241
Putting on the Protection - Page 242
Chapter 7: Maintaining Multiple Worksheets - Page 243
Chapter 7: Maintaining Multiple Worksheets - Page 244
Chapter 7: Maintaining Multiple Worksheets - Page 245
Chapter 7: Maintaining Multiple Worksheets - Page 246
Don’t Short-Sheet Me! - Page 247
Don’t Short-Sheet Me! - Page 248
Don’t Short-Sheet Me! - Page 249
Don’t Short-Sheet Me! - Page 250
Don’t Short-Sheet Me! - Page 251
Opening Windows on Your Worksheets - Page 252
Opening Windows on Your Worksheets - Page 253
Opening Windows on Your Worksheets - Page 254
Opening Windows on Your Worksheets - Page 255
Comparing Worksheets Side by Side - Page 256
Comparing Worksheets Side by Side - Page 257
Shifting Sheets to Other Workbooks - Page 258
Shifting Sheets to Other Workbooks - Page 259
Shifting Sheets to Other Workbooks - Page 260
Summing Stuff on Different Worksheets - Page 261
Summing Stuff on Different Worksheets - Page 262
Summing Stuff on Different Worksheets - Page 263
Summing Stuff on Different Worksheets - Page 264
Part IV: Digging Data Analysis - Page 265
Part IV: Digging Data Analysis - Page 266
Chapter 8: Doing What-If Analysis - Page 267
Playing What-If with Data Tables - Page 268
Playing What-If with Data Tables - Page 269
Playing What-If with Data Tables - Page 270
Playing What-If with Data Tables - Page 271
Playing What-If with Data Tables - Page 272
Playing What-If with Goal Seeking - Page 273
Playing What-If with Goal Seeking - Page 274
Making the Case with Scenario Manager - Page 275
Making the Case with Scenario Manager - Page 276
Making the Case with Scenario Manager - Page 277
Making the Case with Scenario Manager - Page 278
Making the Case with Scenario Manager - Page 279
Making the Case with Scenario Manager - Page 280
Chapter 9: Playing with Pivot Tables - Page 281
Data Analysis with Pivot Tables - Page 282
Data Analysis with Pivot Tables - Page 283
Data Analysis with Pivot Tables - Page 284
Data Analysis with Pivot Tables - Page 285
Data Analysis with Pivot Tables - Page 286
Data Analysis with Pivot Tables - Page 287
Data Analysis with Pivot Tables - Page 288
Formatting Pivot Tables - Page 289
Sorting and Filtering Pivot Table Data - Page 290
Sorting and Filtering Pivot Table Data - Page 291
Sorting and Filtering Pivot Table Data - Page 292
Sorting and Filtering Pivot Table Data - Page 293
Sorting and Filtering Pivot Table Data - Page 294
Modifying Pivot Tables - Page 295
Modifying Pivot Tables - Page 296
Modifying Pivot Tables - Page 297
Creating Pivot Charts - Page 298
Creating Pivot Charts - Page 299
Creating Pivot Charts - Page 300
Creating Pivot Charts - Page 301
Creating Pivot Charts - Page 302
Part V: Life beyond the Spreadsheet - Page 303
Part V: Life beyond the Spreadsheet - Page 304
Chapter 10: Charming Charts and Gorgeous Graphics - Page 305
Chapter 10: Charming Charts and Gorgeous Graphics - Page 306
Chapter 10: Charming Charts and Gorgeous Graphics - Page 307
Chapter 10: Charming Charts and Gorgeous Graphics - Page 308
Chapter 10: Charming Charts and Gorgeous Graphics - Page 309
Chapter 10: Charming Charts and Gorgeous Graphics - Page 310
Chapter 10: Charming Charts and Gorgeous Graphics - Page 311
Chapter 10: Charming Charts and Gorgeous Graphics - Page 312
Chapter 10: Charming Charts and Gorgeous Graphics - Page 313
Chapter 10: Charming Charts and Gorgeous Graphics - Page 314
Chapter 10: Charming Charts and Gorgeous Graphics - Page 315
Chapter 10: Charming Charts and Gorgeous Graphics - Page 316
Chapter 10: Charming Charts and Gorgeous Graphics - Page 317
Chapter 10: Charming Charts and Gorgeous Graphics - Page 318
Adding Great-Looking Graphics - Page 319
Adding Great-Looking Graphics - Page 320
Adding Great-Looking Graphics - Page 321
Adding Great-Looking Graphics - Page 322
Adding Great-Looking Graphics - Page 323
Adding Great-Looking Graphics - Page 324
Adding Great-Looking Graphics - Page 325
Adding Great-Looking Graphics - Page 326
Adding Great-Looking Graphics - Page 327
Adding Great-Looking Graphics - Page 328
Adding Great-Looking Graphics - Page 329
Adding Great-Looking Graphics - Page 330
Adding Great-Looking Graphics - Page 331
Adding Great-Looking Graphics - Page 332
Adding Great-Looking Graphics - Page 333
Adding Great-Looking Graphics - Page 334
Adding Great-Looking Graphics - Page 335
Controlling How Graphic Objects Overlap - Page 336
Controlling How Graphic Objects Overlap - Page 337
Controlling How Graphic Objects Overlap - Page 338
Printing Just the Charts - Page 339
Printing Just the Charts - Page 340
Chapter 11: Getting on the Data List - Page 341
Chapter 11: Getting on the Data List - Page 342
Chapter 11: Getting on the Data List - Page 343
Chapter 11: Getting on the Data List - Page 344
Chapter 11: Getting on the Data List - Page 345
Chapter 11: Getting on the Data List - Page 346
Chapter 11: Getting on the Data List - Page 347
Chapter 11: Getting on the Data List - Page 348
Sorting Data Lists - Page 349
Sorting Data Lists - Page 350
Sorting Data Lists - Page 351
Sorting Data Lists - Page 352
Sorting Data Lists - Page 353
Filtering Data Lists - Page 354
Filtering Data Lists - Page 355
Filtering Data Lists - Page 356
Filtering Data Lists - Page 357
Filtering Data Lists - Page 358
Filtering Data Lists - Page 359
Importing External Data - Page 360
Importing External Data - Page 361
Importing External Data - Page 362
Importing External Data - Page 363
Importing External Data - Page 364
Chapter 12: Linking, Automating, and Sharing Spreadsheets - Page 365
Chapter 12: Linking, Automating, and Sharing Spreadsheets - Page 366
Chapter 12: Linking, Automating, and Sharing Spreadsheets - Page 367
Using Excel Add-Ins - Page 368
Adding Hyperlinks to a Worksheet - Page 369
Adding Hyperlinks to a Worksheet - Page 370
Adding Hyperlinks to a Worksheet - Page 371
Automating Commands with Macros - Page 372
Automating Commands with Macros - Page 373
Automating Commands with Macros - Page 374
Automating Commands with Macros - Page 375
Automating Commands with Macros - Page 376
Automating Commands with Macros - Page 377
Automating Commands with Macros - Page 378
Sharing Your Worksheets - Page 379
Sharing Your Worksheets - Page 380
Sharing Your Worksheets - Page 381
Sharing Your Worksheets - Page 382
Sharing Your Worksheets - Page 383
Sharing Your Worksheets - Page 384
Sharing Your Worksheets - Page 385
Sharing Your Worksheets - Page 386
Sharing Your Worksheets - Page 387
Sharing Your Worksheets - Page 388
Part VI: The Part of Tens - Page 389
Part VI: The Part of Tens - Page 390
Chapter 13: Top Ten Beginner Basics - Page 391
Chapter 13: Top Ten Beginner Basics - Page 392
Chapter 14: The Ten Commandments of Excel 2013 - Page 393
Chapter 14: The Ten Commandments of Excel 2013 - Page 394