When you click on links to various merchants on this site and make a purchase, this can result in this site earning a commission. Affiliate programs and affiliations include, but are not limited to, the eBay Partner Network.
Excel 2016 Formulas (Mr. Spreadsheet's Bookshelf) by Alexander, Michael
- Item No : 167578744103
- Condition : Brand New
- Brand : No brand Info
- Seller : loveourprices2
- Current Bid : US $36.67
-
* Item Description
Introduction xxvii Part I: Understanding Formula Basics Chapter 1: The Excel User Interface in a Nutshell 3 Chapter 2: Basic Facts About Formulas 19 Chapter 3: Working with Names 45 Part II: Leveraging Excel Functions Chapter 4: Introducing Worksheet Functions 85 Chapter 5: Manipulating Text 99 Chapter 6: Working with Dates and Times 125 Chapter 7: Counting and Summing Techniques 163 Chapter 8: Using Lookup Functions 195 Chapter 9: Working with Tables and Lists 219 Chapter 10: Miscellaneous Calculations 257 Part III: Financial Formulas Chapter 11: Borrowing and Investing Formulas 279 Chapter 12: Discounting and Depreciation Formulas 299 Chapter 13: Financial Schedules 317 Part IV: Array Formulas Chapter 14: Introducing Arrays 341 Chapter 15: Performing Magic with Array Formulas 365 Part V: Miscellaneous Formula Techniques Chapter 16: Importing and Cleaning Data 393 Chapter 17: Charting Techniques 425 Chapter 18: Pivot Tables 469 Chapter 19: Conditional Formatting 521 Chapter 20: Using Data Validation 547 Chapter 21: Creating Megaformulas 561 Chapter 22: Tools and Methods for Debugging Formulas 581 Part VI: Developing Custom Worksheet Functions Chapter 23: Introducing VBA 607 Chapter 24: VBA Programming Concepts 627 Chapter 25: Function Procedure Basics 659 Chapter 26: VBA Custom Function Examples 679 Part VII: Appendixes Appendix A: Excel Function Reference 725 Appendix B: Using Custom Number Formats 743 Index 763
