Excel 2016: Formulas and Functions

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.

Key Features

1. Quickly create powerful spreadsheets with FlashFill
2. Use conditional formatting to instantly reveal anomalies, problems, or opportunities
3. Analyze your data with standard tables and PivotTables
4. Use complex criteria to filter data in lists
5. Understand correlations between data
6. Perform sophisticated what-if analyses
7. Use regression to track trends and make forecasts
8. Build loan, investment, and discount formulas
9. Validate data, troubleshoot problems, and build more accurate, trustworthy spreadsheets

Table of Contents

1. Chapter 1   Getting the Most Out of Ranges
2. Chapter 2   Using Range Names
3. Chapter 3   Building Basic Formulas
4. Chapter 4   Creating Advanced Formulas
5. Chapter 5   Troubleshooting Formulas
6. Chapter 6   Understanding Functions
7. Chapter 7   Working with Text Functions
8. Chapter 8   Working with Logical and Information Functions
9. Chapter 9   Working with Lookup Functions
10. Chapter 10   Working with Date and Time Functions
11. Chapter 11   Working with Math Functions
12. Chapter 12   Working with Statistical Functions
13. Chapter 13   Analyzing Data with Tables
14. Chapter 14   Analyzing Data with PivotTables
15. Chapter 15   Using Excel’s Business Modeling Tools
16. Chapter 16   Using Regression to Track Trends and Make Forecasts
17. Chapter 17   Solving Complex Problems with Solver
18. Chapter 18   Building Loan Formulas
19. Chapter 19   Building Investment Formulas
20. Chapter 20   Building Discount Formulas

Author Biography

Paul McFedries runs Logophilia Limited, a technical writing company, and has been writing computer books for more than 25 years. He is the author or coauthor of more than 90 books that have sold more than 4 million copies worldwide. Paul is also the proprietor of Wordspy.com, a website that tracks new words and phrases as they enter the language.