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
Price: 41.86 USD
Location: Matraville, NSW
End Time: 2025-01-01T23:31:25.000Z
Shipping Cost: 0 USD
Product Images
Item Specifics
Return shipping will be paid by: Buyer
All returns accepted: Returns Accepted
Item must be returned within: 60 Days
Refund will be given as: Money Back
Return policy details:
EAN: 9781119067863
UPC: 9781119067863
ISBN: 9781119067863
MPN: N/A
Format: Paperback, 816 pages
Author: Alexander, Michael
Item Height: 4.8 cm
Item Length: 23.1 cm
Item Weight: 0.73 kg
Item Width: 18.5 cm
Language: Eng
Publication Name: N/A
Publisher: Wiley
Type: N/A
