Brilliant Microsoft Excel 2007 Formulas & Functions

Bill Jelenis Mr. Excel! He is principal behind the leading Excel website, MrExcel.com and a Microsoft MVP for Excel. He is an accomplished author of books on Excel , and as an Excel consultant, he has written Excel VBA solutions for hundreds of clients around the English-speaking world. His website hosts over 12 million page views annually and his daily video podcast is regularly in the top tech podcasts in iTunes. Michael Alexanderis a Microsoft Certified Application Developer (MCAD) with over 13 years experience developing business solutions with Microsoft Office, VBA, and .Net. H e currently heads an analytical services group for a $700-million company. In his spare time he runs a free tutorial site, www.datapigtechnologies.com, where he shares basic Access and Excel tips with intermediate users.

Introduction I Mastering Excel Ranges and Formulas 1. Getting the Most Out of Ranges 2. Using Range Names 3. Building Basic Formulas 4. Creating Advanced Formulas 5. Troubleshooting Formulas II Harnessing The Power of Functions 6. Understanding Functions 7. Working with Text Functions 8. Working with Logical and Information Functions 9. Working with Lookup Functions 10. Working with Date and Time Functions 11. Working with Math Functions 12. Working with Statistical Functions III Building Business Models 13. Analyzing Data with Tables 14. Analyzing Data with Pivot Tables 15. Using Excel's Business-Modeling Tools 16. Using Regression to Track Trends and Make Forecasts 17. Solving Complex Problems with Solver IV Building Financial Formulas 18. Building Loan Formulas 19. Building Investment Formulas 20. Building Discount Formulas Index