Companies Home Search Profile

Create Excel Accounting Worksheet, Enter Opening Balances, & Add Subledgers

Focused View

Robert Steele

2:27:06

14 View
  • 01 Introduction.mp4
    01:36
  • 02 Create General Journal.mp4
    10:15
  • 03 Create Trial Balance.mp4
    15:17
  • 04 Create General Ledger.mp4
    10:15
  • 05 Finish General Ledger.mp4
    12:57
  • 06 Inventory & Inventory Subsidiary Ledger.mp4
    25:17
  • 07 Accounts Receivable & Subsidiary Ledger.mp4
    12:11
  • 08 Accounts Payable & Subsidiary Ledger.mp4
    09:02
  • 09 Financial Statements.mp4
    19:06
  • 10 Add New Accounts & Opening Balances.mp4
    20:42
  • 11 Adjust Beginning Balances in Worksheet for Current Period Data Input.mp4
    10:28
  • Exercise Files.zip
  • Description


    This course is project-based. Learners will create a new accounting system using an Excel workbook. You may also use another electronic spreadsheet like Google Sheets.

    We will build a general journal, a general ledger, a trial balance, and subsidiary ledgers. We will then add beginning balances into our new accounting system.

    What You'll Learn?


      • Business
      • Accounting
      • Excel
      • Accounting Basics
      • Accounting & Excel

    More details


    User Reviews
    Rating
    0
    0
    0
    0
    0
    average 0
    Total votes0
    Focused display
    Robert Steele
    Robert Steele
    Instructor's Courses
    Skillshare is an online learning community based in the United States for people who want to learn from educational videos. The courses, which are not accredited, are only available through paid subscription.
    • language english
    • Training sessions 11
    • duration 2:27:06
    • English subtitles has
    • Release Date 2024/02/24