Applying custom formatting in Excel 365
Excel Microsoft 365 (2021)
| Intermediate
- 6 videos | 19m 6s
- Includes Assessment
- Earns a Badge
- 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 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
-
47sThis 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 31sIn 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
-
3. Using advanced conditional formatting4m 30sGo 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
-
4. Managing conditional formatting rules2m 37sIf 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
-
5. Using intelligent data types4m 5sIf 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
-
6. Converting number types with BIN and HEX2m 35sWe 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.
