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.
Cet exercice fait partie du cours
Microsoft Copilot in Excel
Exercice interactif pratique
Passez de la théorie à la pratique avec l’un de nos exercices interactifs
Commencer l’exercice