YoVDO

Conditional Formatting in Excel - Excel Training - Excel Tutorial for Beginners

Offered By: Great Learning via YouTube

Tags

Microsoft Excel Courses Data Analysis Courses Data Visualization Courses Google Sheets Courses

Course Description

Overview

Learn how to use conditional formatting in Excel to enhance data visualization and analysis. Explore various formatting options including color scales, data bars, and icon sets to highlight important information. Discover techniques for applying conditional formatting based on cell contents, custom formulas, and specific criteria. Practice implementing these powerful features to quickly identify trends, patterns, and outliers in your spreadsheets. Master the art of creating visually appealing and informative Excel documents that effectively communicate data insights.

Syllabus

Introduction.
Agenda.
Formatting.
Conditional Formatting.
Formatting in Excel.
Data Bars.
Color Scales.
Icon Sets.
Cells that contain.
More rule type.
Formula based.
Google Sheets.
Color Scales.
Top/Bottom values.
Unique and similar values.
Greater than.
Summary.


Taught by

Great Learning

Related Courses

Intro to Statistics
Stanford University via Udacity
Introduction to Data Science
University of Washington via Coursera
Passion Driven Statistics
Wesleyan University via Coursera
Information Visualization
Indiana University via Independent
DCO042 - Python For Informatics
University of Michigan via Independent