Learn conditional formatting in Excel and present data in a quick and easy to read way.
Read more.Instructor
Hello! My name is Kathryn and I create online courses to help you to learn all about Excel and how it can make your life easier. I have worked with Excel for many years, and despite having IT qualifications, there is so much that I've learnt about this program through my everyday use at work. Since starting to use Excel, I now use it to make life easier both in work and at home. Follow my courses, which are aimed at complete beginners, to learn how spreadsheets can streamline your business
Access all courses in our library for only $9/month with All Access Pass
Get Started with All Access PassBuy Only This CourseAbout This Course
Who this course is for:
- Beginner Excel users
What you’ll learn:Â
- Conditional formatting in Excel
- Anybody who needs a way to present data in a quick and easy to read way
Requirements:Â
- No prior knowledge is required to take this course
Hello and welcome to this simple and easy to understand course on how to use Excel.
In this course, we shall delve into how to present data in a spreadsheet. I’ve created some easy-to-follow lessons that show you how to understand “Conditional Formatting” – this is a function in Excel that allows you to add rules which format cells if the data meets specific criteria.
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 will 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
- Guest lists
- and much more…
I hope you enjoy 🙂
Our Promise to You
By the end of this course, you will have learned conditional formatting in Excel.
Â
10 Day Money Back Guarantee. If you are unsatisfied for any reason, simply contact us and we’ll give you a full refund. No questions asked.
Â
Get started today!
Course Curriculum
| Section 1 - Lecture Videos | |||
| Introduction | 00:00:00 | ||
| What Is Conditional Formatting | 00:00:00 | ||
| Data Bars | 00:00:00 | ||
| Colour Scales | 00:00:00 | ||
| Icon Sets | 00:00:00 | ||
| Top – Bottom Rules | 00:00:00 | ||
| Highlight Cells Rules | 00:00:00 | ||
| More Rules | 00:00:00 | ||
Course Review
5.0
3 RatingsRelated Courses
Are you interested in higher education?
Conditional Formatting In Excel
Very simple and easy. Not too long or too short. Straight to the point. Thank You, Kathryn I enjoyed the short lesson.
Good Information
I never officially learned excel but I’ve always been an explorer with computers. It is refreshing to see the proper way to do things on excel. This was good.
Very useful tool
Excellent little course to show such an insightful little tool. Very quick to complete and incredibly useful.