Excel Formulas and Functions For Dummies (eBook)
402 Seiten
John Wiley & Sons (Verlag)
978-0-7645-9647-6 (ISBN)
* Shows readers how to use Excel functions in formulas to helpthem decide between buying and leasing a car, calculate mortgagecosts, compute grades, evaluate investment performance, figurecollege expenses, and more
* Gives explanations and examples of real-world situations
* Provides an abbreviated discussion of an additional 200functions
* Excel commands nearly 90 percent of the market for spreadsheetapplications; although this book is written for Excel 2003, thefunctions described are in earlier versions as well
Ken Bluttman has been working as a software developer for 15years. Ken specializes in VB/VBA based applications, often with anemphasis on Microsoft Office. Ken has written several articles onvarious computer topics including Office/VBA development, XML, SQLServer, and InfoPath. His most recent book is DevelopingMicrosoft Office Solutions. Ken lives in New York with hiswife, son, and dog. Peter Aitken has been writing about computers andprogramming for over 10 years, with over 35 books well as hundredsof magazine and trade publication articles to his credit. Hisrecent book titles include Powering Office 2003 With XML,Excel Programming Weekend Crash Course, .NET Graphics andPrinting, Visual Basic .NET Programming With PeterAitken, Office XP Development With VBA, XML theMicrosoft Way, Windows Script Host, and TeachYourself Visual Basic .NET Internet Programming in 21 Days.
Introduction.
Part I: Getting Started with Excel Formulas andFunctions.
Chapter 1: Understanding Fundamentals, Formulas, andFunctions.
Chapter 2: Saving Time with the Insert Function Dialog Box.
Chapter 3: Understanding Array Formulas and Functions.
Chapter 4: Correcting Formulas.
Part II: Evaluating Loans and Investments.
Chapter 5: Calculating Loan Payments and Interest Rates.
Chapter 6: Performing Advanced Financial Calculations.
Part III: Working with Numbers.
Chapter 7: Using Math Functions to Figure Basic MathAnswers.
Chapter 8: Getting More Advanced with Math.
Chapter 9: Using Descriptive Statistical Functions.
Chapter 10: Using Significance Tests.
Chapter 11: Using Prediction and Probability Functions.
Part IV: Working with Data.
Chapter 12: Working with Date Functions.
Chapter 13: Keeping Track with Time Functions.
Chapter 14: Using Lookup, Logical, and Reference Functions.
Chapter 15: Working with Information Functions.
Chapter 16: Working with Text Functions.
Chapter 17: Summarizing Data with Database Functions.
Part V: The Part of Tens.
Chapter 18: Ten + One Great Tips for Working with Formulas.
Chapter 19: Top Ten Functions You Must Know to Be an ExcelGuru.
Chapter 20: Ten Cool Things to Do with the Analysis ToolPakAdd-In.
Index.
| Erscheint lt. Verlag | 15.7.2005 |
|---|---|
| Sprache | englisch |
| Themenwelt | Informatik ► Office Programme ► Excel |
| Schlagworte | Computer-Ratgeber • End-User Computing • Excel • Microsoft Excel |
| ISBN-10 | 0-7645-9647-0 / 0764596470 |
| ISBN-13 | 978-0-7645-9647-6 / 9780764596476 |
| 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
