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

Business microlearning from Japan’s No1 MBA

Edge

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

Discover what kokorozashi is and how to begin developing your own personal mission.
4 videos
9 min
"Blameless" post-mortem? Yeah, right. Watch Scott try to find a scapegoat using buzzwords in this corporate comedy.
1 videos
4 min
Learn what adaptive thinking is and how it can help you react and thrive in today's fast-changing business environment.
4 videos
7 min
It's the 90s, but we're using ChatGPT! Learn to make spreadsheets (for tracking bathroom breaks) without knowing a single formula.
1 videos
6 min
Join University of Tokyo Professor Miles Pennington to hear the critical role design plays in innovation and how to promote this thinking in your company.
1 videos
9 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