What you'll 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!)
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.
Overview
Section 1: First Things First
Lecture 1 Welcome!
Lecture 2 Navigating Udemy Course Interface
Lecture 3 Learning Tips
Lecture 4 Download Exercise Files
Section 2: Pre-set Conditional Formatting Rules In Excel
Lecture 5 Conditional Formatting Based On Text - Problem Definition
Lecture 6 Text-Based Conditional Formatting Rules - Solution
Lecture 7 Less Than, Greater Than, Equal To - Problem Definition
Lecture 8 Less Than, Greater Than, Equal To - Solution
Lecture 9 Date-Based Conditional Formatting (Date Occurring) - problem definition
Lecture 10 Conditional Formatting Based On Dates (Date Occurring) - Solution
Lecture 11 Highlight Duplicates - Problem Definition
Lecture 12 Highlight Duplicates - Solution
Lecture 13 Top-Bottom - Problem Definition
Lecture 14 Top-Bottom - Solution
Lecture 15 Data Bars, Icon Sets, Color Scales - Introduction
Lecture 16 Data Bars, Icon Sets, Color Scales - Solution
Lecture 17 Copy And Clear Rules
Lecture 18 Some Useful Points On The Default Conditional Formatting Rules
Section 3: Custom Conditional Formatting Rules In Excel
Lecture 19 Custom Conditional Formatting Rules - Overview Of Tools
Lecture 20 Icon Sets In Excel Based On Specific Numbers
Lecture 21 Displaying Icon Sets In Another Column
Lecture 22 Icon Sets Based On A Formula
Lecture 23 Icon Sets Triggered By Percents And Percentiles
Lecture 24 Custom Data-Bar Rules
Section 4: Formula-Based Conditional Formatting
Lecture 25 First Formula-Based Conditional Formatting Example - Problem Definition
Lecture 26 First Formula-Based Conditional Formatting Example - Solution
Lecture 27 Timesheet With Conditional Formatting - Problem Definition
Lecture 28 Timesheet - Solution
Lecture 29 Timesheet - One More Solution
Lecture 30 Conditional Formatting Based On VLOOKUP - Problem Definition
Lecture 31 VLOOKUP in Excel Conditional Formatting - Solution
Lecture 32 Alternating Row Color With Conditional Formatting
Lecture 33 Use Conditional Formatting To Highlight Row And Column - Problem Definition
Lecture 34 Highlight Row And Column - Solution
Section 5: One For The Road
Lecture 35 Secret Message With Conditional Formatting
Lecture 36 Thank you!!!
Section 6: Real-Life Problem Solving
Lecture 37 Dayan Montano's
Lecture 38 How to use ISTEXT, ISBLANK, ISNUMBER and ISFORMULA as conditions
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



Download link

rapidgator.net:


uploadgig.com:


nitroflare.com:


1dl.net: