- Readers discover how to exploit the power of Excel 2007 with detailed instructions that explore specialized Excel functions - Explains how and why readers should use a particular function, then gives examples of how that function is used within a formula to solve real-world problems - Examples of Excel formulas and functions show how to compare 15year vs. 30year mortgage terms, choose between leasing or buying a car, compute classroom grades, determine election results, evaluate investment performance, calculate the real cost of credit card purchases, design a database, forecast college expenses and savings, and much more…mehr
- Readers discover how to exploit the power of Excel 2007 with detailed instructions that explore specialized Excel functions
- Explains how and why readers should use a particular function, then gives examples of how that function is used within a formula to solve real-world problems
- Examples of Excel formulas and functions show how to compare 15year vs. 30year mortgage terms, choose between leasing or buying a car, compute classroom grades, determine election results, evaluate investment performance, calculate the real cost of credit card purchases, design a database, forecast college expenses and savings, and much more
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.
Inhaltsangabe
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.
