2011•International Linear ColliderRequires access

Microsoft Excel 2010 Formulas and Functions Inside Out

Egbert Jeschke, Helmut Reinke, Sara Unverhau, Eckehard Pfeifer, Bodo Fienitz, Jens Johannes Bock

Abstract

Conquer Microsoft Excel formulas and functionsfrom the inside out! Youre 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. Its all muscle and no fluff. Discover how the experts increase their data analysis capabilities using Excel 2003, 2007, or 2010and 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)

About this research paper

What this paper is about

Why it matters

OpenAlex reports 1 citations for this work. Citation counts describe recorded attention and do not establish research quality.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

Key concepts: Visual Basic for Applications, Microsoft excel, Computer science, Troubleshooting, Ms excel, Workaround, Computer graphics (images), Function (biology)