DAY 5 #15DAYSHTTDataChallenge.
- PIVOT TABLE
INSIGHTS
1. Total Sales by Product Line
- Insight: Identify your top-performing product lines.
2. Order Quantity by City
3. Order Quantity by Gender
4. Order Quantity by Unit and Branch
#hertechtrailacademy
Day 4 of 15-day Data Challenge @hertechtrail
Conditional formatting
Conditional formatting was applied to column J in the dataset below
It instantly highlights top-performing sales, making it easier to spot trends. Managers can quickly identify which products, are performing best
Day 3 – #15DaysHTTDataChallenge
Our focus today is on Basic Excel Formulas using the Supermarket Sales dataset.
I practiced how to:
1. Calculate Total Sales using the =SUM() function.
2. Find the Average Order Value with the =AVERAGE() function.
#hertechtrailacademy
Day 1/15: My Journey into Data Analytics
I never imagined I would one day be exploring the world of data analytics—yet here I am, taking bold steps into a field that is reshaping the way decisions are made. Follow me on this on trend let’s grow together.
#HerTechTrail
10K Followers 17 FollowingHelping African Women Globally build sustainable and Profitable Careers with Tech & Digital Skills through #techeducation & community. #inclusion Non-Profit!