Microsoft Excel 2013: Full Coverage of Excel 2013 s Top Features and Functions

Contents iii......Page 5
Getting Started with Excel 2013 1......Page 11
Exploring Excel 2013 2......Page 12
Exploring the Excel Web App 4......Page 14
Creating a New Blank Spreadsheet 6......Page 16
Creating a New Spreadsheet from a Template 8......Page 18
Saving Your Spreadsheet 10......Page 20
Opening an Existing Spreadsheet 12......Page 22
Changing Views 14......Page 24
Customizing the Ribbon 16......Page 26
Personalizing the Quick Access Toolbar 18......Page 28
Configuring Other Important Options 20......Page 30
Entering and Editing Data 23......Page 33
Understanding the Spreadsheet Layout 24......Page 34
Entering Numbers 26......Page 36
Entering Dates and Times 28......Page 38
Entering Text 30......Page 40
Editing Cell Data 32......Page 42
Deleting Data from a Cell 34......Page 44
Finding and Replacing Text 36......Page 46
Copying Cells 38......Page 48
Moving Cells 40......Page 50
Formatting Data 43......Page 53
Applying Bold, Italic, and Other Font Effects 44......Page 54
Changing Font and Font Size 46......Page 56
Aligning Text 48......Page 58
Aligning Text Vertically 50......Page 60
Wrapping Text Within a Cell 52......Page 62
Centering Text Across Multiple Columns 53......Page 63
Rotating Text 54......Page 64
Applying a Background Color 56......Page 66
Applying Number Formats 58......Page 68
Changing Currency Formats 60......Page 70
Displaying Decimal Places 61......Page 71
Using Automatic Number Formats 62......Page 72
Using Conditional Formatting 64......Page 74
Applying Cell Styles 66......Page 76
Creating a New Cell Style 67......Page 77
Adding Borders 68......Page 78
Copying Cell Formatting 70......Page 80
Working with Rows and Columns 73......Page 83
Understanding Rows and Columns 74......Page 84
Naming Cells, Rows, and Columns 76......Page 86
Changing Column Width 78......Page 88
Changing Row Height 79......Page 89
Inserting a New Row 80......Page 90
Inserting a New Column 81......Page 91
Deleting a Row 82......Page 92
Deleting a Column 83......Page 93
Inserting a Single Cell 84......Page 94
Deleting a Single Cell 86......Page 96
Copying a Row or Column 88......Page 98
Moving a Row or Column 90......Page 100
Hiding and Unhiding a Row or Column 92......Page 102
Freezing a Row or Column 94......Page 104
Merging Two or More Cells 96......Page 106
Splitting a Merged Cell 97......Page 107
Formatting Rows and Columns 98......Page 108
Sorting Data 100......Page 110
Working with worksheet 105......Page 115
Understanding Worksheets and Workbooks 106......Page 116
Creating a New Worksheet 108......Page 118
Changing the Default Number of Worksheets 109......Page 119
Copying a Worksheet 110......Page 120
Moving a Worksheet 111......Page 121
Moving or Copying a Worksheet to a Different Workbook 112......Page 122
Renaming a Worksheet 113......Page 123
Changing the Tab Color 114......Page 124
Deleting a Worksheet 115......Page 125
Grouping Worksheets 116......Page 126
Splitting a Worksheet into Panes 118......Page 128
Hiding and Unhiding Worksheets 120......Page 130
Formatting Worksheets and Workbooks 123......Page 133
Changing Gridline Color 124......Page 134
Showing or Hiding Gridlines 125......Page 135
Showing or Hiding Row and Column Headings 126......Page 136
Formatting a Worksheet’s Background Color 127......Page 137
Adding a Background Picture to a Worksheet 128......Page 138
Copying Formatting Between Worksheets 130......Page 140
Applying Visual Effects to a Workbook 131......Page 141
Changing Workbook Colors 132......Page 142
Setting Workbook Fonts 134......Page 144
Applying a Workbook Theme 136......Page 146
Working with Ranges 139......Page 149
Selecting a Range of Cells 140......Page 150
Naming a Range 142......Page 152
Navigating with Range Names 144......Page 154
Managing Names in a Workbook 145......Page 155
Moving a Range of Cells 146......Page 156
Copying a Range of Cells 148......Page 158
Deleting a Range 150......Page 160
Filling a Range of Cells with AutoFill 152......Page 162
Flash Filling a Range 154......Page 164
Using Quick Analysis to Format or Analyze a Range 156......Page 166
Using Formulas and Functions 159......Page 169
How Formulas Work 160......Page 170
Creating a Formula162......Page 172
Editing a Formula 164......Page 174
Using Absolute Cell References in a Formula 166......Page 176
Using Ranges in a Formula 168......Page 178
Referencing Other Worksheets in a Formula 170......Page 180
Showing and Hiding Formulas 172......Page 182
Checking for Errors in Formulas 173......Page 183
Understanding Functions 174......Page 184
Using Functions in Formulas 176......Page 186
Using the AutoSum Function 178......Page 188
Using the AVERAGE Function 180......Page 190
Using the COUNT Function 181......Page 191
Creating Charts 183......Page 193
Exploring Excel’s Chart Types184......Page 194
Creating a Chart186......Page 196
Moving and Resizing a Chart 188......Page 198
Moving a Chart to Its Own Chart Sheet 189......Page 199
Changing the Chart Type 190......Page 200
Changing a Chart’s Source Data 192......Page 202
Adding and Removing Chart Elements 194......Page 204
Changing Chart Style and Color 196......Page 206
Formatting Chart Elements 198......Page 208
Formatting the Chart Area 200......Page 210
Formatting the Plot Area 201......Page 211
Formatting Axes 202......Page 212
Formatting Axis Titles 203......Page 213
Formatting the Chart Title 204......Page 214
Formatting Data Labels 205......Page 215
Formatting a Data Table 206......Page 216
Formatting Gridlines 207......Page 217
Formatting the Legend 208......Page 218
Formatting 3-D Rotation 209......Page 219
Formatting Data Series 210......Page 220
Formatting a Pie Chart 211......Page 221
Adding Graphics 213......Page 223
Inserting a Photo 214......Page 224
Inserting a Clip Art Image 216......Page 226
Inserting SmartArt 218......Page 228
Inserting a Shape 220......Page 230
Inserting a Text Box 222......Page 232
Inserting WordArt 223......Page 233
Working with Tables 225......Page 235
Converting a Range to a Table 226......Page 236
Adding New Data to a Table 228......Page 238
Removing Rows from a Table 230......Page 240
Inserting Table Columns 232......Page 242
Deleting Table Columns233......Page 243
Sorting a Table 234......Page 244
Filtering Data in a Table 235......Page 245
Adding Column Totals 236......Page 246
Converting a Table to a Range 237......Page 247
Applying Table Styles 238......Page 248
Working with PivotTables 241......Page 251
How PivotTables Work 242......Page 252
Creating a PivotTable 246......Page 256
Adding Fields to a PivotTable 250......Page 260
Changing Value Calculations 252......Page 262
Changing the Source Data 254......Page 264
Sorting a PivotTable 255......Page 265
Filtering PivotTable Data with Slicers 256......Page 266
Filtering by Date with Timelines 258......Page 268
Other Ways to Filter PivotTable Data 260......Page 270
Creating a PivotChart 262......Page 272
Analyzing Data 265......Page 275
Using Goal Seek for What-If Analysis 266......Page 276
Using Scenario Manager 268......Page 278
Producing a Scenario Summary Report 270......Page 280
Showing Trends with Sparklines 272......Page 282
Printing 275......Page 285
Printing One or More Worksheets 276......Page 286
Printing Part of a Worksheet 278......Page 288
Changing Page Orientation 280......Page 290
Scaling the Spreadsheet to Fit 281......Page 291
Inserting Page Breaks 282......Page 292
Configuring Other Print Options 284......Page 294
Printing Row and Column Titles 285......Page 295
Adding a Header and Footer 286......Page 296
Sharing and Collaborating 289......Page 299
Sharing Online with SkyDrive 290......Page 300
Sharing a Workbook via Email 292......Page 302
Enabling Change Tracking 293......Page 303
Accepting and Rejecting Changes 294......Page 304
Adding Comments 296......Page 306
Collaborating Online with the Excel Web App 298......Page 308
Glossary 300......Page 310
Keyboard Shortcuts 302......Page 312
Index 306......Page 316