Excel master John Walkenbach shows the reader how to create financial formulas, release the power of array formulas, develop custom worksheet functions with VBA, debug formulas, and much more. "Excel "X" Formulas" is a invaluable reference for Excel beginners, intermediate users, power users, and would-be power users. Fully updated for the new Microsoft Office release, this latest edition provides comprehensive formulas coverage, delivering more than 800 pages of Excel tips, tricks, and techniques readers won't find anywhere else. Includes valuable content online with sample files, templates and worksheets from the book.
This is my go to book for working with Excel formulas. Even though I am now using 2016 this books still covers the basic formula questions and the more experienced issues that I face. It's right by my desk ready for the next use. Great detail and step by step instructions and it's easy to find what you need.
An excellent primer on Excel functionality with brilliant tips and tricks that help you make the most of it. Every single workaround I'd imagined or had to use in the last three months was printed there plain as daylight. Only wish I'd read it earlier.