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.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 ...
Get MOS 2016 Study Guide for Microsoft Excel Expert now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
