Custom & Conditional Formatting

Excel 2019 (Windows)    |    Intermediate
  • 10 Videos | 1h 1m 38s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
  • Certification PMI PDU
Likes 75 Likes 75
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. 

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

Likes 266 Likes 266  
Likes 94 Likes 94  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 705 Likes 705  
Likes 95 Likes 95  
Likes 176 Likes 176