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 2. Apply custom data formats and layouts

The skills tested in this section of the Microsoft Office Specialist Expert exam for Microsoft Excel 2016 relate to creating custom number formats, performing data validation, applying conditional formatting, and creating custom styles and theme elements. Specifically, the following objectives are associated with this set of skills:

2.1 Apply custom data formats and validation

2.2 Apply advanced conditional formatting and filtering

2.3 Create and modify custom workbook elements

2.4 Prepare a workbook for internationalization

Many worksheets are drab, lifeless conglomerations of numbers, formulas, and text. If you’ll be sharing your worksheets with other people, your numbers will have much ...

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