DATABASE CREATION THROUGH IF, VLOOKUPM SUM AND SUMIF FUNCTIONS OF MICROSOFT EXCEL
Journal Title: PRIZREN SOCIAL SCIENCE JOURNAL - Year 2018, Vol 2, Issue 2
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 because a beginner enterpreneur doesn’t have to pay lots of money to create a database, but this worksheet will help them create one without being an expert in Microsoft Excel. In conclusion, we can say it is very important to be innovative in the activities we conduct, because the enterprenur spirit will not let their work be affected by someone else, including a software of advanced technology.
Authors and Affiliations
Juysuf Qarkaxhija
Keywords
Related Articles
- EP ID EP373064
- DOI -
- Views 130
- Downloads 0
Public Policy on Safety and Security Railroad System in Indonesia
Implementation of the new law on railways are yet to be seen due to government regulation as executors being discussed. Government regulations mandated by Law No. 23, 2007 set as fast as 1 (one) year from the entry into...
Characters in Fatos Kongoli Novel
The greater philosopher,Aristotle,dealing with the characters would have said that “due to the fact that they imitate, they imitate acting people, and these people will, of course, be good or evil because characters almo...
WHOSE IDENTITY? RETHINKING ISLAM IN CONTEMPORARY SOUTHEAST EUROPE
The socio-political heredity of the long-term presence of Islam in Southeast Europe deserves to be questioned in the light of today’s climate of suspicion and heightened tensions toward autochthonous Muslims within the r...
Internalization of Value System in Mineral Materials Management Policies Instead of Metal And Rocks in Merauke District
Public policy public comes from the existing problems in the community, so that policy objectives realized. Value systems as part of people's lives need to get places in the policy process, among others related to enviro...
Analysis on Government’s Organizational Culture at the Kisaran Barat Sub-District Office, Asahan Regency, North Sumatera Province, Indonesia
The objective of the study was to find out organizational culture in the Kisaran Barat Sub-district Office, Asahan Regency, North Sumatera. The study used a qualitative method, and the data were gathered by conducting in...