Financial Accounting & Excel–Comprehensive Accounting Course
4.2 (250 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
12,685 students enrolled

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.2 (250 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
12,685 students enrolled
Last updated 6/2019
English
English [Auto]
Current price: $69.99 Original price: $99.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 21.5 hours on-demand video
  • 1 downloadable resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll 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
Requirements
  • We will use Excel. Having Excel will allow us to work through the problems along with the video. If we do not have Excel, we can still follow along with the comprehensive problem.
Description

If we are a business owner or accounting professional who would like to get a better understanding of what our accounting software is doing

Or

An accounting student or student in general that would like to get a better understanding of what our accounting textbook is doing

This course is a course for us.

Business owners, accounting professionals, and accounting students often have the same problem with accounting. . .

that we are focused on one small component of the accounting process and not able to make all the necessary connections to other components of the accounting process to fully benefit from an understanding of how the business runs.

Business owners focus on cash flow and revenue, accounting professionals focus on their component of the accounting department and enter data into the accounting software, and accounting students focus on the topic they are currently working on.

Accounting professional often focus on one component of the accounting cycle like accounts receivable, accounts payable, or payroll often not having much time to consider the relationship with other areas of the accounting cycle.

Accounting software helps simplify the data entry process, but the simplification also restricts us from seeing how the data is being processed into the end product, into financial statements and reports.

Students are focused on one component of the accounting cycle at a time following an accounting textbook that is putting the pieces of the accounting puzzle together one step at a time.

As students zoom their focus into the current topic, they often lose sight of it fits into the larger objective and this loss of sight causes students to question the relevance of what they are losing. Student’s questioning the relevance of what they are learning causes students to lose interest. A loss of student interest causes students grades to fall.

Part of the reason accounting textbooks have a difficult time incorporating the current topic into the big picture is that a textbook is restricted by what can fit on a page and the problems a textbook provides are restricted by what a student can accomplish with paper and pencil.

The use of instructional video providing a step by step process along with Excel that allows students to sum up large columns of numbers in a short time provides the tools to create a comprehensive problem that will demonstrate current topics in the context of the entire accounting process.

Why Take This Course?

We will learn the accounting cycle in a comprehensive way and learn the fundamental of Excel.

Learning the accounting process without Excel or Excel without accounting is a waste of time and not an efficient way to learn either topic.

Like assets being equivalent to liabilities and equity, accounting is equivalent to Excel in many ways and therefore learning Excel will accelerate our learning of accounting and make what we learn more applicable.

Accounting is also the perfect tool to learn Excel. This course will not provide a broad overview of everything Excel can do because that is not a way to learn. Courses attempting to demonstrate all the functions Excel fail to create value for learners because learners will not retain what they learn without a foundation of core concepts and a reason for learning each new function.

This course will cover the fundamentals of Excel, those components used 99% of the time, and the components needed as a foundation for learning more about Excel.

The core components of Excel we will learn include adding, subtracting, and summing up columns of numbers.

We will learn the core concept of Excel through demonstration, repetition, and application to practical problems.

What Will Be Included in This Course?

We will complete a comprehensive problem using both instructional video and application.

Although the course offers much more than just instructional video, it does include over 20 hours of instructional video.

We also include an Excel worksheet with just about every presentation allowing us to both see the completed answer and work through the problems step by step along with the video.

Each Excel workbook includes at least two tabs. One tab will have the answer so that we can see how the completed worksheet is constructed and the second tab will provide us the opportunity to enter the data along with the instructional video.

Who Will We Be Learning From?

We will be learning from somebody who has practical accounting experience as a practicing CPA, teaching experience, curriculum design experience.

Credentials include:

We are learning from someone who has both instruction and curriculum development experience needed to construct comprehensive courses of a technical nature in a way that meets students’ needs and expectations.

 What Will We Learn?

We will learn how to complete the components of the accounting cycle and the fundamental of Excel including addition, subtraction, and the sum function.

Below is a short list of what is included in the accounting cycle and what we will cover in the course:

  • Journalizing journal entries
  • Posting to the general ledger
  • Create a trial balance
  • Adjusting entries
  • Bank reconciliations
  • Financial statement generation
  • Closing entries
  • Reversing entries

How Will We Be Taught?

We will learn through viewing and then doing.

We will demonstrate each component of the problem in small digestible parts using both a completed Excel worksheet and instructional video.

We will provide an Excel worksheet that can be filled in along with the instructional video or after watching the instructional video.

Please join us in learning Accounting, Excel, debits, and credits.

It will be Great 

Course Content Includes:

  • Start a New Business Section of Accounting & Excel Course
  • 05 Set up New Company Worksheet
  • 10 Set Up Inventory Items
  • 15 Set Up Customer Balances
  • 20 Set Up Vendors Beginning Balances
  • 25 Enter Opening Account Balances
  • Accounting Concepts Section of Accounting & Excel Course
  • 135 Cash Method vs Accrual Method
  • 132 Balance Sheet & Income Statement Relationship
  • 155 Financial Transaction Rules
  • 160 Financial Transaction Thought Process
  • Enter Data for First Month Section of Accounting & Excel Course
  • 05 Owner Deposit & Loan Deposit
  • 10 Purchase Furniture & Record Investment
  • 20 Part 1 Invoice Transaction
  • 20 Part Two Create on Invoice Transaction
  • 25 Receive Payment Part 1
  • 25 Receive Payment Part 2
  • 25 Receive Payment Part 3
  • 30 Cash Sales Transaction Part 1
  • 30 Cash Sales Part 2
  • 35 Deposit Part 1
  • 35 Deposit Part 2
  • 40 Part 1 Inventory Payment
  • 40 Part 2 Inventory Payment
  • 45 Invoice for Preordered Item Part 1.
  • 45 Invoice for Pre-ordered Item Part 2
  • 50 Receive Payment & Make Deposit
  • 55 Part 1 Write Check
  • 55 Part 2 Write Check Part 2
  • 60 Pay Bills
  • 65 Customer Jobs
  • 70 Payroll
  • 75 Job Sales Receipt
  • 80 Financial Statements & Reports
  • 90 Closing Process January
  • 92 Worksheet Month Two
  • Enter Data for Second Month Section of Accounting & Excel Course
  • 05 Make Loan Payments
  • 10 Short Term Investment
  • 20 Receive Inventory With Bill
  • 20 Receive Inventory With Bill Part 2
  • 25 Sales Receipt & Deposit
  • 25 Part 2 Sales Receipt & Deposit
  • 30 Advanced Payment From Customer
  • 35 Apply Credit to Invoice
  • 40 Record Sales on Account
  • 45 Advance Customer Payment
  • 50 Bills Track & Pay
  • 55 Customer Payment on Account
  • 60 Pay Sales Tax
  • 65 Pay Payroll Tax
  • 70 Enter Bills & Pay Bills
  • 75 Service Item & Invoices
  • 77 Purchase Equipment with Debt
  • 80 Payroll
  • 90 Rental Income
  • 95 Financial Statements
  • Bank Reconciliations Section of Accounting & Excel Course
  • 10 Bank Reconciliation January
  • 12 Bank Reconciliation Adjusting Entries January
  • 15 Bank Reconciliation February
  • 20 Bank Reconciliation Feb. Adjusting Entries
  • Adjusting Entries & Financial Statement Section of Accounting & Excel Course
  • 10 Loan Payable Adjusting Entry Part 1
  • 15 Loan Payable Adjusting Entry Part 2
  • 20 Accrued Interest Adjusting Entry
  • 25 Invoice Adjusting Entry
  • 40 Prepaid Insurance Adjusting Journal Entry
  • 45 Depreciation Adjusting Entry
  • 50 Unearned Revenue Adjusting Entry
  • 60 Financial Statements
  • 65 Closing Process February
  • 300 Accrued Interest Reversing Entry
  • 350 Accounts Receivable Reversing Entry
  • 550 Unearned Revenue Reversing Entry


Who this course is for:
  • Business Owners
  • Accounting Professionals
  • Accounting Students
  • Students taking accounting courses
Course content
Expand all 145 lectures 21:30:35
+ Starting a New Business
11 lectures 01:43:21
Excel Download - 6.10 Set Up Inventory Items
00:14
6.10 Set Up Inventory Items
34:28
Excel Download - 6.15 Set Up Customer Balances
00:14
6.15 Set Up Customer Balances
13:52
Excel Download - 6.20 Set Up Vendors Beginning Balances
00:14
6.20 Set Up Vendors Beginning Balances
12:44
Excel Download - 6.25 Enter Opening Account Balances
00:14
6.25 Enter Opening Account Balances
24:16
+ Accounting Concepts
5 lectures 01:01:12
135 Cash Method vs Accrual Method
16:19
132 Balance Sheet & Income Statement Relationship
23:47
155 Financial Transaction Rules
07:48
160 Financial Transaction Thought Process
11:52
+ Enter Data For the First Month of Operations
52 lectures 07:37:57
Excel Download - 7.05 Owner Deposit & Loan Deposit
00:14
Excel Download - 7.10 Purchase Furniture & Record Investment
00:14
7.10 Purchase Furniture & Record Investment
19:59
Excel Download - 7.20 Part 1 Invoice Transaction
00:14
7.20 Part 1 Invoice Transaction
30:00
Excel Download - 7.20 Part Two Create on Invoice Transaction
00:14
7.20 Part Two Create on Invoice Transaction
24:12
Excel Download - 7.25 Receive Payment Part 1
00:14
7.25 Receive Payment Part 1
11:49
Excel Download - 7.25 Receive Payment Part 2
00:14
7.25 Receive Payment Part 2
10:12
Excel Download - 7.25 Receive Payment Part 3
00:14
7.25 Receive Payment Part 3
08:53
Excel Download - 7.30 Cash Sales Transaction Part 1
00:14
7.30 Cash Sales Transaction Part 1
23:45
Excel Download - 7.30 Cash Sales Part 2
00:14
7.30 Cash Sales Part 2
11:56
Excel Download - 7.35 Deposit Part 1
00:14
7.35 Deposit Part 1
10:35
Excel Download - 7.35 Deposit Part 2
00:14
7.35 Deposit Part 2
12:53
Excel Download - 7.40 Part 1 Inventory Payment
00:14
7.40 Part 1 Inventory Payment
17:31
Excel Download - 7.40 Part 2 Inventory Payment
00:14
7.40 Part 2 Inventory Payment
14:57
Excel Download - 7.45 Invoice for Preordered Item Part 1.ENCODING
00:14
7.45 Invoice for Preordered Item Part 1.ENCODING
25:24
Excel Download - 7.45 Invoice for Preordered Item Part 2
00:14
7.45 Invoice for Preordered Item Part 2
23:02
Excel Download - 7.50 Receive Payment & Make Deposit
00:14
7.50 Receive Payment & Make Deposit
19:59
Excel Download - 7.55 Part 1 Write Check
00:14
7.55 Part 1 Write Check
16:39
Excel Download - 7.55 Part 2 Write Check Part 2
00:14
7.55 Part 2 Write Check Part 2
15:48
Excel Download - 7.60 Pay Bills
00:14
7.60 Pay Bills
11:00
Excel Download - 7.65 Customer Jobs
00:14
7.65 Customer Jobs
05:19
Excel Download - 7.70 Payroll
00:14
7.70 Payroll
33:28
Excel Download - 7.75 Job Sales Receipt
00:14
7.75 Job Sales Receipt
09:39
Excel Download - 7.80 Financial Statements & Reports
00:14
7.80 Financial Statements & Reports
40:44
Excel Download - 7.90 Closing Process January
00:14
7.90 Closing Process January
27:04
Excel Download - 7.92 Worksheet Month Two
00:14
7.92 Worksheet Month Two
06:33
Accounting Comic Break
00:14
+ Enter Data For the Second Month of Operations
41 lectures 06:15:24
Excel Download - 8.05 Make Loan Payments
00:14
Excel Download - 8.10 Short Term Investment
00:14
8.10 Short Term Investment
11:42
Excel Download - 8.20 Receive Inventory With Bill
00:14
8.20 Receive Inventory With Bill
15:39
Excel Download - 8.20 Receive Inventory With Bill Part 2
00:14
8.20 Receive Inventory With Bill Part 2
15:41
Excel Download - 8.25 Sales Receipt & Deposit
00:14
8.25 Sales Receipt & Deposit
18:16
Excel Download - 8.25 Part 2 Sales Receipt & Deposit
00:14
8.25 Part 2 Sales Receipt & Deposit
06:53
Excel Download - 8.30 Advanced Payment From Customer
00:14
8.30 Advanced Payment From Customer
12:03
Excel Download - 8.35 Apply Credit to Invoice
00:14
8.35 Apply Credit to Invoice
21:39
Excel Download - 8.40 Record Sales on Account
00:14
8.40 Record Sales on Account
32:33
Excel Download - 8.45 Advance Customer Payment
00:14
8.45 Advance Customer Payment
13:36
Excel Download - 8.50 Bills Track & Pay
00:14
8.50 Bills Track & Pay
11:07
Excel Download - 8.55 Customer Payment on Account
00:14
8.55 Customer Payment on Account
19:14
Excel Download - 8.60 Pay Sales Tax
00:14
8.60 Pay Sales Tax
10:16
Excel Download -8.65 Pay Payroll Tax
00:14
8.65 Pay Payroll Tax
10:21
Excel Download - 8.70 Enter Bills & Pay Bills
00:14
8.70 Enter Bills & Pay Bills
31:43
Excel Download - 8.75 Service Item & Invoices
00:14
8.75 Service Item & Invoices
46:46
Excel Download - 8.77 Purchase Equipment with Debt
00:14
8.77 Purchase Equipment with Debt
10:36
Excel Download - 8.80 Payroll
00:14
8.80 Payroll
35:31
Excel Download - 8.90 Rental Income
00:14
8.90 Rental Income
08:16
Excel Download - 8.95 Financial Statements
00:14
8.95 Financial Statements
06:40
+ Bank Reconciliation
9 lectures 01:19:08
Excel Download - 9.10 Bank Reconciliation January
00:14
Excel Download - 9.12 Bank Reconciliation Adjusting Entries January
00:14
9.12 Bank Reconciliation Adjusting Entries January
17:48
Excel Download - 9.15 Bank Reconciliation February
00:14
9.15 Bank Reconciliation February
21:01
Excel Download - 9.20 Bank Reconciliation Feb. Adjusting Entries
00:14
9.20 Bank Reconciliation Feb. Adjusting Entries
14:16
+ Adjusting Entries, Financial Statements, Closing Entries, and Reversing Entries
25 lectures 03:21:59
Excel download - 10.10 Loan Payable Adjusting Entry Part 1
00:14
Excel Download - 10.15 Loan Payable Adjusting Entry Part 2
00:14
10.15 Loan Payable Adjusting Entry Part 2
14:33
Excel Download - 10.20 Accrued Interest Adjusting Entry
00:14
10.20 Accrued Interest Adjusting Entry
09:25
Excel Download - 10.25 Invoice Adjusting Entry
00:14
10.25 Invoice Adjusting Entry
13:57
Excel Download - 10.40 Prepaid Insurance Adjusting Journal Entry
00:14
10.40 Prepaid Insurance Adjusting Journal Entry
08:39
Excel Download - 10.45 Depreciation Adjusting Entry
00:14
10.45 Depreciation Adjusting Entry
10:53
Excel Download - 10.50 Unearned Revenue Adjusting Entry
00:14
10.50 Unearned Revenue Adjusting Entry
10:43
Excel Download - 10.60 Financial Statements
00:14
10.60 Financial Statements
45:31
Excel Download - 10.65 Closing Process February
00:14
10.65 Closing Process February
28:13
Excel Download - 10.300 Accrued Interest Reversing Entry
00:14
10.300 Accrued Interest Reversing Entry
10:20
Excel Download - 10.350 Accounts Receivable Reversing Entry
00:14
10.350 Accounts Receivable Reversing Entry
13:21
Excel Download - 10.550 Unearned Revenue Reversing Entry
00:14
10.550 Unearned Revenue Reversing Entry
09:21