Видео

This video introduces students to the growing demand for accountants and career opportunities awaiting them.

This video introduces students to the ways data analytics can be used to help companies manage their receivables.

This video introduces students to the ways data analytics can be used to help companies manage their inventory.

This video introduces students to the ways data analytics can be used to help companies manage credit sales.

This video provides an overview of the different types of data analytics and how they pertain to accounting.

In this video, I show how to use Excel's workbook/sheet hiding and protection capabilities to safely distribute private information to a group. My example describes disseminating grades to students, but it could be applied to a variety of information distribution scenarios.

This video shows students how companies estimate their bad debts using the Percent of Credit Sales method of estimation.

This video walks students through preparing the Operating Cash Flows section of the Direct Method Statement of Cash Flows.

This video explains the concept of recording Inventory Purchase Discounts in a Perpetual Inventory System in an easy-to-understand way using crudely drawn stick figures.

This video shows how Microsoft Excel's conditional formatting tool can be used to automatically color grade a series of numerical values or automatically highlight the largest and smallest values in a range using an Indirect Method Statement of Cash Flows as an example data source.

This video discusses the differences between operating, investing, and financing activities of companies from the perspective of their classification on the Statement of Cash Flows.

This video introduces students to the concept of unearned revenue and walks them through accounting for unearned revenue transactions.

This video contains a series of practice questions putting students' knowledge of fixed assets and depreciation to the test.

In this video I demonstrate two ways to use conditional formatting in Microsoft Excel that can be useful to analyzing a balance sheet: 1) visually identifying when assets are in balance with liabilities and shareholders' equity; and 2) coloring scaling an analysis such as the debt-to-asset ratio within a pre-defined range of acceptability.

Excel Tutorial: Conditional Formatting in a Multi-Step Income Statement

Excel Tutorial: Conditional Formatting in a Single Step Income Statement

Stick Figure Accounting: Inventory Cost Flows

Practice Problem CASH-04: Mastering the Bank Reconciliation

Financial Reporting Principles

Balance Sheet Accounts

Emerging Technology in Business and Accounting

Practice Problem TECH-01: Emerging Technology

Practice Problem TRANS-03: Types of Economic Transactions

Practice Problem SCF-04: Mastering the Indirect Method Statement of Cash Flows

Practice Problem SCF-03: Preparing the Indirect Method Statement of Cash Flows

Practice Problem SCF-02: Significant Non-Cash Activities

Practice Problem SCF-01: Elements of the Indirect Method Statement of Cash Flows

Cash Flows From Investing and Financing Activities

Cash Flows From Operating Activities (Indirect Method)