Description
Pearson Excel 2016: Formulas And Functions by Paul McFedries
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.
Salient Features
Quickly create powerful spreadsheets with FlashFill
Use conditional formatting to instantly reveal anomalies, problems, or opportunities
Analyze your data with standard tables and PivotTables
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"