Applying custom formatting in Excel 365

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

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
    57s
    UP NEXT
  • Playable
    2. 
    Analyzing data ranges with conditional formatting
    5m 59s
  • Locked
    3. 
    Using advanced conditional formatting
    5m 49s
  • Locked
    4. 
    Managing conditional formatting rules
    3m 38s
  • Locked
    5. 
    Using intelligent data types
    5m 31s
  • Locked
    6. 
    Converting number types with BIN and HEX
    3m 30s

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

Likes 704 Likes 704  
Likes 67 Likes 67