5 Conditional Formatting tips to make you a rock star at work 🤘
170.5 هزار بار بازدید -
2 سال پیش
-
Aah... Conditional Formatting. My most
Aah... Conditional Formatting. My most favourite feature of Excel. In this video, let me reveal 5 AMAZING tricks to make you a rock star at work.
The five tips are,
1) How to highlight top 3 items & Bottom 3 items
2) Highlight data where sales more than $150,000
3) Highlight top 3 sales persons with CF Formula rule
4) Using Data Bars to add in-cell visualization
5) Creating a stylish report with conditional formatting
Video timestamps ⏱👉
====================
0:00 - Introduction
0:25 - Highlighting top 3 sales values
1:35 - Highlighting bottom 3 sales values
2:48 - Formula based rule for highlighting sales above $150k
5:09 - Using an input cell to control the format rules
6:26 - Formula rule for highlighting top 3 sales values (RANK.AVG)
8:45 - Adding Databars to instantly visualize your data
9:36 - Making an eye-catching report with CF tricks
Sample file 📗👇
=============
Download the sample file from here - https://chandoo.org/wp/wp-content/upl...
More videos on CF 🟩🟫🟪🟦🟧🟨
==============================
Add color to your spreadsheets with these amazing CF tricks.
5 must have Conditional Formatting tricks - 5 *Must have* Excel Conditional Forma...
Color change when date changes - Change color when date changes ~ Powe...
Conditional formatting in Pivot Tables - Advanced Pivot Tables #10 - Condition...
Highlight overdue items with CF - Highlight overdue items using Conditi...
10 Formatting tricks only Excel PROs know - 10 Excel formatting tricks *ONLY* exp...
#ExcelTips #CF
~
Don't forget to be awesome 😎
The five tips are,
1) How to highlight top 3 items & Bottom 3 items
2) Highlight data where sales more than $150,000
3) Highlight top 3 sales persons with CF Formula rule
4) Using Data Bars to add in-cell visualization
5) Creating a stylish report with conditional formatting
Video timestamps ⏱👉
====================
0:00 - Introduction
0:25 - Highlighting top 3 sales values
1:35 - Highlighting bottom 3 sales values
2:48 - Formula based rule for highlighting sales above $150k
5:09 - Using an input cell to control the format rules
6:26 - Formula rule for highlighting top 3 sales values (RANK.AVG)
8:45 - Adding Databars to instantly visualize your data
9:36 - Making an eye-catching report with CF tricks
Sample file 📗👇
=============
Download the sample file from here - https://chandoo.org/wp/wp-content/upl...
More videos on CF 🟩🟫🟪🟦🟧🟨
==============================
Add color to your spreadsheets with these amazing CF tricks.
5 must have Conditional Formatting tricks - 5 *Must have* Excel Conditional Forma...
Color change when date changes - Change color when date changes ~ Powe...
Conditional formatting in Pivot Tables - Advanced Pivot Tables #10 - Condition...
Highlight overdue items with CF - Highlight overdue items using Conditi...
10 Formatting tricks only Excel PROs know - 10 Excel formatting tricks *ONLY* exp...
#ExcelTips #CF
~
Don't forget to be awesome 😎
2 سال پیش
در تاریخ 1401/01/04 منتشر شده
است.
170,587
بـار بازدید شده