Custom & Conditional Formatting in Excel 2019 for Windows
Excel
| Intermediate
- 10 videos | 46m 38s
- Includes Assessment
- Earns a Badge
- CPE
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 5sExcel 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 36sIn 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
-
3. Customizing your date & time formats in Excel 2019 for Windows4m 39sExcel 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
-
4. Using color in custom formats in Excel 2019 for Windows4m 5sIf you want to quickly modify the color applied to data in a worksheet , you can use the custom format options in Excel. FREE ACCESS
-
5. Creating conditional custom formats in Excel 2019 for Windows4m 9sThe 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
-
6. Creating conditional formatting rules in Excel 2019 for Windows3m 28sConditional 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
-
7. Calling out data with conditional formatting tools in Excel 2019 for Windows6m 14sIf 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
-
8. Analyzing data ranges with conditional formatting tools in Excel 2019 for Windows4m 22sConditional 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
-
9. Using advanced conditional formatting in Excel 2019 for Windows4m 34sGo 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
-
10. Controlling conditional formatting rules in Excel 2019 for Windows4m 26sIf 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.
