Conquer Microsoft® Excel® formulas and functions—from the inside out!
You’re beyond the basics, so dive right in and really put Excel formulas and functions to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds. It’s all muscle and no fluff. Discover how the experts increase their data analysis capabilities using Excel 2003, 2007, or 2010—and challenge yourself to new levels of mastery.
Customize Excel formulas using 350+ built-in functions
Create reusable formulas for common calculations
Learn smarter ways to calculate date and time values
Systematically search worksheets with lookup and reference functions
Perform advanced calculations using mathematical, statistical, and financial functions
Build complex formulas by nesting one function inside of another
Analyze profit margins and more with new functions in Excel 2010
Develop your own functions with Visual Basic® for Applications (VBA)
NOTE: The sample Excel files that accompany the book were updated on 12/4/2012. Click the Companion Content link to download the files.
Most Helpful Customer Reviews
When I read that someone had written a book documenting EVERY formula used in Excel, I didn't believe it. First of all, who has that kind of time? Secondly, Why?
When I first received the book and attempted to thumb through it, I was AMAZED. The book is not only comprehensive in its coverage of ALL THE FORMULAS, but also includes highly detailed explanations (including examples) of all the formulas and functions included in the program.
I do not envision anyone actually sitting down to read this entire book, but as a reference for ANYone who finds themselves looking for a quick reference to better understand some of the extended functionality of Excel, I think this book is invaluable.
As someone who has used Excel for 23 years and training people in Excel for 18 years I thought that I knew Exce well!
I do know Excel very well but this book has blown me away with its explanations of every single function in Excel 2010. I haven't read every page but the tips and insight into each function is amazing.
I will be using this book as a reference for a long time to come and continue to discover new functions and uses for functions on every read.
Highly recommended as a reference book and also a great challange to learn something new for those experienced Excel users out there.
For anyone who feels confident with the core features of Excel, this is a very useful guide. Once you are comfortable with spreadsheets you don't want to sift through masses of pages to find the specific reference that you are after. Instead, you just want the formula and the key things to look out for when plugging it in to your data - this is exactly what this book delivers.
In a simple alphabetic fashion you can find any formula that you are after, a discussion of each argument required and details of different ways in which they can be treated. One of the best features is the `Note' section which succinctly illustrates any common problems that you may encounter with this particular function.
I have found I don't need to hunt for examples either because they are covered here too. This is great because sometimes seeing something presented in the context of an example makes it easier to understand and apply to your own circumstances. There isn't a lot more that...
The authorised South African distributor of this product is under no obligation to honour the manufacture's guarantees/warranties or to provide after-sales service.
Please note that this item is imported from the USA, and is designed to be used in the USA. In addition, if the unit is powered it will come with a US plug and an adapter/transformer may be required. Please click here for more information on power requirements, or check with us if you are unsure or need any assistance!
Please also note that certain items cannot be imported, these include Alcohol, Animals, Batteries, Flammable Materials, Currency, Food, Furs, Chemicals, Explosives, Medications, Plants, Seeds, Supplements, Pressurized Cans, Tactical Equipment, Vitamins, Weaponry and Weaponry Accessories. In these cases, the item and information is displayed for reference purposes only. If you are not sure if we are permitted to bring an item, please send us an e-mail with a link to the item to confirm.
Please also ensure that you are ordering the correct item for your particular application as returns to the USA are costly. Product reviews are also provided for most of our items, which can give you a good idea for possible things to look out for and the quality of the item. By clicking Add to Cart, you are confirming that the item is correct and you accept the conditions listed here.