Excel 2016 Formulas and Functions 1/e
(Paperback)

4 products added to cart in last 30 minutes
MRP: ₹749.00 | Saved: ₹211 (28%) ₹538.00 @ Amazon Last Updated: 15-Jul-2018 12:27:46 am
✅ Lowest price available on Amazon
✅ Usually dispatched within 24 hours
✅ Total 37 new items found
✅ Eligible for Prime
✅ Eligible for Super Saver Shipping

Related Categories

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

AuthorMcFedries
BindingPaperback
EAN9789332578616
EditionFirst
ISBN9332578613
Weight137 g
LanguageEnglish
Language TypePublished
Number Of Pages528
Package Quantity4
Product GroupBook
Publication Date2016-09-29
PublisherPearson Education India
StudioPearson Education India
Sales Rank91890

Bestsellers in Software & Business Applications

Trending Products at this Moment

General information about Excel 2016 Formulas and Functions 1/e