Skillshare – All That You Need To Know About Conditional Formatting In Microsoft Excel-SkilledHares
English | Size: 865.06 MB
Category: Tutorial
All that You Need to Know about Conditional Formatting in Microsoft Excel
Conditional Formatting, in Microsoft Excel, enables you to highlight cells, or range of cells based on certain conditions, to visually explore and analyze data.
The conditional formatting works by changing the appearance of the cells based on the conditions that you specify: only when the conditions are met, then, the cell or cell range is formatted; else, the cells remain as such without formatting. You may use the built-in formatting options in Excel, or create your own conditions. You can apply conditional formatting to a single cell, range of cells (including a named range), Excel Table and Pivot Table
In this course, you will learn about the basics of conditional formatting, the various for conditional formatting options, using Quick Analysis Tool for conditional formatting, building your own conditional formatting rules, and managing the rules. You will be exposed to several real-life situations wherein you can use conditional formatting to visually explore data, to find patterns & trends, and to detect critical issues.
Course Content:
Introduction
Pre-built Conditional Formatting Options
Identify Specific Text, Number or Date (Static)
Identify Specific Text and Number (Dynamic)
Identify Duplicate Values
Format the Duplicate Records
Format Top or Bottom Ranked Values
Format using Above Average / Below Average Values
Format Cells using Data Bars
Format using 2-Color Scale
Format using 3-Color Scale
Format using Icon Sets (Directional Arrows)
Format using Icon Sets (Shapes)
Format using Icon Sets (Ratings)
Apply Conditional Formatting using Quick Analysis
Conditionally Format Pivot Table Reports
Find Cells that have Conditional Formatting
Clear Conditional Formatting
Class Project
Wrapping up
There is a class project, with a number of exercises, that you can complete to reinforce the learning you have had from the various lessons.
Author: Narayanan Veeriah
Duration: 1h 16m
Exer/Code:
Installation:
Unpack that shit, run that shit
RAPIDGATOR
rapidgator.net/file/4fa65bfd1de83a516fdffd12604d5773/Skillshare.All.That.You.Need.To.Know.About.Conditional.Formatting.In.Microsoft.Excel-SkilledHares.part1.rar.html
rapidgator.net/file/e655d1b7bcc8601c3de24e60e33e0fb4/Skillshare.All.That.You.Need.To.Know.About.Conditional.Formatting.In.Microsoft.Excel-SkilledHares.part2.rar.html
NITROFLARE
nitroflare.com/view/1E5473A087005FB/Skillshare.All.That.You.Need.To.Know.About.Conditional.Formatting.In.Microsoft.Excel-SkilledHares.part1.rar
nitroflare.com/view/859CF2ACF529A46/Skillshare.All.That.You.Need.To.Know.About.Conditional.Formatting.In.Microsoft.Excel-SkilledHares.part2.rar