Excel 2016 Formulas and Functions 1/e

This book provides coverage of specific features and functions related to their particular productivity use. This series is for students who need to go further with the software to specifically solve complex applications and uses. This book not only takes them through Excel's intermediate and advanced options, but also tells them why these options are useful and shows them how to use them in everyday situations and real-world models with no-nonsense, step-by-step tutorials and lots of practical, useful examples.
Quickly create powerful spreadsheets with Flash fill.
Use conditional formatting to instantly reveal anomalies, problems or opportunities.
Analyze your data with standard tables and Pivot Tables.
Use complex criteria to filter data in lists.
Understand correlations between data.
Perform sophisticated what-if analyses.
Use regression to track trends and make forecasts.
Build loan, investment and discount formulas.
Validate data, troubleshoot problems and build more accurate, trustworthy spreadsheets.

Chapter 1 Getting the Most Out of Ranges
Chapter 2 Using Range Names
Chapter 3 Building Basic Formulas
Chapter 4 Creating Advanced Formulas
Chapter 5 Troubleshooting Formulas
Chapter 6 Understanding Functions
Chapter 7 Working with Text Functions
Chapter 8 Working with Logical and Information Functions
Chapter 9 Working with Lookup Functions
Chapter 10 Working with Date and Time Functions
Chapter 11 Working with Math Functions
Chapter 12 Working with Statistical Functions
Chapter 13 Analyzing Data with Tables
Chapter 14 Analyzing Data with Pivot Tables
Chapter 15 Using Excel s Business Modeling Tools
Chapter 16 Using Regression to Track Trends and Make Forecasts
Chapter 17 Solving Complex Problems with Solver
Chapter 18 Building Loan Formulas
Chapter 19 Building Investment Formulas
Chapter 20 Building Discount Formulas