Custom & Conditional Formatting

Excel Microsoft 365 (Windows)
  • 10 Videos | 58m 1s
  • Includes Assessment
  • Earns a Badge
Likes 178 Likes 178
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • Playable
    1. 
    Customizing your number formats
    5m 22s
    UP NEXT
  • Playable
    2. 
    Customizing your text formats
    4m 55s
  • Locked
    3. 
    Customizing your date & time formats
    5m 28s
  • Locked
    4. 
    Using color in custom formats
    3m 14s
  • Locked
    5. 
    Creating conditional custom formats
    5m 27s
  • Locked
    6. 
    Creating conditional formatting rules
    5m 5s
  • Locked
    7. 
    Calling out data with conditional formatting tools
    6m 27s
  • Locked
    8. 
    Analyzing data ranges with conditional formatting tools
    5m 1s
  • Locked
    9. 
    Using advanced conditional formatting
    5m 38s
  • Locked
    10. 
    Controlling conditional formatting rules
    6m 24s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

COURSE Managing Data
Likes 75 Likes 75  
Likes 713 Likes 713  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 705 Likes 705  
Likes 129 Likes 129  
Likes 206 Likes 206