Day :3 Data analytics

✨️✨️Learning Excel Step by Step
Hello everyone!
I am learning Data Analytics at Payilagam Institute.
Today is my 3rd day, and I learned many useful things in Microsoft Excel.

Here is what I learned today:

✅ Sorting – I learned how to arrange data from A to Z or Z to A.
✅ Multiple Sorting – I learned how to sort using two or more columns.
✅ Filtering – I learned how to show only the data I want to see.
✅ Total Sales – I found out how to add all sales together.
✅ Average Sales – I learned how to find the average of sales.
✅ Sales in Every Region – I checked how much sales happened in each region.
✅ Sales Person Sales – I found out how much each person sold.
✅ Blank Count Formula – I used a formula to count empty cells.
✅ Total Value Formula – I used a formula to get the full value of sales.
✅ Unit Price – I learned how to find the price for one item.
✅ Conditional Formatting – I added colors to cells based on value (example: red for low sales).
✅ Insert Function – I used Excel’s tool to add formulas easily.
✅ $ Symbol – I learned where and why we use the $ symbol in formulas.
✅ Change $ to ₹ – I changed the currency from dollars to rupees.
✅ Types of Charts – I saw different charts like bar chart, pie chart, and line chart to show data.