We may earn an affiliate commission when you visit our partners.
Course image
Excel Mojo

The Financial Modeling Starter Pack (2025 Edition) is the ultimate beginner-friendly program designed to help you master the essential tools and concepts used in real-world financial analysis and investment decision-making.

Begin with the Basic Excel Course, where you'll learn the core skills needed to work confidently with spreadsheets—formatting data, using formulas, sorting and filtering, creating charts, and managing workbooks efficiently.

Read more

The Financial Modeling Starter Pack (2025 Edition) is the ultimate beginner-friendly program designed to help you master the essential tools and concepts used in real-world financial analysis and investment decision-making.

Begin with the Basic Excel Course, where you'll learn the core skills needed to work confidently with spreadsheets—formatting data, using formulas, sorting and filtering, creating charts, and managing workbooks efficiently.

Progress to the Financial Modeling in Excel Course (2025) and start building complete financial models from scratch. Learn how to analyze historical statements, forecast revenues and costs, model depreciation and working capital, and build fully integrated financial statements that actually balance.

Next, dive into valuation with the Fundamentals of Equity Valuation course. Learn key methods used by analysts and investors, including Dividend Discount Models, Free Cash Flow techniques, and valuation multiples like P/E and EV/EBITDA. Understand when and how to apply each method with clarity.

In the Fixed Income Basics course, explore bonds, treasury instruments, and debt markets. Learn how to price fixed income securities, understand interest rate risk, credit risk, and build fixed income portfolios for steady returns and diversification.

Finally, build your capital market knowledge with the Capital Markets Basics course. Understand how primary and secondary markets function, explore key instruments like derivatives and exchange-traded funds or ETFs, and learn about major players like clearing houses, rating agencies, and intermediaries.

Whether you're a student, aspiring analyst, or finance enthusiast, this bundle gives you the skills to get started with confidence.

Enroll now and take the first step toward becoming a financial modeling professional.

Enroll now

What's inside

Learning objectives

  • Build complete financial models using excel from scratch
  • Analyze financial statements and forecast key business drivers
  • Learn core equity valuation methods like ddm and dcf
  • Understand bonds, fixed income pricing, and risk analysis
  • Gain clarity on capital markets, instruments, and participants

Syllabus

Basic Excel Course

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.

Read more

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 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 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.

Save this course

Create your own learning path. Save this course to your list so you can find it easily later.
Save

Activities

Coming soon We're preparing activities for Financial Modeling Starter Pack (2025 Edition). These are activities you can do either before, during, or after a course.

Career center

Learners who complete Financial Modeling Starter Pack (2025 Edition) will develop knowledge and skills that may be useful to these careers:

Reading list

We haven't picked any books for this reading list yet.
Covers advanced topics in financial modeling, including the use of Monte Carlo simulations, optimization techniques, and scenario analysis. It is suitable for those with some experience in financial modeling and those interested in learning more about advanced techniques.
Covers the use of financial models in risk management. It provides a detailed overview of different types of financial risks and the models used to assess and mitigate them. It is suitable for those interested in learning more about financial risk management and the role of financial models in this field.
Covers the use of financial models in corporate finance. It provides a detailed overview of different types of corporate financial decisions and the models used to support these decisions. It is suitable for those interested in learning more about corporate finance and the role of financial models in this field.
Provides a comprehensive guide to building and using financial models in Python. It covers a wide range of topics, from basic concepts to advanced techniques. It is suitable for those with some experience in programming and those interested in learning more about financial modeling in Python.
Is widely considered a foundational text in financial modeling, often used in university settings. It provides a comprehensive overview of financial modeling principles and applications using Excel. It is highly valuable for building a solid understanding of core concepts and is an excellent reference tool.
This practical guide focuses on financial modeling within the context of investment banking and private equity. It is highly relevant for those seeking careers in these fields and provides step-by-step guidance on valuation methodologies. It serves as a useful reference for industry-specific modeling techniques.
Offers a practical approach to constructing financial models, emphasizing good model design and structure. It's beneficial for both beginners and those looking to improve their modeling efficiency and clarity. It provides a strong foundation in the mechanics of building robust models.
An excellent starting point for beginners, this book introduces financial modeling concepts using Microsoft Excel. It's highly practical with hands-on exercises, making complex topics accessible. It is particularly useful for those with limited prior finance or Excel experience.
Focuses on mastering financial modeling specifically within the Excel environment. It covers various techniques and best practices for building effective models. It valuable resource for those who rely heavily on Excel for their financial analysis.
A well-balanced book that covers both concepts and applications for intermediate to advanced users. It delves into designing, structuring, and building accurate and understandable models. is valuable for those looking to deepen their practical modeling skills.
This McKinsey & Company classic focuses on valuation principles, which are integral to financial modeling. It provides a rigorous framework for valuing companies and understanding the drivers of value. It key resource for anyone involved in corporate finance and valuation.
Combines financial analysis and modeling with the use of Excel and VBA. It's suitable for those who want to leverage the power of VBA for more advanced modeling and automation. It bridges the gap between theoretical concepts and practical implementation in Excel.
Tailored for business owners and entrepreneurs, this book connects financial modeling with business planning and decision-making. It provides practical methods for building models relevant to startups and small businesses. It's a great resource for those in entrepreneurial roles.
Provides a comprehensive guide to financial modeling in both corporate and project finance contexts. It includes case studies and practical exercises, making it valuable for those focusing on project finance modeling. It covers complex topics with a clear approach.
A concise and practical introduction to financial modeling in Excel, focusing on core concepts and structures. It's suitable for beginners and those looking for a focused guide on essential modeling techniques in Excel.
Offers a hands-on approach to long-term financial forecasting and analysis, with an emphasis on incorporating uncertainty. It's valuable for those involved in strategic planning and forecasting. It provides a framework for building robust forecasting models.
A fundamental book for understanding financial statements, which are the basis for financial modeling. It provides essential prerequisite knowledge for building accurate and insightful models. It's highly recommended for beginners in finance.

Share

Help others find this course page by sharing it with your friends and followers:

Similar courses

Similar courses are unavailable at this time. Please try again later.
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser