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
Calculus I
Let's face it: most students don't take calculus because they find it intellectually stimulating. It's not …
book
Business Analysis with Microsoft Excel, Fifth Edition
Gain Deeper Insights, Make Smarter Decisions, and Earn More Profits It’s time to put the full …
book
The Time Cleanse: A Proven System to Eliminate Wasted Time, Realize Your Full Potential, and Reinvest in What Matters Most
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, …
book
An Artist's Guide to Programming
An Artist's Guide to Programming teaches computer programming with the aid of 100 example programs, each …