Excel Formulas and Functions For Dummies
Published on 15. July 2005
402 pages
978-0-7645-9647-6 (ISBN)
Description
* Targets beginning to intermediate Excel users seekingreal-world examples of how they can use Excel's powerful built-infunctions
* 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
More details
Other editions
Additional editions
Ken Bluttman | Peter G. Aitken
Excel Formulas and Functions For Dummies
Book
02/2005
Hungry Minds Inc,U.S.
€19.90
Article exhausted; check for reprint
Persons
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.
Content
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.
