Udemy

Platform

English

Language

Accounting & Bookkeeping

Category

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.54 (337 reviews)

27060

Students

21.5 hours

Content

Mar 2021

Last Update
$99.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


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



Screenshots

Financial Accounting & Excel–Comprehensive Accounting Course
Financial Accounting & Excel–Comprehensive Accounting Course
Financial Accounting & Excel–Comprehensive Accounting Course
Financial Accounting & Excel–Comprehensive Accounting Course

Content

Introduction

Introduction

Course Outline

Starting a New Business

Start a New Business Section of Accounting & Excel Course

Excel Worksheet - 6.05 Set Up New Company Worksheet

6.05 Set up New Company Worksheet

Excel Download - 6.10 Set Up Inventory Items

6.10 Set Up Inventory Items

Excel Download - 6.15 Set Up Customer Balances

6.15 Set Up Customer Balances

Excel Download - 6.20 Set Up Vendors Beginning Balances

6.20 Set Up Vendors Beginning Balances

Excel Download - 6.25 Enter Opening Account Balances

6.25 Enter Opening Account Balances

Accounting Concepts

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 the First Month of Operations

Enter Data for First Month Section of Accounting & Excel Course

Excel Download - 7.05 Owner Deposit & Loan Deposit

7.05 Owner Deposit & Loan Deposit

Excel Download - 7.10 Purchase Furniture & Record Investment

7.10 Purchase Furniture & Record Investment

Excel Download - 7.20 Part 1 Invoice Transaction

7.20 Part 1 Invoice Transaction

Excel Download - 7.20 Part Two Create on Invoice Transaction

7.20 Part Two Create on Invoice Transaction

Excel Download - 7.25 Receive Payment Part 1

7.25 Receive Payment Part 1

Excel Download - 7.25 Receive Payment Part 2

7.25 Receive Payment Part 2

Excel Download - 7.25 Receive Payment Part 3

7.25 Receive Payment Part 3

Excel Download - 7.30 Cash Sales Transaction Part 1

7.30 Cash Sales Transaction Part 1

Excel Download - 7.30 Cash Sales Part 2

7.30 Cash Sales Part 2

Excel Download - 7.35 Deposit Part 1

7.35 Deposit Part 1

Excel Download - 7.35 Deposit Part 2

7.35 Deposit Part 2

Excel Download - 7.40 Part 1 Inventory Payment

7.40 Part 1 Inventory Payment

Excel Download - 7.40 Part 2 Inventory Payment

7.40 Part 2 Inventory Payment

Excel Download - 7.45 Invoice for Preordered Item Part 1.ENCODING

7.45 Invoice for Preordered Item Part 1.ENCODING

Excel Download - 7.45 Invoice for Preordered Item Part 2

7.45 Invoice for Preordered Item Part 2

Excel Download - 7.50 Receive Payment & Make Deposit

7.50 Receive Payment & Make Deposit

Excel Download - 7.55 Part 1 Write Check

7.55 Part 1 Write Check

Excel Download - 7.55 Part 2 Write Check Part 2

7.55 Part 2 Write Check Part 2

Excel Download - 7.60 Pay Bills

7.60 Pay Bills

Excel Download - 7.65 Customer Jobs

7.65 Customer Jobs

Excel Download - 7.70 Payroll

7.70 Payroll

Excel Download - 7.75 Job Sales Receipt

7.75 Job Sales Receipt

Excel Download - 7.80 Financial Statements & Reports

7.80 Financial Statements & Reports

Excel Download - 7.90 Closing Process January

7.90 Closing Process January

Excel Download - 7.92 Worksheet Month Two

7.92 Worksheet Month Two

Accounting Comic Break

Enter Data For the Second Month of Operations

Enter Data for Second Month Section of Accounting & Excel Course

Excel Download - 8.05 Make Loan Payments

8.05 Make Loan Payments

Excel Download - 8.10 Short Term Investment

8.10 Short Term Investment

Excel Download - 8.20 Receive Inventory With Bill

8.20 Receive Inventory With Bill

Excel Download - 8.20 Receive Inventory With Bill Part 2

8.20 Receive Inventory With Bill Part 2

Excel Download - 8.25 Sales Receipt & Deposit

8.25 Sales Receipt & Deposit

Excel Download - 8.25 Part 2 Sales Receipt & Deposit

8.25 Part 2 Sales Receipt & Deposit

Excel Download - 8.30 Advanced Payment From Customer

8.30 Advanced Payment From Customer

Excel Download - 8.35 Apply Credit to Invoice

8.35 Apply Credit to Invoice

Excel Download - 8.40 Record Sales on Account

8.40 Record Sales on Account

Excel Download - 8.45 Advance Customer Payment

8.45 Advance Customer Payment

Excel Download - 8.50 Bills Track & Pay

8.50 Bills Track & Pay

Excel Download - 8.55 Customer Payment on Account

8.55 Customer Payment on Account

Excel Download - 8.60 Pay Sales Tax

8.60 Pay Sales Tax

Excel Download -8.65 Pay Payroll Tax

8.65 Pay Payroll Tax

Excel Download - 8.70 Enter Bills & Pay Bills

8.70 Enter Bills & Pay Bills

Excel Download - 8.75 Service Item & Invoices

8.75 Service Item & Invoices

Excel Download - 8.77 Purchase Equipment with Debt

8.77 Purchase Equipment with Debt

Excel Download - 8.80 Payroll

8.80 Payroll

Excel Download - 8.90 Rental Income

8.90 Rental Income

Excel Download - 8.95 Financial Statements

8.95 Financial Statements

Bank Reconciliation

Bank Reconciliations Section of Accounting & Excel Course

Excel Download - 9.10 Bank Reconciliation January

9.10 Bank Reconciliation January

Excel Download - 9.12 Bank Reconciliation Adjusting Entries January

9.12 Bank Reconciliation Adjusting Entries January

Excel Download - 9.15 Bank Reconciliation February

9.15 Bank Reconciliation February

Excel Download - 9.20 Bank Reconciliation Feb. Adjusting Entries

9.20 Bank Reconciliation Feb. Adjusting Entries

Adjusting Entries, Financial Statements, Closing Entries, and Reversing Entries

Adjusting Entries & Fianncial Statement Section of Accounting & Excel Course

Excel download - 10.10 Loan Payable Adjusting Entry Part 1

10.10 Loan Payable Adjusting Entry Part 1

Excel Download - 10.15 Loan Payable Adjusting Entry Part 2

10.15 Loan Payable Adjusting Entry Part 2

Excel Download - 10.20 Accrued Interest Adjusting Entry

10.20 Accrued Interest Adjusting Entry

Excel Download - 10.25 Invoice Adjusting Entry

10.25 Invoice Adjusting Entry

Excel Download - 10.40 Prepaid Insurance Adjusting Journal Entry

10.40 Prepaid Insurance Adjusting Journal Entry

Excel Download - 10.45 Depreciation Adjusting Entry

10.45 Depreciation Adjusting Entry

Excel Download - 10.50 Unearned Revenue Adjusting Entry

10.50 Unearned Revenue Adjusting Entry

Excel Download - 10.60 Financial Statements

10.60 Financial Statements

Excel Download - 10.65 Closing Process February

10.65 Closing Process February

Excel Download - 10.300 Accrued Interest Reversing Entry

10.300 Accrued Interest Reversing Entry

Excel Download - 10.350 Accounts Receivable Reversing Entry

10.350 Accounts Receivable Reversing Entry

Excel Download - 10.550 Unearned Revenue Reversing Entry

10.550 Unearned Revenue Reversing Entry



Reviews

C
C.12 September 2020

I really enjoyed the way the trainer taught the course. He was very thorough, articulate and professional. He taught in a way that worked well for a detail-oriented person like myself. He also explained the effects of the transactions on the other accounts, financial reports, etc. It helped me to learn the 'flow', as I had no previous accounting experience. I enjoyed his style, so I just purchased his Quickbooks Online course also. Thank you!

S
Stephen13 July 2020

Would be very useful if shown exactly what QB is going to do with these transactions as opposed to being told what it would do. For example, it would have been useful to do a customer beginning balance entry in QB and then see journal entries and the financials.

B
Bismark18 May 2020

i have learnt a lot from this course. now i can create my own journals with the help of excel and can record almost all financial transactions with the help of excel.

M
Mathieu14 March 2020

it takes an eternity juste to make = check cell * another cell... come on, also you can copy paste this formula on each of your selling items so you dont have to dot it for each items...

S
Sage3 February 2020

Absolutely, love the course! It has been a refreshing one for the basic accounting concepts that are slowly forgotten earlier. If you can cutdown / modify the narration a little, I mean avoiding a few repeated statements like - view > window > freeze panes > freeze /unfreeze the panes; repeating the change of alignment using the home tab; repeating paste 123 .. it will be really helpful. After the first 2-3 lectures, repeating these statements don't make much sense. And you may also remove that 14 sec lecture videos that keeps repeating on how to download the resources will be helpful and save us a lot of time. Instead you may place those resource files in the respective lectures. Overall, I say it is an excellent course for learning / refreshing accountancy concepts with practical examples.

D
David16 January 2020

This was exactly the course I needed. This course is excellent for individuals who have studied in a classroom (as I have) and found the taught lessons moving to quickly to grasp various aspects of the subject area (as I did) . This course allowed me to move at my own speed, which in turn has helped in building my confidence in the subject area. My thanks.

M
Mohamed9 July 2019

Thank you for your explaining your experiences in accounting and financial statement in excel, i really liked your explanation about the quick book based on the balance sheet, which makes me to understand more about Company`s Asset, Liability and equity, and also I learnt how record Inventory items, Account payable, Account receivable and other Ledgers in basic Accounting, and this is really helping me a lot in my work experiences about as bank operations Officer to equipped and Understandable Financial Accounting skills in excel sheet, Thanks for detailed lessons.

R
Rhenado1 May 2019

The concepts of accounting are broken down in a easy understandable format, while clearly explaining what happen on the back-end of any accounting software with the aid of using excel.I would recommend this course to beginners and also those who already have an accounting background but still need to know how any accounting software operates.

J
Junseok31 July 2018

This guy repeats pane freeze and unfreeze every single time and SPENDS time explaining how to freeze and unfreeze pane, like 10,000 times throughout the course. I'm so sick of listening the same thing over and over again. The amount of time he spends doing this and explaining the freezing thing is absolutely redundant and huge waste of my time. This is not even funny.

L
Lesley26 July 2018

It was a good match because the course explains the fundamentals of accounting and how the g/l ties into the trial balance which comprise the balance sheets.

N
Nicola20 July 2018

The graphics are AWFUL. It's okay for what I paid, but for the regular price, I expect clearer and more sophisticated graphics. I find they distract from the learning experience. The Excel recordings are fine; it's the clip-art graphics that are bothersome.

K
Kareen18 June 2018

This course was a perfect refresher for me as someone in the accounting field that has not worked for over 3 years. Some new and vital excel tricks were learned and I will be using them in the near future. I think that it would be perfect for someone who does not know much about accounts and needs to learn, as the instructor made sure the process was timely and in order but most importantly repetitive, so that, if you did not understand the first time at some point in time of the course you will eventually grasp the concepts. Well done Mr. Steele my mission has been accomplished with you course material. Thank you.

R
Randell5 April 2018

The graphics at the beginning of each section is a bit off-putting. Though it looked like you had fun creating them, I wondered, "What was he thinking?" It was a visual as well as mental distraction. (I'm easily distracted that way, I suppose.) Any graphics or images should add to, not take away from, the presentation. I recommend losing them. Go simple. Also, the speech pattern during the introductions is a bit stiff and overly articulated - somewhat wince-able. (I'll get over it. :)) Now, on to the good stuff. The content is certainly directed for someone who has had some accounting or financial background - not for newbies, for sure. It was something I could follow and also be challenged at the same time. I enjoyed the exercises and wish there had been more of them, like a quiz inserted periodically. Can't complain though, I got my money's worth. The instruction was easy to follow and reinforces what I have surmised over the years as an operations manager who has had to account for the financial performance of my business. Great introduction. Good job.

K
Kenya12 January 2018

Can't answer this question cause the instructor is still talking about the intro to the course. Intro needs to not run so long.

D
Deryck18 December 2017

I think the plan of the course is very effective. The course will cater to students who are interested in learning the fundamentals of accounting and excel.



Coupons

StatusDateDiscount
Expired11/1/2019100% OFF
Expired4/19/2020100% OFF
Expired5/2/2020100% OFF
Expired5/23/2020100% OFF
Expired7/20/2020100% OFF
Expired8/14/2020100% OFF
Expired8/31/2020100% OFF
Expired10/24/2020100% OFF
Expired12/27/2020100% OFF
Expired1/27/2021100% OFF
Expired3/1/2021100% OFF

1458300

Udemy ID

12/4/2017

Course created date

11/1/2019

Course Indexed date
Bot
Course Submitted by