Applying custom formatting in Excel 365

Excel    |    Intermediate
  • 6 videos | 19m 6s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Rating 4.4 of 282 users Rating 4.4 of 282 users (282)
To customize data even further, you can create your own conditional formatting in Excel 365. In this course, you will observe how to create and use conditional formatting, work with intelligent data types, and convert values from the default base-10 number system into binary and hexadecimal. To start, you will discover how to apply advanced conditional custom formatting to data values and create conditional formatting rules to enhance how your data values display. You will also delve into managing conditional formatting rules and using intelligent data types that can be mapped automatically to existing values in a data range, thereby enriching your worksheets and reports. In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane or in the Resources section.

WHAT YOU WILL LEARN

  • Discover the key concepts covered in this microsoft 365: applying custom formatting in excel 365 course
    Use conditional formatting to analyze a data range in excel 365
    Use advanced conditional formatting tools in excel 365
  • Manage conditional formatting rules in excel 365
    Use intelligent data types in excel 365
    Convert numbers with bin and hex in excel 365

IN THIS COURSE

  • 47s
    This video outlines the key content covered in the Microsoft 365: Applying custom formatting in Excel 365 course, including how to analyze data ranges with conditional formatting, manage conditional formatting rules, and how to use intelligent data types in Excel. FREE ACCESS
  • 4m 31s
    In Excel 365, conditional formatting lets you apply different rules to analyze your data more clearly. In this video, you will explore how to use conditional formatting to analyze a data range in Excel 365. This video aligns with the MOS MO-200 / Excel Associate Certification exam objective: 2.4.2 Apply built-in conditional formatting. As well as with the MOS MO-200 / Excel Associate Certification exam objective: 2.4.3 Remove conditional formatting. FREE ACCESS
  • Locked
    3.  Using advanced conditional formatting
    4m 30s
    Go 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 this video, you will explore how to use advanced conditional formatting tools in Excel 365. This video aligns with the MOS MO-201 / Excel Expert Certification exam objective: 2.3.1 Create custom conditional formatting rules. FREE ACCESS
  • Locked
    4.  Managing conditional formatting rules
    2m 37s
    If you have multiple conditional formats applied to a worksheet, it's a good idea to know which rule is applied first. You can set the hierarchical order of the conditional formatting rules that have been applied, as well as resolve rule conflicts. In this video, you will explore how to manage conditional formatting rules in Excel 365. This video aligns with the MOS MO-201 / Excel Expert Certification exam objective: 2.3.3 Manage conditional formatting rules. FREE ACCESS
  • Locked
    5.  Using intelligent data types
    4m 5s
    If a data range contains stock-related or geographical values, you can use Excel 365's data types to dynamically insert and visualize associated information. This information can be mapped automatically to existing values in a data range, thereby enriching your worksheets and reports. In this video, you will explore how to use intelligent data types in Excel 365. FREE ACCESS
  • Locked
    6.  Converting number types with BIN and HEX
    2m 35s
    We generally use a base-10 decimal system in everyday life, but you may occasionally find it useful to work in binary and hexadecimal. In this video, you will explore how to convert numbers with BIN and HEX in Excel 365. 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

Course Exploring essential functions in Excel 365 (2023)
Rating 4.9 of 7 users Rating 4.9 of 7 users (7)
Course Automating tasks in Excel 365 (2024)
Rating 4.1 of 14 users Rating 4.1 of 14 users (14)
Course Troubleshooting common issues in Excel 365
Rating 4.6 of 190 users Rating 4.6 of 190 users (190)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Defining Cloud Computing for Decision-makers: Cloud Computing Principles
Rating 4.3 of 328 users Rating 4.3 of 328 users (328)
Course Customizing text & number formats in Excel 365
Rating 4.5 of 310 users Rating 4.5 of 310 users (310)
Course Collaborating effectively in Excel 365
Rating 4.6 of 378 users Rating 4.6 of 378 users (378)