Publication Search

Accountability in preparing financial reports is a crucial instrument for the sustainability of business entities, because inaccurate financial data management can hinder decision-making and harm business performance in the future. For MSME actors in the PKK Tanggamus community, strengthening financial reporting competence is an urgent need so they can map expenditure structures, record income, calculate profit, and evaluate business development periodically. This community service activity aims to improve participants’ financial discipline, particularly in separating personal assets, business capital, and gross profit, while introducing accessible office technology. The training focused on optimizing LibreOffice Calc as an alternative to Microsoft Excel with similar functions for creating transaction tables, cost recapitulations, and simple financial reports. The activity method included material presentation, software demonstrations, report preparation practice, and interactive discussions based on participants’ business needs. Training results showed high enthusiasm, improved understanding, and readiness to use LibreOffice Calc as a more organized, transparent, and sustainable financial recording tool. Thus, this activity provides practical contributions to building an accountable financial administration culture for community-based MSMEs.

This study aims to develop an educational application based on a Graphical User Interface (GUI) using MATLAB App Designer that functions as an interactive simulation for evaluating blood pressure. The application allows users to input systolic and diastolic blood pressure values along with supporting information such as name and age. The input data are then analyzed and classified into several blood pressure categories according to the standards of the American Heart Association (AHA), including normal, hypotension, stage 1 hypertension, stage 2 hypertension, and hypertensive crisis. The classification results are presented visually through an interactive pie chart with dynamic percentages and legends to enhance user understanding. In addition, all data are automatically stored in a Microsoft Excel file containing a summary of blood pressure categories and session timestamps. The system is designed with a simple interface and intuitive interaction, making it suitable for early health education purposes. Although the application still relies on manual data input, it has the potential to serve as an effective learning tool for increasing public awareness of the importance of regular blood pressure monitoring. 

This study addresses the inefficiencies in the manual student payment administration system currently used at SMK Bina Insan Nusantara, which relies on handwritten ledgers and Microsoft Excel spreadsheets, leading to frequent data errors, delayed reporting, and difficulties in retrieving payment records. The research aims to design a web-based information system to streamline the recording, monitoring, and reporting of student payments. A descriptive research approach was employed, with data collected through direct observation, semi-structured interviews with administrative staff, and literature review. System analysis was conducted using the PIECES framework, and system design followed the Unified Modeling Language (UML) methodology. The proposed system features user authentication, student data management, real-time payment input, digital receipt generation, and automated reporting (daily, monthly, and yearly). Black-box testing confirmed that the system functions as intended, validating inputs, processing transactions accurately, and generating reliable outputs. Findings indicate that the web-based system significantly improves data accuracy, operational efficiency, accessibility, and service quality compared to the existing manual process. The implementation of this system enables school administrators to manage payments more effectively, provides students and parents with timely access to payment information, and supports faster, data-driven decision-making by school leadership and the foundation. Future enhancements could include mobile integration and online payment gateways.

PT Intelix, a technology and information company with numerous collaborative projects, faces challenges in effective project management and monitoring. Despite utilizing project management applications like Jira, the generation of final reports often remains a manual process using Microsoft Excel, which is time-consuming and prone to errors. To address these issues, PT Intelix developed an internal Project Management application, yet it required further enhancements in its dashboard and reporting features for more detailed project monitoring optimization. This research aims to develop the Dashboard menu by adding a priority project table and several sub-menus in the Report menu to accelerate and simplify the preparation of final project reports. The development methodology employed is Agile Kanban, encompassing planning, system and interface design, incremental development and implementation, and testing. System functionality testing was conducted using Black Box Testing and User Acceptance Test (UAT) involving the project owner and end-users from PT Intelix. Test results showed all main functions running smoothly and stably, with all black box scenarios passing. UAT testing on six menus received a "very good" response from the project owner and users. The SUS evaluation of three users scored a 5 on the scale, with several scoring a 4, indicating a good system. Performance testing with 10 simultaneous users also demonstrated stable traffic and no errors.. The development of High Priority Project, Milestone Project, and Implementation Project features on the Dashboard successfully presented more detailed project information, while the addition of sub-menus in the Report accelerated report generation. Thus, this development successfully optimized integrated project monitoring and reporting at PT Intelix, reducing manual effort and enhancing data accuracy for decision-making.

The rapid development of technology has greatly assisted human work in various fields, including education. One tangible outcome of technological progress is the availability of Microsoft Office applications, which consist of Microsoft Word, Microsoft Excel, and Microsoft PowerPoint. Microsoft Word functions as a word processing software that allows users to create, edit, and format documents, while Microsoft Excel is used for managing numbers and data, and PowerPoint plays an important role in preparing engaging presentations. However, the teachers at SD Masehi Kadu Eta are not yet able to operate Microsoft Word, Excel, and PowerPoint optimally, as the school has never conducted any specific training. Therefore, this community service program focused on providing training on how to utilize Microsoft Office for teachers at SD Masehi Kadu Eta. The training aimed to improve teachers’ knowledge and skills in using information technology, particularly in operating Microsoft Word, Excel, and PowerPoint. Through this program, teachers gained not only new experiences but also basic skills that can support their daily tasks, such as preparing school administration documents, creating reports, and developing more systematic teaching materials. The results of the program showed that the training provided significant benefits. Teachers demonstrated strong enthusiasm, actively participated in every session, and showed improvement in their understanding of Microsoft Office applications. They also expressed their expectations for similar activities to be carried out regularly so that their skills could continue to improve and better equip them to face the ongoing development of information and communication technology in the future.

This community service program was designed to enhance the inventory management skills of santri at Pesantren Assyifa through the use of spreadsheet technology. Many pesantren-based business units still rely on manual inventory methods, leading to inefficiencies, stock errors, and operational delays. To address this issue, a structured training program was conducted involving 25 selected santri actively engaged in the pesantren’s economic units. The program consisted of three interactive sessions covering basic inventory concepts, spreadsheet functions, and hands-on design of inventory tracking systems. Using tools like Microsoft Excel and Google Sheets, participants were guided to create real-time stock records, calculate inventory movement, and generate reports. The success of the training was measured through pre- and post-tests, spreadsheet project submissions, and participant feedback surveys. The results showed a 68% average increase in test scores, a 96% project completion rate, and a 4.6/5 satisfaction score. Additionally, 84% of participants applied the system directly within pesantren business units. Feedback from participants indicated high engagement, practical usefulness, and a strong desire for follow-up training. This initiative demonstrated the effectiveness of integrating digital tools into pesantren education, contributing to the development of digitally literate and economically empowered santri.

Microsoft Excel is a software that is very important in processing data, both in the world of education, business and daily needs. However, even though many people often use it, quite a few have difficulty operating some of the important features provided by Excel. Some problems that often arise include difficulties in using complex formulas, lack of understanding of basic and advanced functions, and complicated data format settings. This ignorance results in decreased user productivity, inaccurate data produced, and the time required to complete tasks becomes longer.

This journal discusses the changes in editing in Microsoft Excel, the software that exists in the world. Since the launch of the ribbon interface in Excel 2007, access to editing tools has become more intuitive. The real-time collaboration feature introduced in Excel Online and Excel 2016 allows users to edit documents simultaneously, increasing work efficiency. The integration of AI technology, such as the "Ideas" feature, helps data analysis with automatic suggestions. The addition of new functions and more flexible formatting options strengthens data analysis capabilities. These changes demonstrate Microsoft's commitment to improving the user experience and relevance of Excel in modern business.

This research discusses the application of cash receipts and cash payments from cash sales and cash purchases at CV Banua Prima Teknik. This research aims to determine the accounting system for cash receipts and cash disbursements at CV Banua Prima Teknik, as well as to create a web-based cash receipt and disbursement application at CV Banua Prima Teknik. The theoretical framework of this research involves information system analysis, by examining the information needed by management, related functions, documents used, and document flowcharts. MySql is used as a database, with the PHP programming language. The research results show that the recording at CV Banua Prima Teknik has been computerized but still uses Microsoft Excel. The weakness of this method is that it is difficult to find out the recapitulation report of cash receipts and disbursements based on a certain period. Therefore, the application developed in this research is expected to help produce cash receipt and disbursement reports more effectively and efficiently, thereby improving performance in company financial management.

This study aims to identify problems in the process of submitting and accounting for project budget funds at PT. Leon Testing and Consultancy Banjarbaru, and to design an application program that can simplify the process. This study uses the theoretical framework of the Accounting Information System for Submission and Accountability of Budget Funds, which includes analysis of management information, related functions, procedure networks, documents, accounting records, internal control systems, and existing flowcharts. Applicable accounting standards are used in this study, with MySQL as the backend and PHP as the frontend. The results of the study indicate that the process of submitting and accounting for funds at PT. Leon Testing and Consultancy Banjarbaru is still semi-manual, using Microsoft Excel. Therefore, it is recommended that the company adopt an online-based application to improve the efficiency and effectiveness of the process

 Microsoft Excel is a versatile tool for data analysis that can be used in various contexts, including health. This study focuses on the use of Excel to manage and analyze health data. The process begins with the creation of Excel tables that include health data such as weight, height, blood pressure, and blood sugar levels. Next, we apply various Excel formulas and functions to interpret this data. Examples include the use of the SUM function to sum data, the AVERAGE function to calculate averages, and the IF function to create conditional statements to determine a person's health status based on certain parameters. The results show that Microsoft Excel is a powerful and effective tool for managing health data and provides valuable insights for health analysis. This research provides a strong foundation for the use of Excel in the health context and highlights the importance of a thorough understanding of Excel formulas and functions for accurate and informative data analysis.    

The aim of this research is to find out whether the accounting information system for cash receipts and disbursements is running effectively and efficiently. Meanwhile, the benefit of this research is as material for consideration and input in improving cash receipt and disbursement procedures at PT. Pelindo Daya Sejahtera, and to produce a Web-Based Cash Receipts and Disbursements Application Program. In this research the author used primary data and secondary data such as interview results, observations and documentation.The theoretical framework is to analyze the Cash Receipts and Disbursements Accounting Information System, namely by analyzing the information needed by management, related functions, procedural networks, documents and accounting records used, as well as document flowcharts.From this research it was found that all cash recording at PT Pelindo Daya Sejahtera is still semi-manual, namely using Microsoft Excel. The author suggests that PT Pelindo Daya Sejahtera use the Web-Based Cash Receipts and Disbursements Application Program to help record cash receipts and disbursements data, as well as make it easier to create reports effectively and efficiently.      

Currently, internally funded research and community service activities are still carried out at a semi-computerized level, so the data is not yet well integrated. The process of submitting proposals and reporting research activities and community service still uses Google Form, while assessments are carried out using Microsoft Excel. In this process, several obstacles have been identified, one of which is the potential impact of changes to submission data which could affect other data. Therefore, a fully computerized information system will be created, aimed at making it easier for P3M units to manage the internal grant application, assessment and reporting process through an online-based website. The results of this research, the internal grant application system for processing internal grant data has been integrated with the results of black box testing, obtaining a percentage of 100% which is in accordance with the goals and functions of the system. Apart from that, user response testing or User Acceptance Testing (UAT) has been carried out with an average percentage result of 90.83% stating that the system helps in improving the smoothness of the internal grant application process