Data Entry Project
Invoice
No
INV101
INV102
INV103
INV104
INV105
INV106
Customer
Name
Sima Sarkar
Mukti Rani
Choiti
Sarkar
Ayesa
Siddika
Ussa Begum
INV108
Bristy Das
Sompa
Khatun
Azrin
Khatun
INV109
Rifa Khatun
INV110
Utopol Day
Sumi
Khatun
INV107
INV111
Product
Number
1
4
Product
Name
Product_A
Product_D
Quantity
2
Total
Price
$20.00
$50.00
Due
$0.00
$45.00
Pyment
Status
Paid
Due
Product
Name
1.Product_A
2.Product_B
Unit
Price
$10.00
$30.00
5
Product_E
3
$210.00
$210.00
Due
3.Product_C
$20.00
2
3
Product_B
Product_C
No Product
Buy
2
$30.00
$40.00
$30.00
$40.00
Due
Due
4.Product_D $50.00
5.Product_E $70.00
4
0
$0.00
Not Buying
Paid
$20.00
$5.00
2
Product_B
2
$60.00
$60.00
Due
1
Product_A
No Product
Buy
No Product
Buy
No Product
Buy
2
$20.00
$20.00
Due
2
0
$0.00
Not Buying
2
0
$0.00
Not Buying
2
0
$0.00
Not Buying
Total Sell
430
Total
Paid
25
Total
Due
405
Hello,
I am presenting a project to you, which I have developed using Microsoft Excel formulas. Before
I explain the project, let me briefly introduce myself.
I am skilled in using Excel for various tasks, especially by applying formulas. In addition, I am
proficient in Microsoft Word, Microsoft Access, and Microsoft PowerPoint. I also have
knowledge of programming languages such as C, HTML, and Python, as well as the ability to
solve a variety of mathematical problems.
�About the Project:
In this project:
I have listed product names in column K and their prices in column L.
When the price of a product is changed, all related calculations are updated
automatically.
If a product is selected in column C, its name appears automatically in column D.
When a quantity is entered, the total price is calculated automatically.
Once the amount is paid, the status shows "Paid", and if any amount is remaining, it
shows "Due".
Finally, the total of all calculations is displayed.
If you need more details, feel free to contact me. I can also share the Excel file with you.
However, I expect the work to be handled with 100% honesty. If you have a task for me, feel
free to send me the file. If you have any ideas or suggestions, you can share them as well, and I’ll
be happy to implement them.
Money isn’t my top priority—doing quality work is what matters most. If you’re interested in
working with me, I hope to offer you the best possible service.