Excel Formulas & Functions For Dummies

ISBN-13: 9781119839118 / Angielski / Miękka / 2021 / 416 str.

Ken Bluttman

Spis treści

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

O autorze

Ken Bluttman is a veteran software and web developer specializing in Excel/VBA and database-centric web applications. He has written articles and books on topics like Office/VBA development, XML, SQL Server, and InfoPath. Ken is the author of Excel Charts For Dummies and all previous editions of Excel Formulas & Functions For Dummies.