Learn to use Conditional Formatting to Develop Your Excel Skills by Applying Colour Scales, Data Bars, Icons and More!
Join my community of over 6,700 students learning my courses!
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.
By the end of this course you will be able to:
Other benefits from taking this course:
Click the “Take this course" button at top right corner. Without the knowledge of conditional formatting you are missing awesome opportunities.
Lore delivers value at the intersection of learning, interests and skills.
Access learning options recommended by industry experts, professionals and thought leaders.
Quickly search, select and add learning options to your learning list.
Tell us more about yourself to access the latest learning options, curated just for you.