MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 ChGenre: eLearning | Language: English + srt | Duration: 23 lectures (8h 15m) | Size: 4.9 GB
Learn how to build an accounting system using Excel and how to enter common transactions from a CPA
How to create an accounting system using Excel, starting from a blank worksheet
How to navigate and format Excel worksheets
How to create a general journal
How to create a general ledger
How to create a trial balance
How to create subsidiary ledgers
How to create financial statements, including a balance sheet and income statement
How to enter transactions related to the vendor cycle, including the impact on subsidiary ledgers and financial statements
How to enter transactions related to the customer cycle, including the impact on subsidiary ledgers and financial statements
How to enter transactions related to the employee cycle, including the impact on subsidiary ledgers and financial statements
None - if you do not have Excel you may use Google Sheets or some other spreadsheet program
In this course we will build an accounting system starting with a blank Excel worksheet, creating a general journal, a general ledger, a trial balance, subledgers, and financial statements.