Home / Course catalog / Excel level 2 – 4 Making issue... (Bus_Excel_02-04)

Business tools

Excel level 2 – 4 Making issues visible with formatting rules (Bus_Excel_02-04)


Description

This module helps learners make issues visible and avoid “formatting disappears” problems in their files. It directly answers the need to use conditional formatting correctly so that overdue items, missing data, duplicates, and priorities are highlighted consistently and remain stable when ranges change.

Content
  • Conditional Formatting
  • What is conditional formatting
  • How to use conditional formatting
  • Highlight rows based on a cell value
  • Optional : How to remove duplicates
  • Optional : Apply conditional formatting based on VLOOKUP
Completion rules
  • All units must be completed