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.
Joseph Rubin, C.P.A., is the principal of ExcelTip.com, a leading Excel web site, and the coauthor of Mr. Excel on Excel. He is an independent consultant specializing in the development of applications using Microsoft Excel for the financial industry. He has served as a chief financial officer, controller, and has run a private CPA practice. He lives in Los Angeles.