Excel 2013 for Dummies

by Harvey, Greg

• ISBN13: 9781118510124
• ISBN10: 1118510127
• Edition: 1st
• Format: Paperback
• Copyright: 2013-01-29
• Publisher: For Dummies

Summary

Excel 2013 For Dummies will be updated to reflect the major changes Microsoft is making to Office. Covers everything you need to know to perform the task at hand. Includes information on creating and editing worksheets, formatting cells, entering formulas, creating and editing charts, inserting graphs, designing database forms, adding database records, using seek-and-find options, printing, adding hyperlinks to worksheets, saving worksheets as web pages, adding existing worksheet data to an existing web page, and sending worksheets via e-mail.

Author Biography

Greg Harvey, PhD, is President of Mind Over Media, an online media company. He has written all editions of Excel For Dummies, Excel All-in-One For Dummies, and Excel Workbook For Dummies. Greg is an experienced educator with a wide variety of interests.

Table of Contents

Introduction  1

Part I: Getting Started with Excel 2013  9

Chapter 1: The Excel 2013 User Experience 11

Chapter 2: Creating a Spreadsheet from Scratch 41

Part II: Editing without Tears  95

Chapter 3: Making It All Look Pretty 97

Chapter 4: Going Through Changes 143

Chapter 5: Printing the Masterpiece 175

Part III: Getting Organized and Staying That Way  201

Chapter 6: Maintaining the Worksheet 203

Chapter 7: Maintaining Multiple Worksheets 229

Part IV: Digging Data Analysis  251

Chapter 8: Doing What-If Analysis 253

Chapter 9: Playing with Pivot Tables 267

Part V: Life beyond the Spreadsheet  289

Chapter 10: Charming Charts and Gorgeous Graphics 291

Chapter 11: Getting on the Data List 327

Chapter 12: Linking, Automating, and Sharing Spreadsheets 351

Part VI: The Part of Tens  375

Chapter 13: Top Ten Beginner Basics 377

Chapter 14: The Ten Commandments of Excel 2013 379

Index  381