Hello and welcome to this simple and easy to understand course on how to use conditional formatting in Excel.
In this course, we shall delve into how to present data in a spreadsheet. I have created some easy to follow lessons with some example datasets that show you how to understand "Conditional formatting" this is a function in Excel that allows you to add rules to cells or datasets which can format the cells if the data is in those cells or datasets meets specific criteria. You could use conditional formatting to improve the spreadsheets you currently produce and make them much easier to read.
This course is ideal for anybody who needs a way to present your data in a quick and easy to read way, for example, business people, teachers, caterers, ice cream shop owners, and students. Throughout this course, I assume you have absolutely no knowledge of Excel or even spreadsheets in general, so I take you right from the start and describe each step in terms you will understand.
The sorts of places you can implement conditional formatting are:
· Sales tables
· Keeping track of tasks
· Keeping track of finances
· Monitoring students grades
· Guestlists
· and much more...
I hope you enjoy :)