Accounting Excel Corporation Comprehensive Prob-First Month
4.3 (88 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.
22,307 students enrolled

Accounting Excel Corporation Comprehensive Prob-First Month

Comprehensive corporation accounting cycle problem in Excel with preformed Excel worksheet for each step
4.3 (88 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.
22,307 students enrolled
Last updated 8/2018
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
  • 4 hours on-demand video
  • 26 downloadable resources
  • 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
  • Enter accounting transaction
  • Enter journal entries into a general journal
  • Post journal entries to a general ledger
  • Create a trial balance from a general ledger
  • Enter adjusting entries
  • Create an adjusted trial balance
  • Create financial statements from the trial balance
  • Build a balance sheet
  • Build an income statement
  • Build a statement of stockholders’ equity
  • Navigate an Excel worksheet
  • Enter standard Excel formulas
Requirements
  • We should have a basic understanding of financial accounting and debits and credits.
Description

Full accounting cycle comprehensive corporate problem where we will enter journal entries into the general journal related to setting up a corporation and to the first month of operations.

We will enter the normal financial transaction for a month of operations, recording the debits and credits, or journalizing the financial transactions in the general journal.

We will perform these tasks using preformatted Excel worksheets. Even though this is a comprehensive problem, each new step will have a new Excel worksheet so that we can jump forward or go back and rework any component of the comprehensive problem.

Each new step in the process will include an Excel worksheet with at least two tabs, one demonstrating the completed task, and one with a preformatted worksheet to complete the task in a step by step format along with instructional videos.

Once we have journalized the journal entries, we will post them to the general ledger and then create a trial balance from the general ledger.

After completing the accounting transactions for the month, we will enter adjusting journal entries for the month, using an adjusting entry worksheet, the result being an adjusted trial balance.

We will use the adjusted trial balance to create the financial statements, to create the balance sheet, income statement, and statement of shareholders’ equity.

Finally, we will enter the closing entries to prepare for the next accounting period, the next month of operations. We will use a four-step closing process.

Who will we be learning from?

You will be learning from somebody who has technical experience in accounting concepts and in accounting software like QuickBooks, as well as experience teaching and putting together curriculum.

You will be learning from somebody who is a:

•    CPA – Certified Public Accountant

•    CGMA – Chartered Global Management Accountant

•    Master of Science in Taxation

•    CPS – Certifies Post-Secondary Instructor

•    Curriculum Development Export

As a practicing CPA the instructor has worked with many technical accounting issues and helped work through them and discuss them with clients of all levels.

As a CPS and professor, the instructor has taught many accounting classes and worked with many students in the fields of accounting, business, and business applications.

The instructor also has a lot of experience designing courses and learning how students learn best and how to help students achieve their objectives. Experience designing technical courses has also benefit in being able to design a course in a logical fashion and deal with problems related to technical topics and the use of software like QuickBooks Pro. 

Content Includes: 

·        Enter accounting transaction

·        Enter journal entries into a general journal

·        Post journal entries to a general ledger

·        Create a trial balance from a general ledger

·        Enter adjusting entries

·        Create an adjusted trial balance

·        Create financial statements from the trial balance

·        Build a balance sheet

·        Build an income statement

·        Build a statement of stockholders’ equity

·        Navigate an Excel worksheet

·        Enter standard Excel formulas

Who this course is for:
  • Accounting students
  • Business owner
  • Anyone who whats to learn accounting
Course content
Expand all 27 lectures 03:53:08
+ Financial Transactions
13 lectures 01:51:13
20 Corporation Comp Prob Stock Purchase
24:09
40 Corporation Comp Prob Supplies Purchase
07:53
60 Corporation Comp Prob Customer Payment Unearned Revenue
06:02
70 Corporation Comp Prob Purchase Insurance
06:14
80 Corporation Comp Prob Unhide and Hide pains
02:24
90 Corporation Comp Prob Pay Vendor One Account
05:29
100 Corporation Comp Prob Receive Cash on Account
05:04
110 Corporation Comp Prob Revenue for Cash
05:08
120 Corporation Comp Prob Pay Expenses
14:31
130 Corporation Comp Prob Dividends
13:39
+ Adjusting Entries
5 lectures 38:07
140 Corporation Comp Prob Adj Entry Insurance
10:17
150 Corporation Comp Prob Adj Entry Supplies
05:26
160 Corporation Comp Prob Adj Entry Depreciation
07:57
170 Corporation Comp Prob Adj Entry Wages
07:05
180 Corporation Comp Prob Adj Entry Unearned Revenue
07:22
+ Financial Statements
4 lectures 55:57
190 Corporation Comp Prob Financial Statements Assets
15:40
200 Corporation Comp Prob Liability & Equity
11:43
210 Corporation Comp Prob Net Income
08:27
220 Corporation Comp Prob Statement of Equity
20:07
+ Closing Entries
4 lectures 25:46
230 Corporation Comp Closing Entry One
05:58
240 Corporation Comp Closing Entry Two
09:26
250 Corporation Comp Closing Entry Three
05:11
260 Corporation Comp Closing Entry Four
05:11