Microsoft Excel 2010 Formulas and Functions Inside Out
1st Edition
Published on 22. December 2011
1084 pages
978-0-7356-6897-3 (ISBN)
Description
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.
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)
NOTE: The sample Excel files that accompany the book were updated on 12/4/2012. Click the Companion Content link to download the files.
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.
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)
NOTE: The sample Excel files that accompany the book were updated on 12/4/2012. Click the Companion Content link to download the files.
More details
Series
Language
English
Place of publication
Redmond
United States
Target group
College/higher education
ISBN-13
978-0-7356-6897-3 (9780735668973)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Classification
Other editions
Additional editions
Egbert Jeschke | Helmut Reinke | Sara Unverhau
Microsoft Excel 2010 Formulas and Functions Inside Out
Book
12/2011
Microsoft Press
€79.41
Article exhausted; check different version
Persons
Dr. Bodo Fienitz, Ph.D., teaches in adult education, specializing in the sciences (Chemistry, Physics, and Biology) and IT-related subjects. With his interest in data visualization, he became an expert in Microsoft Excel.
