Financial Accounting & Excel–Comprehensive Accounting Course

Comprehensive accounting course to learn the accounting cycle in a practical way and pick up critical Excel fundamentals
4.53 (805 reviews)
Udemy
platform
English
language
Accounting & Bookkeeping
category
Financial Accounting & Excel–Comprehensive Accounting Course
62 949
students
21.5 hours
content
Aug 2022
last update
$74.99
regular price

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:

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 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

Financial Accounting & Excel–Comprehensive Accounting Course – Screenshot 1
Screenshot 1Financial Accounting & Excel–Comprehensive Accounting Course
Financial Accounting & Excel–Comprehensive Accounting Course – Screenshot 2
Screenshot 2Financial Accounting & Excel–Comprehensive Accounting Course
Financial Accounting & Excel–Comprehensive Accounting Course – Screenshot 3
Screenshot 3Financial Accounting & Excel–Comprehensive Accounting Course
Financial Accounting & Excel–Comprehensive Accounting Course – Screenshot 4
Screenshot 4Financial Accounting & Excel–Comprehensive Accounting Course

Loading charts...

1458300
udemy ID
04/12/2017
course created date
01/11/2019
course indexed date
Bot
course submited by