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.