Excel 2016 All-in-One For Dummies

Excel 2016 All-in-One For Dummies

by Greg Harvey

Paperback

$31.99 $39.99 Save 20% Current price is $31.99, Original price is $39.99. You Save 20%.
View All Available Formats & Editions
Choose Expedited Shipping at checkout for guaranteed delivery by Monday, November 19

Product Details

ISBN-13: 9781119077152
Publisher: Wiley
Publication date: 11/16/2015
Series: For Dummies Series
Pages: 816
Sales rank: 18,839
Product dimensions: 7.30(w) x 9.20(h) x 1.60(d)

About the Author

Greg Harvey, PhD, is the president of Mind Over Media, LLC., and a bestselling author of books on Excel, including all editions of Excel For Dummies and Excel Workbook For Dummies. He began teaching business users about computers back in the 1980s, and has been a dedicated educator ever since.

Table of Contents

Introduction 1

Book I: Excel Basics 11

Chapter 1: The Excel 2016 User Experience 13

Chapter 2: Customizing Excel 2016 43

Book II: Worksheet Design 75

Chapter 1: Building Worksheets 77

Chapter 2: Formatting Worksheets 127

Chapter 3: Editing and Proofing Worksheets 185

Chapter 4: Managing Worksheets 233

Chapter 5: Printing Worksheets 269

Book III: Formulas and Functions 297

Chapter 1: Building Basic Formulas 299

Chapter 2: Logical Functions and Error Trapping 341

Chapter 3: Date and Time Formulas 363

Chapter 4: Financial Formulas 379

Chapter 5: Math and Statistical Formulas 393

Chapter 6: Lookup, Information, and Text Formulas 413

Book IV: Worksheet Collaboration and Review 435

Chapter 1: Protecting Workbooks and Worksheet Data 437

Chapter 2: Using Hyperlinks 459

Chapter 3: Sending Workbooks Out for Review 467

Chapter 4: Sharing Workbooks and Worksheet Data 495

Book V: Charts and Graphics 519

Chapter 1: Charting Worksheet Data 521

Chapter 2: Adding Graphic Objects 553

Book VI: Data Management 581

Chapter 1: Building and Maintaining Data Lists 583

Chapter 2: Filtering and Querying a Data List 607

Book VII: Data Analysis 649

Chapter 1: Performing What-If Scenarios 651

Chapter 2: Performing Large-Scale Data Analysis 675

Book VIII: Macros and VBA 721

Chapter 1: Recording and Running Macros 723

Chapter 2: VBA Programming 735

Index 759

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews