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.

Table of Contents:
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 Workbook 182 Check Spelling and Grammar 184 Close a Workbook 186 Chapter 9 Formatting Workbooks Modify the Workbook Colors 190 Set the Workbook Fonts 192 Choose Workbook Effects 194 Apply a Workbook Theme 196 Add a Workbook Header 198 Add a Workbook Footer 200 Chapter 10 Printing Workbooks Adjust the Workbook Margins 204 Change the Page Orientation 206 Insert a Page Break 207 Choose a Paper Size 208 Set the Print Area 210 Configure Titles to Print on Each Page 212 Preview the Printout 214 Print a Workbook 216 Chapter 11 Working with Tables Understanding Tables 220 Get to Know Table Features 221 Convert a Range to a Table 222 Select Table Data 224 Insert a Table Row 226 Insert a Table Column 227 Delete a Table Row 228 Delete a Table Column 229 Add a Column Subtotal 230 Convert a Table to a Range 232 Apply a Table Style 233 Build a Custom Table Style 234 Create a PivotTable 236 Chapter 12 Analyzing Data Sort a Range or Table 240 Filter a Range or Table 242 Set Data Validation Rules 244 Create a Data Table 246 Summarize Data with Subtotals 248 Group Related Data 250 Analyze Data with Goal Seek 252 Analyze Data with Scenarios 254 Remove Duplicate Values from a Range or Table 258 Load the Excel Analysis ToolPak 260 Chapter 13 Visualizing Data with Charts Examine Chart Elements 264 Understanding Chart Types 265 Create a Chart 266 Create a Recommended Chart 268 Add Chart Titles 270 Add Data Labels 271 Position the Chart Legend 272 Display Chart Gridlines 273 Display a Data Table 274 Change the Chart Layout and Style 275 Select a Different Chart Type 276 Change the Chart Source Data 278 Move or Resize a Chart 280 Add a Sparkline to a Cell .282 Chapter 14 Adding Worksheet Graphics Draw a Shape 286 Insert a Clip Art Image 288 Insert a Photo 290 Insert a WordArt Image 292 Insert a SmartArt Graphic 294 Move or Resize a Graphic 296 Crop a Picture 298 Format a Picture 300 Chapter 15 Collaborating with Others Add a Comment to a Cell 304 Protect a Worksheet’s Data 306 Protect a Workbook’s Structure 308 Share a Workbook with Other Users 310 Track Workbook Changes 312 Accept or Reject Workbook Changes 314 Save a Workbook to Your SkyDrive 316 Send a Workbook as an E-Mail Attachment 318 Save Excel Data as a Web Page 320 Make a Workbook Compatible with Earlier Versions of Excel 322 Mark Up a Worksheet with a Digital Pen 324 Collaborate on a Workbook Online 326 Chapter 15 Collaborating with Others Index 328