Financial Accounting & ExcelComprehensive Accounting Course (Udemy.com)
Comprehensive accounting course to learn the accounting cycle in a practical way and pick up critical Excel fundamentals
Created by: Robert (Bob) Steele
Produced in 2019
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
Quality Score
Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/
Overall Score : 78 / 100
Course 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. Students 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 entriesPosting to the general ledgerCreate a trial balanceAdjusting entriesBank reconciliationsFinancial statement generationClosing entriesReversing 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 Course05 Set up New Company Worksheet10 Set Up Inventory Items15 Set Up Customer Balances20 Set Up Vendors Beginning Balances25 Enter Opening Account BalancesAccounting Concepts Section of Accounting & Excel Course135 Cash Method vs Accrual Method132 Balance Sheet & Income Statement Relationship155 Financial Transaction Rules160 Financial Transaction Thought ProcessEnter Data for First Month Section of Accounting & Excel Course05 Owner Deposit & Loan Deposit10 Purchase Furniture & Record Investment20 Part 1 Invoice Transaction20 Part Two Create on Invoice Transaction25 Receive Payment Part 125 Receive Payment Part 225 Receive Payment Part 330 Cash Sales Transaction Part 130 Cash Sales Part 235 Deposit Part 135 Deposit Part 240 Part 1 Inventory Payment40 Part 2 Inventory Payment45 Invoice for Preordered Item Part 1.
45 Invoice for Pre-ordered Item Part 250 Receive Payment & Make Deposit55 Part 1 Write Check55 Part 2 Write Check Part 260 Pay Bills65 Customer Jobs70 Payroll75 Job Sales Receipt80 Financial Statements & Reports90 Closing Process January92 Worksheet Mon
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. Students 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 entriesPosting to the general ledgerCreate a trial balanceAdjusting entriesBank reconciliationsFinancial statement generationClosing entriesReversing 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 Course05 Set up New Company Worksheet10 Set Up Inventory Items15 Set Up Customer Balances20 Set Up Vendors Beginning Balances25 Enter Opening Account BalancesAccounting Concepts Section of Accounting & Excel Course135 Cash Method vs Accrual Method132 Balance Sheet & Income Statement Relationship155 Financial Transaction Rules160 Financial Transaction Thought ProcessEnter Data for First Month Section of Accounting & Excel Course05 Owner Deposit & Loan Deposit10 Purchase Furniture & Record Investment20 Part 1 Invoice Transaction20 Part Two Create on Invoice Transaction25 Receive Payment Part 125 Receive Payment Part 225 Receive Payment Part 330 Cash Sales Transaction Part 130 Cash Sales Part 235 Deposit Part 135 Deposit Part 240 Part 1 Inventory Payment40 Part 2 Inventory Payment45 Invoice for Preordered Item Part 1.
45 Invoice for Pre-ordered Item Part 250 Receive Payment & Make Deposit55 Part 1 Write Check55 Part 2 Write Check Part 260 Pay Bills65 Customer Jobs70 Payroll75 Job Sales Receipt80 Financial Statements & Reports90 Closing Process January92 Worksheet Mon
Instructor Details
- 3.9 Rating
49 Reviews
Robert (Bob) Steele
Through working with students from many different schools, Mr. Steele has learned best practices for helping people understand accounting fast. Learning new skills and finding the best way to share knowledge with people who can benefit from it is a passion of his.
Mr. Steele has experience working as a practicing Certified Public Accountant (CPA), an accounting and business instructor, and curriculum developer. He has enjoyed putting together quality tools to improve learning and has been teaching, making instructional resources, and building curriculum since 2009. He has been a practicing CPA since 2005. Mr. Steele is a practicing CPA, has a Certified Post-Secondary Instructor (CPI) credential, a Master of Science in taxation from Golden Gate University, a Bachelors Degree in Business Economics with an emphasis in accounting from The University of California Santa Barbara, and a Global Management Accounting Designation (CGMA) from The American Institute of CPA (AICPA).
Mr. Steele has also authored five books that can be found on Amazon or in audiobook format on Audible. He has developed bestselling courses in accounting topics including financial accounting and QuickBooks accounting software.
In addition to working as an accountant, teaching, and developing courses Mr. Steele has helped create an accounting website at accountinginstruction, a YouTube channel called Accounting Instruction, Help, and
More courses by Robert (Bob) Steele
QuickBooks Online 2021, 2019 & 2018 Start to Finish (2021)
4.4 (284 Reviews)
Provider: Udemy
Time: 91h
$11.99
Tax Preparation and Law 2021, 2021, 2019 & 2018 - Income Tax (2021)
4.5 (221 Reviews)
- Provider: Udemy
- Time: 50.5h
$11.99
QuickBooks Pro Desktop 2021, 2021, 2019, & 2018 (2021)
4.2 (187 Reviews)
- Provider: Udemy
- Time: 147h
$11.99
Financial Statement Analysis Ratio Analysis (2021)
4.2 (99 Reviews)
- Provider: Udemy
- Time: 24.5h
$11.99
More finance & accounting courses
Accounting - A Brief Introduction - in 60 Minutes (2016)
4.8 (312 Reviews)
- Provider: Udemy
- Time: 1 hour on-demand videoh
$11.99
Forex Trading Price Action: Advanced Swing Trading Strategy (2021)
4.8 (307 Reviews)
- Provider: Udemy
- Time: 4h
$11.99
Options Trading for Rookies: Understand Options Completely (2021)
4.8 (300 Reviews)
- Provider: Udemy
- Time: 2.5h
$11.99
How to Start an Amazon FBA Store on a Tight Budget (2021)
4.8 (300 Reviews)
- Provider: Udemy
- Time: 10.5h
$11.99
Build Your Spiritual Healing Business on a Budget (2021)
4.8 (224 Reviews)
- Provider: Udemy
- Time: 4h
$11.99
Options Trading for Rookies: Basic Stock Options Strategies (2021)
4.8 (210 Reviews)
- Provider: Udemy
- Time: 2.5h
$11.99
Reviews
- Video Duration:
21.5h - Price: 11.99 Track Price 11.99 Track Price
- Provider: Udemy
- Year:
2019 - Language:
English - Certificate:
Yes
30-Day Money-Back Guarantee
Udemy Coupon Price Tracker
