eCourse Site

[Udemy] Excel Accounting 2–Worksheet, Opening Balances, & Subledger

Deal Score0
100% OFF Get Course
Deal Score0
100% OFF Get Course

What you’ll learn

  • How one can create an accounting system in Excel
  • How one can enter starting account balances into a brand new accounting system
  • How one can navigate Microsoft Excel
  • How one can enter starting balances for stock and create an accompanying subsidiary ledger


  • None – When you shouldn’t have entry to Microsoft Excel you should utilize Google Sheets or one other digital spreadsheet program


On this course we’ll create an accounting system ranging from a clean Excel worksheet and add begging balances to our accounts.

Learners will discover ways to navigate Microsoft Excel in addition to find out how to create a well-designed accounting worksheet, full with a normal journal, trial steadiness, normal ledger, and subsidiary ledgers for accounts receivable, accounts payable, & stock.

Excel is an excellent software to study accounting as a result of it’s way more clear than a database program, like accounting software program, QuickBooks being a typical instance of accounting software program.

For many new steps within the course of, you should have entry to a downloadable Excel Workbook, containing no less than two tabs, one with the reply, the brand new steps being accomplished, the opposite beginning out the place the prior presentation left off.

As soon as our accounting system utilizing an Excel worksheet is about up, we’ll add journal entries to enter starting balances to our accounts, imagining we’re shifting from a previous accounting system to our new Excel worksheet system.

When including the start stock steadiness to the chart of accounts, we will even add a list subsidiary ledger, reporting stock by merchandise and unit, in addition to by value.

Who this course is for:

  • Anyone who needs to study accounting
  • Anyone who needs to study Microsoft Excel

Check Today's 30+ Free Courses on Telegram!

eCourse Site