Book description
Unlock the power of Excel with a stepbystep roadmap to its formulas and functionsThere's a Swiss Army knife in your digital toolbox that can multiply your productivity and make you the smartest guy or gal in almost any room. It's called Microsoft Excel.
If you're like most people, you've barely scratched the surface of what this powerful tool's hundreds of builtin functions can do. But with a little help from Excel Formulas & Functions For Dummies, you'll soon be organizing, analyzing, and interpreting data like a pro.
For those who don't know the difference between a spreadsheet and a bedsheet, the book gets you up to speed with formula and function basics first. But you can also skip ahead to the fancy stuff and learn about working with probabilities, significance tests, and lookup functions.
This easytouse Excel formulas and functions survival guide shows you how to:
 Work with financial functions like PMT, PPMT, NPER, RATE, and PV
 Calculate mean, median, mode, standard deviation, and many more statistical functions
 Troubleshoot formulas for common errors and validate your data to avoid mistakes
 Work with dates, times, logic operators, conditions, and basic and advanced mathematical functions
You don't need a degree in data science or advanced mathematics to take advantage of the full functionality and flexibility of Microsoft Excel. Let Excel Formulas & Functions For Dummies show you how to transform this unassuming program into the most useful tool in your toolbox.
Table of contents
 Cover
 Title Page
 Copyright
 Introduction
 Part 1: Getting Started with Excel Formulas and Functions
 Part 2: Doing the Math
 Part 3: Solving with Statistics

Part 4: Dancing with Data
 Chapter 12: Dressing Up for Date Functions
 Chapter 13: Keeping WellTimed 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
 FineTuning 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 5: The Part of Tens
 Chapter 18: Ten Tips for Working with Formulas
 Chapter 19: Ten Ways to Get Fancy with Excel

Chapter 20: Ten Really Cool Functions
 Work with Hexadecimal, Octal, Decimal, and Binary Numbers
 Convert Units of Measurement
 Find the Greatest Common Divisor and the Least Common Multiple
 Easily Generate a Random Number
 Convert to Roman Numerals
 Factor in a Factorial
 Determine Part of a Year with YEARFRAC
 Find the Data TYPE
 Find the LENgth of Your Text
 Just in CASE
 Index
 About the Author
 Advertisement Page
 Connect with Dummies
 End User License Agreement
Product information
 Title: Excel Formulas & Functions For Dummies, 6th Edition
 Author(s):
 Release date: December 2021
 Publisher(s): For Dummies
 ISBN: 9781119839118
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 Macros For Dummies, 3rd Edition
Save time and become an Excel wizard with the world’s leading Excel macro guide Do you …
book
Excel AllinOne For Dummies
Excelerate your productivity with the only guide you'll need to the latest versions of Microsoft Excel …
book
Excel Data Analysis For Dummies, 4th Edition
Take Excel to the next level Excel is the world’s leading spreadsheet application. It’s a key …