Learn How to Create an Accounting Worksheet Using Microsoft Excel from a Certified Public Accountant (CPA)
What you will learn:
How to navigate Microsoft Excel or other computerized spreadsheet like Google Sheets
How to create an accounting system in Excel from a blank worksheet including a general journal, trial balance, general ledger, subsidiary ledgers and more
How to enter journal entries related to common transactions and list the data input forms often used to enter them into accounting software like QuickBooks
How to enter two months worth of data input into our accounting system
How to do two month of back reconciliations, comparing the process to how accounting software like QuickBooks would accomplish the task
How to enter period end adjusting journal entries
Create financial statements
Enroll Here:
What you will learn:
How to navigate Microsoft Excel or other computerized spreadsheet like Google SheetsHow to create an accounting system in Excel from a blank worksheet including a general journal, trial balance, general ledger, subsidiary ledgers and moreHow to enter journal entries related to common transactions and list the data input forms often used to enter them into accounting software like QuickBooksHow to enter two months worth of data input into our accounting systemHow to do two month of back reconciliations, comparing the process to how accounting software like QuickBooks would accomplish the taskHow to enter period end adjusting journal entriesCreate financial statementsEnroll Here: