There Are 12 Units Of Study

Accounts Payable
In this lesson, you'll learn all about accounts payable, which is a group of accounts that shows how much your business owes its vendors. You'll be journalizing and posting your company's purchases and preparing a Schedule of Accounts Payable. Keeping track of what your company owes others is a vital part of operating a business. This lesson will give you the tools you'll need to successfully track those accounts.

Accounts Receivable
We'll take a close look at accounts receivable in this lesson. This is the money that your customers owe your business. After completing this lesson, you'll know how to enter charge sales into your Sales Journal and then post them to your General Ledger. Knowing what your customers owe you can make the difference between your company's success or failure.

Uncollectible Accounts Receivable
Today, we'll be dealing with uncollectible accounts receivable. While we'd all like to think that our customers will pay what they owe, it's not always the case. You'll learn how to account for long overdue receivables that probably won't ever be paid. While this doesn't happen often, it's a fact of business, so you'll need to know how to account for it in your company's books.

Plant Assets and Depreciation
In this lesson, we'll look at plant assets and depreciation. Most all businesses have assets they use to determine their income. Just like your car, business assets depreciate over time, so you'll need to know how to account for that expense in your records. And you'll need to record these assets and calculate their depreciation in a timely manner to keep accurate records for your business.

Notes Payable and Notes Receivable
This lesson is all about notes payable and notes receivable. A business might need a little extra time to pay a bill beyond the usual terms offered by the vendor. Or a customer may need an extension of credit beyond what your business usually offers its charge customers. You'll find out all you need to know about accounting for these situations as we look at how to record the issuance and payment of these notes payables and notes receivables.

Accrued Income and Accrued Expenses
Today, you'll learn how to deal with accrued income and accrued expenses. Accrued income is money that the company earns in one fiscal period that it doesn't receive until after another fiscal period begins. Similarly, accrued expenses are expenses that are incurred during one fiscal period that aren't paid until the next period. To get a true picture of the net income or net loss of your business, you'll need to account for the accrued income and accrued expenses within the period they're incurred.

Dividends and Starting the Year-End Worksheet
In this lesson, we'll be dealing with dividends, which is money paid to the company's stockholders on their investment. You'll learn how the business accounts for the dividends it pays to its stockholders. We'll also look at retained earnings, or the amount of profit the corporation retains for future use. Then we'll begin to prepare the worksheet, possibly the most important financial report a business compiles each year.

Complete Year-End Worksheet with Adjustments
Today, we'll determine if our business has a net income or a net loss by completing the worksheet we started in the previous lesson. And because many General Ledger accounts change throughout the fiscal period—supplies are used, insurance premiums are depleted—we'll need to bring these accounts up to date to reflect their current values. So we'll also take a close look at how to make adjusting entries to update our General Ledger accounts for the beginning of the new fiscal period

End-of-Fiscal-Period Financial Reports
It's time to begin wrapping up our books for the end of the fiscal period. In this lesson, you'll learn how to compile most of the various financial reports a corporation needs to complete at the end of the fiscal period. You'll prepare an Income Statement, Stockholders' Equity Statement, Balance Sheet, and more. These are the reports that really demonstrate the success of a business.

Adjusting and Closing Entries and Post Closing Trial Balance
In this lesson, we'll get the books all caught up and ready for the next fiscal period. You'll go back and journalize those adjusting entries you entered into your worksheet, then you'll enter closing entries into your journal. Finally, you'll post these journal entries to the General Ledger to prepare it for the new fiscal period.

Preparing a Payroll
Today, we'll cover every employee's favorite subject: Payroll! You'll learn about various mandatory and voluntary deductions from employees' pay, as well as how to journalize and post an entire payroll. As an added bonus, after this lesson, you'll be able to check the accuracy of your own paycheck.

Preparing Federal Tax Deposits and Year-End Tax Reports
We'll finish up by preparing a variety of end-of-year tax reports. Here's your chance to go step-by-step through a multitude of IRS forms with instructions that are much easier to understand! You'll fill out the federal Form 941, then learn how to make federal income tax deposits. Then we'll look closely at Form W-2s and Form W-3s. Finally, we'll look at how to calculate and report the company's Federal Unemployment Tax payment. This lesson is jam packed with valuable tax information!

There are 12 Units Of Study

Account Classifications, Account Titles, T Accounts, and the Accounting Equation

Welcome to Accounting Fundamentals! In this first lesson, you'll learn all about account classifications, debits, credits, and T accounts. You'll learn the difference between a liability and an asset, and you'll find out how to determine an owner’s equity.

General Ledger Accounts and the Balance Sheet

Here's where you'll begin your hands-on accounting practice: You'll start by creating an imaginary company for which you'll be the accountant. You'll learn how to analyze your company's transactions to determine which amounts go into which accounts, then you'll create your company's own General Ledger forms and post a few transactions into those accounts. You'll also prepare a Balance Sheet to prove your accounting equations.

Journalizing Transactions and Posting to the General Ledger

Now that you have an understanding of the functions of the General Ledger, you're ready to move on to the next phase of recording transactions: the Journal. In this lesson, you'll learn how to enter transactions into an 11-column journal and then post or transfer those amounts into appropriate General Ledger accounts.

Journalizing and Posting Cash and Charge Purchases and Payments on Account

In this lesson, you'll learn all about Accounts Payable--money that you owe your vendors and suppliers. You'll practice journalizing cash purchases and purchases on account, and you'll get hands-on practice transferring those purchases to their corresponding Accounts Payable Ledger accounts.

Journalizing and Posting Cash and Charge Sales and Cash Received on Account

In this lesson, you'll learn about Accounts Receivable, which is another name for money owed to your company by its customers. You'll learn how to journalize and post those sales on account, how to enter charge sales into the journal, and how to transfer the information into an Accounts Receivable Ledger.

Payroll and Various Deductions

It's payday! This lesson will teach you how to determine gross pay, deductions, and net pay. You'll learn how to prepare a payroll, write payroll checks, and how to prepare and maintain accurate payroll records

Banking Services and Reports

In this lesson, you'll learn all about banks and banking services: You'll learn the proper way to write checks, make out deposit tickets, and reconcile your company's checking account with the bank statement--skills you'll find valuable in both your business and personal life!

Posting Journal Totals to the General Ledger and Schedule of Accounts Payable and Schedule of Accounts Receivable

This lesson will teach you how to prepare a Schedule of Accounts Payable and a Schedule of Accounts Receivable. These reports can be used to compare the amount of money your business owes its creditors with the amount of money your customers owe your business

End-of-Year Worksheet

In this lesson, you'll prepare a worksheet showing the net income or net loss for the fiscal period. The worksheet will show all income and expenses for the fiscal period as well as the assets, liabilities, and owner’s equity account balances

End-of-Year Financial Reports

In this lessn, you will learn how to prepare various reports that are vital to the well-being of your company. You'll learn how these reports can be used to make sound financial decisions in the next fiscal period. You will discover how to put together an Owner’s Equity Statement, an Income Statement, and a Distribution of Net Income.

Journalizing and Posting Adjusting Entries

In this lesson, you'll prepare for the end of the fiscal period by adjusting your asset account balances to accurately reflect the assets remaining at the end of the year. You will also find out how to journalize and post adjusting and closing entries to bring your company's General Ledger up to date.

Journalizing and Posting Closing Entries and Preparing a Post Closing Trial Balance

In our final lesson, we will prepare a Post Closing Trial Balance report to ensure that all of our debits and credits in the General Ledger balance out in preparation for the new fiscal period.

There are 12 units of study

Lesson 01 - Pivot Table Concepts
In our first lesson, you'll develop a solid understanding of the requirements to use pivot tables. We'll go over the foundational elements you need to understand to get the most out of pivot tables, and we'll take a peek into the sometimes-intimidating Pivot Table Fields task pane and pivot table-specific Ribbon tabs.

Lesson 02 - Creating a Pivot Table
Not all data is created equal. In this lesson, you'll learn what's required to make sure your data is organized well enough to be used in a pivot table. I'll give you an example of a very common issue that occurs when the source data changes or expands, and I'll show you how to easily eliminate that issue in just a few quick clicks of the mouse.

Lesson 03 - Pivot Table Analyze and Design Tabs
Working efficiently with pivot tables requires knowing where to find the proper pivot table feature without searching high and low for it. Most pivot table features reside on one of the two pivot table-specific Ribbon tabs. Knowing how the different features are grouped and what each one provides is a must if you want to consider yourself a master pivot table user, so we'll explore all of it in today's lesson.

Lesson 04 - Pivot Table Formatting Inside and Out
Formatting a pivot table report can be challenging if you don't know all the secrets. In this lesson, you'll learn how to format cells and numbers, as well as how to handle empty cells or errors in your source data. In addition, you'll get some exposure to renaming fields and how to sort and filter data within your pivot table report.

Lesson 05 - Pivot Table Options and Field Settings
Most users aren't aware there are certain options and settings that provide little-known but extremely useful features. Most of these features are accessed through the pivot table Ribbon tabs, but some aren't. In this lesson, you'll learn how to use some of the more obscure settings in the Pivot Table Options and Field Settings dialog boxes.

Lesson 06 - Value Field Settings
Similar to the Field Settings, the Values section of a pivot table report have unique settings and summarization options. For most people, simply summing or counting the data within the Values section is enough. But once you learn how to use these lesser-known settings, you'll go from an average pivot table user to an expert.

Lesson 07 - Grouping Pivot Table Fields
A pivot table is ideal for analyzing and summarizing data. By default, the table does an excellent job at summarizing the data within the various fields, but there is a way to summarize the data even further. In this lesson, we'll group ordinary pivot table fields, which will create new fields that you can use within the pivot table or as a Slicer. In addition, you'll learn how to expand and collapse fields to help in summarizing the pivot table data.

Lesson 08 - Data-Integrity Checks and Report Filters
A pivot table is a great way to locate data anomalies in large data sets that would otherwise be hard to find scanning through the source table. In addition, the proper use of report filters can assist in any data investigation, as well as providing a great tool to create multiple reports from a single pivot table report. You'll learn all about these tools in today's lesson.

Lesson 09 - Cloning a Pivot Table and the Wonderful World of Slicers
Pivot tables are extremely useful and flexible for data analysis and reporting. It's easy to add, remove, or simply move fields to create different-looking reports from the same source data. Routinely, it's necessary to create different versions of reports, but the best way to do so isn't as straightforward as you might think. You'll see what I mean in this lesson.

Lesson 10 - Calculated Fields and Items
Pivot tables are great for analyzing and reporting information, but they're limited in their functionality when your source data is missing needed information. Or, perhaps the information isn't needed in the source data and is only needed for analysis for a short time. Using Excel's Calculated Items and Fields feature provides you with a way to create items that are missing from the source data or that you need for a one-time analysis. You'll see what I mean when we practice using it in today's lesson.

Lesson 11 - Working With Slicers and Pivot Charts
Your pivot table isn't complete without a Slicer and pivot chart. In order to create an effective dashboard, a pivot table and pivot chart controlled by multiple Slicers is a must. Creating and managing Slicers and Pivot Charts is really quite simple and a lot of fun. You'll see what I mean in today's lesson.

Lesson 12 - Timelines and Dashboard Development
There are many interactive tools and techniques available to make pivot tables and pivot charts fun to use, and we'll go over some of my favorites in this, our final lesson. Similar to a Slicer, Excel offers a tool called Timelines. Timelines are available when a field available in your pivot table or chart is a date. Within a dashboard, using the Timeline feature can be useful and eye catching to the users.

There are 12 units of study

Introduction to the Financial Planning Process

In this course, you'll discover the keys to achieving financial freedom steadily and successfully. You'll learn how to make financial discipline and wise financial choices a natural part of your life. Our journey begins today with an overview of the five steps of financial planning.

Organize Your Finances

How much money do you actually have and where is it all going? You have to be able to answer these questions before you can create a financial plan. So, in this lesson, we'll work on organizing your financial life. You'll create an organized filing system, get a handle on your spending, and learn how valuable cash flow statements, budgets, and balance sheets are to financial success. Don't worry; it's not as hard as it sounds!

Short- Term Investments : Building Cash Assets

There are three types of investment money: short-term, intermediate, and long-term. We'll start this lesson with a look at short-term money and the purpose it serves. This is money you would set aside for something specific in the near future like buying a car, making a down payment on a house, or paying off interest-free debt. You'll learn the trade-off between investment risk and investment reward and see why it takes more than putting your money in a savings account to get rich.

Bonds, Stocks, and Mutual Funds

In this lesson, you'll learn how a combination of stocks, bonds, and mutual funds will help you build wealth. You'll also see how investment risk correlates with investment return. Then you'll discover how time mitigates higher-risk investments, making them an excellent choice if you've got enough time and want to see double-digit returns.

Education Accounts

Saving money to fund a college education is a common financial goal. So, today we'll talk about the pros and cons of the different education savings plans that are out there. By the end of this lesson, you'll be the neighborhood expert on saving for college!

Retirement Savings

Most people's number-one financial goal is saving for retirement. Social Security alone won't cover the bills. Some of us have employer pension plans, but many of us have to figure out how we'll make up the shortage once we stop working. This lesson is about taking care of yourself in retirement. We'll examine retirement savings plans and discover why they're a great place for your cash investments.

Real Property Assets

Up to now, this course has been about accumulating cash assets. Today we'll learn how real property assets complement your wealth. Real property assets are things you can feel, see, and touch (such as land or precious metals). When you complete this lesson, you'll know the challenges and benefits of owning real property.

Understanding Mortgages

Since most of us don't have enough to buy a house with cash, we need someone to lend us money. Going to the bank for a loan isn't as simple as walking in and filling out an application. Completing an extensive questionnaire about your income, debts, and job history is part of the loan process, but there's more. You need to decide which kind of mortgage to apply for. Just like there are a number of ways to order coffee from your favorite barista, there are a number of ways to finance a house. In this lesson, you'll learn about the different loan types, understand why some cost more (or less) than others, and figure out which loan program is best for you.

Other Financing

Almost all of us have credit cards in our wallets. And most of us are plagued by consumer debt. Credit cards, car loans, car leases, and in-store financing are where consumer debt builds up. But today you'll learn how to use these forms of financing to maximize your wealth.

Risk Management

As you accumulate wealth, it's important to protect it against loss. We buy car insurance in case of car crashes, homeowners insurance in case of damage or destruction to our houses, and health insurance to help with the rising cost of medical care. These are obvious assets to protect, but what about your most valuable asset: your ability to earn an income? If you have people depending on your paycheck to put food on the table and a roof over their heads, then you need to protect your income. So in this lesson, we'll talk about life and disability insurance and when you should get them.

Build Your Team of Professionals

Today, we'll talk about the professionals who can help you on your journey toward wealth. You'll learn the areas of expertise for an attorney, CPA, financial advisor, and insurance agent. You'll also get a sense of when is the right time to call on each of these professionals.

Put Your Plan into Action

In this, our final lesson, we'll talk about the most challenging part of the financial planning process: implementation. We will go over a technique that's very helpful in getting you and keeping you moving on your journey toward wealth. You'll leave this course knowing what you need to do to reach your goals and how to do it. You'll have everything it takes to achieve financial freedom!