Microsoft Office Excel 2007 Formulas & Functions For Dummies [Paperback]

Ken Bluttman (Author), Peter G. Aitken (Author)

Book Description

Publication Date: January 30, 2007 | ISBN-10: 0470046554 | ISBN-13: 978-0470046555 | Edition: 1

Make Excel do the math and make sense of your data


Use the Insert Function dialog box, array formulas and functions, and more

Excel 2007 has more than 500 built-in functions. This book looks at the top 150, so you can find out which ones will make your life easier. Want to compare a 15-year mortgage to a 30-year mortgage? Forecast expenses for your college freshman? See how your online business is doing? Here's the fun and easy way!

Discover how to
* Create worksheets to track costs and revenue
* Tell the difference among average, median, and mode
* Work with statistical functions
* Develop forecasts and track trends
* Manipulate strings and work with database functions

Editorial Reviews

From the Back Cover

Make Excel do the math and make sense of your data

Use the Insert Function dialog box, array formulas and functions, and more

Excel 2007 has more than 500 built-in functions. This book looks at the top 150, so you can find out which ones will make your life easier. Want to compare a 15-year mortgage to a 30-year mortgage? Forecast expenses for your college freshman? See how your online business is doing? Here's the fun and easy way!

Discover how to

• Create worksheets to track costs and revenue
• Tell the difference among average, median, and mode
• Work with statistical functions
• Develop forecasts and track trends
• Manipulate strings and work with database functions

About the Author

Ken Bluttman has been working as a software developer for nearly two decades. Ken specializes in VB.Net/VBA/database/web applications. He has written several articles on various computer topics including Office/VBA development, XML, SQL Server, and InfoPath. He has a number of books out on Excel and Access. Ken lives in New York with his wife, son, dog, hamster, some frogs, and a couple of geckos.

Peter Aitken has been writing about computers and programming for over 15 years. He has more than 45 books to his credit with over 1.5 million copies in print, and also has extensive experience writing software documentation, online help, and magazine and trade-publication articles. Some recent book titles are Managing Your Money and Investment with Excel, Powering Office XP with XML, Excel PivotTables and Charts, and Visual Basic.NET Programming with Peter Aitken. He is the proprietor of PGA Consulting, providing custom application development and technical writing services since 1994.

Product Details

• Paperback: 384 pages
• Publisher: For Dummies; 1 edition (January 30, 2007)
• Language: English
• ISBN-10: 0470046554
• ISBN-13: 978-0470046555
• Product Dimensions: 9.2 x 7.4 x 0.8 inches
• Shipping Weight: 1.1 pounds (View shipping rates and policies)
• Average Customer Review: 4.2 out of 5 stars  See all reviews (4 customer reviews)
• Amazon Best Sellers Rank: #108,169 in Books (See Top 100 in Books)

More About the Author

It all started with Creative Writing 101 back in high school. There are oodles of unfinished fiction works around my desk, but it has been writing techy and artsy books that are the path I walk these days.

Hope you enjoy what I have provided. It's always a hoot writing a book - keeping late hours, forgetting to eat, and trying to pet my cat and type at the same time.

Thanks!

Ken B

Customer Reviews

Most Helpful Customer Reviews

12 of 14 people found the following review helpful:

2.0 out of 5 stars If you are a dummy.....skip this!, October 12, 2007

By 

(Rizzo) Rizzuto (Denver) - See all my reviews
(VINE VOICE)   

This review is from: Microsoft Office Excel 2007 Formulas & Functions For Dummies (Paperback)

First, don't make a mistake with the Excel Books for Dummies. This book is about formulas & functions; it is NOT the original Excel for Dummies that demonstrates the fundamentals. This is for some serious formulating and functioning.

Second, if you can follow through and understand this book on formulas & functions, you may not be a dummy. A dummy would not understand book; it is clearly for the more advanced.

The book is black and white; no colorful graphics, there are few small icons through that identify a tip, warning, remember, and technical stuff. Periodically there are cartoons throughout the book.

The visuals of computer spreadsheets do help a little, but the view is light and often too small.

The book is divided into five sections, with several chapters within each section. Part 1 is Putting the Fun in Functions (I can't ever see fun with functions). Part II is counting On Your Money. Part III is Doing the Math, and this can get fairly advanced. Part IV is Working with Data (this is dates, time, database, etc.

This book consists of over 340 pages, and if you already have a great knowledge about formulas and functions, it may work for you. If you are a dummy, and require more visuals, forget this book. Rizzo

1 of 1 people found the following review helpful:

5.0 out of 5 stars Excel 2007 Formulas & Functions for Dummies, August 14, 2010

By 

Sunny - See all my reviews

Amazon Verified Purchase

This review is from: Microsoft Office Excel 2007 Formulas & Functions For Dummies (Paperback)

This is really an eye opener for dummies, I guess it has taken me step by step to be able to enter the formulas as well as using the different functions that Excel has, It's really good and makes it easy to learn excel in an faster and a more friendlier way.I would definitely recommend this book to everyone.

1 of 1 people found the following review helpful:

5.0 out of 5 stars CLEAR CONSCISE, great for beginners looking for specifics, August 3, 2008

By 

Freebird "caricaturist" (Sydney Australia) - See all my reviews

This review is from: Microsoft Office Excel 2007 Formulas & Functions For Dummies (Paperback)

Just like the previous version, this much needed update to the new 2007 which is a totally new interface in office, is the clearest book there is if you know the basics of using excel but are new to formulas and functions, this book is the right start for beginners and those who aren`t good at maths..its explains formulas and functions as to what they do, where to locate them and how to set them up in the correct sequence without complicated language and uses practical useful and simple samples.

an easy intro to powerful calculation tools in excel.