Excel 2013 All-in-one for Dummies

  • ISBN13:


  • ISBN10:


  • Format: Paperback
  • Copyright: 2013-03-04
  • Publisher: For Dummies

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Purchase Benefits

  • Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $34.99 Save up to $11.48
  • Rent Book $31.49
    Add to Cart Free Shipping


Supplemental Materials

What is included with this book?

  • The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.
  • The Rental copy of this book is not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.


Excel 2013 All-In-One For Dummies will be completely updated to reflect the major changes Microsoft is making to Office. From basic Excel functions, such as creating and editing worksheets, to sharing and reviewing worksheets, to editing macros with Visual Basic, the Excel 2013 All-in-One For Dummies provides the reader with a broad scope of the most common Excel applications and functions -- including formatting worksheets, setting up formulas, protecting worksheets, importing data, charting data, and performing statistical functions. Covers importing data, building and editing worksheets, creating formulas, generating pivot tables, and performing financial functions, what-if scenarios, database functions, and Web queries. More advanced topics include: worksheet sharing and auditing, performing error trapping, building and running macros, charting data, and using Excel in conjunction with Visual Basic and the Web.

Author Biography

Greg Harvey, PhD, is President of Mind Over Media and a highly skilled instructor. He has been writing computer books for more than 20 years, and his long list of bestsellers includes all editions of Excel For Dummies, Excel All-in-One For Dummies, and Excel Workbook For Dummies.

Table of Contents

Introduction  1

About This Book 1

Foolish Assumptions 2

How This Book Is Organized 3

Book I: Excel Basics 3

Book II: Worksheet Design 3

Book III: Formulas and Functions 4

Book IV: Worksheet Collaboration and Review 5

Book V: Charts and Graphics 5

Book VI: Data Management 6

Book VII: Data Analysis 6

Book VIII: Macros and VBA 6

Conventions Used in This Book 7

Icons Used in This Book 8

Where to Go from Here 9

Book I: Excel Basics  11

Chapter 1: The Excel 2013 User Experience  13

Chapter 2: Customizing Excel 2013  41

Book II: Worksheet Design  73

Chapter 1: Building Worksheets 75

Chapter 2: Formatting Worksheets 125

Chapter 3: Editing and Proofing Worksheets 183

Chapter 4: Managing Worksheets 231

Chapter 5: Printing Worksheets 269

Book III: Formulas and Functions  297

Chapter 1: Building Basic Formulas 299

Chapter 2: Logical Functions and Error Trapping 339

Chapter 3: Date and Time Formulas 361

Chapter 4: Financial Formulas     375

Chapter 5: Math and Statistical Formulas 389

Chapter 6: Lookup, Information, and Text Formulas  409

Book IV: Worksheet Collaboration and Review  431

Chapter 1: Protecting Workbooks and Worksheet Data  433

Chapter 2: Using Hyperlinks 455

Chapter 3: Sending Workbooks Out for Review 463

Chapter 4: Sharing Workbooks and Worksheet Data 489

Book V: Charts and Graphics  513

Chapter 1: Charting Worksheet Data 515

Chapter 2: Adding Graphic Objects  545

Book VI: Data Management  575

Chapter 1: Building and Maintaining Data Lists 577

Chapter 2: Filtering and Querying a Data List 601

Book VII: Data Analysis  643

Chapter 1: Performing What-If Scenarios 645

Chapter 2: Generating Pivot Tables     667

Book VIII: Macros and VBA  707

Chapter 1: Building and Running Macros 709

Chapter 2: VBA Programming 721

Index  745

Rewards Program

Write a Review