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.
Este ejercicio forma parte del curso
Microsoft Copilot in Excel
Ejercicio interactivo práctico
Pon en práctica la teoría con uno de nuestros ejercicios interactivos
Empezar ejercicio