Excel 2013 Formulas and Function

DescriptionAster core Excel 2013 tools for building powerful, reliable spreadsheets!Excel expert Paul McFedries shows how to use Excel 2013s core features to solve problems and get the answers you need. Using real-world examples, McFedries helps you get the absolute most out of features and improvements ranging from FlashFill to Excels newest functions. Along the way, you discover the fastest, best ways to handle essential day-to-day tasks ranging from generating account numbers to projecting the impact of inflation.Becoming an Excel expert has never been easier! You’ll find crystal-clear instructions insider insights even complete step-by-step projects for building timesheets, projecting cash flow, aging receivables, analyzing defects, and more.Key FeaturesThe power users guide to building powerful, reliable spreadsheet models with Excel 2013 data analysis tools, formulas, functions and lists!No-nonsense, step-by-step tutorials and practical examples from a world-renowned expert in demystifying complex technology, Paul McFedriesThoroughly updated to reflect Excel 2013s newest and best improvementsIncludes specific techniques for analyzing complex data, modeling business problems, tracking trends, making forecasts, and building financial formulasPart of the popular MrExcels Library series, edited by Excel legend Bill JelenTable of ContentsPart I: Mastering Excel Ranges and FormulasChapter 1 Getting the Most Out of RangesChapter 2 Using Range NamesChapter 3 Building Basic FormulasChapter 4 Creating Advanced FormulasChapter 5 Troubleshooting FormulasPart II: Harnessing the Power of FunctionsChapter 6 Understanding FunctionsChapter 7 Working with Text FunctionsChapter 8 Working with Logical and Information FunctionsChapter 9 Working with Lookup FunctionsChapter 10 Working with Date and Time FunctionsChapter 11 Working with Math FunctionsChapter 12 Working with Statistical FunctionsPart III: Building Business ModelsChapter 13 Analyzing Data with TablesChapter 14 Analyzing Data with PivotTablesChapter 15 Using Excels Business-Modeling ToolsChapter 16 Using Regression to Track Trends and Make ForecastsChapter 17 Solving Complex Problems with SolverPart IV: Building Financial FormulasChapter 18 Building Loan FormulasChapter 19 Building Investment FormulasChapter 20 Building Discount FormulasAuthor BiographyPaul McFedries is an Excel expert and full-time technical writer. Paul has been authoring computer books since 1991 and has more than 80 books to his credit, which combined have sold more than four million copies worldwide. His titles include the Que Publishing books Windows 8 In Depth (with coauthor Brian Knittel), PCs for Grownups, and Tweak It and Freak It: A Killer Guide to Making Windows Run Your Way, as well as the Sams Publishing book Windows 7 Unleashed.