Microsoft Excel 2013

CHAPTER 1: Working with Excel - Page 14
CHAPTER 1: Working with Excel - Page 15
Getting to Know Excel - Page 16
Getting to Know Excel - Page 17
Start Excel - Page 18
Start Excel - Page 19
Tour the Excel Window - Page 20
Work with the Excel Ribbon - Page 21
Work with the Excel Galleries - Page 22
Work with the Excel Galleries - Page 23
Customize the Quick Access Toolbar - Page 24
Customize the Quick Access Toolbar - Page 25
Customize the Ribbon - Page 26
Customize the Ribbon - Page 27
Change the View - Page 28
Change the View - Page 29
Configure Excel Options - Page 30
Configure Excel Options - Page 31
Add Excel to the Windows Taskbar - Page 32
Quit Excel - Page 33
CHAPTER 2: Entering Data - Page 34
CHAPTER 2: Entering Data - Page 35
Learning the Layout of a Worksheet - Page 36
Understanding the Types of Data You Can Use - Page 37
Enter Text into a Cell - Page 38
Enter Text into a Cell - Page 39
Enter a Number into a Cell - Page 40
Enter a Number into a Cell - Page 41
Enter a Date or Time into a Cell - Page 42
Enter a Date or Time into a Cell - Page 43
Insert a Symbol - Page 44
Insert a Symbol - Page 45
Edit Cell Data - Page 46
Edit Cell Data - Page 47
Delete Data from a Cell - Page 48
Delete Data from a Cell - Page 49
CHAPTER 3: Working with Ranges - Page 50
CHAPTER 3: Working with Ranges - Page 51
Select a Range - Page 52
Select a Range - Page 53
Fill a Range with the Same Data - Page 54
Fill a Range with the Same Data - Page 55
Fill a Range with a Series of Values - Page 56
Fill a Range with a Series of Values - Page 57
Flash Fill a Range - Page 58
Flash Fill a Range - Page 59
Move or Copy a Range - Page 60
Move or Copy a Range - Page 61
Insert a Row or Column - Page 62
Insert a Row or Column - Page 63
Insert a Cell or Range - Page 64
Insert a Cell or Range - Page 65
Delete Data from a Range - Page 66
Delete Data from a Range - Page 67
Delete a Range - Page 68
Delete a Range - Page 69
Hide a Row or Column - Page 70
Hide a Row or Column - Page 71
Freeze Rows or Columns - Page 72
Freeze Rows or Columns - Page 73
Merge Two or More Cells - Page 74
Merge Two or More Cells - Page 75
Transpose Rows and Columns - Page 76
Transpose Rows and Columns - Page 77
CHAPTER 4: Working with Range Names - Page 78
CHAPTER 4: Working with Range Names - Page 79
Understanding the Benefits of Using Range Names - Page 80
Understanding the Benefits of Using Range Names - Page 81
Define a Range Name - Page 82
Define a Range Name - Page 83
Use Worksheet Text to Define a Range Name - Page 84
Use Worksheet Text to Define a Range Name - Page 85
Navigate a Workbook Using Range Names - Page 86
Navigate a Workbook Using Range Names - Page 87
Change a Range Name - Page 88
Change a Range Name - Page 89
Delete a Range Name - Page 90
Delete a Range Name - Page 91
CHAPTER 5: Formatting Excel Ranges - Page 92
CHAPTER 5: Formatting Excel Ranges - Page 93
Change the Font and Font Size - Page 94
Change the Font and Font Size - Page 95
Apply Font Effects - Page 96
Apply Font Effects - Page 97
Change the Font Color - Page 98
Change the Font Color - Page 99
Align Text Within a Cell - Page 100
Align Text Within a Cell - Page 101
Center Text Across Multiple Columns - Page 102
Center Text Across Multiple Columns - Page 103
Rotate Text Within a Cell - Page 104
Rotate Text Within a Cell - Page 105
Add a Background Color to a Range - Page 106
Add a Background Color to a Range - Page 107
Apply a Number Format - Page 108
Apply a Number Format - Page 109
Change the Number of Decimal Places Displayed - Page 110
Change the Number of Decimal Places Displayed - Page 111
Apply an Auto Format to a Range - Page 112
Apply an Auto Format to a Range - Page 113
Apply a Conditional Format to a Range - Page 114
Apply a Conditional Format to a Range - Page 115
Apply a Style to a Range - Page 116
Apply a Style to a Range - Page 117
Change the Column Width - Page 118
Change the Column Width - Page 119
Change the Row Height - Page 120
Change the Row Height - Page 121
Wrap Text Within a Cell - Page 122
Wrap Text Within a Cell - Page 123
Add Borders to a Range - Page 124
Add Borders to a Range - Page 125
CHAPTER 6: Building Formulas - Page 126
CHAPTER 6: Building Formulas - Page 127
Understanding Excel Formulas - Page 128
Understanding Excel Formulas - Page 129
Build a Formula - Page 130
Build a Formula - Page 131
Understanding Excel Functions - Page 132
Understanding Excel Functions - Page 133
Add a Function to a Formula - Page 134
Add a Function to a Formula - Page 135
Add a Row or Column of Numbers - Page 136
Add a Row or Column of Numbers - Page 137
Build an AutoSum Formula - Page 138
Build an AutoSum Formula - Page 139
Add a Range Name to a Formula - Page 140
Add a Range Name to a Formula - Page 141
Reference Another Worksheet Range in a Formula - Page 142
Reference Another Worksheet Range in a Formula - Page 143
Move or Copy a Formula - Page 144
Move or Copy a Formula - Page 145
CHAPTER 7: Manipulating Worksheets - Page 146
CHAPTER 7: Manipulating Worksheets - Page 147
Navigate a Worksheet - Page 148
Rename a Worksheet - Page 149
Create a New Worksheet - Page 150
Create a New Worksheet - Page 151
Move a Worksheet - Page 152
Move a Worksheet - Page 153
Copy a Worksheet - Page 154
Copy a Worksheet - Page 155
Delete a Worksheet - Page 156
Delete a Worksheet - Page 157
Change the Gridline Color - Page 158
Change the Gridline Color - Page 159
Toggle Worksheet Gridlines On and Off - Page 160
Toggle Worksheet Headings On and Off - Page 161
CHAPTER 8: Dealing with Workbooks - Page 162
CHAPTER 8: Dealing with Workbooks - Page 163
Create a New Blank Workbook - Page 164
Create a New Blank Workbook - Page 165
Create a New Workbook from a Template - Page 166
Create a New Workbook from a Template - Page 167
Save a Workbook - Page 168
Open a Workbook - Page 169
Arrange Workbook Windows - Page 170
Arrange Workbook Windows - Page 171
Find Text in a Workbook - Page 172
Find Text in a Workbook - Page 173
Replace Text in a Workbook - Page 174
Replace Text in a Workbook - Page 175
CHAPTER 9: Formatting Workbooks - Page 176
CHAPTER 9: Formatting Workbooks - Page 177
Modify the Workbook Colors - Page 178
Modify the Workbook Colors - Page 179
Set the Workbook Fonts - Page 180
Set the Workbook Fonts - Page 181
Choose Workbook Effects - Page 182
Choose Workbook Effects - Page 183
Apply a Workbook Theme - Page 184
Apply a Workbook Theme - Page 185
Add a Workbook Header - Page 186
Add a Workbook Header - Page 187
Add a Workbook Footer - Page 188
Add a Workbook Footer - Page 189
CHAPTER 10: Working with Tables - Page 190
CHAPTER 10: Working with Tables - Page 191
Understanding Tables - Page 192
Get to Know Table Features - Page 193
Convert a Range to a Table - Page 194
Convert a Range to a Table - Page 195
Select Table Data - Page 196
Select Table Data - Page 197
Insert a Table Row - Page 198
Insert a Table Column - Page 199
Delete a Table Row - Page 200
Delete a Table Column - Page 201
Add a Column Subtotal - Page 202
Add a Column Subtotal - Page 203
Convert a Table to a Range - Page 204
Apply a Table Style - Page 205
Build a Custom Table Style - Page 206
Build a Custom Table Style - Page 207
CHAPTER 11: Analyzing Data - Page 208
CHAPTER 11: Analyzing Data - Page 209
Sort a Range or Table - Page 210
Sort a Range or Table - Page 211
Filter a Range or Table - Page 212
Filter a Range or Table - Page 213
Set Data Validation Rules - Page 214
Set Data Validation Rules - Page 215
Create a Data Table - Page 216
Create a Data Table - Page 217
Summarize Data with Subtotals - Page 218
Summarize Data with Subtotals - Page 219
Group Related Data - Page 220
Group Related Data - Page 221
Analyze Data with Goal Seek - Page 222
Analyze Data with Goal Seek - Page 223
Analyze Data with Scenarios - Page 224
Analyze Data with Scenarios - Page 225
Analyze Data with Scenarios - Page 226
Analyze Data with Scenarios - Page 227
Remove Duplicate Values from a Range or Table - Page 228
Remove Duplicate Values from a Range or Table - Page 229
CHAPTER 12: Visualizing Data with Charts - Page 230
CHAPTER 12: Visualizing Data with Charts - Page 231
Examine Chart Elements - Page 232
Understanding Chart Types - Page 233
Create a Chart - Page 234
Create a Chart - Page 235
Create a Recommended Chart - Page 236
Create a Recommended Chart - Page 237
Add Chart Titles - Page 238
Add Data Labels - Page 239
Position the Chart Legend - Page 240
Display Chart Gridlines - Page 241
Display a Data Table - Page 242
Change the Chart Layout and Style - Page 243
Select a Different Chart Type - Page 244
Select a Different Chart Type - Page 245
Change the Chart Source Data - Page 246
Change the Chart Source Data - Page 247
Move or Resize a Chart - Page 248
Move or Resize a Chart - Page 249
CHAPTER 13: Collaborating with Others - Page 250
CHAPTER 13: Collaborating with Others - Page 251
Add a Comment to a Cell - Page 252
Add a Comment to a Cell - Page 253
Protect a Worksheet’s Data - Page 254
Protect a Worksheet’s Data - Page 255
Protect a Workbook’s Structure - Page 256
Protect a Workbook’s Structure - Page 257
Share a Workbook with Other Users - Page 258
Share a Workbook with Other Users - Page 259
Track Workbook Changes - Page 260
Track Workbook Changes - Page 261
Accept or Reject Workbook Changes - Page 262
Accept or Reject Workbook Changes - Page 263
Save a Workbook to Your SkyDrive - Page 264
Save a Workbook to Your SkyDrive - Page 265
Send a Workbook as an E-Mail Attachment - Page 266
Send a Workbook as an E-Mail Attachment - Page 267
Save Excel Data as a Web Page - Page 268
Save Excel Data as a Web Page - Page 269
Make a Workbook Compatible with Earlier Versions of Excel - Page 270
Make a Workbook Compatible with Earlier Versions of Excel - Page 271
Mark Up a Worksheet with a Digital Pen - Page 272
Mark Up a Worksheet with a Digital Pen - Page 273
Collaborate on a Workbook Online - Page 274
Collaborate on a Workbook Online - Page 275