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.
Это и многое другое вы найдете в книге F1 Get the Most Out of Excel Formulas & Functions: The Ultimate Excel Formulas & Functions Help Guide (Joseph Rubin)