Microsoft Excel Formulas & Functions For Dummies, 4ed
ISBN: 9788126559466
408 pages
Description
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.
Introduction
Part I: Getting Started with Formulas and Functions
Chapter 1: Tapping Into Formula and Function Fundamentals
Chapter 2: Saving Time with Function Tools
Chapter 3: Saying "Array!" for Formulas and Functions
Chapter 4: Fixing Formula Boo-Boos
Part II: Doing the Math
Chapter 5: Calculating Loan Payments and Interest Rates
Chapter 6: Appreciating What You'll Get, Depreciating What You've Got
Chapter 7: Using Basic Math Functions
Chapter 8: Advancing Your Math
Part III: Solving with Statistics
Chapter 9: Throwing Statistics a Curve
Chapter 10: Using Significance Tests
Chapter 11: Rolling the Dice on Predictions and Probability
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
Part V: The Part of Tens
Chapter 18: Ten Tips for Working with Formulas
Chapter 19: Ten Functions You Really Should Know
Chapter 20: Some Really Cool Functions
Index