Excel Conditional Formatting Master Class

Learn how to use Conditional Formatting in Excel! Take your knowledge and skills to the next level.
4.5 (17 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.
1,201 students enrolled
$45
Take This Course
  • Lectures 37
  • Contents Video: 3.5 hours
    Other: 1 min
  • 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 4/2014 English

Course Description

Over 1000 people have taken this course!

When you see conditional formatting in Excel for the first time, you are amazed, to put it mildly. If Excel formatting makes your spreadsheets visually pleasant, conditional formatting in Excel makes them infinitely more powerful and useful. In this easy-to-follow Excel course, you will not only learn the basics of conditional formatting in Excel, but also become comfortable with more advanced conditional formatting techniques, such as conditional formatting based on text, conditional formatting based on another cell, conditional formatting based on a date, or on a range of dates, as well as conditional formatting with formulas, range-based conditional formatting rules and more. This Excel conditional formatting course will quickly build your Excel skills. It will serve you well as an Excel conditional formatting tutorial that takes your productivity to the next level.

When you take this course, you will benefit from over 3 hours of high-quality video material, so you can quickly improve your Excel skills. After you enroll and complete this course, you will have acquired various carefully selected conditional formatting tips and tricks.

This course is designed with a conditional formatting problem-solving approach in mind. The majority of these high-quality video lessons first introduce and define a specific, real-life problem and then provide an elegant conditional formatting based solution, so you can apply the newly-acquired skills immediately.

After you have taken this course, you will:

1) Become more productive in Excel.

2) Enhance your conditional formatting skills.

3) Save time with conditional formatting at work.

4) Make your spreadsheets more dynamic with conditional formatting.

5) Impress your boss, your colleagues, and your clients.

6) Improve your data analysis capabilities with conditional formatting.

7) Become comfortable with conditional formatting formula based rules.

This Excel course is one of the Easy Excel With Igor series. The other high quality Excel tutorials include:

"Microsoft Excel Without Pain" that helps you quickly build your foundation skills in Excel;

"Data Manipulation In Excel" allowing you to save up to 90% of time when using Excel for certain data management tasks;

"Excel Pivot Tables Data Analysis Master Class" that takes you step by step to mastering pivot tables data crunching skills;

"Microsoft Excel Charts Master Class" that builds your skills in creating your skills in Excel charts and graphs.

What are the requirements?

  • Access to a computer with Excel installed.
  • Recommended to take my Excel Without Pain course

What am I going to get from this course?

  • Learn the power of conditional formatting in Excel.
  • Use Conditional Formatting to save time at work
  • Become more creative in Excel.
  • Acquire specific ideas and proven strategies to become more productive in Excel.
  • Make your spreadsheets more dynamic with conditional formatting

What is the target audience?

  • Excel users of any level.
  • Anyone looking for a better way in Excel.
  • Anyone who wants to learn to effectively use conditional formatting in Excel

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: First Things First
03:36

What is conditional formatting anyway?

Navigating Udemy Course Interface
Preview
05:57
02:58

A few points before you begin to enjoy the course.

Section 2: Pre-set Conditional Formatting Rules In Excel
02:02

Let's discover a problem that can be solved with Conditional Formatting based on text.

06:29

Here we learn how to use conditional formatting based on text, or text-based conditional formatting in Excel.

01:15

Let's introduce a conditional formatting based on numbers. These are less than, greater than, equal to conditional formatting rules.

04:04

Let us take a look at how you can benefit from the conditional formatting based on numbers rules. The Less than, greater than, equal to conditional formatting.

01:29

Here we take a look at an example of Excel conditional formatting based on a date, or date-based conditional formatting rules.

06:16

Let's learn how to apply the Date Occurring conditional formatting in Excel. These are the date-based conditional formatting rules.

01:16

Let's see how we can find duplicates with conditional formatting in Excel.

01:13

Let's learn the technique of finding duplicates in Excel with conditional formatting.

02:00

Here we introduce how to look for highest or lowest values with Excel conditional formatting. These are called Top-Bottom conditional formatting rules in Excel.

09:56

Let us learn now how to use the top-bottom conditional formatting rules in Excel.

02:01

These are relatively new Excel conditional formatting rules called Data Bars, Icon Sets and Color Scales. They make you more productive in Excel spreadsheets when you work with data.

07:35

Let's learn how to create conditional formatting in Excel to display Data Bars, Icon Sets, Color Scales.

13:21

In this lecture we explore how you can copy and clear conditional formatting in Excel.

Some Useful Points On The Default Conditional Formatting Rules
06:43
Section 3: Custom Conditional Formatting Rules In Excel
08:02

Here we overview the Conditional Formatting tools in Excel. It is important to be comfortable with these Excel tools in order to create impressive custom Conditional Formatting rules in Excel.

04:17

Here we explore custom Conditional Formatting rules using Icon Sets in Excel.

05:02

In this lecture we learn to display Icon Sets in Excel in a different column by using Excel Conditional Formatting.

03:17

Let's create Icon Sets in Excel based on a formula-based conditional formatting rule.

11:32

Here we play with conditional formatting icon sets in Excel based on Percents and Percentiles.

07:50

Let's keep learning custom Excel Conditional formatting. Here we play with custom Data Bars in Excel.

Section 4: Formula-Based Conditional Formatting
01:58

Let's introduce Excel conditional formatting based on a formula. A very powerful technique.

12:00

Here we learn how to create formula-based conditional formatting in Excel. Amazing!

01:40

Here we explore an example of conditional formatting based on date in Excel.

12:41

Let us learn how to use date--based conditional formatting in Excel.

05:02

One more useful example of Excel conditional formatting based on dates.

Conditional Formatting Based On VLOOKUP - Problem Definition
Preview
02:26
08:31

This your tutorial on using Conditional Formatting based on VLOOKUP finction in Excel.

08:44

Let's explore how we can use conditional formatting to alternate row color in Excel.

01:34

Question. How can I highlight row and column in Excel by using Conditional Formatting?

11:18

Let's go step by step and learn how to highlight row and column by using Excel conditional formatting.

Section 5: One For The Road
01:11

Let me show you one fun example of using Conditional Formatting based on a formula in Excel.

06:19

This is your tutorial on how to do fun things with formula-based conditional formatting in Excel.

Section 6: Real-Life Problem Solving
15:04

Here we solve a real-life conditional formatting problem presented by Dayan Montano.

Bonus Lecture: Special Offers
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Igor Ovchinnikov, Learn It Your Way!

I love creating on-line courses. It has been my favorite pastime since 2013. I love the independent nature of this activity. There is so much to learn!

Independence is what I value most. I am an independent instructor – a free-lance instructor. My on-line courses are not the only thing that I do. I also teach in a classroom setting. My corporate clients hire me to conduct training for their employees. It is my main job: classroom and face-to-face training – as a free-lance of course. I have been in the training business for over 10 years.

I live in San Francisco and, naturally, most of my clients come from the Silicon Valley and from the Bay Area but not only from here. My corporate clients often ask me to travel to conduct training for them.

I have done training for many organizations for over 10 years. Among the more prominent are: Apple Computers, Stanford University, University of California, Google, Boston Scientific, Altera, Stryker Endoscopy, Air Liquide, BAE Systems, City of San Francisco, Anritsu, Genentech, Novartis, Bayer, Systron Donner, and many others. There are too many to list all of them here.

I am also a faculty of the American Management Association and conduct many of their training seminars – both public and private, or on-site. When I am not creating my on-line courses, I teach for one of these, or other fine companies.

I teach a broad range of topics. Such as Software, Project Management, Strategic Planning, Strategic Thinking, Business Creativity, Leadership, Communication, Negotiation, Sales, and Public Speaking. I do hold an M.B.A. from Ohio State University, and am a PMI®-certified Project Management Professional (PMP®).

Ready to start learning?
Take This Course