HDTutorial
EN
How to use Conditional formatting in Excel - Data Bars for data analysis

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to use Conditional formatting in Excel - Data Bars for data analysis

6,502 views July 26, 2020 2:38

Watch on YouTube
ChannelEfficiency 365

Description from the creator

Understand conditional formatting in Excel to interpret data more easily. You will learn about customizing the appearance of Data Bars. Very useful tool for Visual data analysis.

Answer to Quiz
------------------------------------------------------------------------------------------------------------------------
Quiz: How to highlight minimum and maximum value in data using Excel
Answer: Use Conditional Formatting
Steps:
1. Select data
2. Home tab - Conditional Formatting - Highlight Cells - Top/Bottom Rules - Top 10 Items
3. Change value of 10 to 1 - choose any formatting
4. Repeat the process with Bottom 10 - choose different formatting

Dr Nitin Paranjape
Microsoft MVP
Most Valuable Professional
Read 1000+ articles on the blog by Dr Nitin Paranjape efficiency365.com

About this tutorial

Efficiency 365 published this 2:38 video tutorial on July 26, 2020. It has been watched 6,502 times on YouTube.

Duration
2:38
Published
July 26, 2020
Views
6,502
Likes
55

Tags

Share

Further reading

  • Use conditional formatting to highlight information - Excel support.microsoft.com

    Use conditional formatting to help you visually explore and analyze data, detect critical issues, and identify patterns and trends. Conditional formatting makes it easy to highlight interesting cells or ranges of cells,…

  • Excel Data Bars Conditional Formatting contextures.com

    On the Ribbon, click the Home tab, and then in the Styles group, click Conditional Formatting. In the list of conditional formatting options, click Data Bars, and then click one of the Data Bar options -- Gradient Fill…

  • Excel Data Analysis - Conditional Formatting - Tutorialspoint tutorialspoint.com

    The data will be highlighted based on the given conditions and the corresponding formatting. Data Bars. You can use colored Data Bars to see the value in a cell relative to the values in the other cells. The length of t…

This tutorial in other languages