Excel 2016 All-in-One For Dummies (2016)

Excel 2016 All-in-One For Dummies (2016)

Book I: Excel Basics

Chapter 1: The Excel 2016 User Experience

Chapter 2: Customizing Excel 2016

Book II: Worksheet Design

Chapter 1: Building Worksheets

Chapter 2: Formatting Worksheets

Chapter 3: Editing and Proofing Worksheets

Chapter 4: Managing Worksheets

Chapter 5: Printing Worksheets

Book III: Formulas and Functions

Chapter 1: Building Basic Formulas

Chapter 2: Logical Functions and Error Trapping

Chapter 3: Date and Time Formulas

Chapter 4: Financial Formulas

Chapter 5: Math and Statistical Formulas

Chapter 6: Lookup, Information, and Text Formulas

Book IV: Worksheet Collaboration and Review

Chapter 1: Protecting Workbooks and Worksheet Data

Chapter 2: Using Hyperlinks

Chapter 3: Sending Workbooks Out for Review

Chapter 4: Sharing Workbooks and Worksheet Data

Book V: Charts and Graphics

Chapter 1: Charting Worksheet Data

Chapter 2: Adding Graphic Objects

Book VI: Data Management

Chapter 1: Building and Maintaining Data Lists

Chapter 2: Filtering and Querying a Data List

Book VII: Data Analysis

Chapter 1: Performing What-If Scenarios

Chapter 2: Performing Large-Scale Data Analysis

Book VIII: Macros and VBA

Chapter 1: Recording and Running Macros

Chapter 2: VBA Programming