Chapter 1 Getting Started with Excel

Getting to Know Excel 4

Start Excel on the Desktop 6

Navigate to Excel for the Web 7

Tour the Excel Window 8

Work with the Excel Ribbon 9

Chapter 2 Entering Data

Learning the Layout of a Worksheet 12

Understanding the Types of Data You Can Use 13

Enter Text into a Cell 14

Enter a Number into a Cell 16

Enter a Date or Time into a Cell 18

Edit Cell Data 20

Delete Data from a Cell 22

Chapter 3 Working with Ranges

Select a Range 26

Fill a Range with the Same Data 28

Fill a Range with a Series of Values 30

Flash Fill a Range 32

Move or Copy a Range 34

Insert a Row or Column 36

Insert a Cell or Range 38

Delete Data from a Range 40

Delete a Range 42

Hide a Row or Column 44

Freeze Rows or Columns 46

Merge Two or More Cells 48

Chapter 4 Working with Range Names

Understanding the Benefits of Using Range Names 52

Define a Range Name 54

Using Worksheet Text to Define a Range Name 56

Navigate a Workbook Using Range Names 58

Change a Range Name 60

Delete a Range Name 62

Chapter 5 Formatting Excel Ranges

Change the Font and Font Size 66

Apply Font Effects 68

Change the Font Color 70

Align Text Within a Cell 72

Center Text Across Multiple Columns 74

Rotate Text Within a Cell 76

Add a Background Color to a Range 78

Apply a Number Format 80

Change the Number of Decimal Places Displayed 82

Apply a Conditional Format to a Range 84

Apply a Style to a Range 86

Change the Column Width 88

Change the Row Height 90

Wrap Text Within a Cell 92

Add Borders to a Range 94

Copy Formatting from One Cell to Another 96

Chapter 6 Building Formulas

Understanding Excel Formulas 100

Build a Formula 102

Understanding Excel Functions 104

Add a Function to a Formula 106

Add a Range of Numbers 108

Build an AutoSum Formula 110

Add a Range Name to a Formula 112

Reference Another Worksheet Range in a Formula 114

Move or Copy a Formula 116

Switch to Absolute Cell References 118

Troubleshoot Formula Errors 120

Chapter 7 Manipulating Worksheets

Navigate a Worksheet 124

Rename a Worksheet 125

Create a New Worksheet 126

Move a Worksheet 128

Copy a Worksheet 130

Delete a Worksheet 132

Zoom In on or Out of a Worksheet 134

Split a Worksheet into Two Panes 136

Hide and Unhide a Worksheet 138

Chapter 8 Dealing with Workbooks

Create a New Blank Workbook 142

Create a New Workbook from a Template 144

Save a Workbook 146

Open a Workbook 147

Find Text in a Workbook 148

Replace Text in a Workbook 150

Chapter 9 Formatting Workbooks

Modify the Workbook Colors 154

Set the Workbook Fonts 156

Choose Workbook Effects 158

Apply a Workbook Theme 160

Add a Workbook Header 162

Add a Workbook Footer 164

Chapter 10 Importing Data into Excel

Understanding External Data 168

Import Data from an Access Table 170

Import Data from a Word Table 172

Import Data from a Text File 174

Import Data from a Web Page 176

Import Data from an XML File 178

Refresh Imported Data 180

Separate Cell Text into Columns 182

Chapter 11 Working with Tables

Understanding Tables 186

Get to Know Table Features 187

Convert a Range to a Table 188

Select Table Data 190

Insert a Table Row 192

Insert a Table Column 193

Delete a Table Row 194

Delete a Table Column 195

Add a Column Subtotal 196

Convert a Table to a Range 198

Apply a Table Style 199

Chapter 12 Analyzing with PivotTables

Understanding PivotTables 202

Explore PivotTable Features 203

Build a PivotTable from an Excel Range or Table 204

Refresh PivotTable Data 206

Add Multiple Fields to the Row or Column Area 208

Add Multiple Fields to the Data Area 210

Move a Field to a Different Area 212

Group PivotTable Values 214

Apply a PivotTable Filter 216

Chapter 13 Analyzing Data

Sort a Range or Table 220

Filter a Range or Table 222

Set Data Validation Rules 224

Create a Data Table 226

Summarize Data with Subtotals 228

Group Related Data 230

Analyze Data with Goal Seek 232

Highlight Cells That Meet Some Criteria 234

Highlight the Top or Bottom Values in a Range 236

Analyze Cell Values with Data Bars 238

Analyze Cell Values with Color Scales 240

Analyze Cell Values with Icon Sets 242

Chapter 14 Visualizing Data with Charts

Examine Chart Elements 246

Understanding Chart Types 247

Create a Chart 248

Create a Recommended Chart 250

Add Chart Titles 252

Add Data Labels 253

Position the Chart Legend 254

Display Chart Gridlines 255

Display a Data Table 256

Change the Chart Layout and Style 257

Select a Different Chart Type 258

Change the Chart Source Data 260

Move or Resize a Chart 262

Chapter 15 Adding Worksheet Graphics

Draw a Shape 266

Insert an Online Image 268

Insert a Photo from Your PC 270

Insert a SmartArt Graphic 272

Move or Resize a Graphic 274

Format a Picture 276

Chapter 16 Collaborating with Others

Add a Comment to a Cell 280

Protect a Worksheet's Data 282

Protect a Workbook's Structure 284

Save a Workbook to Your OneDrive 286

Send a Workbook as an Email Attachment 288

Save Excel Data as a Web Page 290

Make a Workbook Compatible with Earlier Versions of Excel 292

Mark Up a Worksheet with Digital Ink 294

Collaborate on a Workbook Online 296

Index 298