Dummies.com
  • Print
  • Share
Excel 2013 All-in-One For Dummies (1118550218) cover image

Excel 2013 All-in-One For Dummies

ISBN: 978-1-118-55021-2
E-book
792 pages
February 2013
US $22.99 Purchase This E-book

This price is valid for United States. Change location to view local pricing and availability.

How to read this e-book on:

Adobe e-books are read using Adobe Digital Editions. Install Adobe Digital Editions on your PC in order to read or transfer your e-book.
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

  • Print
  • Share