Microsoft 365 Excel Formulas & Functions for Dummies

Introduction 1
Part 1: Getting Started with Excel Formulas and Functions 5
Chapter 1: Tapping into Formula and Function Fundamentals 7
Chapter 2: Saving Time with Function Tools 39
Chapter 3: Saying "Array!" for Formulas and Functions 57
Chapter 4: Fixing Formula Boo-Boos 71
Part 2: Doing the Math 89
Chapter 5: Calculating Loan Payments and Interest Rates 91
Chapter 6: Appreciating What You'll Get, Depreciating What You've Got 111
Chapter 7: Using Basic Math Functions 127
Chapter 8: Advancing Your Math 145
Part 3: Solving with Statistics 173
Chapter 9: Throwing Statistics a Curve 175
Chapter 10: Rolling the Dice on Predictions and Probability 215
Part 4: Dancing with Data 235
Chapter 11: Dressing Up for Date Functions 237
Chapter 12: Keeping Well-Timed Functions 255
Chapter 13: Using Lookup, Logical, and Reference Functions 263
Chapter 14: Digging Up the Facts 295
Chapter 15: Writing Home about Text Functions 309
Part 5: The Part of Tens 337
Chapter 16: Ten Tips for Working with Formulas 339
Chapter 17: Ten Ways to Get Fancy with Excel 353
Chapter 18: Ten Really Cool Functions 359
Index 367