
What is conditional formatting anyway?
A few points before you begin to enjoy the course.
Let's discover a problem that can be solved with Conditional Formatting based on text.
Here we learn how to use conditional formatting based on text, or text-based conditional formatting in Excel.
Let's introduce a conditional formatting based on numbers. These are less than, greater than, equal to conditional formatting rules.
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.
Here we take a look at an example of Excel conditional formatting based on a date, or date-based conditional formatting rules.
Let's learn how to apply the Date Occurring conditional formatting in Excel. These are the date-based conditional formatting rules.
Let's see how we can find duplicates with conditional formatting in Excel.
Let's learn the technique of finding duplicates in Excel with conditional formatting.
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.
Let us learn now how to use the top-bottom conditional formatting rules in Excel.
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.
Let's learn how to create conditional formatting in Excel to display Data Bars, Icon Sets, Color Scales.
In this lecture we explore how you can copy and clear conditional formatting in Excel.
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.
Here we explore custom Conditional Formatting rules using Icon Sets in Excel.
In this lecture we learn to display Icon Sets in Excel in a different column by using Excel Conditional Formatting.
Let's create Icon Sets in Excel based on a formula-based conditional formatting rule.
Here we play with conditional formatting icon sets in Excel based on Percents and Percentiles.
Let's keep learning custom Excel Conditional formatting. Here we play with custom Data Bars in Excel.
Let's introduce Excel conditional formatting based on a formula. A very powerful technique.
Here we learn how to create formula-based conditional formatting in Excel. Amazing!
Here we explore an example of conditional formatting based on date in Excel.
Let us learn how to use date--based conditional formatting in Excel.
One more useful example of Excel conditional formatting based on dates.
This your tutorial on using Conditional Formatting based on VLOOKUP finction in Excel.
Let's explore how we can use conditional formatting to alternate row color in Excel.
Question. How can I highlight row and column in Excel by using Conditional Formatting?
Let's go step by step and learn how to highlight row and column by using Excel conditional formatting.
Let me show you one fun example of using Conditional Formatting based on a formula in Excel.
This is your tutorial on how to do fun things with formula-based conditional formatting in Excel.
Here we solve a real-life conditional formatting problem presented by Dayan Montano.
This lecture shows you how to use ISTEXT, ISBLANK, ISNUMBER, and ISFORMULA functions as conditional formatting rules.
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.
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…
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.