![Excel 2016 Formulas and Functions 1/e by McFedries Book-9789332578616 Excel 2016 Formulas and Functions 1/e by McFedries Book-9789332578616](https://www.madrasshoppe.com/26600-large_default/excel-2016-formulas-and-functions-1-e-mcfedries.jpg)
![Excel 2016 Formulas and Functions 1/e by McFedries Book-9789332578616 Excel 2016 Formulas and Functions 1/e by McFedries Book-9789332578616](https://www.madrasshoppe.com/26600-large_default/excel-2016-formulas-and-functions-1-e-mcfedries.jpg)
Book Title: | Excel 2016 Formulas and Functions 1/e |
Author: | McFedries |
ISBN-13: | 9789332578616 |
Publication: | Pearson Education India |
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
Software&BusinessApplications
Paperback
English
528 pages
9332578613
29 Sep 2016
Students and Professionals:Computing,Internet&DigitalMedia, Software&BusinessApplications
Disclaimer: