Introduction to Computer & Accounting Application (4 Credits)
Learning Outcomes:
Classify a large volume of data across multiple worksheets or pages of information in the file; Analysis data with formulas and functions; Create comparison of data by using chart, conditional formatting and spark lines function; Demonstrate the skill to setup initial data configuration in accounting application; Demonstrate the skill to correctly enter purchase, sales, banking, inventory, general journal entries and reports into accounting application.
Topics:
- Getting Started with Excel
- Creating Formulas that Count and Sum
- Getting Started Making Charts
- Communicating Data Visually
- Opening Setup – New Data File, Chart of Account, Customer, Supplier, and Link Account
- Opening Balances – Inventory
- Purchase Transactions
- Sales Transactions
- Banking, General Entries, and Reporting
- Introducing Formulas and Functions.
Published at :
SOCIAL MEDIA
Let’s relentlessly connected and get caught up each other.
Looking for tweets ...