Database creation through if, vlookup, sum and sumif functions of Microsoft Excel

  • Jusuf Qarkaxhija AAB College

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.

References

Rexhepi, A “Microsoft Access”, Printing Press, Prishtinë 2002

Shmalz M, “Integrating Excel and Access”, O’Reilly Media,Inc, Pennsylvania Usa, 2005

Qarkaxhija, J “Online database publication and management”, PAR International Leadership Conference Press, ISBN 978-953-57258-5-5

http://www.dbta.com/Editorial/Trends-and-Applications/Good-Performance-Management-Reduces-Costs-Minimizes-Risk-to-Database-57830.aspx

Reisner, T ”Microsoft Office Excel 2003”, Sams Publishing, Cacak 2004
Published
2018-07-08
How to Cite
QARKAXHIJA, Jusuf. Database creation through if, vlookup, sum and sumif functions of Microsoft Excel. PRIZREN SOCIAL SCIENCE JOURNAL, [S.l.], v. 2, n. 2, p. 27-34, july 2018. ISSN 2616-387X. Available at: <http://prizrenjournal.com/index.php/PSSJ/article/view/33>. Date accessed: 19 nov. 2018.