AI, Data Science & Cloud Certificates from Google, IBM & Meta
Power BI Fundamentals - Create visualizations and dashboards from scratch
Overview
Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
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