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 2. Apply Custom Formats and Layouts

The skills tested in this section of the Microsoft Office Specialist Expert exams for Microsoft Excel 2013 relate to manipulating formatting and layout options. Specifically, the following objectives are associated with this set of skills:

2.1 Apply custom data formats
2.2 Apply advanced conditional formatting and filtering
2.3 Apply custom styles and templates
2.4 Prepare workbooks for internationalization and accessibility

Being a numbers program, Excel provides extensive number-format customization, beyond the extensive complement of built-in formats. You can use conditional formatting to flag critical values, and you can use custom cell styles and themes to store your custom formats.

This chapter guides ...

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