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.70 (771 reviews)
Udemy
platform
English
language
Accounting & Bookkeeping
category
Financial Accounting & Excel–Comprehensive Accounting Course
62,781
students
21.5 hours
content
Aug 2022
last update
$84.99
regular price

What you will learn

Accounting Cycle

Debits & Credits

Excel Fundamentals - Add, Subtract, Sum Function

Journalize Journal Entries

Post Journal Entries to General Ledger

Create Trial Balance From General Ledger

Adjusting Entries

Bank Reconciliations

Financial Statement Generation

Closing Journal Entries

Reversing Journal Entries

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.

Screenshots

Financial Accounting & Excel–Comprehensive Accounting Course - Screenshot_01Financial Accounting & Excel–Comprehensive Accounting Course - Screenshot_02Financial Accounting & Excel–Comprehensive Accounting Course - Screenshot_03Financial Accounting & Excel–Comprehensive Accounting Course - Screenshot_04

Our review

--- **Overview of the Course:** The course has been highly rated with a global average of **4.70**. It is praised for breaking down complex accounting concepts into understandable formats, while also integrating practical Excel skills with the use of accounting software, such as QuickBooks. The course's approach to repetition seems to be both a strength and a point of contention among reviewers. While some found it helpful for reinforcing learning, others felt it was overly redundant. **Pros:** - **Comprehensive Content:** The course covers the fundamentals of accounting, including the accounting cycle, G/L, balance sheets, and trial balances, which are essential for anyone looking to understand how accounts tie together within financial statements. - **Hands-On Learning with Excel:** Reviewers appreciated the practical application of Excel in understanding accounting principles, making this course suitable for both beginners and those with prior accounting knowledge. - **Repetition for Clarity:** Some found the repetitive explanations, particularly on how to use Excel features like freezing panes, helpful for cementing concepts and skills. - **Clear and Professional Instruction:** The instructor's teaching style is described as thorough, articulate, and professional, with a methodology that aids in understanding the accounting process. - **Visual Aids:** Although some graphics were criticized, others found visual tools like side-by-side Excel images useful for maintaining focus on the big picture. **Cons:** - **Overemphasis on Repetition:** Some reviewers felt that the course focused too much on repetitive tasks such as copying formulas or freezing panes, which they found tedious and unnecessarily time-consuming. - **Lack of Advanced Accounting Topics:** A few reviewers pointed out that the course might miss more advanced accounting topics like FIFO and LIFO, bad debt accounting, depreciation methods, and accounting principles. - **One-Sided Excel Focus:** The course is criticized for teaching only one specific Excel sheet setup rather than focusing on the principles of accounting. - **Redundant Content:** Some found the course content to be too basic or redundant if they already had a grasp of accounting principles. **User Experience:** - **Refresher and Learning Tool:** The course is recommended as a refresher for those with some background in accounting, as well as for complete beginners looking to learn from the ground up. - **Enjoyable and Informative:** Many reviewers expressed enjoyment and found the content informative, particularly appreciating the finite detail in which topics were covered. - **Painful Repetition:** A notable number of reviews highlighted that the level of repetition was painful and unnecessary for learning the material. **Conclusion:** Overall, this course is highly regarded for its comprehensive coverage of accounting principles within the context of using Excel alongside QuickBooks. It seems to cater well to learners who either lack prior knowledge or wish to refresh their understanding. The course's emphasis on repetition appears to serve as a double-edged sword, helping some learners to solidify their skills while frustrating others with its redundancy. Prospective students should consider their current level of accounting knowledge and their preference for learning style when deciding whether this course is the right fit for their needs.

Charts

Price

Financial Accounting & Excel–Comprehensive Accounting Course - Price chart

Rating

Financial Accounting & Excel–Comprehensive Accounting Course - Ratings chart

Enrollment distribution

Financial Accounting & Excel–Comprehensive Accounting Course - Distribution chart
1458300
udemy ID
12/4/2017
course created date
11/1/2019
course indexed date
Bot
course submited by