Excel for Auditors – Conditional Formatting (1 CPE)

This is an archived event from 3-31-25 Excel for Auditors: Conditional Formatting.

In this course, we will show specific ways for auditors to use conditional formatting, as well as provide example files and exercises for attendees to work along with us!

In Excel, conditional formatting automatically formats cells based on specific criteria, highlighting notable data or patterns, and making it easier to identify trends or exceptions. When cell values are entered/pasted or changed, the formatting dynamically updates, saving users time and providing immediate new information to assess.

Learning Objectives

In this course, you will:

•  Learn about various aspects of conditional formatting, from the perspective and experience of a 30+ year auditor
• See and engage with actual use-cases of conditional formatting related to audit tests and risk identification
• Discover ways to automate and quickly access conditional formatting for your audit work and reporting

Duration: 1 hour (approximate)
CPEs Available: 1
Knowledge Level: Basic
Category: Data Analytics