Fraud Blocker
Announcement bar drops down here to inform users of the latest news and sales!

Excel Data Analysis: Conditional Formatting

19 minutes (1 section)

Course Description

Conditional formatting is a powerful tool for added flexibility in data analysis.
It even allows you to create personalized rules for greater customization.

This course covers how to:
• Apply conditional formatting and manage its rules,
• Use data bars, color scales, icon sets and heat map to visualize data,
• Highlight duplicates and alternate rows,
• Compare two lists for discrepancies,
• And, look into the hierarchy of conditional formatting rules to resolve rule conflicts.

Join us, and explore how conditional formatting dynamically highlights vital data trends, anomalies, and insights.

Share this course:

Related Courses

Master AI research tools. Discover how to inspect citations, verify sources, and use follow-up prompts to refine your results.
1 videos
5 min
As AI advances, learn about why it's critical for companies to consider governance, risk, and compliance.
7 videos
33 min
Discover how artificial intelligence is transforming modern organizational structures, leadership decision-making, and industry dynamics in the era of generative technology.
7 videos
36 min
Learn how to brainstorm with AI! See how clarifying prompts and adding detailed parameters guide AI to highly specific scenarios.
1 videos
5 min
Learn about differences between US & Japan Tech ecosystems and their impact on VC and startups in this panel from the 2026 G1 Silicon Valley Conference.
1 videos
60 min

Start your free trial

Sign up to watch the rest of this course for free - no strings attached!
Continue with a subscription of USD 16.67 / month* after free trial ends
*USD 99.99 billed every 6 months