Excel 2013 All-in-One For Dummies

Excel 2013 All-in-One For Dummies

by Greg Harvey

Paperback

$31.49 $34.99 Save 10% Current price is $31.49, Original price is $34.99. You Save 10%.
View All Available Formats & Editions
Use Standard Shipping. For guaranteed delivery by December 24, use Express or Expedited Shipping.

Product Details

ISBN-13: 9781118510100
Publisher: Wiley
Publication date: 03/04/2013
Series: For Dummies Series
Pages: 800
Sales rank: 187,795
Product dimensions: 6.90(w) x 9.30(h) x 1.90(d)

About the Author

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.

Read an Excerpt

Click to read or download

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

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews