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

Making Sense of Data
Google via Independent
Introduction to Spreadsheets and Models
University of Pennsylvania via Coursera
Comptabilité de gestion et pratique du tableur
Université Montpellier 2 via France Université Numerique
The Power of Data in Health and Social Care
University of Strathclyde via FutureLearn
Digital Media Analytics: Introduction
Purdue University via FutureLearn