Financial Accounting in Excel – New Business
We will start a comprehensive worksheet in Excel and enter journal entries related to setting up a new business.
Created by Robert (Bob) Steele - CPA, CGMA, M.S. Tax, CPI
Students: 33184, Price: Free
If we are a business owner or accounting professional who would like to get a better understanding of what our accounting software is doing
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 start to 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?
In addition to instruction video we 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.
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
- Financial statement generation
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
Introduction to Financial Accounting
Learn the fundamentals and building blocks of the accounting process
Created by Tim Vipond - CEO at Corporate Finance Institute | 350,000+ students
Students: 32313, Price: Free
Introduction to Accounting course overview:
This FREE Introduction to Accounting course will guide you through the fundamentals of the accounting process. We will explore the layout of the balance sheet, income statement, and cash flow statement; and demonstrate how to prepare financial statements from scratch. This fundamental accounting course is an essential building block required for performing financial modeling and other types of Wall Street financial analysis.
Constructing an income statement and balance sheet
In the first section of this free accounting course, we will explore the layout of the balance sheet and income statement, how transactions are recorded, and how to prepare a simple balance sheet and income statement. By the end of this section, you will have a solid understanding of how to construct a balance sheet and income statement.
- Explain the format of the income statement and balance sheet
- Define various financial statement terms (e.g. accounts receivable, prepayments, etc.)
- Record financial statement transactions (e.g. invoicing, raising equity, buying inventory, etc.)
- Prepare a simple income statement and balance sheet
Constructing a cash flow statement
In this second section of this Intro to Accounting course, we will explore the layout of the cash flow statement, explain the differences between the cash flow statement and the income statement, and prepare a cash flow statement from scratch. By the end of this section, you will have a solid understanding of how to construct a cash flow statement.
- Outline the format of the cash flow statement
- Explain the difference between profit and cash
- Prepare a simple cash flow statement using the balance sheet and income statement
More Accounting Course Details
This online accounting course incorporates a wide range of applied exercises and case studies. Sophisticated search and navigation tools allow you to go at your own pace while quizzes test what you’ve just learned.
The course also includes two PDF reference guides – an accounting factsheet and a financial statements glossary - that can be used while taking the course and downloaded to your computer for future reference. This is the ultimate accounting crash course to prep for Wall Street careers!
Social Media for Financial Services
Successfully originate new accounts on social media in accordance with SEC and FINRA rules and regulations.
Created by Eric Schwartzman - Digital Marketing Consultant
Students: 12846, Price: Free
Using Social Media in Financial Services
Social Media for Financial Services Providers guides financial advisers, investment advisers, registered principals and anyone else associated with a broker-dealer or an investment advisory firm through the process of using social media for business communications.
In recent years, regulatory organizations like FINRA and the SEC have issued guidance on how firms and individuals can remain in compliance with all the applicable regulations, while still benefitting from the power of social media.
This course covers what financial service professionals need to know to use social media without running into problems with regulators or their firms.
Financial Ratios Simplified : A practicle guide
This course is for accounting and finance students . This course covers various types of financial ratios with examples
Created by EduFinWizards Edu - Educating for better tommorow
Students: 7393, Price: Free
In the course we will cover ,
1. Activity Ratio
2. Profitability ratios
3. Dividend ratios
5. Solvency ratios
6. Coverage ratios
7. Return ratios
8. Margin ratios
9. Liquidity ratios
We will then discuss time series and cross sectional ratio analysis
We will then take examples of Google . Tesla and Alibaba to understand ratio analysis
We will also do cross sectional analysis of weed stocks
Assignment : Use the attached excel sheet to do ratio analysis of a company of your choice
Accounting Fundamentals in 30 minutes
Accounting concepts from journal entry to financial statements
Created by Vikas Handa - Director at Qviksoft
Students: 2967, Price: Free
You will learn how business activities are transformed into:
Bookkeeping of various activities
Equipped with this knowledge, you can implement Financial accounting systems with more confidence. You will also be able to appreciate the purpose of the configuration when you configure various setups in ERP. Your fear for accounting will disappear and you will start enjoying various terms on Accounting.
Accounting- Financial Accounting, Cash vs Accrual Accounting
Why use Accrual Accounting; Gaps in Cash Accounting; Prepare financial statements under both methods; financial analysis
Created by Sandesh Banger - MBA (IIM), CFA level 2, Finance Enthusiast
Students: 2844, Price: Free
Let's discover the untold story of Cash vs Accrual Accounting.
If you are an accounting or finance enthusiast, this mini course is for you.
Have you ever thought why Accounting has to be complex? Why someone made Accrual Accounting? Why it can’t be simple? Why don’t we use the simple Cash based Accounting? I bet you have.
I will tell you the answer. And for that we need to understand how business accounts will look like if we use Cash Accounting vs Accrual Accounting. And we will learn that in this course.
One thing is sure that Accrual Accounting is used by the whole world. That means it has to have certain characteristics which make it powerful. What are these, let’s find out.
In this mini-course I’m going to take you through an excel based exercise on creating accounts using cash based and then using accrual based accounting. So, that we can compare the two and figure out interesting insights.
I teach this module in b-schools and students find it an incredible insight, never told before.
By realizing what lies at the core of accounting, you will not only appreciate accounting methods but will also be equipped with the right mindset to learn. It will enable you to better analyse the financials of any company.
Contents and Overview This course includes 10 lectures and just over 30 minutes of content in order to give students a working knowledge and an invaluable insight into Accounting.
What you’ll learn
At the end of this course you have following takeaways
You will be well versed with Cash vs Accrual Accounting
You will be able to record basic transactions in Cash as well as Accrual Accounting
You will have an invaluable insight into the science behind of Accounting
Basics of Financial Accounting
Created by Radhika Ghelani - ACCA Tutor and Oxford Brookes Project Mentor
Students: 2132, Price: Free
Debit, Credit, Credit, Debit... Are you also confused with the debits and credits in accounting!? Don't worry, this FREE short course is all you need!
In this course, you will learn about the basics of financial accounting.
You will learn:
1. The difference between management accounting and financial accounting
2. Definition of assets, liabilities & Equity
3. The accounting equation
4. Source documents, journals & ledgers
5. Basics of double entry bookkeeping, how to record transactions in ledger accounts and how to balance ledger accounts.
6. Meaning and purpose of a Trial Balance
7. How to prepare a Trial Balance
8. Errors that affect & those that do not affect the Trial Balance
Financial Accounting Primer
Free Yourself From the Fear of Accounting
Created by Eric Knight, DBA, CPA, CGMA - A teacher that makes the complex into something simple
Students: 1070, Price: Free
Accounting can be an intimidating course. Accounting students look forward with anticipation but also hesitance. Non accounting majors that are forced to take accounting look at accounting with dread. This course is designed to make accounting a more friendly course by getting you ready. A big fear of the unknown will now be known.
Fear: Loss of control
Fear: Left behind or lost
Who will benefit from this course?
Are you about to take financial accounting? Would you like to better understand financial accounting? Are you a student, businessperson or manager that does not have a background in accounting but may need to deal with the accounting department? Then this course would benefit you!
What you will learn
We will learn what accounting really is and what it is not. We will see the truth behind the ‘math’ misunderstanding of accounting. You will get a primer in accounting by understanding what accounting reports. You will get an introduction into basic accounting equation. You will be introduced to debits and credits. You will even learn to use journal entries. I will show you some examples using Excel.
· Introduction to the course: You will get an overview of this course and what to expect. You will see how this course will help pre-accounting students gain an understanding of accounting. Knowing what accounting is about will take away that fear. Managers that deal with accounting may be at a disadvantage if they do not know what the accounting department does.
· Common student fears introduced: The biggest fears students have in accounting are discussed in this lesson. One fear is that of math. Math can be intimidating or even scary. Math students often fear math because of the use of formulas. Students in math see the questions as right or wrong with no interpretation. Students also fear accounting for its use of rules. Accounting is seen as a profession of rules. Students believe not knowing the rules can lead to failure. Students often fear the use of debits and credits in problems. After this course you will understand that none of the common misconceptions about accounting, math, debits and credits, or rules is true.
· Perception vs reality: What is an accountant’s life like? We perceive accounting and accountants a certain way. In this lesson we’ll discuss that perception. We’ll then discuss the reality of the profession. What do accountants really do? What is their career like?
· Basic accounting terms: Key terms include transaction and account. These terms are used throughout business. The reason for confusion is that there are multiple definitions for these terms in business depending on your role.
· Accounting Reports: What are the reports provided by accountants? You’ll learn the major two accounting reports that are taught in school. You’ll see what kind of information is provided in these reports.
· Who?: In this lesson you will get to see who uses the accounting reports. You’ll find out why accounting reports are so useful and why there is such a need for accountants.
· Math: You will get the truth about math as it is used in financial accounting. There are numbers in accounting but what accountants really do is communicate. The numbers are part of that transfer of information to the user. The ‘math’ accountants use is really just adding, subtracting, multiplying and dividing. The accounting problems take no special math skills, but those accounting problems may be a challenge. So how should you approach accounting problems when you take the course?
· Accounting Equation: All of financial accounting can be boiled down to one formula: Assets = Liabilities + stockholders’ equity. You will understand this formula as a fundamental or foundation of information you will need for the course.
· Debits and Credits Oh My!: You will know, by the end of the lesson, what a debit and credit is and what they are not. You will understand how these are merely tools for increasing or decreasing accounts.
· Journal Entry: Learn how to do a journal entry. Get some examples from real world transactions. You will follow the journal entries as they are completed using Excel.
No prerequisite: You will learn the very basics of financial accounting!
Learn Accounting in 1 hour FREE (Material, quizzes & videos)
From Double entry to Financial Statements, learn every basics of financial accounting & bookkeeping from a UK lecturer
Created by Ilias Rubel ACCA, MBA - Chartered Accountant
Students: 758, Price: Free
You will learn accounting within 1 hour. This is a brief introduction to bookkeeping & accounting.
No prerequisite knowledge is required!
This course is ideal for any accounting beginner student, an aspiring bookkeeper & accountant, a businessman who wants to know how to keep daily accounting records or anybody who is interested how accounting system works in real life.
The Accounting Equation
How to remember Debit & Credit
What T-Accounts are
How T-Accounts and Journal Entries are made
How to create a simple Balance Sheet/SOFP
How to create a simple Income Statement/SPL
At the end of this course, you will be confident in preparing double entry, trial balance & financial statements.
Are you a business owner who wants to better understand your business finances?
Are you someone who is interested in bookkeeping and accounting?
Well, this course is for you, and all you need is 1 hour! Bookkeeping & accounting doesn't have to be hard. Accounting is not all about math. If you can understand the concepts and know how to use a calculator, you can be an excellent bookkeeper.
This course takes you through the basics of bookkeeping in 1 hour. By the end of this course, you will have a solid understanding of the main accounts in bookkeeping & accounting, the different financial reports, and I will show you step-by-step how to do bookkeeping & accounting.
This is a FREE course
Information Vital to the Entrepreneur
Created by Shane Patrick Irvine, BSL JD - Become your own Business Lawyer
Students: 98, Price: Free
The world was dealt a serious blow with the Covid-19 pandemic. During the 2020 time of writing Entrepreneurs, Et al, and recovery was just getting started. Different regions were affected differently and the level of resources to promote entrepreneurship also varies by region. Jobs and financial resources became alarmingly scarce.
Working from home, being self-employment and undertaking entrepreneurial endeavors quickly became the new business norm as many people had no choice except to go to work for themselves.
With major corporations and government entities outsourcing much of their work to avoid workplace exposure to the coronavirus. Initially, only essential workers were retained while many people, were left unemployed, laid off, or had their jobs suspended. The lucky ones were able to work from home.
As a result, entrepreneurialism became the new standard for business in the United States and around the world. Many entrepreneurs had studied business science in undergraduate or graduate coursework, and were able to adapt. However, many found themselves unprepared to start or manage their own business, and going back to school was just not an option. This series of courses is designed for those who want to improve their business skills but lack the resources to go back to school.
There are certain disciplines in business that every entrepreneur needs to be familiar with, but it is not necessary to learn them in a traditional academic setting. Business disciplines are typically taught in classrooms with a live instructor and typically include basic business scholastic selections such as entrepreneurship, management strategies, insurance, finance, sales, marketing, human resources, and accounting principles. However, the information provided in these disciplines is generic. No one university has a monopoly on standard business knowledge. As a matter of fact, most of the business curriculum has become standardized so that transferring students have equivalent knowledge about the standard curriculum.
Because this information is considered standard knowledge, it can be taught through either traditional classroom study or self-study. Not every student has the self-discipline to achieve a high level of understanding of a subject matter. Not every university student has the ability to even pass their classes. Education is very individual. People learn at different levels. Some people are capable of learning with minimal assistance by just listening, reading along, and doing independent studying on areas they don’t initially grasp.
Quite often a discipline requires understanding fundamental principles. If those principles are not understood from the beginning, the whole study thereafter may be flawed by a lack of understanding of core principles. All too often, the speed of the class does not allow students to go back and relearn what they missed. Some students excel while others are left behind. The courses often flow at the speed of the top learners. This deprives other students of an opportunity to matriculate and achieve scholastic successes.
Not everyone needs a traditional classroom setting to learn in and some are just not cut out for university education. However, many people are capable of learning independently at their own pace.
If one plans to start their own business, they don’t necessarily need an actual diploma, they need the knowledge. The curriculum contained herein is designed to give a broad knowledge of the functional areas of how businesses are structured, practical managerial skills, communication skills, and business decision-making capability.
When it comes to business, there is no one right way to do anything. There are as many different approaches as there are different opportunities. The goal of every business student is to synthesize the information and extrapolate from that information that is necessary to achieve their end business goal.