Microsoft Excel 2016 BIBLE (2016)
Part I: Getting Started with Excel
Chapter 2: Entering and Editing Worksheet Data
Chapter 3: Essential Worksheet Operations
Chapter 4: Working with Cells and Ranges
Chapter 6: Worksheet Formatting
Chapter 7: Understanding Excel Files
Chapter 8: Using and Creating Templates
Part II: Working with Formulas and Functions
Chapter 10: Introducing Formulas and Functions
Chapter 11: Creating Formulas That Manipulate Text
Chapter 12: Working with Dates and Times
Chapter 13: Creating Formulas That Count and Sum
Chapter 14: Creating Formulas That Look Up Values
Chapter 15: Creating Formulas for Financial Applications
Chapter 16: Miscellaneous Calculations
Chapter 17: Introducing Array Formulas
Chapter 18: Performing Magic with Array Formulas
Part III: Creating Charts and Graphics
Chapter 19: Getting Started Making Charts
Chapter 20: Learning Advanced Charting
Chapter 21: Visualizing Data Using Conditional Formatting
Chapter 22: Creating Sparkline Graphics
Chapter 23: Enhancing Your Work with Pictures and Drawings
Part IV: Using Advanced Excel Features
Chapter 24: Customizing the Excel User Interface
Chapter 25: Using Custom Number Formats
Chapter 26: Using Data Validation
Chapter 27: Creating and Using Worksheet Outlines
Chapter 28: Linking and Consolidating Worksheets
Chapter 29: Excel and the Internet
Chapter 30: Protecting Your Work
Chapter 31: Making Your Worksheets Error Free
Part V: Analyzing Data with Excel
Chapter 32: Importing and Cleaning Data
Chapter 33: Introducing Pivot Tables
Chapter 34: Analyzing Data with Pivot Tables
Chapter 35: Performing Spreadsheet What-If Analysis
Chapter 36: Analyzing Data Using Goal Seeking and Solver
Chapter 37: Analyzing Data with the Analysis ToolPak
Chapter 38: Working with Get & Transform
Part VI: Programming Excel with VBA
Chapter 39: Introducing Visual Basic for Applications
Chapter 40: Creating Custom Worksheet Functions
Chapter 41: Creating UserForms
Chapter 42: Using UserForm Controls in a Worksheet
Chapter 43: Working with Excel Events
Chapter 45: Creating Custom Excel Add-Ins
Part VII: Appendixes
Appendix A: Worksheet Function Reference
Appendix B: Excel Shortcut Keys