Course details

Excel Office 365: Custom & Conditional Formatting

Excel Office 365: 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 for Office 365, or you can use your own. Learn how to create custom formats for numbers, text, and date and time, as well as how to create and use conditional formatting.



Expected Duration (hours)
0.9

Lesson Objectives

Excel Office 365: 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