Excel 2016 Formulas

Introduction

Part I: Understanding Formula Basics
1. The Excel User Interface in a Nutshell
2. Basic Facts About Formulas
3. Working with Names

Part II: Leveraging Excel Functions
4. Introducing Worksheet Functions
5. Manipulating Text
6. Working with Dates and Times
7. Counting and Summing Techniques
8. Using Lookup Functions
9. Working with Tables and Lists
10. Miscellaneous Calculations

Part III: Financial Formulas
11. Borrowing and Investing Formulas
12. Discounting and Depreciation Formulas
13. Financial Schedules

Part IV: Array Formulas
14. Introducing Arrays
15. Performing Magic with Array Formulas

Part V: Miscellaneous Formula Techniques
16. Importing and Cleaning Data
17. Charting Techniques
18. Pivot Tables
19. Conditional Formatting
20. Using Data Validation
21. Creating Megaformulas
22. Tools and Methods for Debugging Formulas

Part VI: Developing Custom Worksheet Functions
23. Introducing VBA
24. VBA Programming Concepts
25. Function Procedure Basics
26. VBA Custom Function Examples

Part VII: Appendixes
Appendix A: Excel Function Reference
Appendix B: Using Custom Number Formats

Index