Course Overview
Financial Modeling Course you're interested in, with 5 courses and over 22+ hours of tutorials, is a great way to build your expertise in financial analysis, forecasting, and valuation models. This type of course typically covers topics like
Core Coverage
Financial Modeling Training Certification is an awesome bundle of 5 courses, Projects with 22+ hours of Financial Modeling video tutorials.Through this course, we are going to focus on Financial Modeling in Excel from scratch. It covers Basic & Advanced Excel, Accounting, Financial Modeling in Tesla company case study.
Eligibility
- Anyone serious about learning Financial Modeling and wants to make a career in this Field
- Anytime, Anywhere Access: Learn at your own pace, wherever you are
- Verifiable Certificates: Earn certificates for course completion
Financial Modeling Course Curriculum
Basic Excel Training
Available in
days
days
after you enroll
- accessing MS Excel new (2:41)
- MS Excel Startup Screen (2:27)
- Understanding the Ribbon (3:03)
- Cells in Excel (1:18)
- Worksheet Essentials (3:10)
- Saving the File (1:14)
- Formatting Cells (14:23)
- Custom Cell Styles (6:12)
- Custom Number Formatting in Excel (11:39)
- More on Custom Number Formatting (10:59)
- Custom Formats of Data (13:33)
- The BEDMAS Order of Mathematical Operations (9:04)
- Mathematical Operations without Functions new1 (9:43)
- IF Function (10:32)
- Mathematical Operations without Functions Continued (11:38)
- More on IF Function (8:25)
- Importing Data and Calculations (10:46)
- Working with the Count Function (12:40)
- Conditional Counts - CountIF Function (4:58)
- Working with the Sum Function (14:02)
- Finding the Average (11:17)
- Conditional Average - Average IFS Function (8:31)
- Finding the Maximum Value Using the MAX Function (8:36)
- Finding the Minimum Value Using the MINFS Function (8:04)
- Determining Proportions and Updating a Calculation (10:06)
- Conditional Formatting new1 (18:24)
- More on Conditional Formatting (7:47)
- Working with Tables (13:03)
- Formatting Table (13:31)
- Filtering and Sorting of Data (9:40)
- Freeze and Split (11:18)
- Printing and Layouts in Excel (9:51)
- Pivot Tables (7:50)
- Creating Custom Tables (8:58)
- Organizing Pivot Tables (8:35)
- Column Chart (10:32)
- Bar Chart (8:03)
- Line Chart (14:24)
- Pie Chart (10:27)
- Map Chart (6:46)
- Common Errors in Excel (11:12)
- More on Common Errors (13:42)
- Conditional Formatting (9:47)
- Mathematical Operations without Functions (9:43)
Advanced Excel Training 2019
Available in
days
days
after you enroll
- Logical Function - IF new (8:21)
- AND OR and XOR Functions (8:48)
- IFS Function - Example 1 (6:25)
- IFS Function - Example 2 (9:02)
- SWITCH Function (10:17)
- Other Logical Functions (8:20)
- Information Functions - ISBLANK ISERR ISERROR ISEVEN ISODD ISTEXT (10:49)
- Date Functions - TODAY DAY (9:36)
- MONTH YEAR WEEKDAY WEEKNUM Functions (11:23)
- EDATE and EOMONTH Functions (8:38)
- YEARFRAC Function (7:19)
- Joining Data using CONCAT and TEXTJOIN (9:59)
- LEN FIND LEFT RIGHT TRIM (10:26)
- Using UNIQUE and TRANSPOSE (11:27)
- TEXT Function (10:00)
- CHOOSE Function (10:46)
- More on CHOOSE Function (6:34)
- VLookUp Function (12:47)
- HLOOKUP Function (5:12)
- Index Function (10:31)
- Match Function (9:24)
- XLOOKUP and XMATCH Functions (8:43)
- Using the OFFSET Function (8:49)
- OFFSET Function - Total and Average Score (9:29)
- OFFSET Function - Highest and Lowest Score (8:57)
- OFFSET Function - Year to Month Sales (11:01)
- OFFSET Function - Quarterly and Half-Month Sales (6:39)
- Naming of Cell (12:30)
- Naming a Range (10:01)
- Text to Columns (6:35)
- Grouping Tabs and Subtotal Function (12:47)
- Working with Hyperlinks (11:17)
- Data Validation (11:00)
- Data Validation Continued (11:14)
- Custom Data Validation (12:17)
- Generating Random Numbers (6:10)
- Custom Views (10:34)
- Protecting Worksheet and Workbook (17:36)
- PivotTable - Advanced Features (10:02)
- More on Advanced Features (6:50)
- Slicers and Timelines (6:43)
- Solver (11:37)
- Data Tables (10:42)
- More on Data Tables (9:53)
- Goal Seek (8:43)
- Combo Charts (13:51)
- More on Combo Charts (12:11)
- Sparklines (8:10)
- Waterfall Chart (9:37)
- Box Chart (12:48)
- Whisker Chart (11:29)
- TreeMap and Sun Burst Charts (11:53)
- Radar Chart (7:55)
- Scroll Bar (10:00)
- Spin Button and Radio Button (10:52)
- Form Control Application (10:01)
- Form Control Application Continued (5:32)
- Data Entry Form (3:44)
- Logical Function - IF (8:20)
Accounting - The Foundation
Available in
days
days
after you enroll
- An Introduction To Financial Accounting (0:48)
- Purpose Of Financial Statements (3:16)
- Explaining A Business Cycle (2:16)
- Accounting For Income Statement (9:31)
- Accounting For Balance Sheet 1 (7:47)
- Accounting For Balance Sheet 2 (9:53)
- Accounting For Balance Sheet 3 (6:24)
- Accounting For Cash Flows (5:20)
- Conclusion (0:28)
Accounting 01 - Income Statement
Available in
days
days
after you enroll
- Financial Statements - Fiscal Year Vs Calendar Year new (6:34)
- Income Statement Format new (8:23)
- Calculating Profit Margins new1 (2:33)
- Non Recurring Items new (9:10)
- Changes In Accounting Estimates new (3:00)
- Final Remarks new (3:09)
- Revenue Recognition Percentage Completion and Completed Contract new (11:30)
- Revenue Recognition Installment Method and Cost Recovery new (6:22)
- Depreciation Expense x (10:40)
- Downloading Colgates Income Statement new (12:21)
- Analyst Format Of Colgate-S Income Statement (3:17)
- Formatting The Income Statement (2:39)
- Investigating The Non-Recurring Charges (4:58)
- Seperating non-recurring Items (7:07)
- Comparision Of Margins - Before And After Adjustments (3:34)
Financial Modeling Tesla
Available in
days
days
after you enroll
- Tesla Unveiled (4:05)
- Analyzing Teslas Sales Performance (2:23)
- Sourcing Historical Data (6:01)
- Navigating Teslas Annual Report (3:38)
- Consolidated Financial Statements
- Historical Revenue Growth Rate (3:02)
- Projecting Teslas Revenue (17:38)
- Color-Coding in Financial Models (2:53)
- Projecting Cost of Sales (18:07)
- Forecasting Operating Expenses (9:07)
- Working Capital Ratios (7:14)
- Working Capital Projections (12:21)
- Calculating Proportion of Assets (5:47)
- CAPEX Projections (3:31)
- CAPEX Distribution (2:21)
- Using TRANSPOSE Function (4:14)
- Calculating Machinery and Equipment Depreciation (8:38)
- Completing Ending Net PPE (9:04)
- Common Stock Calculations (5:16)
- Retained Earnings Calculations
- Net Income Attributable to Non-Controlling Interests
- Provision for Income Taxes (8:21)
- Cash Flow Statement (14:11)
- Balance Sheet Linkages (9:09)
- Completing cash Flow Linkages (11:59)
- Cash Available for Debt Repayment (3:03)
- Long-Term Debt Payments (6:48)
- Income Statement Linkages (11:52)
- FCFF Calculations (4:19)
- Understanding WACC (4:57)
- WACC Calculations (12:08)
- Terminal Value Explained (7:19)
- NPV Calculation Steps (13:14)
- Target Share Price Calculations (5:51)
- Sensitivity Analysis (7:13)
- Weighted Average Number of Shares (12:11)
- Basic & Diluted EPS (5:13)
- EBITDA Calculations (3:57)
- Tesla Ratio Analysis (16:26)
Check your inbox to confirm your subscription