Excel 2019: Custom & Conditional Formatting


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

To customize data, you can use the built-in formats in Excel 2019, or you can use your own. In this 10-video course, learners will observe how to create custom formats for numbers, text, and date and time, as well as how to create and use conditional formatting. To begin, discover how to customize your number formats, formatting currency, percentages, and phone numbers for data values. Next, observe how to customize your text formats, changing the text format by adding or modifying a text element's appearance; create custom color formatting for data entries; and apply conditional custom formatting to data values. Delve into creating conditional format rules to enhance your data values display; use conditional formatting to highlight data in cells, rows, and columns; and use conditional formatting tools to analyze your data further. This leads into exploring advanced conditional formatting tools, and using these tools to find duplicate values or hide values. Conclude the course by discovering how to organize conditional formatting rules applied to a worksheet. 



Expected Duration (hours)
0.8

Lesson Objectives

Excel 2019: Custom & Conditional Formatting

  • format currency, percentage and phone numbers with data values
  • change your text format by adding or modifying a text elements appearance
  • custom format dates or times with worksheet data
  • 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_msex2019_08_enus

    Expertise Level
    Intermediate