Custom & Conditional Formatting in Excel 2019 for Windows

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 in Excel 2019 for Windows
    5m 5s
    UP NEXT
  • Playable
    2. 
    Customizing your text formats in Excel 2019 for Windows
    5m 36s
  • Locked
    3. 
    Customizing your date & time formats in Excel 2019 for Windows
    4m 39s
  • Locked
    4. 
    Using color in custom formats in Excel 2019 for Windows
    4m 5s
  • Locked
    5. 
    Creating conditional custom formats in Excel 2019 for Windows
    4m 9s
  • Locked
    6. 
    Creating conditional formatting rules in Excel 2019 for Windows
    3m 28s
  • Locked
    7. 
    Calling out data with conditional formatting tools in Excel 2019 for Windows
    6m 14s
  • Locked
    8. 
    Analyzing data ranges with conditional formatting tools in Excel 2019 for Windows
    4m 22s
  • Locked
    9. 
    Using advanced conditional formatting in Excel 2019 for Windows
    4m 34s
  • Locked
    10. 
    Controlling conditional formatting rules in Excel 2019 for Windows
    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

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 231 Likes 231  
Likes 561 Likes 561