Excel Conditional Formatting Master Class
4.7 (23 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,239 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel Conditional Formatting Master Class to your Wishlist.

Add to Wishlist

Excel Conditional Formatting Master Class

Learn these astonishing hidden Excel secrets and skyrocket your spreadsheets from “Meh” to “WOW” almost immediately!
4.7 (23 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,239 students enrolled
Created by Igor Ovchinnikov
Last updated 4/2016
English
Current price: $10 Original price: $75 Discount: 87% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3.5 hours on-demand video
  • 1 Article
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
  • Learn how to use the conditional formatting tools for maximum efficiency and productivity.
  • Learn how to use text-based conditional formatting tools, so you can quickly identify important data at a glance - immediately.
  • Learn to take advantage of the date-based conditional formatting rules to zero in on specific dates quickly by automatically highlighting them.
  • Discover how to quickly highlight duplicate data by using conditional formatting formatting techniques.
  • Know how to use top and bottom conditional formatting rules to identify your “winners” and “losers”.
  • Get astonished by the amazing power of the range-based conditional formatting rules. Such as Data Bars, Icon Sets, and Color Scales.
  • Go deeper and learn to exploit the mega-flexible custom conditional formatting rules.
  • Get even more astonished and learn how to benefit from formula-based conditional formatting rules for keeping close tabs on your constantly changing data.
  • Learn secret and creative ways to use the super-powerful VLOOKUP function in your formula-based conditional formatting rules for maximum flexibility. (This is huge!)
View Curriculum
Requirements
  • Access to a computer with Excel installed.
  • Recommended to take my Excel Without Pain course
Description

Hello, my name is Igor. 

I’d like to invite  you to join over 1400 students to learn Excel conditional formatting in this course.

Excel offers you quite a few amazing tricks that can instantly create a huge difference in your professional life - if you take just a little bit of time to learn. 

In this course, you’ll discover the amazing secrets of conditional formatting that will transform your spreadsheets from excruciatingly boring to infinitely more exciting - super-powerful and hyper-useful.

The best part, it is so embarrassingly easy, you’ll be wondering why you haven’t decided to learn it before

In fact, you may feel that enrolling in this course may be one of the best decisions you’ve ever made - to improve your Excel skills.

Now… when you take this course, you’ll get to enjoy several important benefits.

  • First and foremost, this course will teach you how to transform your flat spreadsheets into colorful, dynamic, actionable reports. 
  • So you can immediately see what’s important in your data and make a decision faster.
  • As a result, you’ll tremendously boost your productivity - since you’ll no longer need to squander your precious time squinting - looking for what’s important in your spreadsheets. 
  • This course may skyrocket your career as well. Because nothing in Excel creates the “wow factor” as conditional formatting. You’ll be astonished.

And so will everyone else.

What you are about to learn in this course will knock the socks off your boss, your clients, and your colleagues. 

It’s like taking a “couch potato” from 1950s and placing them in front of the latest LED HDTV panel. They’ll think you are a “God” from the future.

Imagine what it’ll feel like…

Let me now quickly share with you the story of this course…

Early in my training career, I’ve discovered that we learn better by attacking and solving specific problems.

I also found that only about 10 percent of “excellers” take time to learn how to benefit from conditional formatting.  

That’s why I’ve designed this course to help you solve specific real-life example problems. As you enjoy your way up through the material, you’ll learn by solving these problems .

This is a “learn fast and use it immediately” kind of training, where I’ll quickly guide you step-by-step through the most essential elements of the conditional-formatting toolkit. 

So you are completely ready to take it and use it during the course of your own work.

As a result of this training you will…

  • Learn how to use the conditional formatting tools for maximum efficiency and productivity.
  • Learn how to use text-based conditional formatting tools, so you can quickly identify important data at a glance - immediately.
  • Learn to take advantage of the date-based conditional formatting rules to zero in on specific dates quickly by automatically highlighting them.
  • Discover how to quickly highlight duplicate data by using conditional formatting formatting techniques.
  • Know how to use top and bottom conditional formatting rules to identify your “winners” and “losers”.
  • Get astonished by the amazing power of the range-based conditional formatting rules. Such as Data Bars, Icon Sets, and Color Scales.
  • Go deeper and learn to exploit the mega-flexible custom conditional formatting rules. 
  • Get even more astonished and learn how to benefit from formula-based conditional formatting rules for keeping close tabs on your constantly changing data.
  • Learn secret and creative ways to use the super-powerful VLOOKUP function in your formula-based conditional formatting rules for maximum flexibility. (This is huge!)

And so much more…

Again, I invite you to step up and enroll in this course right now. It’s easy. Just click on the “Take this Course” button and begin to learn.

With the mega-generous unconditional 30-day money back guarantee, it’s absolutely risk free for you to join the hundreds of students who have already had a chance to enjoy this course.

 Their response has been amazing:

“Very methodical and easy to understand. I thought myself pretty much a master at conditional formatting but I learned some new tricks from this course. I would sign up immediately…” (Jawad Niazi)

“I learned so much from this course! The instructor is very easy to follow. He talks at the right speed and explains things well. I was able to follow along with the example files easily and recreate each lesson. The instructor has an easy to follow teaching style and breaks everything down concisely. I highly recommend this course to others who want to learn more about Excel conditional formatting.” (Davd P.)

“It's an outstanding course. I am doing the exercises as I learn and Igor is a great explainer. Great course!” (Richard Sandler)

“Great course, great teaching style, Igor you really break it down to fully understand. The real world examples are great. I am an experienced Excel user, but actually did not use conditional formatting that much with the exceptions of the bars graphs and icon sets. Your course opened up all new possibilities for me. Great course, I highly recommend. Thanks for a great learning resource.” (Stephen Davanzo)

 “…This course was absolutly worth it. It feels like i'm on another level, thanks true this lessons. The course itself is great, the way its presented and the way those video's are made. I really loved the course from start to end. Like to see more from your knowledge. Thank you Igor.” (Eduard Bogaets)

“Great class, clear delivery of material and good applications for work… All in all a good course.” (Kaye Campbell)

“Enjoy taking this course very much, felt at ease with the instructions given by the instructor. Well worth the time and effort to learn this course.” (Florentino Detres)

“Well laid-out material, good delivery pace, and plenty of examples illustrating concepts. Igor's delivery is very good and polished. I had some experience with conditional formatting prior to this course and now I have a more complete picture of Excel's capability. Overall a very good value and money well spent.” (Alec)

“It's easy to find a good excel course, no doubt. ..But Igor's Excel Courses dive you into the strong distinction between just to learn using excel and be really superior in working with it! Thank You!” (Svetlana Neskovska)

“It is with great pleasure and satisfaction that I studied the "Easy Excel Conditional Formatting" course by Igor it was such that I have taken another course by Igor he is explaining everything in a very thorough way! "Easy Charts with Excel" was the other one. You really need it when you are new to charting! Thanks Igor” (Theo Witteveen)

One more time, come along - join the course now.

You are gonna love it.

Igor Ovchinnikov.

Who 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 37 Lectures Collapse All 37 Lectures 03:27:24
+
First Things First
3 Lectures 12:31

What is conditional formatting anyway?

Preview 03:36


A few points before you begin to enjoy the course.

Preview 02:58
+
Pre-set Conditional Formatting Rules In Excel
14 Lectures 01:05:40

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

Preview 02:02

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

Preview 06:29

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

Preview 01:15

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.

Less Than, Greater Than, Equal To - Solution
04:04

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

Preview 01:29

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

Conditional Formatting Based On Dates (Date Occurring) - Solution
06:16

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

Preview 01:16

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

Highlight Duplicates - Solution
01:13

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.

Preview 02:00

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

Top-Bottom - Solution
09:56

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.

Preview 02:01

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

Data Bars, Icon Sets, Color Scales - Solution
07:35

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

Preview 13:21

Some Useful Points On The Default Conditional Formatting Rules
06:43
+
Custom Conditional Formatting Rules In Excel
6 Lectures 40:00

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.

Preview 08:02

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

Icon Sets In Excel Based On Specific Numbers
04:17

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

Displaying Icon Sets In Another Column
05:02

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

Icon Sets Based On A Formula
03:17

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

Icon Sets Triggered By Percents And Percentiles
11:32

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

Custom Data-Bar Rules
07:50
+
Formula-Based Conditional Formatting
10 Lectures 01:05:54

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

Preview 01:58

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

First Formula-Based Conditional Formatting Example - Solution
12:00

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

Preview 01:40

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

Timesheet - Solution
12:41

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

Timesheet - One More Solution
05:02


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

VLOOKUP in Excel Conditional Formatting - Solution
08:31

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

Preview 08:44

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

Preview 01:34

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

Highlight Row And Column - Solution
11:18
+
One For The Road
2 Lectures 07:30

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

Preview 01:11

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

Thank you!!!
06:19
+
Real-Life Problem Solving
2 Lectures 15:54

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

Dayan Montano's
15:04

Bonus Lecture: Special Offers
00:50
About the Instructor
Igor Ovchinnikov
4.6 Average rating
281 Reviews
5,079 Students
10 Courses
Helping you learn fast, so you can do your job well.

Hi, I am Igor Ovchinnikov.

Welcome to my profile page. This is where you normally get to learn about me and read something like this:

“Igor Ovchinnikov is a corporate trainer with over 10 years of experience. He lives in San Francisco and provides excellent training-delivery services to clients all over the Bay Area. He has delivered training for 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. 

Mr. Ovchinnikov holds an MBA from the Ohio State University.”

Well, frankly, I always have some serious cognitive dissonance whenever I have to write about myself in the third person like this. It’s a bit silly - don’t you agree? So, enough of this out-of-body talk!

First of all, you probably don’t care about me that much. Second, you are probably more interested in why you should buy my courses and what’s in them for you? You may be more interested in how my teaching is different compared to the other great instructors out there?

I have to confess, it is something I've been wondering about too. You know, when someone asks you what you are good at, it’s tough to answer that. Especially, because when you are really good at something, you don’t really perceive it as a big deal. Don’t you agree? Think of something you do really well. Now, do you really work hard on it, or does it come kind of naturally?

So, to answer this question to myself, I recently decided to ask my students. Most of the ones I polled are employees of just one organization where I teach - Stanford University, so the research sample may not be fully scientific. Anyway, I asked a few dozens of my students what they liked best about my teaching style. It was really surprising, that most of them told me that their favorite part was how clear things became after I explained it to them. One of them said literally: “You are a great explainer. It was so confusing before, and now I finally understand it!” 

I think, here’s what I can promise you when you enroll in my courses. I promise you clear explanations, so that things will be no longer confusing.

So, here’s my value proposition to you:

When you enroll in my courses and go through the material, you should expect clear explanations that will help you learn and build your skills fast, so you can succeed at your job. 

If that is the experience that you are interested in, simply enroll in my courses below.