Książki

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 functionsYou 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.

Excel Formulas & Functions For Dummies

Introduction 1Part 1: Getting Started with Excel Formulas and Functions 5Chapter 1: Tapping Into Formula and Function Fundamentals 7Chapter 2: Saving Time with Function Tools 39Chapter 3: Saying "Array!" for Formulas and Functions 55Chapter 4: Fixing Formula Boo-Boos 65Part 2: Doing the Math 83Chapter 5: Calculating Loan Payments and Interest Rates 85Chapter 6: Appreciating What You'll Get, Depreciating What You've Got 105Chapter 7: Using Basic Math Functions 121Chapter 8: Advancing Your Math 139Part 3: Solving with Statistics 161Chapter 9: Throwing Statistics a Curve 163Chapter 10: Using Significance Tests 203Chapter 11: Rolling the Dice on Predictions and Probability 213Part 4: Dancing with Data 231Chapter 12: Dressing Up for Date Functions 233Chapter 13: Keeping Well-Timed Functions 251Chapter 14: Using Lookup, Logical, and Reference Functions 261Chapter 15: Digging Up the Facts 297Chapter 16: Writing Home about Text Functions 311Chapter 17: Playing Records with Database Functions 337Part 5: The Part of Tens 353Chapter 18: Ten Tips for Working with Formulas 355Chapter 19: Ten Ways to Get Fancy with Excel 369Chapter 20: Ten Really Cool Functions 375Index 383