Excel formulas and functions for dummies

There are more than 300 built-in functions in Excel 2007, from ABS to ZTEST. The question is Which ones will make my work easier? How and why should I use a particular function in my formulas? Excel Formulas and Functions For Dummies, Second Edition is a thorough but easy-to-read coverage of powerful Excel functions. This book gives detailed step-by-step instruction on Excels 150 most useful functions. The use of each function will be illustrated by helpful, real-world examples showing how a function is used within a formula. Another 85 specialized functions will be described in abbreviated form. In this book readers will put the power of Excel functions and formulas to work so they can compare 15-year vs. 30-year mortgage terms, generate a series of dates, choose between leasing or buying a car, compute classroom grades, create an amortization table, evaluate investment performance, calculate the real cost of credit cardpurchases, create a discounted cash flow schedule, design a database, forecast college expenses and savings, determine election results, and lots more! Although this book covers the latest software version, Excel 2007, the techniquesand functions described can be used on any version of Excel.Ken Bluttman (Allentown, PA) has been working as a software developer for 20 years. Ken specializes in VB/VBA based applications, and developing web applications.. Ken has written several books and articles on various computer topicsincluding Office/VBA development, XML, SQL Server, and many areas of web development.. His most recent book is Photoshop Elements 7 in Simple Steps. Peter Aitken (Chapel Hill, NC) has been writing about computers and programming for over 10 years, with over 35 books well as hundreds of magazine and trade publication articles to his credit. His recent book titles include Powering Office 2003 With XML, Excel Programming Weekend Crash Course, .NET Graphics and Printing, Visual Basic .NET Programming With Peter Aitken, Office XP Development With VBA, XML the Microsoft Way, Windows Script Host, and Teach Yourself Visual Basic .NET Internet Programming in 21 Days.

• ISBN: 978-0-470-56816-3
• Editorial: John Wiley & Sons
• Encuadernacion: Rústica
• Páginas: 384
• Fecha Publicación: 21/05/2010
• Nº Volúmenes: 1
• Idioma: Inglés