Excel Financial Modelling Course + Virtual Work Experience
The Complete Excel Financial Modelling Course
Welcome to the most comprehensive Financial Modelling program available online. Where we'll go through everything you'll need step-by-step and follow along via excel work sheets. Embark on a virtual work experience program and experience the day-to-day of an Investment Banking Analyst and Associate
Your Instructor
The team of 13 Investment Bankers from elite bulge bracket bank to specialist Mergers and Acquisition Boutique bank. A combine deal experience spanning well above $3bn+ within technology, Financial, Consumer Brand, Healthcare and commercial real estate.
Course Curriculum
Introduction
Available in
days
days
after you enroll
Excel Mastery
Available in
days
days
after you enroll
-
StartOverview (8:14)
-
StartUsing the keyboard (6:00)
-
StartExcel settings (5:09)
-
StartBasic excel shortcuts & navigations (10:38)
-
StartBasic formatting (5:57)
-
StartReferencing cells in worksheet (6:24)
-
StartReferencing cells in workbook (1:13)
-
StartFreezing & Splitting Pans (5:32)
-
StartEditing Cells (3:27)
-
StartInserting Rows & Columns (7:51)
-
StartPaste Special (7:04)
-
StartEssential Control Shortcuts (2:05)
-
StartCell Name (4:32)
-
StartAnchoring Cells (5:48)
-
StartWorksheet (0:43)
-
StartGrouping (4:37)
-
StartAuditing Cells (4:15)
-
StartCenter Alignment (2:54)
-
StartGo To Special (1:45)
Essential Accounting
Available in
days
days
after you enroll
-
StartIncome Statement (37:01)
-
StartBalance Sheet Asset Side (31:28)
-
Start03-Balance Sheet Liability & Shareholder Equity (45:20)
-
Start04-Cash flow Statement (40:38)
-
Start05-Linking The Three Financial Statement (30:39)
-
Start06-Practice Model Overview (10:49)
-
Start07-Walk-through of Fin-Statement (5:43)
-
Start08-Depreciation (6:40)
-
Start09-Inventory Change Cash vs Debt (8:56)
-
Start10-Inventory LIFO vs FIFO (15:42)
-
Start11-Accrued Expense (8:56)
-
Start12-Accrued Revenue (6:12)
-
Start13-Deferred Income Taxes (7:44)
-
Start14-Dividend
-
Start15-Issue Repurchase shares (11:32)
-
Start16-Raising & Paying off Debt (6:47)
-
Start17-Equity, Debt Bailout (9:32)
-
Start18-Goodwill Impairment (6:05)
-
Start19-Writing Down Debt (7:23)
-
Start20-iPhone Factories Debt Part-1 (5:59)
-
Start21-iPhone Factories Debt Part-2 (8:03)
-
Start22-iPhone Factories Debt Part-3 (10:56)
-
Start23-Making iPhones Part-1 (3:40)
-
Start24-Making iPhones Part-2 (6:48)