Excel Formulas and Functions For Dummies
John Wiley & Sons Inc (Verlag)
978-1-119-07678-0 (ISBN)
- Titel erscheint in neuer Auflage
- Artikel merken
* 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!
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 various computer topics including Office/VBA development, XML, SQL Server, JavaScript, HTML5, and PHP. Ken also wrote Excel Charts For Dummies.
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
Erscheint lt. Verlag | 1.1.2016 |
---|---|
Verlagsort | New York |
Sprache | englisch |
Maße | 189 x 236 mm |
Gewicht | 542 g |
Themenwelt | Informatik ► Office Programme ► Excel |
Informatik ► Office Programme ► Outlook | |
ISBN-10 | 1-119-07678-1 / 1119076781 |
ISBN-13 | 978-1-119-07678-0 / 9781119076780 |
Zustand | Neuware |
Haben Sie eine Frage zum Produkt? |
aus dem Bereich