A Complete Guide to Conditional Formatting in Microsoft Excel

Instructor:  Jed Guinto
Course Dates: Open-ended
Enrollment Dates: Enroll Anytime
Who can Enroll: Anyone
Course Language: English
Price:  FREE

About the Course

DESCRIPTION
I LOVE Conditional Formatting! The reason I love it is because even though its super simple to use, it makes you look like an expert! Haha! In fact, one trick is to use a lot of conditional formatting at work so that when the boss comes over, it looks like you’re doing a lot of work! 

Besides the benefits I listed above, Conditional Formatting has a lot of practical uses. For example, colour coding data is very useful tool because you can see the values in your tables relative to one another via colour. Also, when communicating this data to others, you can say that the blue values are low and the red values are high. Lastly, it looks super cool!

TARGET AUDIENCE
Conditional formatting is useful for those who analyse data and try and find patterns contained within. Perfect for researchers, accountants and the like. 

STRUCTURE
As conditional formatting has many uses, I decided to do a complete course on the subject. Therefore, this course is broken into several chapters which I encourage you to take slowly. There more than 25 videos and a total time just under 50 minutes. 

DIFFICULTY
This is for users who are already comfortable with creating tables that contain numerical data. This is ideally suited for intermediate users. 

COURSE OUTCOMES

  • Data Bars
  • Numerical Controls and Limits
  • Text Filtering
  • Duplicate Highlighting
  • Icon Sets
  • Average Values
  • Shapes and Indicators
  • Ratings
  • Updating Existing Formatting

Course Structure

  • The Opening Act
    • The Promotion
      00:00:00
      • Don't forget to download the work file so you can follow along!
    • Demonstration
      00:00:00
    • Conditional Format Uses
      00:00:00
  • The Basics
    • Case Study Explained
      00:00:00
    • Quick Start
      00:00:00
    • Removing Conditional Formatting
      00:00:00
  • Data Bars and Multiple Applications
    • Data Bars
      00:00:00
    • Multiple Conditional Formatting
      00:00:00
  • Limiting Functions and Cell Rules
  • Tops, Bottoms and Averages
    • Top/Bottom Conditional Format
      00:00:00
    • Top/Bottom % Conditional Format
      00:00:00
    • Above and Below Average
      00:00:00
  • Shapes and Indicators
  • Bonus Tools
    • Updating and Conditional Formatting
      00:00:00
    • Filters and Conditional Formatting
      00:00:00
  • The Big Finish

Instructors

Jed Guinto
Jed Guinto
Jed Guinto is the Co-Founder of Paperclip Learning. Currently pursuing his Ph.D. in Aerospace Engineering, he is also an avid educator with experience teaching primary students, high school students and undergraduate Aerospace, Civil and Mechanical Engineers. Over 44,000 students from over 170 countries have signed up for his courses.

This entry was posted in . Bookmark the permalink.