开始使用免费开始使用

Surfacing data quality issues with colors

You're a project coordinator at Horizon PMO. Your team lead wants to spot data quality issues in the project tracker before the quarterly review. Use Copilot to add two conditional formatting rules: first highlight any missing or blank values in the table, then highlight duplicate values in the Owner column. Verify the scope of each rule, then answer a question about what you found.

本练习是课程的一部分

Microsoft Copilot in Excel

查看课程

动手互动练习

通过我们的互动练习之一,将理论转化为实践

开始练习