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

Joseph Rubin CPA (Author)

Book Description

Publication Date: October 2005

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.

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

About the Author

Joseph Rubin, CPA, principal of www.exceltip.com (a leading Excel Web site) is the author of the very successful books:
· F1 Get the Most out of Excel!
· F1 Get the Most out of Excel Formulas & Functions
· Financial Statements.xls

Joseph Rubin has over 27 years of financial experience in the accounting industry. He has served as CFO, Controller and has run his own CPA practice for many years. Joseph Rubin, CPA, is an independent consultant specializing in the development of applications using Microsoft Excel for the financial industry and has instructed thousands of professionals on Microsoft Excel.

Product Details

• Paperback: 460 pages
• Publisher: Limelight Media (October 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 Best Sellers Rank: #1,335,678 in Books (See Top 100 in Books)
  • #41 in Books > Computers & Technology > Microsoft > Spreadsheets

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

20 of 20 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
(VINE VOICE)    (TOP 500 REVIEWER)    (HALL OF FAME REVIEWER)    (REAL NAME)   

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

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

1 of 1 people found the following review helpful:

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

By 

grad student - See all my reviews

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

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)   

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

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.