Excel Formulas & Functions For Dummies, 4th Edition

  • 5h 17m
  • Ken Bluttman
  • John Wiley & Sons (US)
  • 2016

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 the Author

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.

In this Book

  • Introduction
  • Tapping Into Formula and Function Fundamentals
  • Saving Time with Function Tools
  • Saying "Array!" for Formulas and Functions
  • Fixing Formula Boo-Boos
  • Calculating Loan Payments and Interest Rates
  • Appreciating What You'll Get, Depreciating What You've Got
  • Using Basic Math Functions
  • Advancing Your Math
  • Throwing Statistics a Curve
  • Using Significance Tests
  • Rolling the Dice on Predictions and Probability
  • Dressing Up for Date Functions
  • Keeping Well-Timed Functions
  • Using Lookup, Logical, and Reference Functions
  • Digging Up the Facts
  • Writing Home about Text Functions
  • Playing Records with Database Functions
  • Ten Tips for Working with Formulas
  • Ten Functions You Really Should Know
  • Some Really Cool Functions


Rating 3.0 of 2 users Rating 3.0 of 2 users (2)
Rating 3.9 of 21 users Rating 3.9 of 21 users (21)