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

Introduction to Computational Finance and Financial Econometrics
University of Washington via Coursera
Excel 2010
Miríadax
The Finance of Retirement & Pensions
Stanford Graduate School of Business via NovoEd
Einführung in die Wahrscheinlichkeitstheorie
Johannes Gutenberg University Mainz via iversity
Introduction to VBA/Excel Programming
Cal Poly Pomona via Open Education by Blackboard