Coupon Details
Accounting Excel Corporation Comprehensive Prob-First Month, Comprehensive corporation accounting cycle problem in Excel with preformed Excel worksheet for each step
Created by Robert (Bob) Steele
What Will I 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 were 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 with instructional videos.
Once we have journalized the journal entries, we will post them to the general ledger and then create a trial balance form 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. In addition to instructional video, this course will include downloadable
• Downloadable PDF Files
• Excel Practice Files
• Multiple Choice Practice Questions
• Short Calculation Practice Questions
• Discussion Questions
The PDF files allow us to download reference information we can use offline and as a guide to help us work through the material.
Excel practice files will be preformatted so that we can focus on the adjusting process and learning some of the basics of Excel, like addition, subtraction, and cell relationships.
Multiple choice example question helps us improve our test-taking skills by reducing the information into the size and format of multiple choice questions and discussing how to approach these questions.
Short calculation questions help us reduce problems that have some calculation down to a short format that could be used in multiple choice questions.
Discussion Question will provide an opportunity to discuss these topics with the instructor and other students, a process many students find very helpful because it allows us to see the topic from different viewpoints.
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 is the target audience?
- Accounting students
- Business owner
- Anyone who whats to learn accounting
Students Also Bought These Courses
Accounting & Financial Ratio Analysis made easy. Learn important accounting skills that will get your foot in the door!
More Courses by Robert (Bob) Steele
Learn QuickBooks Online 2018 in a comprehensive online course taught by a practicing CPA, CGMA, CPI, with BS tax
Learn QuickBooks Desktop 2018 in a comprehensive online course taught by a practicing CPA, CGMA, CPI, with BS tax
Payroll calculations - federal income tax, social security, Medicare - Payroll journal entries posted to ledger accounts