Using Custom and Conditional Formatting in Excel 365 (2024)
Excel 365 (2024)
| Intermediate
- 10 videos | 45m 25s
- Includes Assessment
- Earns a Badge
- CPE
Excel 365 provides various advanced tools for data presentation and analysis. In this course, discover the different techniques for customizing number, date, and time formats, as well as using conditional formatting to enhance data management. First, learn how to tailor number formats to meet specific requirements, which include creating unique custom number formats and adjusting date and time formats for better clarity and locale-specific presentation. Next, discover the power of conditional formatting, a feature in Excel 365 that enables users to apply formatting rules to cells based on their values or other criteria. Learn how to analyze data effectively using conditional formatting, customize these rules for more complex data scenarios, apply them using formulas for dynamic formatting, and manage multiple formatting rules efficiently. Lastly, explore how to use intelligent data types in Excel 365, a feature that enhances the functionality of spreadsheets by allowing users to work with rich, contextual data. This course aligns with the objectives of Exams MO-210: Microsoft Excel (Microsoft 365 Apps) and MO-211: Microsoft Excel Expert (Microsoft 365 Apps). Would you like hands-on practice? Go to the Course Contents pane and download the sample files to follow along with select videos.
WHAT YOU WILL LEARN
-
Discover the key concepts covered in this using custom and conditional formatting in excel 365 (2024) course
Modify and customize number formats
Create custom number formats with colors and conditions
Customize date, time, and special number formats
Use conditional formatting to analyze a data range -
Create and edit custom conditional formatting rules
Create and edit custom conditional formatting rules using formulas
Find, sort and filter data with conditional formatting
Manage conditional formatting rules
Work with intelligent data types
IN THIS COURSE
-
57sThis video outlines the key content covered in this Using Custom and Conditional Formatting in Excel 365 (2024) course, including how to create and customize number formats, conditional formatting rules, and format values with intelligent data types. FREE ACCESS
-
4m 14sExcel 365 features numerous number formats, but occasionally it may be required to create your own. In this video, explore how to modify and customize number formats. This video aligns with the MO-211 Microsoft Excel Exam objective: Create custom number formats. FREE ACCESS
-
3. Creating custom number formats in Excel 3654m 29sSometimes concealing information in a worksheet is required without altering the actual data values. Excel 365 allows creating custom number formatting to format and hide data within a cell. Additionally, learn how to create a custom number format using conditions, colors, and icons. FREE ACCESS
-
4. Customizing date and time formats in Excel 3655m 9sDepending on the country or region where data is being presented, individuals may not use the same time and date format. Excel 365 provides a range of diverse date and time formats, and users can even create custom formats. In this video, learn how to personalize date and time formatting in Excel 365 FREE ACCESS
-
5. Analyzing data with conditional formatting in Excel 3655m 5sIn Excel 365, conditional formatting enables the application of various rules to enhance data analysis clarity. In this video, explore the use of conditional formatting to examine a data range within a worksheet. This video aligns with the MO-210 Microsoft Excel Exam objectives: Apply built-in conditional formatting and Remove conditional formatting. FREE ACCESS
-
6. Customizing conditional formatting in Excel 3655m 3sDelve deeper into advanced conditional formatting by emphasizing particular data criteria. For example, learn how to create a rule to identify duplicate values or to hide certain values. This video demonstrates how to use advanced conditional formatting tools in Excel 365. This video aligns with the MO-211 Microsoft Excel Expert Exam objective: Create custom conditional formatting rules FREE ACCESS
-
7. Applying conditional formatting with formulas in Excel 3655m 55sBefore implementing a conditional formatting rule with a formula, testing the formula to verify cell references and conditions on the worksheet is recommended. This video demonstrates the creation of rules using formulas for both numerical and textual values in Excel 365. This video aligns with the MO-211 Microsoft Excel Expert Exam objective: Create conditional formatting rules that use formulas FREE ACCESS
-
8. Using conditional formatting to manage data in Excel 3654m 26sConditional Formatting rules enable the enhancement of data with the use of colors and icons. Excel 365 provides functionalities for organizing and refining data based on its formatting. In this video, discover how to select data formatted with Conditional Formatting and learn how to remove such formatting during copy and paste operations. FREE ACCESS
-
9. Managing conditional formatting rules in Excel 3654m 34sWhen multiple conditional formats are applied to a worksheet, it's beneficial to understand the precedence of each rule. Setting the hierarchical order of the applied conditional formatting rules is possible, as well as resolving any conflicts between them. In this video, explore how to manage conditional formatting rules in Excel 365. This video aligns with the MO-211 Microsoft Excel Expert Exam objective: Manage conditional formatting rules FREE ACCESS
-
10. Using intelligent data types in Excel 3655m 32sIf a data range contains stock-related or geographical values, Excel 365's data types can be used to dynamically insert and visualize associated information. This information can be mapped automatically to existing values in a data range and enrich worksheets and reports. In this video, explore how to use intelligent data types 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.
