Assignment -6 | Order Management and Sales Analysis in Excel

Excepted timing : 5 minutes

| Employee ID | Employee Name  | Department | Salary | Hire Date  |
|-------------|----------------|------------|--------|------------|
| 4           | Emily Johnson  | HR         | 55000  | 2017-11-20 |
| 5           | Michael Lee    | Sales      | 65000  | 2019-08-05 |
| 6           | Sarah Wang     | Finance    | 72000  | 2018-02-15 |
| 7           | Daniel Kim     | Sales      | 63000  | 2020-01-03 |
| 8           | Jessica Liu    | HR         | 58000  | 2016-09-10 |
| 9           | Ethan Chen     | Finance    | 68000  | 2017-06-25 |
| 10          | Sophia Brown   | Sales      | 70000  | 2019-04-12 |
 
 
Task :
  1. Create a table to store sales data with columns for Order ID, Customer Name, Product, Quantity, Unit Price, and Order Date.
  2. Calculate the total sales revenue for each order (Quantity * Unit Price).
  3. Use INDEX and MATCH functions together to find the Customer Name for Order ID 1003.
  4. Create a PivotChart to visualize total sales by product category.
  5. Use slicers in the PivotChart to filter data by month and product.

To perform the tasks outlined in Assignment  using Excel, follow these step-by-step instructions: