McFedries P. Formulas and Functions with Microsoft Office Excel 2007

Pearson Education, Inc., 2007. — 540 p.The book is divided into four main parts. To give you the big picture before diving in, here’s a summary of what you’ll find in each part:Mastering Excel Ranges and Formulas—The five chapters in Part 1 tell you just about everything you need to know about building formulas in Excel. Starting with a thorough look at ranges (crucial for mastering formulas), this part also discusses operators, expressions, advanced formula features, and formula-troubleshooting techniques.Harnessing the Power of Functions—Functions take your formulas to the next level, and you’ll learn all about them in Part 2 . After you see how to use functions in your formulas, you examine the eight main function categories—text, logical, information, lookup, date, time, math, and statistical. In each case, I tell you how to use the functions and give you lots of practical examples that show you how you can use the functions in everyday business situations.Building Business Models—The five chapters in Part 3 are all business as they examine various facets of building useful and robust business models. You learn how to analyze data with Excel tables and PivotTables, how to use what-if analysis and Excel’s Goal Seek and scenarios features, how to use powerful regression-analysis techniques to track trends and make forecasts, and how to use the amazing Solver feature to solve complex problems.Building Financial Formulas—The book finishes with more business goodies related to performing financial wizardry with Excel. You learn techniques and functions for amortizing loans, analyzing investments, and using discounting for business case and cash-flow analysis.