People Innovation Excellence

ACCOUNTING APPLICATION LABORATORY (2 Credits)

Learning Outcomes:

On successful completion of this course, student will be able to; Classify a large volume of data across multiple worksheets or pages of information in the file; Analyze data with formulas and functions; Create comparison of data by using chart, database function and pivot tables function; Demonstrate the skill to setup initial data configurations in accounting application; Demonstrate the skill to correctly enter purchase, sales , bank, inventory, and general journal entries into accounting application.

Topics:

  1. Getting Started With Excel;
  2. Introducing Formulas and Functions;
  3. Working with Formulas and Functions;
  4. Creating Formulas that Lookup Values;
  5. Getting Started making Charts;
  6. Working with database tables in Excel;
  7. Analyzing data with Pivot Tables;
  8. Opening Setup – New Data File, Chart of Account,Customer,Supplier and Link Account;
  9. Opening Balances – Inventory;
  10. Purchase Transactions;
  11. Sales Transactions;
  12. Banking , General Entries,and Inventories;
  13. Case – Opening Setup, Purchase, Sales, Banking Transactions, and General Entries.

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
Close