People Innovation Excellence


Learning Outcomes:

On successful completion of this course, students will be able to: Prepare all step in accounting cycle for service and merchandising company; Explain the methods in recording and measuring assets that consist of inventories, cash, receivables, plant assets, and investments based on International Financial Reporting Standards (IFRS); Explain the methods in recording and measuring liabilities and equity based on International Financial Reporting Standards (IFRS); Prepare statement of cash flows; Analyze companies’ financial statement; Prepare data analysis using Microsoft Excel and configuration setup, master data and transactions using MYOB.


  1. Getting Started with Microsoft Excel & Introducing Formulas and Functions;
  2. Working with Formulas and Functions;
  3. Creating Formulas that Lookup Values;
  4. Getting Started Making Charts;
  5. Working with Database Tables in Excel;
  6. Analyzing data with Pivot Tables;
  7. Opening Setup – New Data File, Chart of Account, Customer, Supplier and Link Account;
  8. Opening Balances – Inventory;
  9. Purchase Transactions;
  10. Sales Transactions;
  11. Banking, General Entries, and Inventories;
  12. Reporting;
  13. Case – Opening Setup, Purchase, Sales, Banking Transactions, and General Entries;
  14. Accounting in Action;
  15. The Recording Process;
  16. Adjusting the Accounts;
  17. Completing the Accounting Cycle;
  18. Accounting for Merchandising Operations;
  19. Inventories;
  20. Fraud, Internal Control, and Cash;
  21. Accounting for Receivables;
  22. Plant Assets, Natural resources, and Intangible Assets;
  23. Liabilities;
  24. Corporations: Organization, Share Transactions, Dividends, and Retained Earnings;
  25. Investments;
  26. Statement of Cash Flows;
  27. Financial Statement Analysis.

Published at : Updated

Periksa Browser Anda

Check Your Browser

Situs ini tidak lagi mendukung penggunaan browser dengan teknologi tertinggal.

Apabila Anda melihat pesan ini, berarti Anda masih menggunakan browser Internet Explorer seri 8 / 7 / 6 / ...

Sebagai informasi, browser yang anda gunakan ini tidaklah aman dan tidak dapat menampilkan teknologi CSS terakhir yang dapat membuat sebuah situs tampil lebih baik. Bahkan Microsoft sebagai pembuatnya, telah merekomendasikan agar menggunakan browser yang lebih modern.

Untuk tampilan yang lebih baik, gunakan salah satu browser berikut. Download dan Install, seluruhnya gratis untuk digunakan.

We're Moving Forward.

This Site Is No Longer Supporting Out-of Date Browser.

If you are viewing this message, it means that you are currently using Internet Explorer 8 / 7 / 6 / below to access this site. FYI, it is unsafe and unable to render the latest CSS improvements. Even Microsoft, its creator, wants you to install more modern browser.

Best viewed with one of these browser instead. It is totally free.

  1. Google Chrome
  2. Mozilla Firefox
  3. Opera
  4. Internet Explorer 9