Microsoft Excel 2013

Section 1: About this book - Page 17
No computerese! - Page 18
No computerese! - Page 19
No computerese! - Page 20
A few assumptions - Page 21
A final word (or two) - Page 22
Section 2: What’s new and improved in Excel 2013 - Page 23
Using Excel 2013 in Windows 8 - Page 24
Analyzing data instantly by using the Quick Analysis tool - Page 25
Entering data quickly by using Flash Fill - Page 26
Creating the right chart by using chart recommendations - Page 27
Filtering Excel tables by using slicers - Page 28
Filtering Excel tables by using slicers - Page 29
Creating a recommended PivotTable - Page 30
Editing a workbook in SkyDrive and the Excel Web App - Page 31
Formatting charts by using the new tools interface - Page 32
Section 3: Getting started with Excel 2013 - Page 33
Surveying the Excel program window - Page 34
Surveying the Excel program window - Page 35
Starting Excel - Page 36
Starting Excel - Page 37
Adding Excel 2013 to the Start screen - Page 38
Starting Excel 2013 in Windows 7 - Page 39
Opening existing workbooks - Page 40
Opening existing workbooks - Page 41
Using file properties - Page 42
Using file properties - Page 43
Creating a new workbook - Page 44
Working with multiple workbooks - Page 45
Sizing and viewing windows - Page 46
Zooming in or out on a worksheet - Page 47
Saving Excel workbooks - Page 48
Saving Excel workbooks - Page 49
Changing the default file folder - Page 50
Closing workbooks and exiting Excel - Page 51
Using the Excel Help system - Page 52
Finding Excel Help on the web - Page 53
Searching for a workbook - Page 54
Section 4: Building a workbook - Page 55
Selecting cells - Page 56
Selecting cells - Page 57
Entering text in cells - Page 58
Entering numbers in cells - Page 59
Entering dates and times in cells - Page 60
Entering dates and times in cells - Page 61
Entering data using fills - Page 62
Entering data using fills - Page 63
Entering data by using Flash Fill - Page 64
Entering data by using Flash Fill - Page 65
Entering data with other shortcuts - Page 66
Entering data with other shortcuts - Page 67
Creating an Excel table - Page 68
Creating an Excel table - Page 69
Editing an Excel Table - Page 70
Editing an Excel Table - Page 71
Editing cell contents - Page 72
Inserting a symbol in a cell - Page 73
Creating hyperlinks - Page 74
Creating hyperlinks - Page 75
Creating hyperlinks to web and email resources - Page 76
Creating hyperlinks to web and email resources - Page 77
Cutting, copying, and pasting cell values - Page 78
Undoing or redoing an action - Page 79
Pasting values with more control - Page 80
Pasting values with more control - Page 81
Clearing cell contents - Page 82
Clearing cell contents - Page 83
Using the Office Clipboard - Page 84
Using the Office Clipboard - Page 85
Finding and replacing text - Page 86
Finding and replacing text - Page 87
Checking the spelling in your worksheet - Page 88
Section 5: Managing and viewing worksheets - Page 89
Viewing and selecting worksheets - Page 90
Renaming worksheets - Page 91
Moving worksheets - Page 92
Copying worksheets - Page 93
Inserting and deleting worksheets - Page 94
Inserting and deleting worksheets - Page 95
Hiding or showing a worksheet - Page 96
Changing worksheet tab colors - Page 97
Inserting, moving, and deleting cells - Page 98
Inserting, moving, and deleting cells - Page 99
Inserting columns and rows - Page 100
Setting insert options - Page 101
Deleting rows or columns - Page 102
Moving rows or columns - Page 103
Hiding and unhiding columns and rows - Page 104
Hiding and unhiding columns and rows - Page 105
Entering data and formatting on many worksheets at the same time - Page 106
Entering data and formatting on many worksheets at the same time - Page 107
Changing how you look at Excel workbooks - Page 108
Changing how you look at Excel workbooks - Page 109
Naming and using worksheet views - Page 110
Naming and using worksheet views - Page 111
Naming and using worksheet views - Page 112
Section 6: Using formulas and functions - Page 113
Creating simple cell formulas - Page 114
Creating simple cell formulas - Page 115
Assigning names to groups of cells - Page 116
Assigning names to groups of cells - Page 117
Using names in formulas - Page 118
Creating a formula that references values in an Excel table - Page 119
Creating formulas that reference cells in other workbooks - Page 120
Creating formulas that reference cells in other workbooks - Page 121
Changing links to different workbooks - Page 122
Analyzing data by using the Quick Analysis lens - Page 123
Summing a group of cells without using a formula - Page 124
Creating a summary formula - Page 125
Summing with subtotals and grand totals - Page 126
Summing with subtotals and grand totals - Page 127
Exploring the Excel function library - Page 128
Exploring the Excel function library - Page 129
Using the IF function - Page 130
Checking formula references - Page 131
Debugging your formulas - Page 132
Debugging your formulas - Page 133
Debugging your formulas - Page 134
Debugging your formulas - Page 135
Debugging your formulas - Page 136
Section 7: Formatting the cell - Page 137
Formatting cell contents - Page 138
Formatting cell contents - Page 139
Formatting part of a cell’s contents - Page 140
Formatting cells containing dates - Page 141
Formatting cells containing numbers - Page 142
Formatting cells containing numbers - Page 143
Adding cell backgrounds and shading - Page 144
Adding cell backgrounds and shading - Page 145
Formatting cell borders - Page 146
Formatting cell borders - Page 147
Defining cell styles - Page 148
Defining cell styles - Page 149
Modifying and deleting cell styles - Page 150
Modifying and deleting cell styles - Page 151
Aligning and orienting cell contents - Page 152
Aligning and orienting cell contents - Page 153
Formatting a cell based on conditions - Page 154
Formatting a cell based on conditions - Page 155
Editing and deleting conditional formats - Page 156
Editing and deleting conditional formats - Page 157
Changing how conditional formatting rules are applied - Page 158
Changing how conditional formatting rules are applied - Page 159
Displaying data bar and icon set formats - Page 160
Displaying data bar and icon set formats - Page 161
Displaying color scales based on cell values - Page 162
Deleting conditional formats - Page 163
Merging or splitting cells or data - Page 164
Merging or splitting cells or data - Page 165
Copying formats with Format Painter - Page 166
Section 8: Formatting the worksheet - Page 167
Applying workbook themes - Page 168
Applying workbook themes - Page 169
Changing theme fonts and effects - Page 170
Changing theme fonts and effects - Page 171
Creating new workbook themes - Page 172
Coloring sheet tabs - Page 173
Changing a worksheet’s gridlines - Page 174
Changing a worksheet’s gridlines - Page 175
Changing row heights and column widths - Page 176
Resizing multiple rows or columns - Page 177
Inserting rows or columns - Page 178
Setting insert options - Page 179
Moving rows and columns - Page 180
Moving rows and columns - Page 181
Deleting rows and columns - Page 182
Grouping and ungrouping worksheet rows - Page 183
Hiding rows and columns - Page 184
Hiding rows and columns - Page 185
Outlining to hide and show rows and columns - Page 186
Protecting worksheets from changes - Page 187
Locking cells to prevent changes - Page 188
Section 9: Printing worksheets - Page 189
Previewing worksheets before printing - Page 190
Previewing worksheets before printing - Page 191
Printing worksheets with current options - Page 192
Choosing whether to print gridlines and headings - Page 193
Choosing printers and paper options - Page 194
Choosing printers and paper options - Page 195
Printing part of a worksheet - Page 196
Printing row and column headings on each page - Page 197
Setting and changing print margins - Page 198
Setting and changing print margins - Page 199
Setting page orientation and scale - Page 200
Setting page orientation and scale - Page 201
Creating headers and footers - Page 202
Creating headers and footers - Page 203
Adding graphics to a header or a footer - Page 204
Adding graphics to a header or a footer - Page 205
Setting and viewing page breaks - Page 206
Setting and viewing page breaks - Page 207
Setting and viewing page breaks - Page 208
Section 10: Customizing Excel to the way you work - Page 209
Opening ready-to-use workbook templates - Page 210
Opening ready-to-use workbook templates - Page 211
Saving a workbook as a template - Page 212
Saving a workbook as a template - Page 213
Adding commands to the Quick Access toolbar - Page 214
Adding commands to the Quick Access toolbar - Page 215
Moving the Quick Access toolbar - Page 216
Removing a ribbon element - Page 217
Adding and reordering ribbon elements - Page 218
Adding and reordering ribbon elements - Page 219
Creating new ribbon tabs and groups - Page 220
Creating new ribbon tabs and groups - Page 221
Renaming a ribbon element - Page 222
Choosing the color Excel uses to display errors - Page 223
Hiding and displaying ribbon tabs - Page 224
Hiding and displaying ribbon tabs - Page 225
Controlling which error messages appear - Page 226
Controlling which error messages appear - Page 227
Defining AutoCorrect entries - Page 228
Defining AutoCorrect entries - Page 229
Controlling AutoFormat rules - Page 230
Section 11: Sorting and filtering worksheet data - Page 231
Sorting worksheet data - Page 232
Sorting worksheet data - Page 233
Creating a custom sort list - Page 234
Creating a custom sort list - Page 235
Filtering data quickly with AutoFilter - Page 236
Filtering data quickly with AutoFilter - Page 237
Filtering data with a search filter - Page 238
Filtering data with a search filter - Page 239
Clearing a filter - Page 240
Clearing a filter - Page 241
Creating an advanced filter - Page 242
Creating an advanced filter - Page 243
Filtering Excel tables visually by using slicers - Page 244
Filtering Excel tables visually by using slicers - Page 245
Clearing and removing slicers - Page 246
Clearing and removing slicers - Page 247
Validating data for correctness during entry - Page 248
Validating data for correctness during entry - Page 249
Validating data using a list - Page 250
Validating data using a list - Page 251
Creating a recommended PivotTable - Page 252
Creating a recommended PivotTable - Page 253
Creating a recommended PivotTable - Page 254
Section 12: Summarizing data visually using charts - Page 255
Creating a chart - Page 256
Creating a chart - Page 257
Changing a chart’s layout and style - Page 258
Changing a chart’s layout and style - Page 259
Changing a chart’s appearance - Page 260
Changing a chart’s appearance - Page 261
Formatting chart legends and titles - Page 262
Formatting chart legends and titles - Page 263
Adding and removing data labels and grid lines - Page 264
Adding and removing data labels and grid lines - Page 265
Formatting chart axes - Page 266
Formatting chart axes - Page 267
Changing a chart’s data source - Page 268
Changing a chart’s data source - Page 269
Adding and deleting data series - Page 270
Adding and deleting data series - Page 271
Filtering charts - Page 272
Filtering charts - Page 273
Manipulating pie charts - Page 274
Manipulating pie charts - Page 275
Creating a stock chart - Page 276
Adding a trendline to a chart - Page 277
Summarizing data using sparklines - Page 278
Summarizing data using sparklines - Page 279
Formatting and deleting sparklines - Page 280
Formatting and deleting sparklines - Page 281
Formatting and deleting sparklines - Page 282
Section 13: Enhancing your worksheets with graphics - Page 283
Section 13: Enhancing your worksheets with graphics - Page 284
Adding drawing objects to a worksheet - Page 285
Adding graphics to worksheets - Page 286
Adding graphics to worksheets - Page 287
Adding text to a shape - Page 288
Applying shape styles - Page 289
Changing a shape’s fill color or image - Page 290
Changing a shape’s fill color or image - Page 291
Adding effects to drawing objects - Page 292
Adding effects to drawing objects - Page 293
Resizing and rotating pictures and objects - Page 294
Resizing and rotating pictures and objects - Page 295
Removing the background from an image - Page 296
Removing the background from an image - Page 297
Aligning and grouping drawing objects - Page 298
Aligning and grouping drawing objects - Page 299
Using WordArt to create text effects in Excel - Page 300
Using WordArt to create text effects in Excel - Page 301
Inserting clip art into a worksheet - Page 302
Inserting clip art into a worksheet - Page 303
Inserting and changing a diagram - Page 304
Inserting and changing a diagram - Page 305
Creating an organization chart - Page 306
Creating an organization chart - Page 307
Changing the layout and design of a SmartArt graphic - Page 308
Changing the layout and design of a SmartArt graphic - Page 309
Adding an equation to a shape - Page 310
Adding an equation to a shape - Page 311
Reordering objects - Page 312
Section 14: Sharing Excel data with other programs - Page 313
Section 14: Sharing Excel data with other programs - Page 314
Section 14: Sharing Excel data with other programs - Page 315
Linking and embedding other files - Page 316
Linking and embedding other files - Page 317
Exchanging table data between Excel and Word - Page 318
Exchanging table data between Excel and Word - Page 319
Copying Excel charts and data into PowerPoint - Page 320
Copying Excel charts and data into PowerPoint - Page 321
Exchanging data between Access and Excel - Page 322
Exchanging data between Access and Excel - Page 323
Importing a text file - Page 324
Importing a text file - Page 325
Importing a text file - Page 326
Section 15: Using Excel in a group environment - Page 327
Sharing workbooks in Excel - Page 328
Adding and viewing cell comments - Page 329
Editing and deleting comments - Page 330
Tracking changes in workbooks - Page 331
Accepting or rejecting changes - Page 332
Accepting or rejecting changes - Page 333
Maintaining a change history - Page 334
Maintaining a change history - Page 335
Saving worksheets to the web - Page 336
Saving worksheets to the web - Page 337
Dynamically updating worksheets published to the web - Page 338
Dynamically updating worksheets published to the web - Page 339
Retrieving web data using Excel - Page 340
Retrieving web data using Excel - Page 341
Copying web data to Excel - Page 342
Modifying web queries - Page 343
Modifying web queries - Page 344
Saving data to the cloud using SkyDrive - Page 345
Interacting over the web using XML - Page 346
Interacting over the web using XML - Page 347
Editing a workbook in the Excel Web App - Page 348
Editing a workbook in the Excel Web App - Page 349
Sharing Excel workbooks on the web - Page 350
Sharing Excel workbooks on the web - Page 351
Making workbooks available on the web - Page 352
Making workbooks available on the web - Page 353