Using MS Excel, create a customer database with at least 10 entries, with screenshots.

Using MS Excel, create a customer database with at least 10 entries, with screenshots.

Following the instruction I created a customer database, which is important information about customers such as names, addresses, and phone numbers:

This database consists of 5 columns including of Customer ID, First Name, Last Name, Phone Number, and Address of the customer.

Additionally, we also created a table for our products which will be sold in the e-commerce website:

And this table can give information about products with 10 columns:

1 - Product ID

2 - Product Name

3 - Unit Price

4 - Stock Quantity 

5 - Stock Sold

6 - Sale Price

7 - Total Cost

8 - Total Sale

9 - Profit

To calculate the profit, total sales, and total cost, I used the formulas given below:

Total Cost = =SUM([@[Unit Price]]*[@[Stock Quantity]])

Total Sale = =[@[Unit Price]]*[@[Sale Price]]

Profit = =[@[Total Sale ]]-[@[Total Cost ]]

Moreover, I analyze my data with pie charts and line graphs to make it clear and easy to understand: