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

by Joseph Rubin CPA (Author) "Select an empty cell and press <Shift+F3>..." (more)
Key Phrases: alphabetically lowest letter, week number corresponding, formula syntax, Time Out, Get the Most, Miscellaneous Calculation (more...)

Editorial Reviews

Review

"A wonderful grab-bag of solutions to all kinds of Excel conundrums."  —Simon Benninga, author, Principles of Finance with Excel

"Very easy to follow and the sample files are great for those who want to experiment."  —spreadsheetsolutions4u.com

Product Description

With more than 300 solutions to the time-consuming problem of combining Microsoft Excel functions into effective, problem-solving formulas, this handbook addresses questions that are regularly posted to Excel newsgroups—topics of the most interest to Excel users. Questions and answers provide a title, problem, solution, explanation, and screenshot, and include many of the complex formulas and their several nested functions. Formulas for wages, shifts, time sheets, income taxes, financial calculations, amortization tables, counting, and handling errors are demonstrated, and the accompanying CD-ROM contains Excel workbook files that incorporate all the formulas presented in the book. Each question and answer includes a hyperlink that allows interested readers to visit the author's website to discuss problems and proposed solutions.

See all Editorial Reviews

Product Details

• Paperback: 460 pages
• Publisher: Limelight Media (December 2005)
• Language: English
• ISBN-10: 0974636851
• ISBN-13: 978-0974636856
• Product Dimensions: 8.8 x 7.4 x 1.3 inches
• Shipping Weight: 2.1 pounds
• Average Customer Review: 4.3 out of 5 stars See all reviews (3 customer reviews)
• Amazon.com Sales Rank: #765,631 in Books (See Bestsellers in Books)

  Popular in this category: (What's this?)

  #44 in

  Books > Computers & Internet > Microsoft > Spreadsheets

Customer Reviews

Most Helpful Customer Reviews

18 of 18 people found the following review helpful:

4.0 out of 5 stars Nice problem-solving reference..., November 19, 2005

By	Thomas Duff "Duffbert" (Portland, OR United States) - See all my reviews (TOP 50 REVIEWER)    (REAL NAME)

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...

5.0 out of 5 stars Never use help again!, April 28, 2008

By	grad student - See all my reviews

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!

2 of 4 people found the following review helpful:

4.0 out of 5 stars Top-notch Reference, March 20, 2006

By	M. Dowell "grmschlr" - See all my reviews (REAL NAME)

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.