Microsoft Office Excel 2007 Formulas and Functions For Dummies (eBook)
388 Seiten
John Wiley & Sons (Verlag)
978-0-470-37739-0 (ISBN)
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
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.
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 and
Functions.
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 What
You 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.
| Erscheint lt. Verlag | 28.6.2008 |
|---|---|
| Sprache | englisch |
| Themenwelt | Informatik ► Office Programme ► Excel |
| Informatik ► Office Programme ► Outlook | |
| Schlagworte | Computer-Ratgeber • End-User Computing • Excel 2007 • Microsoft Excel |
| ISBN-10 | 0-470-37739-9 / 0470377399 |
| ISBN-13 | 978-0-470-37739-0 / 9780470377390 |
| Haben Sie eine Frage zum Produkt? |
PDF (Adobe DRM)Kopierschutz: Adobe-DRM
Adobe-DRM ist ein Kopierschutz, der das eBook vor Mißbrauch schützen soll. Dabei wird das eBook bereits beim Download auf Ihre persönliche Adobe-ID autorisiert. Lesen können Sie das eBook dann nur auf den Geräten, welche ebenfalls auf Ihre Adobe-ID registriert sind.
Details zum Adobe-DRM
Dateiformat: PDF (Portable Document Format)
Mit einem festen Seitenlayout eignet sich die PDF besonders für Fachbücher mit Spalten, Tabellen und Abbildungen. Eine PDF kann auf fast allen Geräten angezeigt werden, ist aber für kleine Displays (Smartphone, eReader) nur eingeschränkt geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen eine
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen eine
Geräteliste und zusätzliche Hinweise
Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.
aus dem Bereich
