Conquer Microsoft Excel formulas and functions—from the inside out!
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, or 2010—and challenge yourself to new levels of mastery.
NOTE: The sample Excel files that accompany the book were updated on 12/4/2012. Click the Companion Content link to download the files.
- 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 Visual Basic for Applications (VBA)
- ISBN10 0735658021
- ISBN13 9780735658028
- Publish Date 22 December 2011 (first published 1 December 2011)
- Publish Status Out of Print
- Out of Print 15 March 2021
- Publish Country US
- Imprint Microsoft Press,U.S.
- Format Paperback
- Pages 1088
- Language English