Excel All-in-One For Dummies

ISBN-13: 9781119830726 / Angielski / Miękka / 2021 / 784 str.

Greg Harvey

Spis treści

Introduction 1Book 1: Excel Basics 7Chapter 1: Excel: The 50-Cent Tour 9Chapter 2: Customizing Excel 39Book 2: Worksheet Design 75Chapter 1: Building Worksheets 77Chapter 2: Formatting Worksheets 131Chapter 3: Editing and Proofing Worksheets 187Chapter 4: Managing Worksheets 229Chapter 5: Printing Worksheets 265Book 3: Formulas and Functions 291Chapter 1: Building Basic Formulas 293Chapter 2: Logical Functions and Error Trapping 337Chapter 3: Date and Time Formulas 363Chapter 4: Finagling Financial Formulas 377Chapter 5: Math and Statistical Formulas 393Chapter 6: Lookup, Information, and Text Formulas 411Book 4: Worksheet Collaboration and Review 439Chapter 1: Protecting Workbooks and Worksheet Data 441Chapter 2: Preparing a Workbook for Distribution 461Chapter 3: Sharing Workbooks and Worksheet Data 475Book 5: Charts and Graphics 501Chapter 1: Charting Worksheet Data 503Chapter 2: Adding Graphic Objects 533Book 6: Data Management 561Chapter 1: Building and Maintaining Tables 563Chapter 2: Filtering and Querying a Table 583Book 7: Data Analysis 617Chapter 1: Performing What-If Analysis 619Chapter 2: Performing Large-Scale Data Analysis 641Book 8: Macros and VBA 685Chapter 1: Recording and Running Macros 687Chapter 2: VBA Programming 701Index 725

O autorze

Paul McFedries has written over 100 books with topics ranging from Windows 10 to Microsoft Office, Apple gadgets, and Amazon Alexa. His most recent For Dummies titles include Google's G Suite, Cord Cutting, and Excel Data Analysis.Greg Harvey, PhD was author of over 30 For Dummies titles covering Excel.