Buch, Englisch, 408 Seiten, Format (B × H): 188 mm x 233 mm, Gewicht: 606 g
Buch, Englisch, 408 Seiten, Format (B × H): 188 mm x 233 mm, Gewicht: 606 g
ISBN: 978-1-119-07678-0
Verlag: John Wiley & Sons
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. To take your knowledge of Excel's functions a step further, 85 specialized functions are described in abbreviated form so you can use Excel to better support your decision-making process when securing a mortgage, buying a car, computing classroom grades, evaluating investment performance, and more.
Functions are predefined formulas that you can use to make data analysis a bit easier within the Microsoft Excel framework. Functions use specific values, called arguments, to calculate a variety of things, from simple sums and averages to more complicated loan payments.
* Explore the 150 most useful functions that help Microsoft Excel make your life easier
* Access real-world examples of how functions fit into larger formulas
* Discover 85 specialized functions, which are described in abbreviated form and take your knowledge of Excel to the next level
* Understand how Microsoft Excel can help you make key decisions, such as whether to go with a 15-year or 30-year mortgage
Excel Formulas & Functions For Dummies, 4th Edition brings order to chaotic data--and helps you make decisions with confidence!
Autoren/Hrsg.
Weitere Infos & Material
Introduction 1
Part I: Getting Started with Formulas and Functions 5
Chapter 1: Tapping Into Formula and Function Fundamentals 7
Chapter 2: Saving Time with Function Tools 37
Chapter 3: Saying "Array!" for Formulas and Functions 55
Chapter 4: Fixing Formula Boo-Boos 65
Part II: 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 103
Chapter 7: Using Basic Math Functions 119
Chapter 8: Advancing Your Math 137
Part III: Solving with Statistics 159
Chapter 9: Throwing Statistics a Curve 161
Chapter 10: Using Significance Tests 199
Chapter 11: Rolling the Dice on Predictions and Probability 209
Part IV: Dancing with Data 227
Chapter 12: Dressing Up for Date Functions 229
Chapter 13: Keeping Well-Timed Functions 249
Chapter 14: Using Lookup, Logical, and Reference Functions 259
Chapter 15: Digging Up the Facts 291
Chapter 16: Writing Home about Text Functions 307
Chapter 17: Playing Records with Database Functions 333
Part V: The Part of Tens 347
Chapter 18: Ten Tips for Working with Formulas 349
Chapter 19: Ten Functions You Really Should Know 361
Chapter 20: Some Really Cool Functions 367
Index 373
