Scribd
Upload
35 views1 page

Excel Task

Uploaded by

akjha.fbd07
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
35 views1 page

Excel Task

Uploaded by

akjha.fbd07
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

Your sample sales dataset has been created!

📊
You can download it here:

👉 Download sample_sales_data.csv

💼 Task for You (Practice Task)

Use the file to complete this task:

🔧 Task: Clean and Analyze the Sales Data

1. Clean the data:

o Remove duplicate entries

o Handle missing values (you decide how to fix them)

o Standardize formats (dates, prices)

2. Add formulas:

o Profit = Revenue - Cost

o Month-over-Month (MoM) sales change

o Average order value = Total Revenue / Total Quantity

3. Use Pivot Tables to show:

o Total sales per platform per month

o Best-selling products by revenue

o Category-wise profits

4. Create a Dashboard:

o Bar chart: Monthly revenue

o Pie chart: Platform-wise sales distribution

o Top 5 products by revenue

If you'd like, I can:

 Review your Excel once done ✅

 Help with Excel formulas 💡

 Show you how to record a Loom-style video for submission 🎥

Want help with any specific step?

You might also like