Publication Search

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