Free Worldwide Shipping

Shop over 1 Million Toys in our Huge New Range

Excel 2013 All-In-One for Dummies
By

Rating

Product Description
Product Details

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

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 .

Ask a Question About this Product More...
Write your question below:
Look for similar items by category
Item ships from and is sold by Fishpond World Ltd.
Back to top