Teach Yourself VISUALLY Excel 2013

The step-by-step, visual way to learn Excel 2013

Excel can be complicated, but this Visual guide shows you
exactly how to tackle every essential task with full-color screen
shots and step-by-step instructions. You'll see exactly what each
step should look like as you learn to use all the new tools in this
latest release of the world's most popular spreadsheet program. In
easy two-page lessons, author Paul McFedries shows you how to
organize, present, analyze, and chart data, over the web or on a
network.

• The Visual learning system is perfect for teaching Excel;
  previous editions of this book have sold more than 230,000
  copies

• Covers common Excel 2013 tasks such as creating spreadsheets
  and charts, filtering and sorting data, and working with
  PivotTables

• Provides step-by-step instructions for each task

• Each step is illustrated with full-color screenshots

Teach Yourself VISUALLY Excel 2013 offers visual learners
the ideal way to master this popular but complex spreadsheet
program.

Auteur

Paul McFedries (Toronto, Ontario) is the president of Logophilia Limited, a technical writing company. He has been programming since he was a teenager in the mid-1970s and has programmed everything from mainframes to desktops to bar code scanners. He has worked with many different languages, including Fortran, assembly language, C++, and, JavaScript. Paul has written more than three dozen books that have sold more than three million copies worldwide, including: Windows Vista Simplified, Teach Yourself Visually Windows Vista, Macs Portable Genius, Office 2007 Visual Quick Tips, and Teach Yourself VISUALLY Macs. Paul encourages all readers to drop by his Web site, www.mcfedries.com.

Résumé

The step-by-step, visual way to learn Excel 2013

Excel can be complicated, but this Visual guide shows you exactly how to tackle every essential task with full-color screen shots and step-by-step instructions. You'll see exactly what each step should look like as you learn to use all the new tools in this latest release of the world's most popular spreadsheet program. In easy two-page lessons, author Paul McFedries shows you how to organize, present, analyze, and chart data, over the web or on a network.

• The Visual learning system is perfect for teaching Excel; previous editions of this book have sold more than 230,000 copies
• Covers common Excel 2013 tasks such as creating spreadsheets and charts, filtering and sorting data, and working with PivotTables
• Provides step-by-step instructions for each task
• Each step is illustrated with full-color screenshots
  Teach Yourself VISUALLY Excel 2013 offers visual learners the ideal way to master this popular but complex spreadsheet program.

Contenu

Chapter 1 Working with Excel

Getting to Know Excel 4

Start Excel 6

Tour the Excel Window 8

Work with the Excel Ribbon 9

Work with the Excel Galleries 10

Customize the Quick Access Toolbar 12

Customize the Ribbon 14

Change the View 16

Configure Excel Options 18

Add Excel to the Windows Taskbar 20

Quit Excel 21

Chapter 2 Entering Data

Learning the Layout of a Worksheet 24

Understanding the Types of Data You Can Use 25

Enter Text into a Cell 26

Enter a Number into a Cell 28

Enter a Date or Time into a Cell 30

Insert a Symbol 32

Edit Cell Data 34

Delete Data from a Cell 36

Chapter 3 Working with Ranges

Select a Range 40

Fill a Range with the Same Data 42

Fill a Range with a Series of Values 44

Flash Fill a Range 46

Move or Copy a Range 48

Insert a Row or Column 50

Insert a Cell or Range 52

Delete Data from a Range 54

Delete a Range 56

Hide a Row or Column 58

Freeze Rows or Columns 60

Merge Two or More Cells 62

Transpose Rows and Columns 64

Chapter 4 Working with Range Names

Understanding the Benefits of Using Range Names 68

Define a Range Name 70

Use Worksheet Text to Define a Range Name 72

Navigate a Workbook Using Range Names 74

Change a Range Name 76

Delete a Range Name 78

Paste a List of Range Names 80

Chapter 5 Formatting Excel Ranges

Change the Font and Font Size 84

Apply Font Effects 86

Change the Font Color 88

Align Text Within a Cell 90

Center Text Across Multiple Columns 92

Rotate Text Within a Cell 94

Add a Background Color to a Range 96

Apply a Number Format 98

Change the Number of Decimal Places Displayed 100

Apply an AutoFormat to a Range 102

Apply a Conditional Format to a Range 104

Apply a Style to a Range 106

Change the Column Width 108

Change the Row Height 110

Wrap Text Within a Cell 112

Add Borders to a Range 114

Copy Formatting from One Cell to Another 116

Chapter 6 Building Formulas

Understanding Excel Formulas 120

Build a Formula 122

Understanding Excel Functions 124

Add a Function to a Formula 126

Add a Row or Column of Numbers 128

Build an AutoSum Formula 130

Add a Range Name to a Formula 132

Reference Another Worksheet Range in a Formula 134

Move or Copy a Formula 136

Switch to Absolute Cell References 138

Hide the Formula Bar or Ribbon 140

Troubleshoot Formula Errors 142

Chapter 7 Manipulating Worksheets

Navigate a Worksheet 146

Rename a Worksheet 147

Create a New Worksheet 148

Move a Worksheet 150

Copy a Worksheet 152

Delete a Worksheet 154

Change the Gridline Color 156

Toggle Worksheet Gridlines On and Off 158

Toggle Worksheet Headings On and Off 159

Set the Worksheet Tab Color 160

Set the Worksheet Background 162

Zoom In on or Out of a Worksheet 164

Split a Worksheet into Two Panes 166

Hide and Unhide a Worksheet 168

Chapter 8 Dealing with Workbooks

Create a New Blank Workbook 172

Create a New Workbook from a Template 174

Save a Workbook 176

Open a Workbook 177

Arrange Workbook Windows 178

Find Text in a Workbook 180 Replace Text in a Wor...