Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
1 Hour(s) 45 Minute(s)
Language
English
Taught by
João Appleton Ribeiro
Rating
3 views
Course Overview
Learn all about Conditional Formatting. From Beginner Level to Formula/Function Based Advanced Exercises
This course is about automatically formatting your Data with Colors, Icons, Bars (and more) using the Conditional Formatting feature of Excel.
The student will learn Conditional Formatting from the very basics to formula use within the tool. Most of the topics on conditional formatting are covered: basic formatting (Equal, Greater than, Smaller than etc.), formatting with text, etc. We also cover Data Bars, Icon Sets and Color Scales. Finally a good portion of the course is dedicated to formula use within the conditional formatting.
Course Content
- 8 section(s)
- 22 lecture(s)
- Section 1 Introduction To The Course
- Section 2 Format Only Cells That Contain (Values Greater/Equal/Smaller/Between/Text)
- Section 3 Format Cells Based on their values (Data Bars, Color Scale, Icon Sets)
- Section 4 Top/Bottom Values
- Section 5 Above/Below Average & Unique/Duplicates
- Section 6 Conditional Formatting Using Formulas
- Section 7 Final Series of Exercises (includes Vlookups, Countifs, Match..)
- Section 8 SMASH IT - Dare Exercise (Removing Duplicates, Using LEN and Substitute)
What You’ll Learn
- Highlight Cells Greater/Smaller/Between a certain Value
- Data Bars, Color Scales, Icon Sets
- To Use Some functions to Format your data (includes AND, IF, SUM, SUMIF, COUNTIF, VLOOKUP, MATCH and more..)
- Highlight Top/Bottom Values & Above and below Average
- Formula base Formating
- Productivity
- Presenting Information
Skills covered in this course
Reviews
-
SSharon Fitzgerald
Excellent formatting course. Instructor demonstrated the use of data validation when formatting, as well as applying different variations of formulas for results. I will refer back to this course many times. Thank you
-
SSergio Barboza
Excelente curso, muy bien detallado desde cero a avanzado, lo recomiendo.
-
MMohd Haroon Khan
Very well explained, never though conditional formatting would be of so use. You made it look easy
-
AApurv Boobna
It was great with good exercises and pace. Only thing missing was explaining the use of these formulas.
