Excel Formulas and Functions For Dummies

Excel Formulas and Functions For Dummies

2.8 5
by Ken Bluttman
     
 

View All Available Formats & Editions

Learn to:

  • Use functions and understand how they work within a formula
  • Take advantage of 150 built-in Excel functions
  • Evaluate investment performance or forecast college expenses
  • Compare 15- versus 30-year mortgage rates

Got numbers to crunch? Master Excel's formulas and functions and put its power to

…  See more details below

Overview

Learn to:

  • Use functions and understand how they work within a formula
  • Take advantage of 150 built-in Excel functions
  • Evaluate investment performance or forecast college expenses
  • Compare 15- versus 30-year mortgage rates

Got numbers to crunch? Master Excel's formulas and functions and put its power to work

Don't be intimidated by Excel! Functions and formulas are its secret weapon, and this friendly guide helps you make sense of them. You'll unlock the mysteries of arrays, discover what goes into a function, understand predictions and probability, analyze data, learn to calculate important things like interest payments and depreciation, and much more!

  • Begin with the basics — first, get a clear understanding of workbooks and worksheets, cells, ranges, and tables
  • Formula for success — learn the proper way to enter a formula, how to include functions, and how to catch and correct errors
  • Do the math — calculate payments, interest rates, how long it will take to pay off a loan, and cost/revenue comparisons
  • Statistics, STAT — understand mean, median, and mode, and use the functions for calculating variance
  • No crystal ball needed — examine predictions and probabilities and how to forecast trends
  • Fun with functions — find things using lookup, logical, and reference functions, and get information with the CELL function
  • Make a date with data — work with database functions, fine-tune criteria, and perform database calculations

Open the book and find:

  • Function tools that make life easier
  • Tips on taming errors
  • How Excel handles money
  • Data analysis techniques
  • All about dates and time in Excel
  • How to handle text
  • Several ways to SUM things up
  • The top ten functions you really should know

Read More

Product Details

ISBN-13:
9781118460849
Publisher:
Wiley
Publication date:
02/26/2013
Series:
For Dummies Series
Pages:
408
Sales rank:
210,029
Product dimensions:
7.40(w) x 9.20(h) x 1.00(d)

Related Subjects

Meet 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.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >