Course Description
What is conditional formatting and why is it useful for you?
Conditional formatting allows the user to format a group of cells
based on one or multiple criteria. This means that you do not have to
format the cells manually and you can let Excel do all the work for you! Also, if there is change in the data Excel will automatically change the formatting, if the cell will now meet a different criteria.
Most frequently I use conditional formatting to allow me visualize the data, meaning that I can start analyzing the data before even looking at the values themselves. This means that you can increase your productivity working with Excel to a high degree using conditional formatting.
You can preview the introduction lectures in order to see some of the applications of conditional formatting in order to get a better understanding how it can be used.
About this course:
In this course I show everything step-by-step, meaning that I will be showing each single button that I press. By doing this I want to make sure that you memorize all the steps and can apply conditional formatting in your own Excel spreadsheets.
This course is designed for a beginner/intermediate level.
You need to have Excel fundamentals, meaning that you will have to know
how to open an Excel file, save it and other similar fundamentals.
However, you do not need to have an advanced knowledge of Excel. The most advanced part of this course is when I will be teaching you to use formulas to make a condition. However, I will explain each formula in depth, meaning that you do not have to worry that you will not understand it.
However, if you are an advanced Excel user, you might still want to
go through the course in order to refresh your knowledge and possibly
learn a couple of new tips.
Curriculum
What Is Conditional Formatting?
A Date Occurring
Above and Below Average Conditional Formatting
Before Creating Custom Formulas You Need to Know How to Lock Rows and Columns
Between
Changing Colours of Alternating Rows Using Formulas in Conditional Formatting
Comparing Two Different Lists For Matches or Mismatches
Comparing Values In Two Columns Using Formulas
Conditional Formatting Based on a Specific Cell (Highly Recommended)
Creating Custom Icon Set Ranges
Directional Icon Sets
Downloadable Material for This Section Is Located in This Lecture
Downloadable Material for This Section Is Located in This Lecture
Duplicate Values/Unique Values
Dynamic Way of Selecting Whole Row Based on a Cell
Equal To
Excel Knowledge Prerequisites Before Taking This Course
Finding Duplicates Using Criteria From Two Columns
Finding Duplicates Using Formulas in Conditional Formatting
Gradient and Solid Data Bar Fills
Greater Than
Highlight Cells Containing Time Information Using Formulas
Highlighting the Whole Row Based on a Column
How to Remove Conditional Formatting
Introduction and Explanation of Icon Sets
Introduction to Creating Your Own Custom Conditional Formatting Rules
Less Than
More Examples of Using Conditional Formatting
More Lectures as Time Goes On!
Order of Conditional and How to Change It
Ratings Icon Sets
Section 1: Introduction and the Uses of Conditional Formatting
Section 2: How to Remove Conditional Formatting
Section 3: Highlight Cell Rules
Section 4: Top and Bottom Rules
Section 5: Data Bars
Section 6: Icon Sets
Section 7: Slightly More Advanced Conditional Formatting
Section 8: Using Formulas in Conditional Formatting
Section 9: Conclusion
Shapes and Indicators Icon Sets
Text That Contains
The Best Way to Watch the Lectures
Top and Bottom X Amount of Items Conditional Formatting
Top and Bottom X% of Items Conditional Formatting
Using Conditional Formatting In Filters
Using Conditional Formatting to Find Discrepancies
LINK FOR THE FREE COURSE
https://www.udemy.com/conditional-formatting-in-microsoft-excel/?couponCode=0USD100% Off, Udemy 100% Off, Udemy Coupon, Udemy Coupon Code, Udemy course, Udemy course download, Udemy course reviews, Udemy courses, Udemy courses for free, Udemy courses free, Udemy courses free download, Udemy discount, Udemy download, Udemy education, Udemy free, Udemy free course, Udemy free courses, Udemy free online courses, Udemy online, Udemy online course, Udemy online courses, Udemy online courses review, Udemy reviews, Udemy tutorial, Udemy tutorials, Udemy.com free courses,
