Microsoft Excel 2016 BIBLE (2016)

Microsoft Excel 2016 BIBLE (2016)

Part I: Getting Started with Excel

Chapter 1: Introducing Excel

Chapter 2: Entering and Editing Worksheet Data

Chapter 3: Essential Worksheet Operations

Chapter 4: Working with Cells and Ranges

Chapter 5: Introducing Tables

Chapter 6: Worksheet Formatting

Chapter 7: Understanding Excel Files

Chapter 8: Using and Creating Templates

Chapter 9: Printing Your Work

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 44: UVBA Examples

Chapter 45: Creating Custom Excel Add-Ins

Part VII: Appendixes

Appendix A: Worksheet Function Reference

Appendix B: Excel Shortcut Keys