Microsoft Office Excel 2007 Formulas and Functions For Dummies - Softcover

Bluttman, Ken

Softcover

ISBN 10: 0470046554 ISBN 13: 9780470046555

Publisher: For Dummies, 2007

Synopsis

An illustrated guide describes the basics of formulas and functions of Microsoft Excel 2007, with step-by-step instructions and information on 150 useful topics, as well as abbreviated foms of an additional two hundred specialized functions, covering such areas as calculating loan payments, using prediction and probability functions, using time functions, databases, design, and working with text functions. Original. (Beginner/Intermediate)

About this title

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.

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

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

Edition details

• Publisher: For Dummies
• Publication date: 2007
• Language: English
• ISBN 10: 0470046554
• ISBN 13: 9780470046555
• Binding: Paperback
• Edition number: 1
• Number of pages: 384