This Author published in this journals
All Journal Dharma Bakti
Dwi Setyowati
Jurusan Sistem Komputer, Fakultas Sains Terapan, IST AKPRIND Yogyakarta

Published : 2 Documents Claim Missing Document
Claim Missing Document
Check
Articles

Found 2 Documents
Search

PELATIHAN PENGOLAHAN DATA ADMINISTRASI KEUANGAN MENGGUNAKAN MICROSOFT EXCEL 2013 Dwi Setyowati; Harmastuti -
DHARMA BAKTI Dharma Bakti Vol 1 No 1 April 2018
Publisher : LPPM IST AKPRIND Yogyakarta

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.34151/dharma.v1i1.291

Abstract

Financial Administration in bookkeeping will make it easier to manage and grow the company. This is due to the large amount of financial data and limited human memory or cannot be maximized. Currently making bookkeeping with the help of MS Excel is quite popular because there are various important tools that serve to complete the financial record. For those working in finance, the most commonly used Excel formulas such as SUMIF, SUMIFS, SUBTOTAL, VLOOKUP, INDEX, and MATCH. Community service activities in the form of training MS Excel 2013, in making financial statements using a combination of Formula IF, OR and SUM Formulas, SUMIF function is used to perform the sum of data with certain criteria and connecting data between sheets. The results achieved by the students of National SMK Nasional Berbah Sleman in this training is able to use and recognize the functions of excel 2013 in processing financial administration data.
PEMANFAATAN MICROSOFT EXCEL UNTUK PEMBELAJARAN MATEMATIKA DAN GRAFIK Harmastuti -; Dwi Setyowati
DHARMA BAKTI Dharma Bakti Vol 1 No 1 April 2018
Publisher : LPPM IST AKPRIND Yogyakarta

Show Abstract | Download Original | Original Source | Check in Google Scholar | DOI: 10.34151/dharma.v1i1.294

Abstract

Mathematics is a study studying the operation of numbers, functions, graphs, space and in the learning can be delivered manually and visually can be used computer. To answer that Microsoft excel is an alternative software part of Microsoft Office can be used to help solve problems related to mathematical modeling, real-time and graphical visual operations of a mathematical function or group of data. In this community service activity was introduced the use of Microsoft excel to complete mathematical operations or mathematical modeling and graphical visuals according to the given module. Results from community service activities students are enthusiastic in practicing the operation of numbers, also create graphical visuals using Microsoft Excel.