Microsoft Excel 2010

PART I: JUST THE BASICS - Page 22
PART I: JUST THE BASICS - Page 23
Chapter 1 Creating a Basic Excel Worksheet - Page 24
Exploring Excel - Page 25
Exploring Excel - Page 26
Exploring Excel - Page 27
Exploring Excel - Page 28
Exploring Excel - Page 29
Exploring Excel - Page 30
Moving Around the Excel Screen - Page 31
Moving Around the Excel Screen - Page 32
Moving Around the Excel Screen - Page 33
Entering Excel Data - Page 34
Entering Excel Data - Page 35
Entering Excel Data - Page 36
Entering Excel Data - Page 37
Selecting Cells on a Spreadsheet - Page 38
Selecting Cells on a Spreadsheet - Page 39
Editing a Worksheet - Page 40
Editing a Worksheet - Page 41
Editing a Worksheet - Page 42
Moving and Copying Data - Page 43
Moving and Copying Data - Page 44
Working with Range Names - Page 45
Working with Range Names - Page 46
Working with Range Names - Page 47
Working with Range Names - Page 48
Working with Range Names - Page 49
Working with Range Names - Page 50
Working with Range Names - Page 51
Working with Range Names - Page 52
Working with Range Names - Page 53
Chapter 2 Working with Formulas - Page 54
Creating Formulas - Page 55
Creating Formulas - Page 56
Creating Formulas - Page 57
Creating Formulas - Page 58
Creating Formulas - Page 59
Creating Formulas - Page 60
Editing Formulas - Page 61
Editing Formulas - Page 62
Controlling Recalculation - Page 63
Copying Formulas - Page 64
Copying Formulas - Page 65
Copying Formulas - Page 66
Copying Formulas - Page 67
Creating an Absolute or Mixed Formula Reference - Page 68
Creating an Absolute or Mixed Formula Reference - Page 69
Creating an Absolute or Mixed Formula Reference - Page 70
Creating an Absolute or Mixed Formula Reference - Page 71
Chapter 3 Using Excel Functions - Page 72
Considering Form versus Function - Page 73
Understanding Function Syntax - Page 74
Creating a Total with the SUM Function - Page 75
Creating a Total with the SUM Function - Page 76
Creating a Total with the SUM Function - Page 77
Creating a Total with the SUM Function - Page 78
Creating a Total with the SUM Function - Page 79
Creating a Total with the SUM Function - Page 80
Creating a Total with the SUM Function - Page 81
Creating a Total with the SUM Function - Page 82
Calculating Results Without Entering a Formula - Page 83
Nesting Functions - Page 84
Nesting Functions - Page 85
Using Other Functions - Page 86
Using Other Functions - Page 87
Using Other Functions - Page 88
Using Other Functions - Page 89
Using Other Functions - Page 90
Using Other Functions - Page 91
Using Other Functions - Page 92
Using Other Functions - Page 93
Using Other Functions - Page 94
Using Other Functions - Page 95
Using Other Functions - Page 96
Using Other Functions - Page 97
Using Other Functions - Page 98
Using Other Functions - Page 99
Using Other Functions - Page 100
Using Other Functions - Page 101
Chapter 4 Troubleshooting Formula Errors - Page 102
Displaying Formulas in a Worksheet - Page 103
Understanding How Excel Handles Formula Errors - Page 104
Understanding How Excel Handles Formula Errors - Page 105
Understanding How Excel Handles Formula Errors - Page 106
Understanding How Excel Handles Formula Errors - Page 107
Understanding How Excel Handles Formula Errors - Page 108
Telling Excel Which Errors to Flag - Page 109
Telling Excel Which Errors to Flag - Page 110
Telling Excel to Flag Result Cells with an Error - Page 111
Telling Excel to Flag Result Cells with an Error - Page 112
Checking for Errors Automatically One at a Time - Page 113
Checking for Errors Automatically One at a Time - Page 114
Checking for Errors Automatically One at a Time - Page 115
Checking for Errors Automatically One at a Time - Page 116
Checking for Errors Automatically One at a Time - Page 117
Checking for Errors Automatically One at a Time - Page 118
Checking for Errors Automatically One at a Time - Page 119
Controlling Whether Errors Print - Page 120
Controlling Whether Errors Print - Page 121
Chapter 5 Making the Worksheet Look Good - Page 122
Adjusting Columns and Rows - Page 123
Adjusting Columns and Rows - Page 124
Adjusting Columns and Rows - Page 125
Adjusting Columns and Rows - Page 126
Adjusting Columns and Rows - Page 127
Adjusting Columns and Rows - Page 128
Adjusting Columns and Rows - Page 129
Adjusting Columns and Rows - Page 130
Formatting Cell Content - Page 131
Formatting Cell Content - Page 132
Formatting Cell Content - Page 133
Formatting Cell Content - Page 134
Formatting Cell Content - Page 135
Applying Numeric Formatting - Page 136
Applying Numeric Formatting - Page 137
Applying Conditional Formatting - Page 138
Applying Conditional Formatting - Page 139
Applying Conditional Formatting - Page 140
Applying Conditional Formatting - Page 141
Applying Conditional Formatting - Page 142
Applying Office Themes and Layouts - Page 143
Applying Office Themes and Layouts - Page 144
Applying Office Themes and Layouts - Page 145
PART II: HANDLING LARGER WORKBOOKS - Page 146
PART II: HANDLING LARGER WORKBOOKS - Page 147
Chapter 6 Managing Large Amounts of Excel Data - Page 148
Working with Multiple Worksheets - Page 149
Working with Multiple Worksheets - Page 150
Working with Multiple Worksheets - Page 151
Working with Multiple Worksheets - Page 152
Working with Multiple Worksheets - Page 153
Working with Multiple Worksheets - Page 154
Working with Multiple Worksheets - Page 155
Working with Multiple Worksheets - Page 156
Working with Multiple Worksheets - Page 157
Working with Multiple Worksheets - Page 158
Working with Multiple Worksheets - Page 159
Working with Multiple Worksheets - Page 160
Working with Multiple Worksheets - Page 161
Working with Multiple Worksheets - Page 162
Working with Multiple Worksheets - Page 163
Working with Multiple Worksheets - Page 164
Using Find and Replace - Page 165
Using Find and Replace - Page 166
Using Find and Replace - Page 167
Using Find and Replace - Page 168
Managing Worksheet Views - Page 169
Managing Worksheet Views - Page 170
Managing Worksheet Views - Page 171
Managing Worksheet Views - Page 172
Managing Worksheet Views - Page 173
Managing Worksheet Views - Page 174
Managing Worksheet Views - Page 175
Managing Worksheet Views - Page 176
Managing Worksheet Views - Page 177
Chapter 7 Sorting Data - Page 178
Sorting from the Ribbon - Page 179
Working with the Sort Command - Page 180
Working with the Sort Command - Page 181
Working with the Sort Command - Page 182
Working with the Sort Command - Page 183
Creating a Subtotal Report - Page 184
Creating a Subtotal Report - Page 185
Creating a Subtotal Report - Page 186
Creating a Subtotal Report - Page 187
Creating Manual Groups from Sorted Rows - Page 188
Creating Manual Groups from Sorted Rows - Page 189
Chapter 8 Filtering Data - Page 190
Creating an AutoFilter - Page 191
Creating an AutoFilter - Page 192
Creating an AutoFilter - Page 193
Creating an AutoFilter - Page 194
Performing a Secondary Filter Selection - Page 195
Exploring Special Filters - Page 196
Exploring Special Filters - Page 197
Exploring Special Filters - Page 198
Exploring Special Filters - Page 199
Creating Custom Filters - Page 200
Creating Custom Filters - Page 201
Using Formulas with Filtered Data - Page 202
Using Formulas with Filtered Data - Page 203
Chapter 9 Preparing to Print - Page 204
Setting the Print Area - Page 205
Previewing Your Worksheet - Page 206
Previewing Your Worksheet - Page 207
Previewing Your Worksheet - Page 208
Adjusting Page Layout - Page 209
Adjusting Page Layout - Page 210
Adjusting Page Layout - Page 211
Adjusting Page Layout - Page 212
Adjusting Page Layout - Page 213
Adjusting Page Layout - Page 214
Adding Headers and Footers - Page 215
Adding Headers and Footers - Page 216
Adding Headers and Footers - Page 217
Inserting a Watermark - Page 218
Inserting a Watermark - Page 219
Chapter 10 Printing and Other Output Formats - Page 220
Printing Your Workbooks - Page 221
Handling Special Printing Needs - Page 222
Handling Special Printing Needs - Page 223
Handling Special Printing Needs - Page 224
Handling Special Printing Needs - Page 225
Handling Special Printing Needs - Page 226
Handling Special Printing Needs - Page 227
Printing Charts - Page 228
Printing a Draft - Page 229
Changing Printers - Page 230
Printing Without Opening Excel - Page 231
Choosing an Alternative to Printing - Page 232
Choosing an Alternative to Printing - Page 233
Printing from the Quick Access Toolbar - Page 234
Printing from the Quick Access Toolbar - Page 235
PART III: WORKING WITH GRAPHICS - Page 236
PART III: WORKING WITH GRAPHICS - Page 237
Chapter 11 Generating Excel Charts - Page 238
Creating a Basic Chart - Page 239
Creating a Basic Chart - Page 240
Creating a Basic Chart - Page 241
Creating a Basic Chart - Page 242
Creating a Basic Chart - Page 243
Creating a Basic Chart - Page 244
Creating a Basic Chart - Page 245
Changing the Chart Options - Page 246
Changing the Chart Options - Page 247
Changing the Chart Options - Page 248
Changing the Chart Options - Page 249
Changing the Chart Options - Page 250
Changing the Chart Options - Page 251
Changing the Chart Options - Page 252
Changing the Chart Options - Page 253
Changing the Chart Options - Page 254
Changing the Chart Options - Page 255
Changing the Chart Options - Page 256
Changing the Chart Options - Page 257
Chapter 12 Inserting Illustrations - Page 258
Designing with Illustrations - Page 259
Designing with Illustrations - Page 260
Formatting Illustrations - Page 261
Formatting Illustrations - Page 262
Formatting Illustrations - Page 263
Formatting Illustrations - Page 264
Working with Shapes - Page 265
Creating SmartArt - Page 266
Creating SmartArt - Page 267
Creating SmartArt - Page 268
Creating SmartArt - Page 269
Using Screenshots - Page 270
Using Screenshots - Page 271
Adding WordArt - Page 272
Adding WordArt - Page 273
PART IV: USING EXCEL TOOLS - Page 274
PART IV: USING EXCEL TOOLS - Page 275
Chapter 13 Setting Security Options - Page 276
Inspecting for Private Information - Page 277
Hiding Data - Page 278
Hiding Data - Page 279
Hiding Data - Page 280
Protecting Data - Page 281
Protecting Data - Page 282
Protecting Data - Page 283
Protecting Data - Page 284
Marking a Workbook as Final - Page 285
Marking a Workbook as Final - Page 286
Marking a Workbook as Final - Page 287
Chapter 14 Collaborating with Others - Page 288
Considering Your Collaboration Options - Page 289
Considering Your Collaboration Options - Page 290
Considering Your Collaboration Options - Page 291
Considering Your Collaboration Options - Page 292
Considering Your Collaboration Options - Page 293
Considering Your Collaboration Options - Page 294
Considering Your Collaboration Options - Page 295
Considering Your Collaboration Options - Page 296
Using Comments in Collaboration - Page 297
Using Comments in Collaboration - Page 298
Using Comments in Collaboration - Page 299
Validating Excel Worksheet Content - Page 300
Validating Excel Worksheet Content - Page 301
Validating Excel Worksheet Content - Page 302
Validating Excel Worksheet Content - Page 303
Validating Excel Worksheet Content - Page 304
Importing and Exporting Your Excel Content - Page 305
Importing and Exporting Your Excel Content - Page 306
Importing and Exporting Your Excel Content - Page 307
Importing and Exporting Your Excel Content - Page 308
Importing and Exporting Your Excel Content - Page 309
Importing and Exporting Your Excel Content - Page 310
Importing and Exporting Your Excel Content - Page 311
Importing and Exporting Your Excel Content - Page 312
Importing and Exporting Your Excel Content - Page 313
Chapter 15 Using PivotTables - Page 314
Creating a PivotTable - Page 315
Creating a PivotTable - Page 316
Creating a PivotTable - Page 317
Creating a PivotTable - Page 318
Using the PivotTable Tools - Page 319
Using the PivotTable Tools - Page 320
Using the PivotTable Tools - Page 321
Using the PivotTable Tools - Page 322
Sorting and Filtering PivotTable Data - Page 323
Sorting and Filtering PivotTable Data - Page 324
Sorting and Filtering PivotTable Data - Page 325
Sorting and Filtering PivotTable Data - Page 326
Formatting Your PivotTable - Page 327
Creating a PivotChart - Page 328
Creating a PivotChart - Page 329
Creating a PivotChart - Page 330
Creating a PivotChart - Page 331