Excel 2019 All-In-One for Dummies by Harvey, Greg

Description: Greg Harvey, PhD, is a veteran computer educator dating back to the days of DOS and Lotus 1-2-3. He has taught spreadsheet and database management courses at Golden Gate University and written dozens of books, including many in the For Dummies series. Introduction 1 Book 1: Excel Basics 11 Chapter 1: The Excel 2019 User Experience 13 Chapter 2: Customizing Excel 2019 45 Book 2: Worksheet Design 79 Chapter 1: Building Worksheets 81 Chapter 2: Formatting Worksheets 133 Chapter 3: Editing and Proofing Worksheets 193 Chapter 4: Managing Worksheets 241 Chapter 5: Printing Worksheets 277 Book 3: Formulas and Functions 305 Chapter 1: Building Basic Formulas 307 Chapter 2: Logical Functions and Error Trapping 347 Chapter 3: Date and Time Formulas 371 Chapter 4: Financial Formulas 387 Chapter 5: Math and Statistical Formulas 401 Chapter 6: Lookup, Information, and Text Formulas 421 Book 4: Worksheet Collaboration and Review 445 Chapter 1: Protecting Workbooks and Worksheet Data 447 Chapter 2: Using Hyperlinks 469 Chapter 3: Preparing a Workbook for Distribution 477 Chapter 4: Sharing Workbooks and Worksheet Data 491 Book 5: Charts and Graphics 517 Chapter 1: Charting Worksheet Data 519 Chapter 2: Adding Graphic Objects 553 Book 6: Data Management 583 Chapter 1: Building and Maintaining Data Lists 585 Chapter 2: Filtering and Querying a Data List 609 Book 7: Data Analysis 647 Chapter 1: Performing What-If Scenarios 649 Chapter 2: Performing Large-Scale Data Analysis 673 Book 8: Macros and VBA 719 Chapter 1: Recording and Running Macros 721 Chapter 2: VBA Programming 733 Index 757

Price: 37.99 USD

Location: East Hanover, New Jersey

End Time: 2024-12-04T18:50:54.000Z

Shipping Cost: 0 USD