Leverage the full power of Excel formulas
Excel 2016 Formulas is fully updated to cover all of the tips, tricks, and techniques you need to maximize the power of Excel 2016 through the use of formulas. This comprehensive book explains how to create financial formulas, release the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and much more. Whether you're a beginner, a power user, or somewhere in between this is your essential go-to for the latest on Excel formulas.
When conducting simple math or building highly complicated spreadsheets that require formulas up to the task, leveraging the right formula can heighten the accuracy and efficiency of your work, and can improve the speed with which you compile and analyze data. Understanding which formulas to use and knowing how to create a formula when you need to are essential.
* Access tips, tricks, and techniques that have been fully updated to reflect the latest capabilities of Microsoft Excel
* Create and use formulas that have the power to transform your Excel experience
* Leverage supplemental material online, including sample files, templates, and worksheets from the book
Produkt-Info
WebSite Associated w/Book
Reihe
Auflage
Sprache
Verlagsort
Zielgruppe
Produkt-Hinweis
Broschur/Paperback
Klebebindung
Maße
Höhe: 235 mm
Breite: 191 mm
Dicke: 43 mm
Gewicht
ISBN-13
978-1-119-06786-3 (9781119067863)
Schweitzer Klassifikation
Michael Alexander is a Microsoft Certified Application Developer and author of several books on Microsoft Access and Excel. He runs a free tutorial site at datapigtechnologies.com.
Dick Kusleika develops Access- and Excel-based solutions, and conducts Office training seminars in the U.S. and Australia. He writes the popular blog dailydoseofexcel.com.
John Walkenbach is a renowned authority on Excel. He has written hundreds of articles, thirty-plus books, created the award-winning Power Utility Pak, and developed the popular spreadsheetpage.com.
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
