O'Reilly logo

MOS 2013 Study Guide for Microsoft® Excel® Expert by Mark Dodge

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 3. Create Advanced Formulas

The skills tested in this section of the Microsoft Office Specialist Expert exams for Microsoft Excel 2013 relate to the creation of sophisticated formulas. Specifically, the following objectives are associated with this set of skills:

3.1 Apply functions in formulas
3.2 Look up data by using functions
3.3 Apply advanced date and time functions
3.4 Create scenarios

Most users of Excel have created formulas that include one or more of the most commonly used Excel functions, such as SUM, AVERAGE, COUNT, MAX, and MIN. However, Excel provides functions for other very specific operations.

This chapter guides you in studying methods for these other operations, such as calculating dates and times, performing statistical ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required