Learn Excel Conditional Formatting with 7 Practical Problems

Learn Excel Conditional Formatting features (both common rules and formula based) to visualize the insight of your data.
4.1 (38 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
5,179 students enrolled
$19
$40
52% off
Take This Course
  • Lectures 20
  • Length 1.5 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 12/2015 English

Course Description

Teaching 11 Courses on Excel and Data Analysis!

OVER 25,000 visitors visit my blog ExcelDemy dot com every month!!

OVER 15,000 successful students have already taken my online courses since November, 2015 with 375 total Reviews!!!

Course Updated:  Nov 01. 2016

Visualizing data is the core idea of all type of data analyzing. Excel conditional formatting is a very useful Excel tool to visualize numeric data. And Microsoft has updated this tool in every version of Excel. In this Excel conditional formatting crash course, we will discuss conditional formatting features using Excel 2013 version.

Let’s discuss now what you will learn from this course.

  1. High Light Cells Rules: At first you will learn how to highlight cells using conditional formatting rules.
  2. Top/Bottom Rules: Then you will work with Top/Bottom conditional formatting rules.
  3. Then you will use data bars.
  4. Then you will work with Color Scales and Icon sets.
  5. Formula based conditional formatting rules: Using formulas in conditional formatting rules will give you huge benefit to visualize data in unique ways. I have used total 7 practical examples to teach you formula based conditional formatting rules. And I have added some relevant practice problems with every lecture. If you watch the lectures and practice the problems, I can guarantee, you will be an expert in using formulas in conditional formatting rules.
  6. Then I have showed you how to manage conditional formatting rules.
  7. And finally I have showed you how to locate conditional formatting cells in a worksheet.
  8. Here is not the end of the course. Time to time, I shall add more lectures to the course that will teach you how to face real life data visualization using Excel conditional formatting rules.

So, if you are interested to learn Excel conditional formatting features with real life problems, then this course is for you. Thanks for reading. Enjoy the course!

What are the requirements?

  • Microsoft Office Software installed in your computer.

What am I going to get from this course?

  • Learn how to use Excel Conditional Formatting Rules.
  • Learn how to Create Formula Based Conditional Formatting rules.
  • And learn how to manage rules and locate conditionally formatted cells in a worksheet.

What is the target audience?

  • This course is meant for intermediate level Excel users who are familiar with the general concepts of Excel features.

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Welcome to the Course! Enhance Data Insights Using Excel Conditional Formatting
01:56

What you will get from this Excel lecture:

  1. You will be welcomed to the course. The instructor of this course is thankful to you that you have enrolled into this course.
  2. You will know which versions of Microsoft Excel has been used to create this course. You will also get idea which versions you can use to follow this course.
  3. You will have an idea how to use this course to get the best from it.
Article

What you will get from this Excel lecture:

  1. This is the download section of the whole course. You will get all the working files, practice problems, Video Index Dashboard, Excel keyboard shortcuts PDF, and other Excel resources in one place.
  2. You will also get an idea how to instantly contact me when you face an Excel or Course related problem.
Article
  1. You will get a list of websites where you can solve Excel related real life problems. If you cannot solve a problem, follow how other experts in the community solve that problem.
  2. Learn from trying to solve an Excel problem or learn from others who solve problems.
06:58

This video is actually about UDEMY platform. You will lea

  1. How to enter the course.
  2. How to use the platform to best view the course.
  3. There are several options in the platform. Without knowing them in details, you cannot expect to best use of the course.
02:40

In this video, you will see how you can get the certificate of your completion of the course.

Section 2: Conditional Formatting - Mastering Excel Conditional Formatting
09:11

In this video lecture:

  1. You will learn how to highlight some cells using conditional formatting based on the following rules:
    1. Greater than
    2. Less than
    3. Between
    4. Equal to
    5. Text that contains
    6. A Date Occurring
    7. And Duplicate Values
  2. You will also learn how to use the New Formatting Rule dialog box to work with more rules.
04:21

In this video lecture:

  1. You will learn how to highlight cells using conditional formatting Tot/Bottom Rules like:
    1. Top 10 Items
    2. Top 10%
    3. Bottom 10 Items
    4. Bottom 10%
    5. Above Average
    6. And Below Average
11:01

In this video lecture:

  1. You will learn how to conditionally format cells using Data Bars.
  2. You will learn how to show Data Bars in many ways.
  3. You will also learn how to show negative values differently.
04:32

In this video lecture:

  1. You will learn how to format cells conditionally using Color Scales.
  2. You will also learn how to create customized color scales using New Formatting Rule dialog box.
04:01

In this video lecture:

  1. You will learn how to create icon sets conditional formats.
  2. You will also learn how to create custom type icon sets.
Section 3: Formula Based Excel Conditional Formatting Rules
05:36

In this video lecture:

  1. You will learn how to format cells using formula based conditional formatting.
  2. You will learn about ISTEXT(...) Function.
  3. And you will learn again how to use Absolute Referencing in formulas.
03:51

In this video lecture:

  1. You will learn how to highlight the weekends from some dates using formula based conditional formatting.
  2. And you will practically use two functions: WEEKDAY() and OR() functions.
03:44

In this video lecture:

  1. You will learn how to highlight a whole row using formula based conditional formatting.
  2. And you will work with Absolute, Relative and Mixed Cell Referencing again in this video.
03:14

In this video lecture:

  1. You will learn how to highlight alternating rows using formula based conditional formatting.
  2. You will use MOD() and ROW() functions to build the formula.
03:17

In this video lecture:

  1. You will learn how to create a Checker Board using formula based conditional formatting.
  2. You will use MOD() and ROW() functions again in this video tutorial.
04:25

In this video lecture:

  1. You will learn how to shade alternating rows of a range using formula based conditional formatting.
  2. You will use INT(), MOD() and ROW() functions to build the formula.
03:28

In this video lecture:

  1. You will learn how to hide the data of a cell based on the data of another cell. To do this, you will use formula based conditional formatting.
  2. You will use COUNT() function to build the formula.
Section 4: Managing Excel Conditional Formatting Rules
03:03

In this video lecture:

  1. You will learn how to manage the conditional formatting rules in great details. You will learn:
    1. How to Edit Rules
    2. How to Delete Rules
    3. How to create New Rules.
    4. And how to move up and move down existing Rules.
02:44

In this video lecture:

  • You will learn how to locate cells that have conditional formatting rules.
Section 5: Learn More: A Special Offer!
Article

Want to get an in-depth knowledge of Microsoft Excel? Join my Advanced Excel 2013 Training + Build a Pro Excel Template course for 50% Off. Or join my Data Analysis in Excel with Statistics: Get Meanings of Data course for 50% Off.

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Kawser Ahmed, Founder ExcelDemy.com | Data Analyst

Love to see you here!

I am Kawser Ahmed, father of two beautiful angels (Marissa and Arissa), a full-time data analysis blogger (using Excel & other tools), corporate Excel trainer, & entrepreneur.

I love to make courses in the combination of both theory and practice.

Monthly 30,000 Excel users visit my Excel blog ExcelDemy (follow the website link in the profile).

I love to learn and teach (teaching from my eighteen)!

Visit my blog!

You will find plenty of useful posts, articles, video tutorials, and important Excel resources.

What I love most is: add some value to people around me, believe me!

Here are some of my working areas:

  • 1. Corporate Budgeting, Planning & Forecasting
  • 2. Mission-critical financial processes
  • 3. Month-end close processes
  • 4. Big Data Analysis using Excel
  • 5. Company Reports (Sales, Marketing, Administrative)
  • 6. Large Projects using Excel VBA
  • 7. Dashboard Design using Excel
  • 8. And Basic Accounting


I am always around you to help and support! 

Just knock me!

Ready to start learning?
Take This Course