Microsoft Excel 2010

Introducing Excel 2010 - Page 29
Spreadsheets Defined - Page 30
Spreadsheets Defined - Page 31
Excel Can Be Fun - Page 32
Getting Around the Worksheet and Data Entry - Page 33
Getting Around the Worksheet and Data Entry - Page 34
Getting Around the Worksheet and Data Entry - Page 35
Selecting Multiple Cells - Page 36
Selecting Cells Down and Across the Worksheet - Page 37
Selecting Cells with the Keyboard - Page 38
Still One More Selection Technique—The Name Box - Page 39
Entering Text and Data - Page 40
Aligning Your Data—Where It Appears in the Cell - Page 41
Aligning Your Data—Where It Appears in the Cell - Page 42
Widening and Narrowing Columns - Page 43
Using the Auto-fit Feature - Page 44
Using the Auto-fit Feature - Page 45
Entering Numerical Data—How it’s Different - Page 46
Entering Data into a Selected Range - Page 47
Entering Data into a Selected Range - Page 48
Entering Data into a Selected Range - Page 49
Using Auto Fill to Speed Up Data Entry - Page 50
Using Auto Fill to Speed Up Data Entry - Page 51
Using Auto Fill with Text - Page 52
Using Auto Fill with Text - Page 53
Using Auto Fill with Text - Page 54
Customizing Auto Fill Lists - Page 55
Data Validation: Bringing Quality Control to the Worksheet - Page 56
Data Validation: Bringing Quality Control to the Worksheet - Page 57
Data Validation: Bringing Quality Control to the Worksheet - Page 58
Making a List—Personalizing a Drop-Down Menu - Page 59
Making a List—Personalizing a Drop-Down Menu - Page 60
Explaining Data Validation Errors with Error Alerts - Page 61
Adding Data Entry Instructions with Input Messages - Page 62
Summary - Page 63
Editing Data - Page 64
Undoing an Edit - Page 65
Undoing an Edit - Page 66
Undoing What You’ve Just Undone with the Redo Button - Page 67
Copying Data - Page 68
Copying Data - Page 69
Moving Data - Page 70
Moving Data - Page 71
Summary - Page 72
Number Crunching 101: Functions, Formulas, and Ranges - Page 73
Adding a Column of Numbers - Page 74
Adding a Column of Numbers - Page 75
Selecting the Range You Need - Page 76
Viewing and Editing Your Formula: Back to the Formula Bar - Page 77
Viewing and Editing Your Formula: Back to the Formula Bar - Page 78
Calculating an Average - Page 79
Displaying Values Based on a Certain Condition - Page 80
Displaying Values Based on a Certain Condition - Page 81
Revisiting Function Structure - Page 82
Revisiting Function Structure - Page 83
Customizing the Worksheet with Formulas - Page 84
Writing a Basic Formula - Page 85
Working Out the Order of Operations in a Formula - Page 86
Copying Formulas: More Than Just Duplication - Page 87
Copying Formulas: More Than Just Duplication - Page 88
Copying Formulas: More Than Just Duplication - Page 89
Copying Formulas: More Than Just Duplication - Page 90
Copying Formulas: More Than Just Duplication - Page 91
Copying Formulas: More Than Just Duplication - Page 92
Copying Formulas: More Than Just Duplication - Page 93
Copying Formulas: More Than Just Duplication - Page 94
Clarifying Cell References by Naming a Range - Page 95
Clarifying Cell References by Naming a Range - Page 96
Clarifying Cell References by Naming a Range - Page 97
Clarifying Cell References by Naming a Range - Page 98
Naming Ranges from the Data in Your Worksheet - Page 99
Naming A Range Containing One Cell: Why Bother? - Page 100
The Name Manager: Where They’re All Ar-ranged - Page 101
Summary - Page 102
For Appearance’s Sake: Formatting Your Data - Page 103
Basic Formatting - Page 104
Basic Formatting - Page 105
Changing the Font Size - Page 106
Using Bold, Italics, and Underline - Page 107
Determining a Cell’s Formatting - Page 108
Adding a Border - Page 109
Adding a Border - Page 110
Adding Color to Your Cells - Page 111
Adding Color to Your Cells - Page 112
Adding Extra Formatting - Page 113
Aligning (and Realigning) Your Data - Page 114
Changing Vertical Alignment - Page 115
Changing Data Orientation - Page 116
Changing Data Orientation - Page 117
Changing Data Orientation - Page 118
Indenting Data - Page 119
Adding a Title with Merge and Center - Page 120
Inserting, Deleting, and Hiding Columns and Rows - Page 121
Inserting a Column or Row - Page 122
Inserting Multiple Columns or Rows - Page 123
What Inserting Does to Formulas - Page 124
Hiding Rows and Columns - Page 125
Hiding Rows and Columns - Page 126
Unhiding Columns and Rows - Page 127
Inserting and Deleting Cells - Page 128
Formatting Values: Making the Numbers Look Good - Page 129
Formatting Values: Making the Numbers Look Good - Page 130
Formatting Values: Making the Numbers Look Good - Page 131
Working with Percentages - Page 132
Formatting Decimal Points - Page 133
Working with Dates: Dates Are Numbers Too - Page 134
Working with Dates: Dates Are Numbers Too - Page 135
Working with Dates: Dates Are Numbers Too - Page 136
Customizing Number Formats - Page 137
The Custom Option - Page 138
The Custom Option - Page 139
Copying Formats (Not Data) with the Format Painter - Page 140
Applying Ready-Made Formats with Styles - Page 141
Customizing Your Own Style - Page 142
Customizing Your Own Style - Page 143
Applying Styles Quickly: Another Way to Access Formatting Options - Page 144
Conditional Formatting - Page 145
Conditional Formatting - Page 146
Conditional Formatting - Page 147
Conditional Formatting - Page 148
Looking for Scores Equal to or Greater Than 90 - Page 149
Some Additional Conditional Formatting Options - Page 150
Some Additional Conditional Formatting Options - Page 151
Turning Off Conditional Formatting - Page 152
Summary - Page 153
Charting Your Data - Page 154
Defining Chart Elements - Page 155
Choosing a Chart Type - Page 156
Choosing a Chart Type - Page 157
Creating a Column Chart - Page 158
Creating a Chart in 2 Seconds - Page 159
Creating a Chart in 2 Seconds - Page 160
Changing the Chart by Changing Its Data - Page 161
Changing the Chart Type - Page 162
Changing the Chart Type - Page 163
Changing the Chart Type - Page 164
Changing the Chart Type - Page 165
Where’s the Pie Chart? - Page 166
Switching Rows with Columns: A Different Kind of Change - Page 167
Formatting Charts - Page 168
Formatting with the Mini-Toolbar - Page 169
Formatting with the Context Menu - Page 170
Exploring the Format Dialog Box - Page 171
Exploring the Format Dialog Box - Page 172
Exploring the Format Dialog Box - Page 173
Reformatting the Vertical Axis - Page 174
Reformatting the Vertical Axis - Page 175
Color-Coordinating Your Data Using Chart Styles - Page 176
Formatting a Chart Object Using Shape Styles - Page 177
Formatting Text Elements with WordArt - Page 178
Adding Extra Chart Elements with Chart Layouts - Page 179
Adding Extra Chart Elements with the Layout Tab - Page 180
Adding Extra Chart Elements with the Layout Tab - Page 181
Adding Extra Chart Elements with the Layout Tab - Page 182
Adding Extra Chart Elements with the Layout Tab - Page 183
Adding Extra Chart Elements with the Layout Tab - Page 184
Adding Extra Chart Elements with the Layout Tab - Page 185
Adding Extra Chart Elements with the Layout Tab - Page 186
Adding Extra Chart Elements with the Layout Tab - Page 187
Introducing Sparklines: Mini-Charts Placed in Cells - Page 188
Introducing Sparklines: Mini-Charts Placed in Cells - Page 189
Modifying Sparklines - Page 190
Representing Binary Values with Sparklines - Page 191
Summary - Page 192
Sorting and Filtering Your Data: Excel’s Database Features - Page 193
Sorting Data: Instilling Order in Your Data - Page 194
Sorting Data: Instilling Order in Your Data - Page 195
Sorting Data: Instilling Order in Your Data - Page 196
Sorting by Two Fields: The Hows and Whys - Page 197
Sorting by Two Fields: The Hows and Whys - Page 198
Sorting by Cell Format - Page 199
Finding What You Want with Filters - Page 200
Finding What You Want with Filters - Page 201
Finding What You Want with Filters - Page 202
Clearing a Filter - Page 203
Clearing a Filter - Page 204
Clearing a Filter - Page 205
Filtering Multiple Fields - Page 206
Tables: Adding User-Friendliness to Your Database - Page 207
Tables: Adding User-Friendliness to Your Database - Page 208
Tables: Adding User-Friendliness to Your Database - Page 209
Tables: Adding User-Friendliness to Your Database - Page 210
Tables: Adding User-Friendliness to Your Database - Page 211
Tables: Adding User-Friendliness to Your Database - Page 212
Tables: Adding User-Friendliness to Your Database - Page 213
Finding Duplicate Records in the Table (and Removing Them) - Page 214
Converting a Table to a Range - Page 215
Summary - Page 216
PivotTables: Data Aggregation Without the Aggravation - Page 217
PivotTables: Data Aggregation Without the Aggravation - Page 218
PivotTables: Data Aggregation Without the Aggravation - Page 219
PivotTables: Data Aggregation Without the Aggravation - Page 220
PivotTables: Data Aggregation Without the Aggravation - Page 221
Creating a PivotTable - Page 222
Creating a PivotTable - Page 223
Creating a PivotTable - Page 224
Choosing Which Data to Work On - Page 225
Getting the Fields Where You Want Them - Page 226
Pivoting the Data Sideways Using the Column Labels Area - Page 227
Pivoting the Data Sideways Using the Column Labels Area - Page 228
Creating a Report Worksheet for Each Item in a Filter - Page 229
Counting Records: A Way to Break Out Text Data - Page 230
Counting Records: A Way to Break Out Text Data - Page 231
Grouping Related Items Ussing Two Fields - Page 232
Grouping Related Items Ussing Two Fields - Page 233
Grouping Related Items Ussing Two Fields - Page 234
Using the Row and Column Value Areas to Group Items - Page 235
Using the Row and Column Value Areas to Group Items - Page 236
Grouping PivotTable Data: Organizing Your Time(s) - Page 237
Refreshing the PivotTable: Changing the Data - Page 238
Adding New Records to a PivotTable - Page 239
Viewing Which Records Are Filtered: Using the Slicer - Page 240
How the Slicer Works - Page 241
How the Slicer Works - Page 242
How the Slicer Works - Page 243
Restyling the Slicer - Page 244
Formatting the PivotTable - Page 245
Formatting the PivotTable - Page 246
Styling Your Report - Page 247
Changing PivotTable Headers - Page 248
Layout Options - Page 249
Layout Options - Page 250
Creating Charts from PivotTables Using PivotCharts - Page 251
Creating Charts from PivotTables Using PivotCharts - Page 252
Creating Charts from PivotTables Using PivotCharts - Page 253
Filtering Data in the Chart with Field Buttons - Page 254
Filtering Data in the Chart with Field Buttons - Page 255
Creating a PivotTable and PivotChart Together - Page 256
Summary - Page 257
Managing Your Workbook - Page 258
Clicking Through the Worksheets - Page 259
Adding and Moving New Worksheets - Page 260
Adding and Moving New Worksheets - Page 261
Deleting Sheets - Page 262
Copying a Sheet - Page 263
Hiding Sheets - Page 264
Grouping Sheets: Changing Multiple Sheets at the Same Time - Page 265
How to Group Sheets - Page 266
Referring to Cells in Other Worksheets: Using Them in Formulas - Page 267
Using Ranges on Other Sheets in Formulas - Page 268
Using Ranges on Other Sheets in Formulas - Page 269
Using the View Context Tab to Show and Hide Basic Screen Elements - Page 270
Showing Formulas in Cells - Page 271
Hiding the Ribbon - Page 272
Keeping Important Data in View with the Freeze Panes Option - Page 273
Keeping Important Data in View with the Freeze Panes Option - Page 274
Freezing Rows and Columns at the Same Time - Page 275
Protecting the Worksheet and the Workbook - Page 276
Protecting a Worksheet - Page 277
Using a Password: Some Extra Protection - Page 278
Unprotecting a Worksheet - Page 279
Unprotecting a Worksheet - Page 280
Hiding Formulas - Page 281
Hiding Formulas - Page 282
Protecting a Workbook - Page 283
Protecting a Workbook - Page 284
Unprotecting a Workbook - Page 285
Printing Your Worksheets: Hard Copies Made Easy - Page 286
Printing a Selection - Page 287
Printing a Selection - Page 288
Printing a Selection - Page 289
Printing a Selection - Page 290
Surveying Printing Options: The Print Backstage - Page 291
Surveying Printing Options: The Print Backstage - Page 292
Surveying Printing Options: The Print Backstage - Page 293
Surveying Printing Options: The Print Backstage - Page 294
Surveying Printing Options: The Print Backstage - Page 295
Surveying Printing Options: The Print Backstage - Page 296
Setting the Print Area - Page 297
Setting the Print Area - Page 298
Customizing Your Printing - Page 299
Customizing Your Printing - Page 300
Customizing Your Printing - Page 301
Previewing the Page Break: Getting a Bird’s-Eye View of the Printout - Page 302
Previewing the Page Break: Getting a Bird’s-Eye View of the Printout - Page 303
Previewing the Page Break: Getting a Bird’s-Eye View of the Printout - Page 304
Printing Titles - Page 305
Printing Titles - Page 306
Printing Titles - Page 307
Printing Titles - Page 308
Adding Headers and Footers - Page 309
Adding Headers and Footers - Page 310
Adding Headers and Footers Using the Page Setup Dialog Box - Page 311
Adding Headers and Footers Using the Page Setup Dialog Box - Page 312
Adding Custom Headers and Footers - Page 313
Adding Custom Headers and Footers - Page 314
Adding Custom Headers and Footers - Page 315
Printing the Gridlines and Headings - Page 316
Printing the Gridlines and Headings - Page 317
Summary - Page 318
Automating Your Work with Macros - Page 319
Composing a Macro - Page 320
Composing a Macro - Page 321
About Saving a Workbook with a Macro - Page 322
Playing Back the Macro - Page 323
What We’ve Done - Page 324
What We’ve Done - Page 325
Saving a Macro to the Personal Macro Workbook - Page 326
Saving a Macro to the Personal Macro Workbook - Page 327
Deleting a Macro - Page 328
VBA: Written Behind the Scenes - Page 329
VBA: Written Behind the Scenes - Page 330
Activating a Macro with a Keyboard Shortcut - Page 331
Activating a Macro with a Keyboard Shortcut - Page 332
A Note on Macro Security - Page 333
Summary - Page 334