Bluttman / Aitken Microsoft Office Excel 2007 Formulas and Functions For Dummies

1. Auflage 2008
ISBN: 978-0-470-37739-0
Verlag: John Wiley & Sons
Format: PDF
Kopierschutz: Adobe DRM (»Systemvoraussetzungen)

E-Book, Englisch, 388 Seiten, E-Book

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 atthe top 150, so you can find out which ones will make your lifeeasier. Want to compare a 15-year mortgage to a 30-year mortgage?Forecast expenses for your college freshman? See how your onlinebusiness 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

Autoren/Hrsg.

Bluttman, Ken

Aitken, Peter G.

Inhaltsverzeichnis

Introduction.
Part I: Putting the Fun in Functions.
Chapter 1: Tapping into Formula and Function Fundamentals.
Chapter 2: Saving Time with Function Tools.
Chapter 3: Saying "Array!" for Formulas andFunctions.
Chapter 4: Fixing Formula Boo-Boos.
Part II: Counting on Your Money.
Chapter 5: Calculating Loan Payments and Interest Rates.
Chapter 6: Appreciating What You'll Get, Depreciating WhatYou Got.
Chapter 7: Using Basic Math Functions.
Chapter 8: Advancing Your Math.
Chapter 9: Throwing Statistics a Curve.
Chapter 10: Using Significance Tests.
Part III: Doing the Math.
Chapter 11: Rolling the Dice on Predictions and Probability.
Chapter 12: Dressing Up for Date Functions.
Chapter 13: Keeping Well-Timed Functions.
Chapter 14: Using Lookup, Logical, and Reference Functions.
Chapter 15: Digging Up the Facts.
Part IV: Working with Data.
Chapter 16: Writing Home about Text Functions.
Chapter 17: Playing Records with Database Functions.
Part V: The Part of Tens.
Chapter 18: Ten-Plus Tips for Working with Formulas.
Chapter 19: Ten-Plus Functions You Really Should Know.
Index.

Über Autor(innen)

Ken Bluttman has been working as a software developer fornearly two decades. Ken specializes in VB.Net/VBA/database/webapplications. He has written several articles on various computertopics including Office/VBA development, XML, SQL Server, andInfoPath. He has a number of books out on Excel and Access. Kenlives in New York with his wife, son, dog, hamster, some frogs, anda couple of geckos.
Peter Aitken has been writing about computers andprogramming for over 15 years. He has more than 45 books to hiscredit with over 1.5 million copies in print, and also hasextensive experience writing software documentation, online help,and magazine and trade-publication articles. Some recent booktitles are Managing Your Money and Investment with Excel,Powering Office XP with XML, Excel PivotTables and Charts, andVisual Basic.NET Programming with Peter Aitken. He is theproprietor of PGA Consulting, providing custom applicationdevelopment and technical writing services since 1994.