Fraud Blocker
Announcement bar drops down here to inform users of the latest news and sales!
Search
Close this search box.

Business microlearning from Japan’s No1 MBA

Search
Close this search box.
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

Explore the role of a "komon", mastering broad skills to solve business gaps and leveraging a network of experts.
1 videos
2 min
Discover how generative AI transforms your business by embracing strategies for unparalleled innovation and operational success.
4 videos
9 min
Explore AI ethics and its societal impact to balance innovation with responsibility.
4 videos
11 min
Explore the history and marketing behind Black Friday, uncovering the truths about deals, FOMO, and consumer behavior in this retail phenomenon.
1 videos
2 min
Learn about ChatGPT, how it works and how it can transform your business operations by enhancing productivity and driving innovation.
3 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