Course details

Excel Office 365 (Windows): Custom & Conditional Formatting

Excel Office 365 (Windows): Custom & Conditional Formatting


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

In this 10-video course, learners can explore how to use built-in formulas in Excel for Office 365, and how to create their own formats. This course demonstrates how to properly display a value—for example, a fraction, currency, or telephone number. You will then learn how to use the custom text format menu to insert additional data into cells, and to change the appearance of existing text. You will learn to use a variety of date and time formats built into Excel, how to create a customized format, and how to modify the color applied to data in a spreadsheet. This course demonstrates how to use Conditional Formatting highlights by adding visual indicators to data values, for example, to highlight specific cells, rows, or columns. You will learn how to use several Conditional Formatting tools to analyze data, and to use advanced conditional formatting by highlighting specific data criteria. Finally, learn how to set the hierarchical order of the Conditional Formatting rules apply, and how to resolve rule conflicts in Excel.



Expected Duration (hours)
0.9

Lesson Objectives

Excel Office 365 (Windows): Custom & Conditional Formatting

  • format currency, percentage and phone numbers with data values
  • change your text format by adding or modifying a text elements appearance
  • change your text format by adding or modifying a text elements appearance
  • create custom color formatting for data entries
  • apply conditional custom formatting to data values
  • create conditional format rules to enhance your data values display
  • use conditional formatting to highlight data in cells, rows and columns
  • use conditional formatting tools to analyze your data further
  • use advanced conditional formatting tools to find duplicate values or hide values
  • organize conditional formatting rules applied to a worksheet
  • Course Number:
    ds_msex365_08_enus

    Expertise Level
    Intermediate