Book description
Unlock the power of Excel with a step-by-step 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 built-in 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 easy-to-use 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 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 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 All-in-One For Dummies
Excel-erate 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 …