Customer Reviews

F1 Get the Most Out of Excel Formulas & Functions: The Ultimate Excel Formulas & Functions Help Guide

5 star:		(1)
4 star:		(2)
3 star:		(0)
2 star:		(0)
1 star:		(0)

 

 

If you spend much time in Excel as part of your daily routine, you probably end up running across things you just don't know how to do. Joseph Rubin's latest book F1 Get The Most Out Of Excel Formulas And Functions might be a really good resource to bail you out when necessary...

Contents: Working With Formulas; Text; Date & Time; Lookup; Logical & Errors; Counting; Summing; List; Miscellaneous Calculation & Math; Income Tax & Financial; List of Functions; Index

There are a large number of "how to" items in this volume, formatted with the pattern of "Problem", "Solution", and "Explanation". Usually each of these are accompanied with a graphic that represents the spreadsheet and/or formula solution. The writing is tight and to the point, so there's not pages and pages of explanations on any single problem. It's a quick "get in, get out" type of tip that should point you in the right direction. I even found a solution to a spreadsheet issue I had (that I wasn't even looking to solve!). I have a spreadsheet that tracks my Amazon reviewer stats, and a couple of the columns show error statements for the blank lines because there are references to cells that aren't yet filled in. With one of these tips, I am now able to avoid that problem. Nice!

If you don't know Excel, then this book isn't going to teach it to you. But if you've conquered the basics and now want to do real work, this is a nice volume to keep on hand to help you around the minor roadblocks you'll be sure to encounter...

I love this book. I should have bought it years ago. Now I will never have to use the help function in Excel to figure out how to do something with a formula, ever again!

Though not a guru, I use Excel quite alot for business and personal purposes. I went through this book page-by-page, marking with post-its the formulas I'd be using. Though there was some more in-depth text manipulation missing, I will have this book handy whenever I embark on an Excel project.