Cart
Free Shipping in Australia
Proud to be B-Corp

Excel Formulas and Functions For Dummies Ken Bluttman

Excel Formulas and Functions For Dummies By Ken Bluttman

Excel Formulas and Functions For Dummies by Ken Bluttman


$21.99
Condition - Very Good
Out of stock

Summary

"Don't be intimidated by Excel! Bluttman helps you unlock the mysteries of arrays, discover what goes into a function, understand predictions and probability, and much more!"--P. [4] of cover.

Excel Formulas and Functions For Dummies Summary

Excel Formulas and Functions For Dummies by Ken Bluttman

Grab these Excel formulas and functions to make your life easier! 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!

About Ken Bluttman

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.

Table of Contents

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

Additional information

GOR007598776
9781119076780
1119076781
Excel Formulas and Functions For Dummies by Ken Bluttman
Used - Very Good
Paperback
John Wiley & Sons Inc
2016-01-01
416
N/A
Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
This is a used book - there is no escaping the fact it has been read by someone else and it will show signs of wear and previous use. Overall we expect it to be in very good condition, but if you are not entirely satisfied please get in touch with us

Customer Reviews - Excel Formulas and Functions For Dummies