Excel Formulas & Functions For Dummies
Excel Formulas & Functions For Dummies
Bluttman, Ken
John Wiley & Sons Inc
03/2022
416
Mole
Inglês
9781119839118
15 a 20 dias
558
About This Book 1
Foolish Assumptions 2
Icons Used in This Book 2
Beyond the Book 3
Where to Go from Here 3
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 55
Chapter 4: Fixing Formula Boo-Boos 65
Part 2: Doing the Math 83
Chapter 5: Calculating Loan Payments and Interest Rates 85
Chapter 6: Appreciating What You'll Get, Depreciating What You've Got 105
Chapter 7: Using Basic Math Functions 121
Chapter 8: Advancing Your Math 139
Part 3: Solving with Statistics 161
Chapter 9: Throwing Statistics a Curve 163
Chapter 10: Using Significance Tests 203
Chapter 11: Rolling the Dice on Predictions and Probability 213
Part 4: Dancing with Data 231
Chapter 12: Dressing Up for Date Functions 233
Chapter 13: Keeping Well-Timed Functions 251
Chapter 14: Using Lookup, Logical, and Reference Functions 261
Chapter 15: Digging Up the Facts 297
Chapter 16: Writing Home about Text Functions 311
Chapter 17: Playing Records with Database Functions 337
Part 5: The Part of Tens 353
Chapter 18: Ten Tips for Working with Formulas 355
Chapter 19: Ten Ways to Get Fancy with Excel 369
Chapter 20: Ten Really Cool Functions 375
Work with Hexadecimal, Octal, Decimal, and Binary Numbers 376
Convert Units of Measurement 377
Find the Greatest Common Divisor and the Least Common Multiple 378
Easily Generate a Random Number 379
Convert to Roman Numerals 379
Factor in a Factorial 379
Determine Part of a Year with YEARFRAC 380
Find the Data TYPE 380
Find the LENgth of Your Text 381
Just in CASE 381
Index 383
About This Book 1
Foolish Assumptions 2
Icons Used in This Book 2
Beyond the Book 3
Where to Go from Here 3
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 55
Chapter 4: Fixing Formula Boo-Boos 65
Part 2: Doing the Math 83
Chapter 5: Calculating Loan Payments and Interest Rates 85
Chapter 6: Appreciating What You'll Get, Depreciating What You've Got 105
Chapter 7: Using Basic Math Functions 121
Chapter 8: Advancing Your Math 139
Part 3: Solving with Statistics 161
Chapter 9: Throwing Statistics a Curve 163
Chapter 10: Using Significance Tests 203
Chapter 11: Rolling the Dice on Predictions and Probability 213
Part 4: Dancing with Data 231
Chapter 12: Dressing Up for Date Functions 233
Chapter 13: Keeping Well-Timed Functions 251
Chapter 14: Using Lookup, Logical, and Reference Functions 261
Chapter 15: Digging Up the Facts 297
Chapter 16: Writing Home about Text Functions 311
Chapter 17: Playing Records with Database Functions 337
Part 5: The Part of Tens 353
Chapter 18: Ten Tips for Working with Formulas 355
Chapter 19: Ten Ways to Get Fancy with Excel 369
Chapter 20: Ten Really Cool Functions 375
Work with Hexadecimal, Octal, Decimal, and Binary Numbers 376
Convert Units of Measurement 377
Find the Greatest Common Divisor and the Least Common Multiple 378
Easily Generate a Random Number 379
Convert to Roman Numerals 379
Factor in a Factorial 379
Determine Part of a Year with YEARFRAC 380
Find the Data TYPE 380
Find the LENgth of Your Text 381
Just in CASE 381
Index 383