O'Reilly logo

MOS 2016 Study Guide for Microsoft Excel Expert by Paul McFedries

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

Objective group 3. Create advanced formulas

The skills tested in this section of the Microsoft Office Specialist Expert exam for Microsoft Excel 2016 relate to the advanced use of formulas and data analysis. 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 Perform data analysis and business intelligence

3.5 Troubleshoot formulas

3.6 Define named ranges and objects

Although Excel works well as a simple database, in most of your worksheets you’ll want to do more than just store data. That is, you’ll also want to summarize your data, apply statistical methods, perform data analysis, consolidate multiple ...

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