Database Creation Through If, Vlookup, Sum and Sumif Functions of Microsoft Excel

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. Mic...

Full description

Bibliographic Details
Published in:	Prizren Social Science Journal
Main Author:	Jusuf Qarkaxhija
Format:	Article
Language:	English
Published:	Association of Scientists and Intellectuals of Kosovo 2018-07-01
Subjects:	software, Microsoft Excel, database, warehouse
Online Access:	https://prizrenjournal.com/index.php/PSSJ/article/view/33

Similar Items

ChatGPT, Python, and Microsoft Excel
by: Kaique Sbampato, et al.
Published: (2025-01-01)

Pelatihan Pembelajaran Statistika dan Peluang dengan Microsoft Excel untuk Peningkatan Kompetensi Guru Matematika SMA
by: Ferry Kondo Lembang, et al.
Published: (2021-06-01)

Threshold detection by fitting segmented regression models in Microsoft Excel
by: Amy J Hopper, et al.
Published: (2025-12-01)

Using macros in microsoft excel to facilitate cleaning of research data
by: Justin Bauzon, et al.
Published: (2021-09-01)

PREPARATION OF MICRO, SMALL, MEDIUM ENTERPRISES FINANCIAL STATEMENTS FOR THAI COMMUNITY USING THE MICROSOFT EXCEL APPLICATION
by: Santy Setiawan, et al.
Published: (2022-12-01)

Математичні методи моделювання у футболі з використанням електронних таблиць Microsoft Excel
by: Artem Fedetskyi
Published: (2016-07-01)

THE STUDENTS’ MATHEMATICAL ABSTRACTION ABILITY THROUGH REALISTIC MATHEMATICS EDUCATION WITH VBA-MICROSOFT EXCEL
by: Nelly Fitriani, et al.
Published: (2018-09-01)

EFEKTIVITAS BUKU AJAR METODE NUMERIK BERBANTUAN MICROSOFT EXCEL PADA MAHASISWA PENDIDIKAN MATEMATIKA
by: Lisa Aditya Dwiwansyah Musa, et al.
Published: (2023-03-01)

Використання електронних таблиць Microsoft Excel в управлінні процесом фізичного виховання студентів Луцького національного технічного університету
by: Олександр Куцай
Published: (2016-11-01)

PERSEPSI SISWA TERHADAP PENGGUNAAN INSTRUMEN THREE-TIER MULTIPLE CHOICE BERBANTUAN MICROSOFT OFFICE EXCEL
by: Ahmad Ali Irfan Ardiansyah, et al.
Published: (2016-07-01)

TECHNOLOGY OF DYNAMIC DATABASES CREATION WITH THE ENCLOSED STRUCTURES IN MS EXCEL
by: L.V. Kravtsova, et al.
Published: (2012-10-01)

Pemanfaatan Microsoft Excel untuk Aplikasi Data Pelanggan pada Pada Usaha Jasa Pembersihan Dan Perawatan Sepatu, Tas, Dan Topi
by: Fajar Astuti Hermawati, et al.
Published: (2021-08-01)

Information and Data Processing Training (INFOLAHTA) with Microsoft Excel for Soldiers and Civil Servants KOREM 052/Wijayakrama Kodam Jaya
by: Jansen Wiratama, et al.
Published: (2023-09-01)

Evaluation of the Microsoft Excel Solver Spreadsheet-Based Program for Nonlinear Expressions of Adsorption Isotherm Models onto Magnetic Nanosorbent
by: Kowit Suwannahong, et al.
Published: (2021-08-01)

THE EFFECT OF CHEMICAL ADDITION FACTORS ON EXTERNAL WATER PURIFICATION WITH MICROSOFT EXCEL APPLICATION
by: Bonar Harahap, et al.
Published: (2023-01-01)

Setting the Initial Value for Single Exponential Smoothing and the Value of the Smoothing Constant for Forecasting Using Solver in Microsoft Excel
by: Wannaporn Junthopas, et al.
Published: (2023-03-01)

PKM Kelompok Guru di SDN 01 Setu Pagi, Kelurahan Setu, Kecamatan Cipayung Jakarta Timur
by: Selli Mariko, et al.
Published: (2019-09-01)

Making health inequality analysis accessible: WHO tools and resources using Microsoft Excel
by: Katherine Kirkby, et al.
Published: (2024-10-01)

USING THE SOFTWARE MICROSOFT OFFICE EXCEL FOR FINANCIAL MODELING DECISION
by: Bălăc escu Aniela
Published: (2009-05-01)

Analisis Ketertarikan Pengguna Microsoft Excel Online untuk Pengolahan Data Silsilah Keluarga Menggunakan TAM dan TPB
by: Fathur Rachman Nufaily, et al.
Published: (2025-09-01)

Research on display system for agricultural science and technology support data based on Microsoft data warehouse
by: Wang Liyun, et al.
Published: (2020-01-01)

TableMaker: An Excel Macro for Publication-Quality Tables
by: Marek Hlavac
Published: (2016-04-01)

Uso do Excel na Matemática: Uma Proposta de Planilha Para Resolução de Problemas de Sistema de Equações Lineares com 3 incógnitas
by: Eduardo Félix Pita Duarte
Published: (2024-06-01)

eeFit: a Microsoft Excel-embedded program for interactive analysis and fitting of experimental dose–response data
by: Michel Vivaudou
Published: (2019-04-01)

A Useful Excel-Based Program for Kinetic Model Discrimination
by: Lidia Pino, et al.
Published: (2018-11-01)

Microsoft Excel Program Training at the Dumai Petroleum Vocational School, Riau Province
by: Fitrianti Fitrianti*, et al.
Published: (2023-08-01)

Sosialisasi Sistem Deteksi Tumbuh Kembang Anak Berbasis Excel di Desa Pesantren
by: Khoirun Niamah, et al.
Published: (2025-05-01)

STRATEGIC CONSIDERATIONS FOR DATABASE SYSTEMS: POSTGRESQL VS. MICROSOFT SQL SERVER
by: R. О. Popov, et al.
Published: (2025-09-01)

Examination Committee Work Management System
by: Abdul Suleiman, et al.
Published: (2007-07-01)

Chlorophyll and carotenoid quantification: An MS Excel-based calculator
by: Muhammad Sajid Aqeel Ahmad, et al.
Published: (2025-03-01)

Pengembangan Sistem Otomatisasi Pengelolaan Data Excel Berbasis Microsoft Power Apps
by: Satriya Adhi Pradana, et al.
Published: (2025-10-01)

Peningkatan Literasi Digital Melalui Pelatihan Micosoft Excel Dasar untuk Himpunan Pengajar PAUD (HIMPAUDI) Kapanewon Ngemplak
by: Novi Prisma Yunita, et al.
Published: (2024-08-01)

Pemanfaatan Microsoft Sway dan Microsoft Form Sebagai Media Pembelajaran Interaktif Pendidikan Agama Islam
by: Ari Priyono, et al.
Published: (2022-12-01)

Open data and databases in analysis of traffic accidents in Belgrade
by: Gladović Pavle V., et al.
Published: (2018-01-01)

QXLA: Adding Upper Quantiles for the Studentized Range to Excel for Multiple Comparison Procedures
by: K. Thomas Klasson
Published: (2018-06-01)

Pemanfaatan Microsoft Mathematics 4.0 dalam Pengembangan Pembelajaran Matematika di SMA/SMK
by: Risma Nurul Auliya, et al.
Published: (2020-03-01)

Analytical Solution of the Time-Dependent Microfluidic Poiseuille Flow in Rectangular Channel Cross-Sections and its Numerical Implementation in Microsoft Excel
by: Patrick Risch, et al.
Published: (2019-05-01)

APPLICATION OF MICROSOFT POWERPOINT PROGRAMS IN HUMANITARIAN TECHNOLOGIES BY EDUCATIONAL ORGANIZATIONS
by: A. G. Masalov
Published: (2022-08-01)

El Word de Microsoft su importancia y mejor utilización
by: Francisco Ficarra
Published: (2015-01-01)

Quick Review of Microsoft Academic
by: Meredith Ayers
Published: (2021-01-01)