Last updated 12/2021Course Language EnglishCourse Caption English [Auto]Course Length 28:45:51 to be exact 103551 seconds!Number of Lectures 93
This course includes:
29 hours hours of on-demand video
Full lifetime access
Access on mobile and TV
Certificate of completion
77 additional resources
How to navigate Microsoft Excel or other computerized spreadsheet like Google Sheets
How to create an accounting system in Excel from a blank worksheet including a general journal, trial balance, general ledger, subsidiary ledgers and more
How to enter journal entries related to common transactions and list the data input forms often used to enter them into accounting software like QuickBooks
How to enter two months worth of data input into our accounting system
How to do two month of bank reconciliations, comparing the process to how accounting software like QuickBooks would accomplish the task
How to enter period end adjusting journal entries
Create financial statements
This course will walk through a comprehensive accounting problem using Microsoft Excel in a step-by-step process. You may also use another spreadsheet software like Google Sheets.Learners will learn how to navigate Microsoft Excel as well as how to create a well-designed accounting worksheet, complete with a general journal, trial balance, general ledger, subsidiary ledgers for accounts receivable, accounts payable, & inventory, financial statements and much more.Excel is a very good tool to learn accounting because it is much more transparent than a database program, like accounting software, QuickBooks being a common example of accounting software.As we enter transactions into our Microsoft Excel worksheet, we will discuss how the data input would commonly be entered into accounting software like QuickBooks and what data input forms would normally drive the transactions.The course will start out from a blank Excel Worksheet. We will build the outline for our accounting system from the blank spreadsheet.For each new step in the process, you will have access to a downloadable Excel Workbook, containing at least two tabs, one with the answer, the new steps being completed, the other starting out where the prior presentation left off.Therefore, you can complete the entire problem starting from one blank spreadsheet, or you can jump forward in the problem and rework any component of the problem by downloading the related worksheet at that point in the process.After constructing the outline of our accounting worksheet, the first section will discuss the most common accounting transactions and the data input form often used in accounting software, like QuickBooks, to enter them, common data input forms including invoice, bill, deposit. . .We will then start our comprehensive problem, constructing a new Excel worksheet and entering beginning balances into it, imagining that we had a prior accounting system which we are now converting to our new accounting system in Excel.We will then enter two-months worth of data input. When entering the accounting data we will create the journal entry, post it to the trial balance, giving us a good look at which accounts are impacted, post to the general ledger, and make adjustments to any subsidiary ledgers needed. We will also update the financial statements periodically.For the second month of operations, we create a bit more complex trial balance, allowing us to calculate both the year-to-date numbers, including both months of data input, and the current period numbers, showing income statement accounts for just the second month of operations.After entering two months of data input, we will process two bank reconciliations, using mock bank statements. As we construct our bank reconciliations, we will discuss how accounting software often accomplishes this task.Next, we will adjust our worksheet to enter period end adjusting journal entries as well as reversing entries. For each adjusting entry we will consider the reasons for it and how to set up the accounting system so that our adjusting entries do not mess up the data input process in the accounting department.After entering the adjusting entries we will construct our financial statements.Who this course is for:Anyone who wants to learn Excel, real world practice problems being the best toolAnybody learning accounting or bookkeepingAnybody who uses accounting software like QuickBooks and wants to understand what the software is doingAccounting students and professionals
Course Content:
Sections are minimized for better readability, click the section title to view the course content
11 Lectures | 02:55:09
1025 Create Accounting Worksheet Part 1
19:13
1028 Create Accounting Worksheet Part 2
11:04
1031 Create Accounting Worksheet Part 3
13:20
1034 Create Accounting Worksheet Part 4
07:50
1037 Create Accounting Worksheet Part 5
17:14
1040 Create Accounting Worksheet Part 6
15:58
1043 Create Accounting Worksheet Part 7
08:28
1046 Create Accounting Worksheet Part 8
15:58
1049 Create Accounting Worksheet Part 9
27:54
1052 Create Accounting Worksheet Part 10
18:39
1055 Create Accounting Worksheet Part 11
19:31
4 Lectures | 01:36:58
1180 Bill Form
27:09
1200 Pay Bills Form Check
21:38
1260 Check Form
22:14
1280 Void Check Prior Period Adjustment
25:57
6 Lectures | 02:59:04
1340 Invoice Form
28:09
1360 Receive Payment Form
27:59
1380 Deposit Form
33:18
1400 Sales Receipts Form
26:30
1420 Credit Memo Refund Form & Bad Debt Expense Service Item
29:55
1488 Credit Memo with Inventory
33:13
2 Lectures | 44:42
1520 Pay Employees Form
18:24
1522 Pay Employees Form Part 2
26:18
4 Lectures | 48:44
6010 Set Up Excel Worksheet
10:15
6012 Set Up Excel Worksheet #2
15:17
6014 Set Up Excel Worksheet #3
10:15
6016 Set Up Excel Worksheet #4
12:57
1 Lectures | 25:17
6300 Inventory & Inventory Subsidiary Ledger
25:17
3 Lectures | 40:19
6340 Accounts Receivable & Subsidiary Ledger
12:11
6360 Accounts Payable & Subsidiary Ledger
09:02
6362 Financial Statements
19:06
2 Lectures | 31:10
6380 Add New Accounts & Opening Balances
20:42
6383 Adjust Beginning Balances in Worksheet for Current Period Data Input
10:28
2 Lectures | 27:48
7020 Record Deposits from Owner and Loan
11:20
7040 Purchase of Furniture & Investment Transactions
16:28
1 Lectures | 23:04
7080 Cash Payment for Inventory Linked to Purchase Order P.O.
23:04
4 Lectures | 01:28:17
7100 Invoice Selling Inventory
31:47
7120 Receive Payment From Previous Invoice
20:43
7140 Sales Receipt Payment Received at Point of Sale
24:13
7160 Deposits From Undeposited Funds
11:34
4 Lectures | 01:19:15
7180 Invoice Created From Check Created From Purchase Order
29:06
7200 Receive Payment & Make Deposit
17:28
7220 Write Checks for Expenses & Prepaid Assets
23:34
7240 Bill Pay
09:07
4 Lectures | 01:15:33
7280 Pay Employees
17:33
7281 Pay Employees Part 2
23:06
7300 Enter Billable Time & Add to Invoice
13:47
7301 Enter Billable Expenses to Invoice
21:07
1 Lectures | 22:10
7320 Month One Financial Statements
22:10
4 Lectures | 58:12
8005 Format Worksheet for New Month
17:39
8020 Make Amortization Table
11:41
8022 Make Loan Payments
17:24
8040 Short Term Investment Sales & Gains
11:28
2 Lectures | 38:52
8120 Sales Receipt & Deposit
28:28
8122 Record Receipt of Inventory with Bill Linked to P.O.
10:24
4 Lectures | 01:17:50
8130 Populate Invoice Using Billable Item That was Created From P.O.
15:21
8140 Advanced Customer Payment or Unearned Revenue Method 1
20:48
8160 Apply Customer Deposit (Credit) to Invoice
17:19
8200 Advanced Customer Payment or Unearned Revenue Method 2
24:22
2 Lectures | 31:05
8320 Bill for Hourly Services of Staff Set up Items & Enter Billable Time
08:57
8322 Create Invoices Using Billable Time
22:08
2 Lectures | 34:53
8342 Rental Income Customer Deposit
14:25
8344 Rental Income Estimate & Invoice
20:28
2 Lectures | 27:36
8360 Purchase & Finance Equipment
10:39
8362 Subaccounts Categories For Fixed Assets
16:57
2 Lectures | 36:20
8365 Bills - Enter, Sort, & Pay
27:00
8370 Pay Sales Tax
09:20
3 Lectures | 52:01
8380 Enter Payroll For Second Month Part 1
16:25
8381 Enter Payroll For Second Month Part 2
20:28
8385 Pay Payroll Taxes
15:08
2 Lectures | 41:48
8420 Create Reports After Second Month of Data Input YTD
21:57
8421 Create Reports After Second Month of Data Month of February Only
If you like to get inspired by great web projects, you should check out Made with Javascript. If you have a project that you wish to share with the world, feel free to submit your project on Made with Javascript Club website.
Free Online Tools And Converters for your use
URL Encoder
Input a string of text or a URL and encode the entered string
Learn How to Create an Accounting Worksheet Using Microsoft Excel from a Certified Public Accountant (CPA)
FAQ: Udemy Free course Most frequent questions and answers
Does Udemy offer Free Udemy coupons?
Yes, Udemy is the largest online education platform, with the broadest selection of video-on-demand courses and qualified instructors available to meet your needs. At theprogrammingbuddy.club we curate the latest udemy coupons, their expiry, and the number of uses left of these udemy coupons.
How to get free Udemy courses?
There are two ways to get free Udemy courses:
Go to udemy.com and search for your desired course category. Then select free from the filter options.
You can also get paid courses for free if you have a coupon. You can head to theprogrammingbuddy.club, where you can get a daily udemy paid course for free.
How to get Udemy Certificates for free?
Udemy offers certification on completion of each course. In order to receive a certificate of completion from Udemy, you need to complete your course 100%. There is a simple hack, you can open a video and jump on the timeline to complete a lecture.
To download the certificate from Udemy, you need to head over to your account on a desktop browser. Udemy certificates can't be accessed on the mobile app.
Do Udemy courses expire?
No, once you enroll, you will have lifetime access to the course. You can complete the course on your schedule.
Why are the Udemy instructors giving away free Udemy Coupons?
Every instructor has worked for hours on each of their courses. As new courses get launched, the instructors have no way to get their course in front of an audience to get some feedback. So, instructors share free coupons for their courses to get feedback from the students. We attheprogrammingbuddy.club work with these instructors to get their courses available to our buddies.
Is Udemy safe to use?
Yes, payments on Udemy are safe. It is no different than paying for other services on an application or website and inputting your payment information before receiving your goods. Just be sure to keep your account secure, do not share your udemy accounts.
Can Udemy courses get you a job?
Earning a skill is more valuable than earning a job these days. Skills are your most valuable asset. They can help you qualify for jobs you want and get promoted to more advanced positions within your organization. Unfortunately, it is difficult for many people to balance taking courses with work and family obligations. We have had many students, who have taken just Udemy courses, started a job as well as started freelancing with the skills they have learned.