MOS Study Guide for Microsoft Excel Expert Exam MO-201

Objective group 3

Create advanced formulas and macros

The skills tested in this section of the Microsoft Office Specialist Expert exam for Microsoft Excel 2019 relate to the advanced use of formulas and data analysis. Specifically, the following objectives are associated with this set of skills:

• 3.1 Perform logical operations in formulas

• 3.2 Look up data by using functions

• 3.3 Apply advanced date and time functions

• 3.4 Perform data analysis

• 3.5 Troubleshoot formulas

• 3.6 Create and modify simple macros

Although Excel works well as a simple database, in most of your worksheets you’ll want to do more than just store data. You’ll also want to summarize your data, apply statistical methods, perform data analysis, automate tasks with macros, and ...