Excel Accounting 1–Transactions for Common Data Input Forms

1. How to create an accounting system using Excel, starting from a blank worksheet
2. How to navigate and format Excel worksheets
3. How to create a general journal
4. How to create a general ledger
5. How to create a trial balance
6. How to create subsidiary ledgers
7. How to create financial statements, including a balance sheet and income statement
8. How to enter transactions related to the vendor cycle, including the impact on subsidiary ledgers and financial statements
9. How to enter transactions related to the customer cycle, including the impact on subsidiary ledgers and financial statements
10. How to enter transactions related to the employee cycle, including the impact on subsidiary ledgers and financial statements