5910 Breckenridge Pkwy Suite B, Tampa, FL. 33610
(800) 272-0707

SkillSoft Explore Course

Collections     Accelerator 2.0: Office 365     Microsoft Office 2019: Intermediate Excel

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. 



Objectives

Excel 2019 for Windows: Custom & Conditional Formatting

  • 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