Excel 2016: Formulas and Functions By Paul Mcfedries (9789332578616)

Description

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.

Table of Content 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 PivotTables , 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 ,

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”

---

Author: Paul Mcfedries
Publisher: Pearson India
ISBN-13: 9789332578616
Language: English
Binding: Paper Back
No. Of Pages: 528
Country of Origin: India
International Shipping: No