Course Description
This course includes understanding the role of Excel in computer accounting, understanding functions in Microsoft Excel for accounting processes, creating macros with the Excel program, designing worksheets in the form of account codes, general and special journals, purchase lists, sales lists, payroll lists, accounts payable and receivable reports , trial balance ledgers, adjusting journals, work papers, financial reports, and modify them, and perform simple accounting cycle processes automatically and generate financial reports for micro, small and medium scale service, trade and manufacturing companies.
Program Objectives (PO)
- Menguasai konsep teoritis software dan aplikasi program Microsoft Excel secara mendalam dan merumuskannya dalam penyelesaian siklus akuntansi perusahaan jasa, perdagangan dan manufaktur secara prosedural
- Mampu memanfaatkan ilmu pengetahuan dan teknologi untuk mengotomatisasi proses siklus akuntansi perusahaan jasa, perdagangan dan manufaktur melalui program perangkat lunak Microsoft Excel