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
Adding Formulas and Links to the Financial Statements
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock