Using Custom and Conditional Formatting in Excel 365 (2024)

Skillsoft issued completion badges are earned based on viewing the percentage required or receiving a passing score when assessment is required. 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). In order to practice what you have learned, you will find practice exercises and samples in the Course Contents pane.