Apply custom formats and layouts in Excel 2013 Overview

The skills tested in this section Apply custom formats and layouts in Excel 2013 for the Microsoft Office Specialist Expert exams preparation which is associated mainly with manipulating formatting and layout options. 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 you in studying methods of applying custom data formats, advanced conditional formatting and filtering, and custom styles and templates. It also describes how to work with international and accessibility requirements.

Specifically, the following objectives are associated with this set of skills:

Apply advanced conditional formatting and filtering

Conditional formatting is typically applied to a range of cells and responds differently depending on the contents of each cell ...
Read More

Prepare workbooks for internationalization and accessibility

In order to prepare workbooks for internationalization and accessibility, whenever you share your workbooks with others, you need to make ...
Read More

This chapter is a part of 77-427 Excel 2013 Expert Part One Prep course. More chapters in this course are

Excel 2013 Workbooks Management

Excel 2013 Workbooks Management Overview The skills tested in this section Excel 2013 Workbooks Management of the Microsoft Office Specialist Expert exams ...
Read More

Apply custom formats and layouts in Excel 2013

Apply custom formats and layouts in Excel 2013 Overview The skills tested in this section Apply custom formats and layouts in ...
Read More

Advanced formulas in Excel 2013

Advanced formulas in Excel 2013 Overview This section discusses the skill of creating Advanced formulas in Excel 2013, which is an ...
Read More

Create advanced charts and tables

Create advanced charts and tables Overview The skills tested in this section Create advanced charts and tables of the Microsoft Office ...
Read More

The Practice tests included in this course are:

No posts found.