×
Suggest this Article to:
TOP INDEXERS
Public Article
-
verified
Database creation through if, vlookup, sum and sumif functions of Microsoft Excel
ISSN: 2616 - 387X
Publisher: author
Database creation through if, vlookup, sum and sumif functions of Microsoft Excel
Indexed in
Business and Management
ARTICLE-FACTOR
1.3
Article Basics Score: 3
Article Transparency Score: 3
Article Operation Score: 2
Article Articles Score: 3
Article Accessibility Score: 3
SUBMIT PAPER ASK QUESTION
International Category Code (ICC):
ICC-0502
Publisher: Prizren Social Science Journal Luan Vardari
International Journal Address (IAA):
IAA.ZONE/26163830387X
eISSN
:
2616 - 387X
VALID
ISSN Validator
Abstract
Using databases is a fundamental matter for every business and non-business related activities. Their creation is more important than their usage, because creating a software through which we could track stock status in a enterprise’s warehouse is a huge burden for a newly founded enterprise. Microsoft Excel, a part of Microsoft Office packet, is a suitable program as it contains the needed tools and fuctions to create a database. We are going to practically show you how to create a database using Excel functions such as if, sum, sumif and vlookup and also using other tools such as condictional formatting and freeze panes. First of, you create a table with the warehouse articles; then you create an invoice for sale articles, and lastly the made sales will substract the article in the warehouse. The result of this worksheet gives us a practical software which calculates what the warehouse has left after the sales. This is important b...
