
This video shows how to launch Excel and introduces learners to the Excel interface.
This video provides a clear understanding of the structure of an Excel workbook, how to open and save Excel documents, and common Excel shortcuts.
This video explains how to format cells with the help of examples.
This video helps develop a practical understanding of number and date formatting.
This video explains how to use basic Excel functions, like SUM, COUNT, and AVERAGE
This video provides a clear understanding of how to work with named ranges.
This video provides practical knowledge of AutoFilter in Excel.
This video explains how one can work with column charts.
This video shows how to format charts in Excel.
This video provides a practical understanding of how to use a pie chart.
This video explains how to insert images and shapes in a worksheet.
This video explains the process of printing worksheets.
This video explains how to build the structure of a financial model.
This video explains the second step of the financial modeling process, which involves conducting an analysis of historical financial statements.
This video explains how to forecast the growth of a company in terms of revenue step-by-step.
This video provides a practical understanding of cost projection, which is the fourth step of financial modeling in Excel price.
This video explains how to project depreciation accurately, which is essential to ensure that the financial model reflects the real value of the assets.
This video provides a clear understanding of how to project working capital accurately.
This video explains step #7 of the financial modeling process, which involves completing the cash flow statement.
This video explains how one can handle debt projections with precision.
This video shows the last step, i.e., step #9 of the financial modeling process, which involves balancing the balance sheet.
This video provides a brief understanding of different topics related to equity valuation, like market price and intrinsic value, to build a strong foundation.
This chapter discusses the cost of debt, the cost of equity, and the weighted average cost of capital (WACC).
This video dives into the Gordon Growth Model, which helps determine the intrinsic value of a stock where the dividend increases at a constant rate.
In this video, the instructor explains the dividend discount model, which involves using a combination of these concepts: Beta, average cost of capital, cost of debt and the Gordon growth model.
This video explains how to compute the present value of all the dividends forecasted in the forthcoming years.
This video discusses the free cash flow to equity model, which involves determining the value of a company on the basis of the free cash flows available to equity shareholders.
This video dives into the concept of Free Cash Flow to the Firm. It talks about the cash available from all sources of capital raised by a company.
This video talks about the two main ratios that are part of the multiplier model, which are the Price to Earnings or P/E ratio and the Enterprise Value to EBITDA ratio.
This video explains the asset-based models, which are used for companies that are going to be liquidated or banks in which tangible values and fair values are close.
This video explains what is fixed income and how fixed income instruments differ from other financial instruments.
This video explores the different fixed income instruments available for investment. Some examples are bonds, treasury bills, and treasury notes.
This video dives in to the key differences between fixed income instruments and variable income securities.
This video looks shows the formula to compute the price of fixed income instruments, like bonds. From the formula, one can get a clear idea regarding the factors on which the price of a bond depends. It also provides a clear idea regarding discount, par, and premium bonds.
This video explains how individuals can create a portfolio comprising fixed income instruments.
This video explores the different kinds of risks associated with fixed income securities. A few examples of such risks are call risk, liquidity risk, and credit risk.
This video dives into the benefits offered by fixed income instruments, for example, sustainable returns and portfolio diversification.
This video dives into the benefits offered by fixed income instruments, for example, sustainable returns and portfolio diversification.
This video explains the meaning and importance of analyzing fixed income securities.
This video dives into the different elements that individuals must factor in when carrying out the analysis of fixed income instruments. Some of these elements are credit risk analysis, interest rate risk analysis, and liquidity risk analysis.
This video looks back at the different concepts covered in the course.
This video introduces learners to the concept of capital markets and explains how they differ from money markets.
This chapter explains why companies are publicly listed with the help of an example and gives an overview of the Securities and Exchange Commission. Later, it also, dives into the different financial instruments available in capital markets.
This chapter explores the different types of capital markets — primary market and secondary market. Moreover, it dives into the subtypes of secondary markets.
This chapter explores the different types of capital markets — primary market and secondary market. Moreover, it dives into the subtypes of secondary markets.
This chapter explores the different types of capital markets — primary market and secondary market. Moreover, it dives into the subtypes of secondary markets.
This chapter dives into securities markets and the noteworthy market participants, like clearing houses and credit agencies.
This video shows the differences between securities and derivatives in detail.
This video explains the butterfly effect and shows key statistics related to global capital markets
This video provides a clear understanding of the different types of financial intermediaries and their roles.
Are you looking to build strong foundations in financial modeling, valuation, Excel, and finance concepts for analyst and finance careers?
This beginner-friendly Financial Modeling Starter Pack is designed to help you learn practical financial modeling in Excel, valuation techniques, fixed income concepts, and capital markets fundamentals through a structured and easy-to-follow learning approach.
Whether you are a finance student, aspiring financial analyst, MBA student, Excel beginner entering finance, or someone interested in valuation and business analysis, this course is designed to help you build practical finance and analytical skills step-by-step.
Unlike many advanced financial modeling programs that assume prior finance knowledge, this course begins with Excel fundamentals. Gradually, it progresses into financial modeling, valuation, fixed income, and capital markets concepts.
The course starts with practical Microsoft Excel fundamentals commonly used in finance and analytical workflows.
You’ll learn the Excel interface, workbook structure, and essential worksheet formatting techniques. The course covers basic Excel functions, named ranges, sorting, and filtering tools. You’ll also create charts, visualizations, and professional Excel reports with confidence.
Additionally, you’ll understand printing workflows and formatting practices for organized and presentation-ready worksheets.
As the course progresses, you’ll move into one of the core sections of the program: financial modeling in Excel.
You’ll learn a practical 9-step financial modeling process, including:
Structuring the financial model
Analyzing historical financial statements
Projecting revenues
Estimating costs
Forecasting depreciation
Working capital projections
Cash flow statement preparation
Debt projections
Balancing the balance sheet
The course focuses on helping you understand how integrated financial statements work together in practical financial modeling workflows.
You’ll also build strong foundations in valuation concepts and financial analysis techniques.
The course covers:
Intrinsic valuation concepts
Cost of capital
Cost of debt
Cost of equity
Weighted average cost of capital or WACC
Gordon Growth Model
Dividend Discount Model or DDM
Free Cash Flow to Equity (FCFE)
Free Cash Flow to Firm (FCFF)
Multiplier valuation models
Asset-based valuation approaches
In addition to financial modeling and valuation, the course introduces fixed income investing concepts, like fixed income instruments, risks associated with such financial instruments, and how to construct a fixed income portfolio.
The program also helps develop a practical understanding of capital markets and financial systems. It includes lectures on capital market fundamentals, primary and secondary markets, securities markets, derivatives overview, and more.
Throughout the course, the learning approach remains highly structured and beginner-friendly. You’ll work through practical Excel exercises, financial modeling workflows, valuation examples, finance concepts, and analytical finance topics designed to help you build stronger finance and financial analyst foundations.
Whether you are a finance student, an MBA student, or an aspiring financial analyst, this course is designed for you. It is also suitable for beginners learning financial modeling and Excel users entering the finance industry. Working professionals can strengthen practical finance, valuation, and financial modeling skills through structured industry-relevant workflows.
By the End of This Course, You Will Be Able To
Build structured financial models confidently in Excel
Understand integrated financial statement workflows
Apply practical valuation concepts and financial analysis techniques
Analyze revenues, costs, cash flows, and debt projections
Understand fixed income and capital market fundamentals
Work more confidently with Excel in finance environments
Build stronger finance and analytical foundations for professional growth
Understand key concepts used in financial analysis and valuation workflows
What Makes This Course Different
Combines Excel, financial modeling, valuation, fixed income, and capital markets in one structured program
Ensures beginner-friendly progression, from Excel basics to finance concepts
Covers practical 9-step financial modeling workflows in Excel
Includes valuation methods commonly used in finance and equity analysis
Helps learners build stronger finance and analytical foundations
Includes a structured learning approach, which is suitable for beginners and aspiring analysts
Covers both practical Excel workflows and finance concepts together
About the Course Director
The course structure and learning experience have been designed under the guidance of Dheeraj Vaidya — CFA, FRM charterholder, Co-Founder of WallStreetMojo and ExcelMojo, and alumnus of IIT and IIM.
As the course director, he oversaw the course structure, curriculum design, and overall learning flow of the program. His focus was to ensure the course remains practical, structured, and industry-oriented with strong reporting and analytical relevance.