Custom & Conditional Formatting in Excel 2019 for Windows

Excel    |    Intermediate
  • 10 videos | 46m 38s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.4 of 355 users Rating 4.4 of 355 users (355)
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

  • 5m 5s
    Excel features multiple number formats. However, there may be occasions when you need to create your own formats. Whether your value is a fraction, a currency or a telephone number, Excel can help you to display it properly. FREE ACCESS
  • 5m 36s
    In Excel, you can also create customized text formats. You can use the custom text format menu to insert additional data to multiple cells as well change the appearance of existing text. FREE ACCESS
  • Locked
    3.  Customizing your date & time formats in Excel 2019 for Windows
    4m 39s
    Excel offers a wide variety of different data and time formats. As well as applying preset formats to your data, you can also create your own customized formats. You can specify exactly which data components are displayed and even adjust the units of measurement.  FREE ACCESS
  • Locked
    4.  Using color in custom formats in Excel 2019 for Windows
    4m 5s
    If you want to quickly modify the color applied to data in a worksheet , you can use the custom format options in Excel. FREE ACCESS
  • Locked
    5.  Creating conditional custom formats in Excel 2019 for Windows
    4m 9s
    The format that you want to apply to your data may depend on whether a particular value meets a condition. In Excel, you can create conditional formats that will be automatically applied if certain criteria are met. You can choose different formats for positive and negative values, and even set conditional value ranges.  FREE ACCESS
  • Locked
    6.  Creating conditional formatting rules in Excel 2019 for Windows
    3m 28s
    Conditional formatting highlights important information in a spreadsheet. By adding visual indicators to your data values, it enables you to make sense of your data and spot important cues in the blink of an eye. FREE ACCESS
  • Locked
    7.  Calling out data with conditional formatting tools in Excel 2019 for Windows
    6m 14s
    If you have a lot of data to analyze in a short time, you can use conditional formatting rules to highlight specific cells, rows or columns to better understand your data. FREE ACCESS
  • Locked
    8.  Analyzing data ranges with conditional formatting tools in Excel 2019 for Windows
    4m 22s
    Conditional formatting enables you to apply different rules to analyze your data more clearly. Discover which tools can be used to help interpret your spreadsheet data values. FREE ACCESS
  • Locked
    9.  Using advanced conditional formatting in Excel 2019 for Windows
    4m 34s
    Go further with advanced conditional formatting by highlighting specific data criteria. If you need to find duplicate values or if you would like to hide specific values, conditional formatting provides you with these tools in Excel. FREE ACCESS
  • Locked
    10.  Controlling conditional formatting rules in Excel 2019 for Windows
    4m 26s
    If you have multiple conditional formats applied to your worksheet, it's a good idea to know which rule is applied first. See how to set the hierarchical order of the conditional formatting rules applied as well as resolve rule confliction in Excel. FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

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

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

Rating 3.9 of 21 users Rating 3.9 of 21 users (21)
Rating 4.6 of 416 users Rating 4.6 of 416 users (416)
Rating 4.5 of 208 users Rating 4.5 of 208 users (208)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.5 of 455 users Rating 4.5 of 455 users (455)
Rating 4.5 of 627 users Rating 4.5 of 627 users (627)
Rating 4.5 of 487 users Rating 4.5 of 487 users (487)