Excel 2019 All-In-One for Dummies

ISBN-13: 9781119517948 / Angielski / Miękka / 2018 / 816 str.

Greg Harvey

Opis

Make Excel work for you Excel 2019 All-In-One For Dummies offers eight books in one!! It is completely updated to reflect the major changes Microsoft is making to Office with the 2019 release.

Spis treści

Introduction 1Book 1: Excel Basics 11Chapter 1: The Excel 2019 User Experience 13Chapter 2: Customizing Excel 2019 45Book 2: Worksheet Design 79Chapter 1: Building Worksheets 81Chapter 2: Formatting Worksheets 133Chapter 3: Editing and Proofing Worksheets 193Chapter 4: Managing Worksheets 241Chapter 5: Printing Worksheets 277Book 3: Formulas and Functions 305Chapter 1: Building Basic Formulas 307Chapter 2: Logical Functions and Error Trapping 347Chapter 3: Date and Time Formulas 371Chapter 4: Financial Formulas 387Chapter 5: Math and Statistical Formulas 401Chapter 6: Lookup, Information, and Text Formulas 421Book 4: Worksheet Collaboration and Review 445Chapter 1: Protecting Workbooks and Worksheet Data 447Chapter 2: Using Hyperlinks 469Chapter 3: Preparing a Workbook for Distribution 477Chapter 4: Sharing Workbooks and Worksheet Data 491Book 5: Charts and Graphics 517Chapter 1: Charting Worksheet Data 519Chapter 2: Adding Graphic Objects 553Book 6: Data Management 583Chapter 1: Building and Maintaining Data Lists 585Chapter 2: Filtering and Querying a Data List 609Book 7: Data Analysis 647Chapter 1: Performing What-If Scenarios 649Chapter 2: Performing Large-Scale Data Analysis 673Book 8: Macros and VBA 719Chapter 1: Recording and Running Macros 721Chapter 2: VBA Programming 733Index 757

O autorze

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.