Financial Accounting Excelcomprehensive Accounting

  1. Home
  2. Financial-accounting
  3. Financial Accounting Excelcomprehensive Accounting

Tags: Financial Accounting

Comprehensive accounting course to learn the accounting cycle in a practical way and pick up critical Excel fundamentals

Last updated 2022-01-10 | 4.4

- Accounting Cycle
- Debits & Credits
- Excel Fundamentals - Add
- Subtract
- Sum Function

What you'll 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

* Requirements

* We will use Excel. Having Excel will allow us to work through the problems along with the video. If we do not have Excel
* we can still follow along with the comprehensive problem.

Description

  • 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

Course content

7 sections • 145 lectures

Introduction 2 lectures

Introduction Preview 06:37

Course Outline Preview 04:57

Starting a New Business 11 lectures

Start a New Business Section of Accounting & Excel Course Preview 01:26

Excel Worksheet - 6.05 Set Up New Company Worksheet Preview 01:17

6.05 Set up New Company Worksheet Preview 14:22

Excel Download - 6.10 Set Up Inventory Items Preview 00:14

6.10 Set Up Inventory Items Preview 34:28

Excel Download - 6.15 Set Up Customer Balances Preview 00:14

6.15 Set Up Customer Balances Preview 13:52

Excel Download - 6.20 Set Up Vendors Beginning Balances Preview 00:14

6.20 Set Up Vendors Beginning Balances Preview 12:44

Excel Download - 6.25 Enter Opening Account Balances Preview 00:14

6.25 Enter Opening Account Balances Preview 24:16

Accounting Concepts 5 lectures

Accounting Concepts Section of Accounting & Excel Course Preview 01:26

135 Cash Method vs Accrual Method Preview 16:19

132 Balance Sheet & Income Statement Relationship Preview 23:47

155 Financial Transaction Rules Preview 07:48

160 Financial Transaction Thought Process Preview 11:52

Enter Data For the First Month of Operations 52 lectures

Enter Data for First Month Section of Accounting & Excel Course Preview 03:15

Excel Download - 7.05 Owner Deposit & Loan Deposit Preview 00:14

7.05 Owner Deposit & Loan Deposit Preview 17:17

Excel Download - 7.10 Purchase Furniture & Record Investment Preview 00:14

7.10 Purchase Furniture & Record Investment Preview 19:59

Excel Download - 7.20 Part 1 Invoice Transaction Preview 00:14

7.20 Part 1 Invoice Transaction Preview 30:00

Excel Download - 7.20 Part Two Create on Invoice Transaction Preview 00:14

7.20 Part Two Create on Invoice Transaction Preview 24:12

Excel Download - 7.25 Receive Payment Part 1 Preview 00:14

7.25 Receive Payment Part 1 Preview 11:49

Excel Download - 7.25 Receive Payment Part 2 Preview 00:14

7.25 Receive Payment Part 2 Preview 10:12

Excel Download - 7.25 Receive Payment Part 3 Preview 00:14

7.25 Receive Payment Part 3 Preview 08:53

Excel Download - 7.30 Cash Sales Transaction Part 1 Preview 00:14

7.30 Cash Sales Transaction Part 1 Preview 23:45

Excel Download - 7.30 Cash Sales Part 2 Preview 00:14

7.30 Cash Sales Part 2 Preview 11:56

Excel Download - 7.35 Deposit Part 1 Preview 00:14

7.35 Deposit Part 1 Preview 10:35

Excel Download - 7.35 Deposit Part 2 Preview 00:14

7.35 Deposit Part 2 Preview 12:53

Excel Download - 7.40 Part 1 Inventory Payment Preview 00:14

7.40 Part 1 Inventory Payment Preview 17:31

Excel Download - 7.40 Part 2 Inventory Payment Preview 00:14

7.40 Part 2 Inventory Payment Preview 14:57

Excel Download - 7.45 Invoice for Preordered Item Part 1.ENCODING Preview 00:14

7.45 Invoice for Preordered Item Part 1.ENCODING Preview 25:24

Excel Download - 7.45 Invoice for Preordered Item Part 2 Preview 00:14

7.45 Invoice for Preordered Item Part 2 Preview 23:02

Excel Download - 7.50 Receive Payment & Make Deposit Preview 00:14

7.50 Receive Payment & Make Deposit Preview 19:59

Excel Download - 7.55 Part 1 Write Check Preview 00:14

7.55 Part 1 Write Check Preview 16:39

Excel Download - 7.55 Part 2 Write Check Part 2 Preview 00:14

7.55 Part 2 Write Check Part 2 Preview 15:48

Excel Download - 7.60 Pay Bills Preview 00:14

7.60 Pay Bills Preview 11:00

Excel Download - 7.65 Customer Jobs Preview 00:14

7.65 Customer Jobs Preview 05:19

Excel Download - 7.70 Payroll Preview 00:14

7.70 Payroll Preview 33:28

Excel Download - 7.75 Job Sales Receipt Preview 00:14

7.75 Job Sales Receipt Preview 09:39

Excel Download - 7.80 Financial Statements & Reports Preview 00:14

7.80 Financial Statements & Reports Preview 40:44

Excel Download - 7.90 Closing Process January Preview 00:14

7.90 Closing Process January Preview 27:04

Excel Download - 7.92 Worksheet Month Two Preview 00:14

7.92 Worksheet Month Two Preview 06:33

Accounting Comic Break Preview 00:14

Enter Data For the Second Month of Operations 41 lectures

Enter Data for Second Month Section of Accounting & Excel Course Preview 02:56

Excel Download - 8.05 Make Loan Payments Preview 00:14

8.05 Make Loan Payments Preview 29:16

Excel Download - 8.10 Short Term Investment Preview 00:14

8.10 Short Term Investment Preview 11:42

Excel Download - 8.20 Receive Inventory With Bill Preview 00:14

8.20 Receive Inventory With Bill Preview 15:39

Excel Download - 8.20 Receive Inventory With Bill Part 2 Preview 00:14

8.20 Receive Inventory With Bill Part 2 Preview 15:41

Excel Download - 8.25 Sales Receipt & Deposit Preview 00:14

8.25 Sales Receipt & Deposit Preview 18:16

Excel Download - 8.25 Part 2 Sales Receipt & Deposit Preview 00:14

8.25 Part 2 Sales Receipt & Deposit Preview 06:53

Excel Download - 8.30 Advanced Payment From Customer Preview 00:14

8.30 Advanced Payment From Customer Preview 12:03

Excel Download - 8.35 Apply Credit to Invoice Preview 00:14

8.35 Apply Credit to Invoice Preview 21:39

Excel Download - 8.40 Record Sales on Account Preview 00:14

8.40 Record Sales on Account Preview 32:33

Excel Download - 8.45 Advance Customer Payment Preview 00:14

8.45 Advance Customer Payment Preview 13:36

Excel Download - 8.50 Bills Track & Pay Preview 00:14

8.50 Bills Track & Pay Preview 11:07

Excel Download - 8.55 Customer Payment on Account Preview 00:14

8.55 Customer Payment on Account Preview 19:14

Excel Download - 8.60 Pay Sales Tax Preview 00:14

8.60 Pay Sales Tax Preview 10:16

Excel Download -8.65 Pay Payroll Tax Preview 00:14

8.65 Pay Payroll Tax Preview 10:21

Excel Download - 8.70 Enter Bills & Pay Bills Preview 00:14

8.70 Enter Bills & Pay Bills Preview 31:43

Excel Download - 8.75 Service Item & Invoices Preview 00:14

8.75 Service Item & Invoices Preview 46:46

Excel Download - 8.77 Purchase Equipment with Debt Preview 00:14

8.77 Purchase Equipment with Debt Preview 10:36

Excel Download - 8.80 Payroll Preview 00:14

8.80 Payroll Preview 35:31

Excel Download - 8.90 Rental Income Preview 00:14

8.90 Rental Income Preview 08:16

Excel Download - 8.95 Financial Statements Preview 00:14

8.95 Financial Statements Preview 06:40

Bank Reconciliation 9 lectures

Bank Reconciliations Section of Accounting & Excel Course Preview 01:38

Excel Download - 9.10 Bank Reconciliation January Preview 00:14

9.10 Bank Reconciliation January Preview 23:29

Excel Download - 9.12 Bank Reconciliation Adjusting Entries January Preview 00:14

9.12 Bank Reconciliation Adjusting Entries January Preview 17:48

Excel Download - 9.15 Bank Reconciliation February Preview 00:14

9.15 Bank Reconciliation February Preview 21:01

Excel Download - 9.20 Bank Reconciliation Feb. Adjusting Entries Preview 00:14

9.20 Bank Reconciliation Feb. Adjusting Entries Preview 14:16

Adjusting Entries, Financial Statements, Closing Entries, and Reversing Entries 25 lectures

Adjusting Entries & Fianncial Statement Section of Accounting & Excel Course Preview 03:14

Excel download - 10.10 Loan Payable Adjusting Entry Part 1 Preview 00:14

10.10 Loan Payable Adjusting Entry Part 1 Preview 21:01

Excel Download - 10.15 Loan Payable Adjusting Entry Part 2 Preview 00:14

10.15 Loan Payable Adjusting Entry Part 2 Preview 14:33

Excel Download - 10.20 Accrued Interest Adjusting Entry Preview 00:14

10.20 Accrued Interest Adjusting Entry Preview 09:25

Excel Download - 10.25 Invoice Adjusting Entry Preview 00:14

10.25 Invoice Adjusting Entry Preview 13:57

Excel Download - 10.40 Prepaid Insurance Adjusting Journal Entry Preview 00:14

10.40 Prepaid Insurance Adjusting Journal Entry Preview 08:39

Excel Download - 10.45 Depreciation Adjusting Entry Preview 00:14

10.45 Depreciation Adjusting Entry Preview 10:53

Excel Download - 10.50 Unearned Revenue Adjusting Entry Preview 00:14

10.50 Unearned Revenue Adjusting Entry Preview 10:43

Excel Download - 10.60 Financial Statements Preview 00:14

10.60 Financial Statements Preview 45:31

Excel Download - 10.65 Closing Process February Preview 00:14

10.65 Closing Process February Preview 28:13

Excel Download - 10.300 Accrued Interest Reversing Entry Preview 00:14

10.300 Accrued Interest Reversing Entry Preview 10:20

Excel Download - 10.350 Accounts Receivable Reversing Entry Preview 00:14

10.350 Accounts Receivable Reversing Entry Preview 13:21

Excel Download - 10.550 Unearned Revenue Reversing Entry Preview 00:14

10.550 Unearned Revenue Reversing Entry Preview 09:21