16 Jan 2025
These were sales between $500 and $700 which I retained and filled with yellow as shown in my Excel sheet below
#conditionalformatting #DataHighlighting #HTTDataChallenge #hertechtrailacademy
@HerTechTrail
@phaibooboo @it_is_reel @preciey_oma @Ogbonna42449096 @som_nnamani
1
1
30
16 Jan 2025
Highlighting cells with highest sales value within a dataset. Using Conditional Formatting rule in Excel having defined my highest sales value to be any sales value higher than the average sales value #hertechtrailacademy #HTTDataChallenge #ConditionalFormatting #DataHighlighting
1
3
69
22 Aug 2024
Just finished Day 4 of the #HTTDataChallenge
Used conditional formatting in Excel to highlight high values and it made spotting trends so much easier
#hertechtrailacademy #HTTDataChallenge,
#ConditionalFormatting #DataHighlighting
1
2
23
12 Sep 2023
Jour 4 - Formatage Conditionnel
Le challenge consiste ร appliquer un style particulier pour mettre en รฉvidence les transactions avec les plus grandes ventes. Pour les identifier , nous avons utilisรฉ le #3รจme #quartile
#20dayswithdata #ConditionalFormatting #DataHighlighting
1
2
8
174
Day 5: Creating a Bar Chart depicting the product-wise sales distribution ๐ฅ
@hertechtrail @phaibooboo @ImaNjokko @fresh_gb @vicSomadina @AtiJoshua @OMOTOSHOOLAMI15
#20dayswithdata #hertechtrailacademy #HTTDataChallenge #ConditionalFormatting #DataHighlighting
1
5
31
8 Sep 2023
DAY 4.
I highlighted cells which had a sales value, greater than the average sales value.
I considered them to have a high sales value.
#20dayswithdata #ConditionalFormatting #DataHighlighting.
3
6
49
6,668
7 Sep 2023
Day4 of #20dayswithdata challenge
I used Excel conditional formatting to get the products with high sales, the top 10 most expensive products and the top 10 cheapest products. #ConditionalFormatting #DataHighlighting #HTTDataChallenge @phaibooboo , @fresh_gb @hertechtrail
1
4
122
7 Sep 2023
Day 4
#20dayswithdata #conditionalformatting
#Datahighlighting
I grouped my high sales as sales made greater than 500.
1
3
52
DAY 4 - CONDITIONAL FORMATTING
#20dayswithdata #hertechtrailacademy #HTTDatachallenge #ConditionalFormatting #DataAnalysis #DataHighlighting
After determining that the average sales value was โฆ323 and the highest sale value reached โฆ1042.65,
1
1
4
336
Day 4!!!
I applied conditional formatting to the totals column,highlighting the values i considered greater than the Average order value as high sales values .
#20dayswithdata #hertechtrailacademy #HTTDataChallenge #Conditionalformatting #DataHighlighting
7 Sep 2023
Day 4.
Today, we apply conditional formatting. Its not as difficult as you imagined it to be.
Lets goooooo!!!
You can use the hashtags #20dayswithdata #ConditionalFormatting #DataHighlighting.
1
241
7 Sep 2023
Day 4
#20dayswithdata
In this dataset, the average sales value is $322.97 and the highest sales value is $1042.65, therefore I would consider a high sales value to be starting from anything above average.
@hertechtrail
#ConditionalFormatting
#DataHighlighting
4
68
7 Sep 2023
is a good starting point for identifying high sales values in a dataset with an average sales value of $322.97.
#20dayswithdata @hertechtrail #hertechtrailacademy #HTTDataChallenge #ConditionalFormatting #DataHighlighting
@phaibooboo @ImaNjokko @fresh_gb @vicSomadina @AtiJoshua
1
39
7 Sep 2023
#Day 4
Conditional Formatting
This method helps to make the data easy to understand and also for simplicity.
#20dayswithdata #HertechtrailAcademy #HTTDataChallenge #ConditionalFormatting #DataHighlighting
2
4
201
7 Sep 2023
DAY 4
#20dayswithdata
I applied Conditional Formatting on a Supermarket Sales Datatset to highlight cells with high Sales Values.
I think a high Sales value is one above the average sales Value
#Conditionalformatting
#DataHighlighting
#HertechtrailAcademy
@hertechtrail
1
1
4
204
7 Sep 2023
Day 4.
Today, we apply conditional formatting. Its not as difficult as you imagined it to be.
Lets goooooo!!!
You can use the hashtags #20dayswithdata #ConditionalFormatting #DataHighlighting.
4
8
37
8,385