Overview of Excel 2016 Formulas and Functions 1/e Book

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

• Book Type :

Software&BusinessApplications

• Book Binding :

Paperback

• Language :

English

• Number of Pages :

528 pages

• ISBN - 10 :

9332578613

• Excel 2016 Formulas and Functions 1/e Published On :

29 Sep 2016

• Resource:

Students and Professionals:Computing,Internet&DigitalMedia, Software&BusinessApplications

Disclaimer:

• Excel 2016 Formulas and Functions 1/e Book is not for reading online or for free download in PDF or eBook format.
• Table of Contents,Index,Syllabus,summary and image of Excel 2016 Formulas and Functions 1/e book may be of a different edition or of the same title.
• Price can change due to reprinting, price change by publisher or sourcing cost change for imported books.