Autoplay
Autocomplete
Previous Lesson
Complete and Continue
The Accountants Excel Toolkit
Section 1: Course Introduction
Introduction to the Course (4:59)
Introduction to the Company (4:28)
DOWNLOAD ME: Exercise Files
DOWNLOAD ME: Course Files
Section 2: Recording Journal Entries
Importing and Formatting Data: XLOOKUP (8:14)
Importing and Formatting Data: GETDATA (5:58)
Importing and Formatting Data: Filtering & Validating Data (8:37)
Introduction to Debit and Credit Entries (5:43)
Journal Entries for Assets and Liabilities (5:48)
Journal Entries for Expenses and Income (5:23)
Introduction to Accruals and Cash Accounting (7:40)
Accounting for Assets (9:57)
Exercise 1 (5:57)
Section 3: Trial Balance and General Ledger
General Ledger Overview (6:07)
Recording Transactions in General Ledger (9:38)
Linking QuickBooks Online and General Ledger (9:54)
Balancing the Trial Balance (7:37)
Accuracy Check for Trial Balance and General Ledger (9:36)
Adjusting Entries (8:07)
Exercise 2 (5:38)
Section 4: Financial Statements (FS)
Overview of the Balance Sheet (9:36)
Overview of the Income Statement (7:40)
Overview of the Cash Flow Statement (9:02)
Adding Formulas and Links to the Financial Statements (9:57)
Ratio Analysis (Part 1 of 2) (9:31)
Ratio Analysis (Part 2 of 2) (9:27)
Decoding Financial Health with Ratios and Analysis (9:29)
Introduction to Forecasting in Excel (9:30)
Exercise 3 (3:41)
Section 5: Bank Reconciliation
Gathering Bank and Company Records (9:07)
Reconciliation Process and Addressing Discrepancies Part 1 (9:24)
Reconciliation Process and Addressing Discrepancies Part 2 (9:07)
Preventing Reconciliation Issues and Best Practices (6:06)
Exercise 4 (8:32)
Closing (4:16)
Course Quiz and Certificate of Completion
Course Quiz and Certificate of Completion
Importing and Formatting Data: GETDATA
Complete and Continue