Learn how to build an accounting system using Excel and how to enter common transactions from a CPA
Sub Category
- Accounting & Bookkeeping
{inAds}
Objectives
- 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
Pre Requisites
- None - if you do not have Excel you may use Google Sheets or some other spreadsheet program
FAQ
- Q. How long do I have access to the course materials?
- A. You can view and review the lecture materials indefinitely, like an on-demand channel.
- Q. Can I take my courses with me wherever I go?
- A. Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
{inAds}
Coupon Code(s)