You're beyond the basics, so dive right in and really put Excel formulas and functions to work! This supremely organized reference packs hundreds of timesaving solutions, troubleshooting tips, and workarounds.
It's all muscle and no fluff. Discover how the experts increase their data analysis capabilities using Excel 2003, 2007, and 2010—and challenge yourself to new levels of mastery.
• Customize Excel formulas using 350+ built-in functions
• Create reusable formulas for common calculations
• Learn smarter ways to calculate date and time values
• Systematically search worksheets with lookup and reference functions
• Perform advanced calculations using mathematical, statistical, and financial functions
• Build complex formulas by nesting one function inside of another
• Analyze profit margins and more with new functions in Excel 2010
• Develop your own functions with Microsoft Visual Basic® for Applications (VBA)
About the Author
Egbert Jeschke is a senior consultant and trainer specializing in business intelligence solutions with Excel.|Helmut Reinke is an instructor, trainer, and writer specializing in Microsoft Office, business solutions, and project management.|Sara Unverhau is a marketing and communications professional who specializes in Microsoft Office and business management.|Eckehard Pfeifer, MCAD, PhD, is a freelance software developer, consultant, and trainer on Microsoft Office. |Bodo Fienitz, PhD, teaches IT and science-related subjects, and became an Excel expert through his interest in data visualization.|Jens Bock relies on his extensive experience with Excelas a consultant for quality control and web applications.