Financial Accounting & Excel–Comprehensive Accounting Course

Why take this course?
It seems like you're outlining a comprehensive curriculum for a course that covers the basics of accounting using Excel as a tool for recording and tracking financial transactions. The course appears to be structured for someone who is starting a new business and needs to set up their accounting system, understand accounting concepts, and learn how to enter data, manage transactions, prepare financial statements, perform bank reconciliations, and make adjusting entries.
Here's a breakdown of the course content you've listed:
-
Start a New Business Section:
- Set up a new company worksheet in Excel.
- Define inventory items and set up customer balances.
- Establish beginning balances for vendors and enter opening account balances.
-
Accounting Concepts Section:
- Understand the cash method versus the accrual method.
- Learn the relationship between the balance sheet, income statement, and cash flows.
- Grasp financial transaction rules and the thought process behind recording transactions.
-
Enter Data for First Month:
- Record owner deposits and loan deposits.
- Purchase furniture and record investment.
- Issue an invoice for a product or service, create a payment on that invoice, and record receipt of payment.
- Handle cash sales and process related deposits.
- Pay for inventory, issue an invoice for a pre-ordered item, and receive payment.
- Write checks for bills, handle customer jobs, process payroll, and create job sales receipts.
-
Enter Data for Second Month:
- Make loan payments, handle short-term investments, and record receiving inventory with a bill.
- Record sales receipts and deposits, advanced customer payments, apply credits to invoices, record sales on account, and process customer payments on account.
- Pay sales tax and payroll taxes, enter bills, pay bills, handle service item invoices, purchase equipment with debt, and record rental income.
-
Bank Reconciliations Section:
- Perform a bank reconciliation for the first month and its adjusting entries.
- Continue with bank reconciliations for subsequent months and their adjusting entries.
-
Adjusting Entries & Financial Statement Section:
- Make various adjusting entries such as loan payable, accrued interest, invoice adjustments, prepaid insurance, depreciation, unearned revenue, and more.
- Prepare financial statements for the relevant periods.
- Perform closing entries at the end of a month to prepare for the next accounting period.
- Reverse previous period's adjusting entries at the beginning of the new period.
This course would provide a solid foundation in both accounting principles and practical application using Excel. It would be ideal for someone looking to start their own business, or for accountants or bookkeepers who want to enhance their skills with spreadsheet software. The hands-on approach of using Excel throughout the course ensures that students can apply what they learn directly to real-world situations.
Course Gallery




Loading charts...