What you’ll 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 bank 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
