Custom & Conditional Formatting in Excel 2019 for Windows

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 elements 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.