Custom & Conditional Formatting in Excel 2016 for Windows

Excel 2016 (Windows)    |    Intermediate
  • 7 videos | 31m 44s
  • Includes Assessment
  • Earns a Badge
Rating 4.6 of 192 users Rating 4.6 of 192 users (192)
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

  • 5m 34s
    Excel 2016 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
  • 3m 17s
    In Excel 2016, 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 your date & time formats in Excel 2016 for Windows
    4m 25s
    Excel 2016 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
  • Locked
    4.  Creating conditional custom formats in Excel 2016 for Windows
    5m 40s
    The format that you want to apply to your data may depend on whether a particular value meets a condition. In Excel 2016, 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
  • Locked
    5.  Using the conditional formatting tools in Excel 2016 for Windows
    4m 48s
    In Excel 2016, 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 stand out by applying a color effect. As well as being able to apply multiple formatting styles at once, you can also create your own conditional formatting rules. FREE ACCESS
  • Locked
    6.  Using advanced conditional formatting in Excel 2016 for Windows
    4m 47s
    In Excel 2016, you can create advanced conditional formatting tools to create specific rules for conditional formatting. FREE ACCESS
  • Locked
    7.  Applying color to the first new entry in a list in Excel 2016 for Windows
    3m 12s
    The data that you have inserted into your Excel 2016 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 automatically highlight the first value in a new group. 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.

YOU MIGHT ALSO LIKE

Channel Microsoft Office Specialist: Expert (Office 2019)
Rating 5.0 of 3 users Rating 5.0 of 3 users (3)
Course Setting your work preferences in Excel 365 (2023)
Rating 5.0 of 1 users Rating 5.0 of 1 users (1)
Course Enhancing a worksheet with visual elements in Excel 365 (2024)
Rating 5.0 of 2 users Rating 5.0 of 2 users (2)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Getting started in Excel 365
Rating 4.4 of 6009 users Rating 4.4 of 6009 users (6009)
Course Using Basic Formulas in Excel 2019 for Windows
Rating 4.5 of 1052 users Rating 4.5 of 1052 users (1052)
Course Developing an AI/ML Data Strategy: The Data Analytics Maturity Model
Rating 4.6 of 260 users Rating 4.6 of 260 users (260)