Applying custom formatting in Excel 365

Excel Microsoft 365 (2021)    |    Intermediate
  • 6 Videos | 19m 6s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
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 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

  • Playable
    1. 
    Course Overview: Applying custom formatting in Excel 365
    47s
    UP NEXT
  • Playable
    2. 
    Analyzing data ranges with conditional formatting
    4m 31s
  • Locked
    3. 
    Using advanced conditional formatting
    4m 30s
  • Locked
    4. 
    Managing conditional formatting rules
    2m 37s
  • Locked
    5. 
    Using intelligent data types
    4m 5s
  • Locked
    6. 
    Converting number types with BIN and HEX
    2m 35s

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.