Custom & Conditional Formatting

Excel 2019 (Windows)    |    Intermediate
  • 10 Videos | 46m 38s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Likes 208 Likes 208
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. In order to practice what you have learned, you will find the Word document named Excel 2019 for Windows: Custom & Conditional Formatting Exercise as well as the associated materials in the Resources section.

WHAT YOU WILL LEARN

  • format currency, percentage, and phone numbers with data values
    customize the text format and appearance of data
    customize the date or time format of 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

IN THIS COURSE

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

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 50 Likes 50  
Likes 119 Likes 119  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 119 Likes 119  
Likes 112 Likes 112  
Likes 41 Likes 41