Custom & Conditional Formatting in Excel 2013 for Windows

Excel 2013 (Windows)    |    Intermediate
  • 6 videos | 38m 54s
  • Earns a Badge
Likes 39 Likes 39
Excel 2013 is highly customizable when it comes to formats. Learn how to customize number, text, and date and time formats; create conditional formats; use conditional formatting tools; and apply color to the first new entry in a list.

WHAT YOU WILL LEARN

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

IN THIS COURSE

  • Playable
    1.  Customizing your number formats in Excel 2013 for Windows
    6m 53s
    Excel 2013 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… FREE ACCESS
  • Playable
    2.  Customizing your text formats in Excel 2013 for Windows
    5m 48s
    In Excel 2013, you can also create customized text formats. You can adjust the leading dots in your cell, add context words and punctuation, and even apply colors to your data. FREE ACCESS
  • Locked
    3.  Customizing the date & time formats in Excel 2013 for Windows
    4m 47s
    Excel 2013 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… FREE ACCESS
  • Locked
    4.  Creating conditional custom formats in Excel 2013 for Windows
    8m 48s
    The format that you want to apply to your data may depend on whether a particular value meets a condition. In Excel 2013, you can create conditional formats that are applied if certain criteria are met. You can choose… FREE ACCESS
  • Locked
    5.  Using conditional formatting tools in Excel 2013 for Windows
    8m 5s
    In Excel 2013, you can create special formatting styles that are applied to particular cell values if they correspond to specified criteria or conditions. You can, for example, make any value within a certain data range… FREE ACCESS
  • Locked
    6.  Applying color to the first new entry in a list in Excel 2013 for Windows
    4m 34s
    The data that you have inserted into your Excel 2013 spreadsheet can be organized. If you want to quickly see where a new group starts and the previous one finishes, you can create a conditional formatting rule that will… 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.