Book description
Grab these Excel formulas and functions to make your life easier!Are you intimidated by major financial choices, like which loan to get or how to grow your savings? Don't worry—we all are! But Excel Formulas & Functions For Dummies, 4th Edition can take some of the pain out of the data organization and analysis processes. This step-by-step reference sheds light on Microsoft Excel's 150 most useful functions, and offers detailed instructions on how to implement them. Additionally, each function is illustrated by helpful, real-world examples that show how they are used within a larger formula. To take your knowledge of Excel's functions a step further, 85 specialized functions are described in abbreviated form so you can use Excel to better support your decision-making process when securing a mortgage, buying a car, computing classroom grades, evaluating investment performance, and more.
Functions are predefined formulas that you can use to make data analysis a bit easier within the Microsoft Excel framework. Functions use specific values, called arguments, to calculate a variety of things, from simple sums and averages to more complicated loan payments.
- Explore the 150 most useful functions that help Microsoft Excel make your life easier
- Access real-world examples of how functions fit into larger formulas
- Discover 85 specialized functions, which are described in abbreviated form and take your knowledge of Excel to the next level
- Understand how Microsoft Excel can help you make key decisions, such as whether to go with a 15-year or 30-year mortgage
Excel Formulas & Functions For Dummies, 4th Edition brings order to chaotic data—and helps you make decisions with confidence!
Table of contents
-
- Cover
- Introduction
- Part I: Getting Started with Formulas and Functions
- Part II: Doing the Math
- Part III: Solving with Statistics
-
Part IV: Dancing with Data
- Chapter 12: Dressing Up for Date Functions
- Chapter 13: Keeping Well-Timed Functions
- Chapter 14: Using Lookup, Logical, and Reference Functions
- Chapter 15: Digging Up the Facts
- Chapter 16: Writing Home about Text Functions
-
Chapter 17: Playing Records with Database Functions
- Putting Your Data into a Database Structure
- Working with Database Functions
- Fine-Tuning Criteria with AND and OR
- Adding Only What Matters with DSUM
- Going for the Middle with DAVERAGE
- Counting Only What Matters with DCOUNT
- Finding Highest and Lowest with DMIN and DMAX
- Finding Duplicate Values with DGET
- Being Productive with DPRODUCT
- Part V: The Part of Tens
- About the Author
- Cheat Sheet
- Advertisement Page
- Connect with Dummies
- End User License Agreement
Product information
- Title: Excel Formulas and Functions For Dummies, 4th Edition
- Author(s):
- Release date: December 2015
- Publisher(s): For Dummies
- ISBN: 9781119076780
You might also like
book
Excel Formulas & Functions For Dummies, 5th Edition
Put the power of Excel functions to work in your formulas There are more than 400 …
book
Excel Formulas & Functions For Dummies, 6th Edition
Unlock the power of Excel with a step-by-step roadmap to its formulas and functions There's a …
book
Excel All-in-One For Dummies
Excel-erate your productivity with the only guide you'll need to the latest versions of Microsoft Excel …
book
Microsoft Excel Functions & Formulas
Easy to use and equipped with a variety of functions, Microsoft Excel is the tool of …