Excel 2013 Formulas and Functions - 9780789748676

Managers, entrepreneurs, and business professionals of all kinds need better skills for building more powerful Microsoft Excel spreadsheet models. In this book, Paul McFedries cuts through Excel 2013's complexity, thoroughly demystifying the most valuable features for spreadsheet model-builders: formulas, functions, ranges, and data analysis tools.

Drawing on his unsurpassed experience simplifying difficult technologies for mainstream users, McFedries walks through using these features to solve a wide variety of real-world problems. Readers will learn how to:

* Create advanced formulas and troubleshoot formula problems

* Work with text, logical, information, lookup, date/time, math, and statistical functions

* Analyze data with standard tables and PivotTables

* Use Excel 2013's powerful business modeling tools

* Utilize Regression to track trends and make forecasts

* Build loan, investment, and discount formulas, and more

Packed with no-nonsense, step-by-step tutorials and practical examples, Excel 2013 Formulas and Functions has been thoroughly updated to reflect Excel 2013's many improvements, as well as features introduced with Excel 2010 and 2007 that many users haven't yet mastered yet.

This book is part of the popular MrExcel's Library series, edited by Bill Jelen, world-renowned Excel expert and host of leading Excel help site MrExcel.com.