Custom & Conditional Formatting

Excel 2016 (Windows)    |    Intermediate
  • 7 Videos | 31m 44s
  • Includes Assessment
  • Earns a Badge
Likes 150 Likes 150
To customize data, you can use the built-in formats in Excel 2016, or you can use your own. Learn how to create custom formats for numbers, text, and date and time, as well as how to create and use conditional formatting.

WHAT YOU WILL LEARN

  • Customizing your number formats
    Customizing your text formats
    Customizing your date & time formats
    Creating conditional custom formats
  • Using the conditional formatting tools
    Using advanced conditional formatting
    Applying color to the first new entry in a list

IN THIS COURSE

  • Playable
    1. 
    Customizing your number formats
    5m 34s
    UP NEXT
  • Playable
    2. 
    Customizing your text formats
    3m 17s
  • Locked
    3. 
    Customizing your date & time formats
    4m 25s
    FREE ACCESS
  • Locked
    4. 
    Creating conditional custom formats
    5m 40s
    FREE ACCESS
  • Locked
    5. 
    Using the conditional formatting tools
    4m 48s
    FREE ACCESS
  • Locked
    6. 
    Using advanced conditional formatting
    4m 47s
    FREE ACCESS
  • Locked
    7. 
    Applying color to the first new entry in a list
    3m 12s
    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 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

COURSE Applying custom formatting in Excel 365
COURSE Troubleshooting common issues in Excel 365
Likes 1 Likes 1  
COURSE Customizing charts in Excel 365

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

COURSE Using Conditional Formulas
Likes 98 Likes 98  
COURSE Working with Formulas
Likes 116 Likes 116  
COURSE Creating, Saving & Sharing Workbooks
Likes 282 Likes 282