Australasia's Biggest Online Store

Turn your Clutter Into Cash with SmartSell.TM Book a Courier Pickup Today!

Excel 2013 Formulas


Product Description
Product Details

Table of Contents

Introduction 1 PART I: Basic Information Chapter 1: Excel in a Nutshell 9 Chapter 2: Basic Facts about Formulas 33 Chapter 3: Working with Names 61 PART II: Using Functions in Your Formulas Chapter 4: Introducing Worksheet Functions 105 Chapter 5: Manipulating Text 123 Chapter 6: Working with Dates and Times 149 Chapter 7: Counting and Summing Techniques 187 Chapter 8: Using Lookup Functions 221 Chapter 9: Working with Tables and Lists 243 Chapter 10: Miscellaneous Calculations 283 PART III: Financial Formulas Chapter 11: Borrowing and Investing Formulas 307 Chapter 12: Discounting and Depreciation Formulas 327 Chapter 13: Financial Schedules 345 PART IV: Array Formulas Chapter 14: Introducing Arrays 369 Chapter 15: Performing Magic with Array Formulas 395 PART V: Miscellaneous Formula Techniques Chapter 16: Importing and Cleaning Data 421 Chapter 17: Charting Techniques 449 Chapter 18: Pivot Tables 493 Chapter 19: Conditional Formatting 545 Chapter 20: Using Data Validation 571 Chapter 21: Creating Megaformulas 583 Chapter 22: Tools and Methods for Debugging Formulas 601 PART VI: Developing Custom Worksheet Functions Chapter 23: Introducing VBA 629 Chapter 24: Function Procedure Basics 643 Chapter 25: VBA Programming Concepts 665 Chapter 26: VBA Custom Function Examples 701 PART VII: Appendixes Appendix A: Excel Function Reference 751 Appendix B: Using Custom Number Formats 769 Index 791

About the Author

John Walkenbach, arguably the foremost authority on Excel, has written 50+ books, including multiple editions of the bestselling Excel Bible and Excel Power Programming with VBA, as well as more than 300 articles for publications such as PC World, InfoWorld, and Windows. He created the award-winning Power Utility Pak, and provides Excel information and insight at

Ask a Question About this Product More...
Write your question below:
Look for similar items by category
How Fishpond Works
Fishpond works with suppliers all over the world to bring you a huge selection of products, really great prices, and delivery included on over 25 million products that we sell. We do our best every day to make Fishpond an awesome place for customers to shop and get what they want — all at the best prices online.
Webmasters, Bloggers & Website Owners
You can earn a 5% commission by selling Excel 2013 Formulas on your website. It's easy to get started - we will give you example code. After you're set-up, your website can earn you money while you work, play or even sleep! You should start right now!
Authors / Publishers
Are you the Author or Publisher of a book? Or the manufacturer of one of the millions of products that we sell. You can improve sales and grow your revenue by submitting additional information on this title. The better the information we have about a product, the more we will sell!
Item ships from and is sold by Fishpond World Ltd.
Back to top