|
Order
ID
|
Customer
Name
|
Product
|
Quantity
|
Unit
Price
|
Order
Date
|
|----------|---------------|-----------|----------|------------|------------|
|
1001
|
John
Doe
|
Laptop
|
2
|
1000
|
2023-05-10
|
1002
|
Jane
Smith
|
Smartphone|
5
|
500
|
2023-06-15
|
1003
|
David
Brown
|
Tablet
|
3
|
700
|
2023-07-20
|
1004
|
John
Doe
|
Laptop
|
2
|
100
|
2023-05-18
|
1005
|
Jane
Smith
|
Smartphone|
10
|
500
|
2023-06-17
|
1005
|
David
Brown
|
Tablet
|
13
|
710
|
2023-07-21
To perform the tasks outlined in Assignment using Excel, follow these step-by-step instructions:
Step 1: Create a Table to Store Sales Data
Step 2: Calculate Total Sales Revenue for Each Order
Step 3: Use INDEX and MATCH Functions to Find Customer Name for Order ID 1003
This formula searches for Order ID 1003 in column A and returns the corresponding Customer Name from column B.
Step 4: Create a PivotChart to Visualize Total Sales by Product Category
Step 5: Use Slicers in the PivotChart to Filter Data by Month and Product