Microsoft Excel 2013 (Step by Step)

Chapter 1: Getting started with Excel 2013 - Page 20
Identifying the different Excel 2013 programs - Page 21
Identifying the different Excel 2013 programs - Page 22
Identifying new features of Excel 2013 - Page 23
If you are upgrading from Excel 2007 - Page 24
If you are upgrading from Excel 2007 - Page 25
If you are upgrading from Excel 2003 - Page 26
Working with the ribbon - Page 27
Working with the ribbon - Page 28
Working with the ribbon - Page 29
Customizing the Excel 2013 - Page 30
Arranging multiple workbook windows - Page 31
Arranging multiple workbook windows - Page 32
Arranging multiple workbook windows - Page 33
Arranging multiple workbook windows - Page 34
Adding buttons to the Quick Access Toolbar - Page 35
Adding buttons to the Quick Access Toolbar - Page 36
Customizing the ribbon - Page 37
Customizing the ribbon - Page 38
Customizing the ribbon - Page 39
Maximizing usable space in the program window - Page 40
Maximizing usable space in the program window - Page 41
Creating workbooks - Page 42
Creating workbooks - Page 43
Creating workbooks - Page 44
Creating workbooks - Page 45
Creating workbooks - Page 46
Modifying workbooks - Page 47
Modifying workbooks - Page 48
Modifying workbooks - Page 49
Modifying workbooks - Page 50
Modifying worksheets - Page 51
Inserting rows, columns, and cells - Page 52
Inserting rows, columns, and cells - Page 53
Inserting rows, columns, and cells - Page 54
Inserting rows, columns, and cells - Page 55
Merging and unmerging cells - Page 56
Merging and unmerging cells - Page 57
Merging and unmerging cells - Page 58
Merging and unmerging cells - Page 59
Key points - Page 60
Key points - Page 61
Chapter 2: Working with data and Excel tables - Page 62
Entering and revising data - Page 63
Entering and revising data - Page 64
Entering and revising data - Page 65
Entering and revising data - Page 66
Managing data by using Flash Fill - Page 67
Managing data by using Flash Fill - Page 68
Managing data by using Flash Fill - Page 69
Managing data by using Flash Fill - Page 70
Moving data within a workbook - Page 71
Moving data within a workbook - Page 72
Moving data within a workbook - Page 73
Moving data within a workbook - Page 74
Finding and replacing data - Page 75
Finding and replacing data - Page 76
Finding and replacing data - Page 77
Finding and replacing data - Page 78
Correcting and expanding upon worksheet data - Page 79
Correcting and expanding upon worksheet data - Page 80
Correcting and expanding upon worksheet data - Page 81
Correcting and expanding upon worksheet data - Page 82
Correcting and expanding upon worksheet data - Page 83
Defining Excel tables - Page 84
Defining Excel tables - Page 85
Defining Excel tables - Page 86
Defining Excel tables - Page 87
Defining Excel tables - Page 88
Key points - Page 89
Key points - Page 90
Key points - Page 91
Chapter 3: Performing calculations on data - Page 92
Naming groups of data - Page 93
Naming groups of data - Page 94
Naming groups of data - Page 95
Naming groups of data - Page 96
Naming groups of data - Page 97
Creating formulas to calculate values - Page 98
Creating formulas to calculate values - Page 99
Creating formulas to calculate values - Page 100
Creating formulas to calculate values - Page 101
Creating formulas to calculate values - Page 102
Creating formulas to calculate values - Page 103
Creating formulas to calculate values - Page 104
Creating formulas to calculate values - Page 105
Creating formulas to calculate values - Page 106
Summarizing data that meets specific conditions - Page 107
Summarizing data that meets specific conditions - Page 108
Summarizing data that meets specific conditions - Page 109
Summarizing data that meets specific conditions - Page 110
Working with iterative calculation options and automatic workbook calculation - Page 111
Working with iterative calculation options and automatic workbook calculation - Page 112
Using array formulas - Page 113
Using array formulas - Page 114
Using array formulas - Page 115
Finding and correcting errors in calculations - Page 116
Finding and correcting errors in calculations - Page 117
Finding and correcting errors in calculations - Page 118
Finding and correcting errors in calculations - Page 119
Finding and correcting errors in calculations - Page 120
Finding and correcting errors in calculations - Page 121
Key points - Page 122
Key points - Page 123
Chapter 4: Changing workbook appearance - Page 124
Formatting cells - Page 125
Formatting cells - Page 126
Formatting cells - Page 127
Formatting cells - Page 128
Formatting cells - Page 129
Defining styles - Page 130
Defining styles - Page 131
Defining styles - Page 132
Defining styles - Page 133
Defining styles - Page 134
Defining styles - Page 135
Applying workbook themes and - Page 136
Applying workbook themes and - Page 137
Applying workbook themes and - Page 138
Applying workbook themes and - Page 139
Applying workbook themes and - Page 140
Applying workbook themes and - Page 141
Making numbers easier to read - Page 142
Making numbers easier to read - Page 143
Making numbers easier to read - Page 144
Making numbers easier to read - Page 145
Making numbers easier to read - Page 146
Making numbers easier to read - Page 147
Changing the appearance of data - Page 148
Changing the appearance of data - Page 149
Changing the appearance of data - Page 150
Changing the appearance of data - Page 151
Changing the appearance of data - Page 152
Changing the appearance of data - Page 153
Changing the appearance of data - Page 154
Adding images to worksheets - Page 155
Adding images to worksheets - Page 156
Adding images to worksheets - Page 157
Adding images to worksheets - Page 158
Key points - Page 159
Key points - Page 160
Key points - Page 161
Chapter 5: Focusing on specific data by using filters - Page 162
Limiting data that appears on your screen - Page 163
Limiting data that appears on your screen - Page 164
Limiting data that appears on your screen - Page 165
Limiting data that appears on your screen - Page 166
Limiting data that appears on your screen - Page 167
Limiting data that appears on your screen - Page 168
Limiting data that appears on your screen - Page 169
Filtering Excel table data by using slicers - Page 170
Filtering Excel table data by using slicers - Page 171
Filtering Excel table data by using slicers - Page 172
Filtering Excel table data by using slicers - Page 173
Filtering Excel table data by using slicers - Page 174
Manipulating worksheet data - Page 175
Summarizing worksheets by using hidden and filtered rows - Page 176
Summarizing worksheets by using hidden and filtered rows - Page 177
Summarizing worksheets by using hidden and filtered rows - Page 178
Summarizing worksheets by using hidden and filtered rows - Page 179
Finding unique values within a data set - Page 180
Finding unique values within a data set - Page 181
Finding unique values within a data set - Page 182
Defining valid sets of values for - Page 183
Defining valid sets of values for - Page 184
Defining valid sets of values for - Page 185
Defining valid sets of values for - Page 186
Defining valid sets of values for - Page 187
Key points - Page 188
Key points - Page 189
Chapter 6: Reordering and summarizing data - Page 190
Sorting worksheet data - Page 191
Sorting worksheet data - Page 192
Sorting worksheet data - Page 193
Sorting worksheet data - Page 194
Sorting worksheet data - Page 195
Sorting data by using custom lists - Page 196
Sorting data by using custom lists - Page 197
Sorting data by using custom lists - Page 198
Sorting data by using custom lists - Page 199
Organizing data into levels - Page 200
Organizing data into levels - Page 201
Organizing data into levels - Page 202
Organizing data into levels - Page 203
Organizing data into levels - Page 204
Organizing data into levels - Page 205
Looking up information in a worksheet - Page 206
Looking up information in a worksheet - Page 207
Looking up information in a worksheet - Page 208
Looking up information in a worksheet - Page 209
Key points - Page 210
Key points - Page 211
Chapter 7: Combining data from multiple sources - Page 212
Using workbooks as templates - Page 213
Using workbooks as templates - Page 214
Using workbooks as templates - Page 215
Using workbooks as templates - Page 216
Using workbooks as templates - Page 217
Using workbooks as templates - Page 218
Using workbooks as templates - Page 219
Using workbooks as templates - Page 220
Linking to data in other - Page 221
Linking to data in other - Page 222
Linking to data in other - Page 223
Linking to data in other - Page 224
Linking to data in other - Page 225
Consolidating multiple sets of data - Page 226
Consolidating multiple sets of data - Page 227
Consolidating multiple sets of data - Page 228
Consolidating multiple sets of data - Page 229
Key points - Page 230
Key points - Page 231
Chapter 8: Analyzing data and alternative data sets - Page 232
Examining data by using the - Page 233
Examining data by using the - Page 234
Examining data by using the - Page 235
Defining an alternative data set - Page 236
Defining an alternative data set - Page 237
Defining an alternative data set - Page 238
Defining an alternative data set - Page 239
Defining multiple alternative data sets - Page 240
Defining multiple alternative data sets - Page 241
Defining multiple alternative data sets - Page 242
Defining multiple alternative data sets - Page 243
Analyzing data by using data tables - Page 244
Analyzing data by using data tables - Page 245
Analyzing data by using data tables - Page 246
Varying your data to get a specific result by using Goal Seek - Page 247
Varying your data to get a specific result by using Goal Seek - Page 248
Varying your data to get a specific result by using Goal Seek - Page 249
Finding optimal solutions by using Solver - Page 250
Finding optimal solutions by using Solver - Page 251
Finding optimal solutions by using Solver - Page 252
Finding optimal solutions by using Solver - Page 253
Finding optimal solutions by using Solver - Page 254
Finding optimal solutions by using Solver - Page 255
Finding optimal solutions by using Solver - Page 256
Analyzing data by using descriptive statistics - Page 257
Analyzing data by using descriptive statistics - Page 258
Key points - Page 259
Key points - Page 260
Key points - Page 261
Chapter 9: Creating charts and graphics - Page 262
Creating charts - Page 263
Creating charts - Page 264
Creating charts - Page 265
Creating charts - Page 266
Creating charts - Page 267
Creating charts - Page 268
Creating charts - Page 269
Creating charts - Page 270
Customizing the appearance of charts - Page 271
Customizing the appearance of charts - Page 272
Customizing the appearance of charts - Page 273
Customizing the appearance of charts - Page 274
Customizing the appearance of charts - Page 275
Customizing the appearance of charts - Page 276
Customizing the appearance of charts - Page 277
Customizing the appearance of charts - Page 278
Finding trends in your data - Page 279
Finding trends in your data - Page 280
Finding trends in your data - Page 281
Creating dual-axis charts - Page 282
Creating dual-axis charts - Page 283
Creating dual-axis charts - Page 284
Creating dual-axis charts - Page 285
Summarizing your data by using sparklines - Page 286
Summarizing your data by using sparklines - Page 287
Summarizing your data by using sparklines - Page 288
Summarizing your data by using sparklines - Page 289
Creating diagrams by using SmartArt - Page 290
Creating diagrams by using SmartArt - Page 291
Creating diagrams by using SmartArt - Page 292
Creating diagrams by using SmartArt - Page 293
Creating diagrams by using SmartArt - Page 294
Creating shapes and mathematical equations - Page 295
Creating shapes and mathematical equations - Page 296
Creating shapes and mathematical equations - Page 297
Creating shapes and mathematical equations - Page 298
Creating shapes and mathematical equations - Page 299
Creating shapes and mathematical equations - Page 300
Creating shapes and mathematical equations - Page 301
Key points - Page 302
Key points - Page 303
Chapter 10: Using PivotTables and PivotCharts - Page 304
Analyzing data dynamically by using PivotTables - Page 305
Analyzing data dynamically by using PivotTables - Page 306
Analyzing data dynamically by using PivotTables - Page 307
Analyzing data dynamically by using PivotTables - Page 308
Analyzing data dynamically by using PivotTables - Page 309
Analyzing data dynamically by using PivotTables - Page 310
Analyzing data dynamically by using PivotTables - Page 311
Analyzing data dynamically by using PivotTables - Page 312
Analyzing data dynamically by using PivotTables - Page 313
Analyzing data dynamically by using PivotTables - Page 314
Filtering, showing, and hiding PivotTable data - Page 315
Filtering, showing, and hiding PivotTable data - Page 316
Filtering, showing, and hiding PivotTable data - Page 317
Filtering, showing, and hiding PivotTable data - Page 318
Filtering, showing, and hiding PivotTable data - Page 319
Filtering, showing, and hiding PivotTable data - Page 320
Filtering, showing, and hiding PivotTable data - Page 321
Filtering, showing, and hiding PivotTable data - Page 322
Filtering, showing, and hiding PivotTable data - Page 323
Editing PivotTables - Page 324
Editing PivotTables - Page 325
Editing PivotTables - Page 326
Editing PivotTables - Page 327
Editing PivotTables - Page 328
Editing PivotTables - Page 329
Formatting PivotTables - Page 330
Formatting PivotTables - Page 331
Formatting PivotTables - Page 332
Formatting PivotTables - Page 333
Formatting PivotTables - Page 334
Formatting PivotTables - Page 335
Formatting PivotTables - Page 336
Formatting PivotTables - Page 337
Creating PivotTables from external data - Page 338
Creating PivotTables from external data - Page 339
Creating PivotTables from external data - Page 340
Creating PivotTables from external data - Page 341
Creating PivotTables from external data - Page 342
Creating dynamic charts by using PivotCharts - Page 343
Creating dynamic charts by using PivotCharts - Page 344
Creating dynamic charts by using PivotCharts - Page 345
Creating dynamic charts by using PivotCharts - Page 346
Creating dynamic charts by using PivotCharts - Page 347
Key points - Page 348
Key points - Page 349
Chapter 11: Printing worksheets and charts - Page 350
Adding headers and footers to printed pages - Page 351
Adding headers and footers to printed pages - Page 352
Adding headers and footers to printed pages - Page 353
Adding headers and footers to printed pages - Page 354
Adding headers and footers to printed pages - Page 355
Adding headers and footers to printed pages - Page 356
Preparing worksheets for printing - Page 357
Preparing worksheets for printing - Page 358
Preparing worksheets for printing - Page 359
Previewing worksheets before printing - Page 360
Previewing worksheets before printing - Page 361
Changing the page printing order for worksheets - Page 362
Changing the page printing order for worksheets - Page 363
Changing the page printing order for worksheets - Page 364
Printing worksheets - Page 365
Printing worksheets - Page 366
Printing worksheets - Page 367
Printing worksheets - Page 368
Printing parts of worksheets - Page 369
Printing parts of worksheets - Page 370
Printing parts of worksheets - Page 371
Printing parts of worksheets - Page 372
Printing parts of worksheets - Page 373
Printing charts - Page 374
Printing charts - Page 375
Key points - Page 376
Key points - Page 377
Chapter 12: Working with macros and forms - Page 378
Enabling and examining macros - Page 379
Enabling and examining macros - Page 380
Examining macros - Page 381
Examining macros - Page 382
Examining macros - Page 383
Examining macros - Page 384
Examining macros - Page 385
Creating and modifying macros - Page 386
Creating and modifying macros - Page 387
Creating and modifying macros - Page 388
Running macros when a button is clicked - Page 389
Running macros when a button is clicked - Page 390
Running macros when a button is clicked - Page 391
Running macros when a button is clicked - Page 392
Running macros when a workbook is opened - Page 393
Running macros when a workbook is opened - Page 394
Running macros when a workbook is opened - Page 395
Inserting form controls and setting form properties - Page 396
Adding list boxes to UserForms - Page 397
Adding combo boxes to UserForms - Page 398
Adding combo boxes to UserForms - Page 399
Adding graphics to UserForms - Page 400
Adding spin buttons to UserForms - Page 401
Writing UserForm data to a worksheet - Page 402
Displaying, loading, and hiding UserForms - Page 403
Displaying, loading, and hiding UserForms - Page 404
Displaying, loading, and hiding UserForms - Page 405
Displaying, loading, and hiding UserForms - Page 406
Displaying, loading, and hiding UserForms - Page 407
Key points - Page 408
Key points - Page 409
Chapter 13: Working with other Office programs - Page 410
Linking to Office documents from workbooks - Page 411
Linking to Office documents from workbooks - Page 412
Linking to Office documents from workbooks - Page 413
Linking to Office documents from workbooks - Page 414
Embedding workbooks into other Office documents - Page 415
Embedding workbooks into other Office documents - Page 416
Embedding workbooks into other Office documents - Page 417
Creating hyperlinks - Page 418
Creating hyperlinks - Page 419
Creating hyperlinks - Page 420
Creating hyperlinks - Page 421
Creating hyperlinks - Page 422
Creating hyperlinks - Page 423
Pasting charts into other Office documents - Page 424
Pasting charts into other Office documents - Page 425
Key points - Page 426
Key points - Page 427
Chapter 14: Collaborating with colleagues - Page 428
Sharing workbooks - Page 429
Sharing workbooks - Page 430
Sharing workbooks - Page 431
Sharing workbooks - Page 432
Saving workbooks for electronic distribution - Page 433
Saving workbooks for electronic distribution - Page 434
Managing comments - Page 435
Managing comments - Page 436
Tracking and managing colleagues’ changes - Page 437
Tracking and managing colleagues’ changes - Page 438
Tracking and managing colleagues’ changes - Page 439
Tracking and managing colleagues’ changes - Page 440
Protecting workbooks and worksheets - Page 441
Protecting workbooks and worksheets - Page 442
Protecting workbooks and worksheets - Page 443
Protecting workbooks and worksheets - Page 444
Protecting workbooks and worksheets - Page 445
Protecting workbooks and worksheets - Page 446
Protecting workbooks and worksheets - Page 447
Protecting workbooks and worksheets - Page 448
Protecting workbooks and worksheets - Page 449
Authenticating workbooks - Page 450
Authenticating workbooks - Page 451
Authenticating workbooks - Page 452
Saving workbooks as web content - Page 453
Saving workbooks as web content - Page 454
Saving workbooks as web content - Page 455
Saving workbooks as web content - Page 456
Saving workbooks as web content - Page 457
Importing and exporting XML data - Page 458
Importing and exporting XML data - Page 459
Importing and exporting XML data - Page 460
Importing and exporting XML data - Page 461
Importing and exporting XML data - Page 462
Working with SkyDrive and Excel Web App - Page 463
Working with SkyDrive and Excel Web App - Page 464
Working with SkyDrive and Excel Web App - Page 465
Working with SkyDrive and Excel Web App - Page 466
Working with SkyDrive and Excel Web App - Page 467
Key points - Page 468