Microsoft Excel 2016 Bible

Acknowledgments
Introduction

Part I: Getting Started with Excel
1. Introducing Excel
2. Entering and Editing Worksheet Data
3. Essential Worksheet Operations
4. Working with Cells and Ranges
5. Introducing Tables
6. Worksheet Formatting
7. Understanding Excel Files
8. Using and Creating Templates
9. Printing Your Work

Part II: Working with Formulas and Functions
10. Introducing Formulas and Functions
11. Creating Formulas That Manipulate Text
12. Working with Dates and Times
13. Creating Formulas That Count and Sum
14. Creating Formulas That Look Up Values
15. Creating Formulas for Financial Applications
16. Miscellaneous Calculations
17. Introducing Array Formulas
18. Performing Magic with Array Formulas

Part III: Creating Charts and Graphics
19. Getting Started Making Charts
20. Learning Advanced Charting
21. Visualizing Data Using Conditional Formatting
22. Creating Sparkline Graphics
23. Enhancing Your Work with Pictures and Drawings

Part IV: Using Advanced Excel Features 601
24. Customizing the Excel User Interface
25. Using Custom Number Formats
26. Using Data Validation
27. Creating and Using Worksheet Outlines
28. Linking and Consolidating Worksheets
29. Excel and the Internet
30. Protecting Your Work
31. Making Your Worksheets Error Free

Part V: Analyzing Data with Excel
32. Importing and Cleaning Data
33. Introducing Pivot Tables
34. Analyzing Data with Pivot Tables
35. Performing Spreadsheet What-If Analysis
36. Analyzing Data Using Goal Seeking and Solver
37. Analyzing Data with the Analysis ToolPak
38. Working with Get & Transform

Part VI: Programming Excel with VBA
39. Introducing Visual Basic for Applications
40. Creating Custom Worksheet Functions
41. Creating UserForms
42. Using UserForm Controls in a Worksheet
43. Working with Excel Events
44. VBA Examples
45. Creating Custom Excel Add-Ins

Part VII: Appendixes
Appendix A: Worksheet Function Reference
Appendix B: Excel Shortcut Keys

Index