Conditional Formatting in Excel

Top/Bottom, Data Bars, Color Scales, Icon Sets, Edit Rules, Formulas, Gantt Chart Application

What will you learn in this course?

Identifying and highlighting a few data points from a large set of data can be extremely tedious and painful. Conditional formatting enables you to accomplish that quickly as per your need. Formulas and filters can help you isolate that data, but these techniques do not provide you a comparative view of the remaining data. This course enables you to use in-built techniques as well as define your own criteria using formulas to identify and highlight data using conditional formatting.

Pre-defined rules

You will learn how to highlight cells using pre-defined rules like top/bottom, between, etc.

You can highlight cells using in-built formatting options or create a custom formatting option of your choice.

Learn formatting options like data bars, color scales, and icon sets thoroughly to use the most appropriate option for the type of data.

Formulas for rules

In case you need to evaluate a complex set of conditions to format data, then you can write custom formulas to highlight the data.

Formulas give you flexibility to evaluate conditions across multiple columns and highlight the resultant data.

Gantt chart

Oganizations use Excel extensively for project tracking and reporting.

Creating Gantt charts within Excel can be tedious and prone to errors.

Through conditional formatting, you can eliminate the need to highlight cells manually every time you add more rows or update dates for an existing row.

How will this course help you?

Conditional formatting enhances your productivity by quickly identifying and highlighting data you want your users to notice and take action on. Learn all you need to know about Conditional Formatting and use it to identify and highlight key data quickly.

Highlight key information

If you don't emphasize the key information, your documents may not have the desired impact, and you may come across as ineffective.

Conditional formatting can make your documents standout.

Using conditional formatting, you can instantly highlight key information at a glance with custom rules. You can show more out of your data faster and easier.

Format related information

Highlight important information related to your data using formulas, so that you can identify trends easily and get actionable insights in no time!

By using formulas, you can easily customize the formatting of any cell based on what’s happening in other cells. With conditional formatting, you can save time, uncover valuable insights, and make informed decisions about your business.

Reporting

Staying on top of progress reports can be a challenge. It's difficult to keep up with manually creating and updating reports, as it takes valuable time away from other tasks.

You can use conditional formatting to simplify your project reporting. You can easily track and report project performance and quickly identify any delays.

A young man wearing headphones and looking at a laptop with focus

What all does this course include?

You'll have access to all these benefits once you enroll in this course

Short lessons for a quick understanding

Personalized feedback on assignment

Course Certificate on approval of assignment

Earn a Skill Badge on approval of assignment

Link to add certificate to your LinkedIn profile

Invitations to upcoming webinars

Discussion forum for clarifying doubts

Downloadable worksheets for practice

Course Curriculum

Using Conditional Formatting
8 Lessons
- Download Resource File
  Start
- Highlight Cells using in-built and custom formatting options
  Start
- Highlight Top/Bottom Cells and modifying pre-defined rules
  Start
- Highlight Cells using default and customized settings for Data Bars
  Start
- Highlight Cells using Color Scales option and customize formatting
  Start
- Highlight Cells using Icon Sets option and customize formatting
  Start
- Highlight Cells based on values of other cells using Formulas
  Start
- Creating a Gantt Chart using Conditional Formatting
  Start
Wrap-up
3 Lessons
- Quiz - Conditional Formatting
  Start
- Final Words
  Start
- Assignment
  Start

Get access to the course

Through this course on Conditional Formatting, you'll learn how to use in-built features and formulas to quickly highlight key information and track projects with ease in Excel.

You can avoid to the hassle of data-finding and minimize the risk of missing on key data and actions associated with it.

Get started today!