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 Youll Get, Depreciating What Youve 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
Are you intimidated by major financial choices, like which loan to get or how to grow your savings? Don't worrywe all are! ButExcel Formulas&Functions For Dummies, 4thEditioncan 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.
Excel Formulas&Functions For Dummies, 4thEditionbrings order to chaotic dataand helps you make decisions with confidence!
Ken Bluttmanis a veteran software and web developer specializing in Excel/VBA and database-centric web applications. He has written articles and books on various computer topics including Office/VBA development, XML, SQL Server, JavaScript, HTML5, and PHP. Ken also wroteExcel Charts For Dummies.
Schlagwörter zu:
Excel Formulas and Functions For Dummies von Ken Bluttman - mit der ISBN: 9781119076797
Computer-Ratgeber; End-User Computing; Excel; Microsoft Excel, Online-Buchhandlung
interessiert haben, schauten sich auch die folgenden Bücher & eBooks an: