Product Details
Excel Formulas and Functions For Dummies

Excel Formulas and Functions For Dummies
By Ken Bluttman, Peter G. Aitken

List Price: $24.99
Price: $16.49 & eligible for FREE Super Saver Shipping on orders over $25. Details

Availability: Usually ships in 24 hours
Ships from and sold by Amazon.com

66 new or used available from $9.00

Average customer review:

Product Description

  • Targets beginning to intermediate Excel users seeking real-world examples of how they can use Excel's powerful built-in functions
  • Shows readers how to use Excel functions in formulas to help them decide between buying and leasing a car, calculate mortgage costs, compute grades, evaluate investment performance, figure college expenses, and more
  • Gives explanations and examples of real-world situations
  • Provides an abbreviated discussion of an additional 200 functions
  • Excel commands nearly 90 percent of the market for spreadsheet applications; although this book is written for Excel 2003, the functions described are in earlier versions as well


Product Details

  • Amazon Sales Rank: #31483 in Books
  • Published on: 2005-01-28
  • Format: Abridged
  • Original language: English
  • Number of items: 1
  • Binding: Paperback
  • 408 pages

Features


Editorial Reviews

From the Back Cover
Use Excel functions to solve problems every day

Evaluate your investments, calculate credit card costs, predict expenses, and more

When you figure in the interest, just how much ARE you paying for that car? You may not want to know, but if you do, Excel has a formula and function for that — and over two hundred others. This book makes it easy to discover what they are, what they do, and how they can help you!

Discover how to:

  • Save time with the Insert Function dialog
  • Calculate loan payments and interest rates
  • Understand array functions
  • Correct formulas
  • Use significance tests
  • Work with date and time functions

About the Author
Ken Bluttman has been working as a software developer for 15 years. Ken specializes in VB/VBA based applications, often with an emphasis on Microsoft Office. Ken has written several articles on various computer topics including Office/VBA development, XML, SQL Server, and InfoPath. His most recent book is Developing Microsoft Office Solutions. Ken lives in New York with his wife, son, and dog.

Peter Aitken has been writing about computers and programming for over 10 years, with over 35 books well as hundreds of magazine and trade publication articles to his credit. His recent book titles include Powering Office 2003 With XML, Excel Programming Weekend Crash Course, .NET Graphics and Printing, Visual Basic .NET Programming With Peter Aitken, Office XP Development With VBA, XML the Microsoft Way, Windows Script Host, and Teach Yourself Visual Basic .NET Internet Programming in 21 Days.


Customer Reviews

Really Helps at Work5
I have to create a lot of Excel spreadsheets at work, and was always sort of intimidated by the functions in Excel. Instead of using functions, I spent a lot of time entering numbers and then finding the answer by hand, and just typing the answer in an empty cell. If any of the data changed, I would have to do all of the calculations over again, and hope that I didn't make any mistakes. This book explains each of the Excel functions in a really clear and easy to understand way, and walks you through how to use them step by step. I'm using more and more functions in my spreadsheets now. I don't have as many mistakes as before, because the functions do the calculations automatically, even when you change some of the data. I keep this book in my desk and look at it all the time. The people I work for have noticed the difference in the quality of my spreadsheets, and I'm getting a lot of complements. They're even coming to me to ask for advice! I definitely recommend this book if you use Excel at work.

Great book!5
I've been using Excel for years, including formulas, but this book really expanded my knowledge about Excel and all the built-in functions. I highly recommend this book!

A Really Helpful Book5
I always found it hard to understand how functions work. It's one thing to use the autosum button to add some numbers together. It's another thing to use functions and know which one to use. But now this Excel book has come to my rescue. The book is well designed by explaining the basics first. Then the book is organized by categories of functions. I recommend it highly!