課程介紹

**Updated for February 2021!**

Do you want to learn how to use Excel in a real working environment?

Are you about to graduate from university and start looking for your first job? 

Are you a young professional looking to establish yourself in you

…[更多細節]

哪些人適合這堂課？

• Graduate students who aspire to become investment bankers, financial advisory professionals, consultants etc.
• Business and finance practitioners who are eager to improve their Excel and Financial Modeling skills

學習目標

• Master Microsoft Excel and many of its advanced features
• Become one of the top Excel users in your team
• Carry out regular tasks faster than ever before
• Build P&L statements from a raw data extraction
• Build Cash Flow statements
• Discover how to value a company
• Build Valuation models from scratch
• Create models with multiple scenarios
• Design professional and good-looking advanced charts

課程介紹

Reasons why you should create a financial model for your startup or small business.  A good financial model can help you:

Test your assumptions and verify key drivers of your business

Compare and contrast different business choices, like pricing mo

…[更多細節]

哪些人適合這堂課？

• Someone who wants to understand how to create a financial model for a startup business
• Someone who wants to start a new business
• Someone who wants to leverage financial modeling to make better business decisions
• Someone who wants to better analyze business opportunities
• Someone interested in doing a startup and plan on raising VC funding
• Someone interested in starting a brick & mortar business

學習目標

• Build financial models for your startup business
• Forecast cash needs for your startup business
• Model user growth
• Model revenue
• Model expenses
• Model attrition
• Model various different business models, from tech to brick & mortar
• Use best practices for financial modeling

課程介紹

Would you like to learn how to value a company?

Even people who don’t have a Finance degree can take this course and learn how to build a complete Discounted Cash Flow Model! 

Attention! You will have to go through the videos and the course materi

…[更多細節]

哪些人適合這堂課？

• Aspiring Investment Bankers
• Graduates who pursue a career in Corporate Finance
• Professionals who would like to deepen their Valuation skills

學習目標

• Be able to build a Cash Flow statement
• Know how to value a company
• Be able to build a Valuation model from scratch
• Know how to create a model with multiple scenarios
• Be able to perform sensitivity analysis
• Know how to create professional and good-looking advanced charts

課程介紹

Arun Mohan – 5 Stars

“The experience was an enlightening one as I was a novice in Finance and Excel and this Class was best fit for me. I could understand everything as the instructor took time to explain at a good pace and patiently introduced exce

…[更多細節]

哪些人適合這堂課？

• Meant for students who want to become proficient in financial model but have little to no experience in Finance and/or EXCEL.
• Want to learn financial modeling without worrying about whether they’re learning unnecessary stuff
• Want to learn from instructors who have relevant industry experience who understands the concepts AND knows what is relevant in practice
• People who want to learn Financial Modeling from accessible instructors

學習目標

• Understand the essentials of financial modeling using Excel
• Understand the financial modeling process
• Be able to build their first financial forecast model in Excel
• Be able to build their first financial reporting model in Excel
• Be able to build their first financial decision making model in Excel
• Be proficient in financial model design
• Understand core concepts in finance
• Know the business of lemonade stands inside out!

課程介紹

Say hello to Financial Analysis done right. You’ll master sophisticated investment analysis and portfolio management techniques that are rigorously grounded in academic and practitioner literature.

Explore and master powerful relationships between s

…[更多細節]

哪些人適合這堂課？

• ACA, ACCA, CFA®, other Professional students
• Ivy League / Russell Group University students
• Finance Managers keen on applying conceptual techniques including portfolio design.
• Investors wanting to work with techniques that are rigorously grounded in academic and practitioner literature.
• Analysts, and aspiring Investment Bankers wanting to gain a solid foundation in investment analysis.
• Anyone who wants to learn investment analysis and portfolio management!

學習目標

• Calculate stock returns manually as well as on Excel and Google Sheets, using real world data obtained from free sources.
• Estimate the Expected Returns of Stocks using the Mean Method, State Contingent Weighted Probabilities, as well as Asset Pricing Models.
• Calculate the total risk, market risk, and firm specific risk of stocks from scratch, and explore how the different risks interact.
• Understand why the math works, and why equations work the way they do – even if your math is weak and if math freaks you out.
• Witness the power of diversification and how the risk of your portfolio can be lower than the individual assets that make up the portfolio!
• Measure your investment portfolio’s performance by calculating portfolio returns and risks.
• Optimise your portfolios by maximising your returns while minimising your risk.

課程介紹

Want to learn how to build professional, dynamic, institutional-quality real estate pro forma models in Microsoft Excel? This course will take you by the hand and walk you step-by-step through the entire process. This is a project-based course, meani

…[更多細節]

哪些人適合這堂課？

• Real estate investors and professionals who want to learn how to create dynamic, institutional-quality real estate pro forma models from scratch
• Aspiring real estate investment professionals who want to begin a lucrative career in private equity real estate
• Single-family home and duplex investors who are looking to go bigger with their investment properties and want to have the skill set to confidently analyze return projections on big deals

學習目標

• Learn how to build dynamic, institutional-grade real estate pro forma investment models from scratch
• Learn how to build customizations and triggers to maximize flexibility for any investment scenario
• Learn how to create institutional, professionally formatted models to present pro forma calculations to investors and partners

課程介紹

What is the aim of this course?

As a business analysts or a consultant you will have to from time to time create financial models. There are a bit different than business models. In business models you go into details of operations and you focus on

…[更多細節]

哪些人適合這堂課？

• Business analysts
• Researchers
• Controllers
• Consultants
• Small and medium business owners

學習目標

• You will master financial modeling in Excel at the needed for business analysts and consultants level
• Understand the main challenges in financial modelling
• Perform the analyses of financial models
• You will get ready models that you can utilize for your purposes
• Model your business in Excel
• Estimate the value of your business

課程介紹

Want to work on project finance and infrastructure deals?
Want to break into private equity? Show you can build “complex financial models from scratch”?
Want to make a quantum leap in your financial modeling skills?
Want to learn Excel VBA and other 

…[更多細節]

哪些人適合這堂課？

• Students and young professionals interested in infrastructure finance!

學習目標

• Build an advanced financial model to analyse project finance & infrastructure deals
• Understand distinguishing features of project financing
• Use Excel VBA to solve common financial modelling problems

課程介紹

Are You An Entrepreneur or Small Business Owner?

Do You Want To Build a Financial Budget But Don’t Know Where To Start? 

Do You Want To Impress Potential Investors From The Start With Your Business Model?

Do You Want To Set Realistic Expectations

…[更多細節]

哪些人適合這堂課？

• Entrepreneurs
• Startup Companies
• Financial Modelers
• Bookkeepers
• CFO’s & CEO’s
• Excel Users
• Anyone who wants to learn financial modeling

學習目標

• Learn From A Top Rated Instructor Who Has Been Teaching On Udemy Since 2013 and Taught Over 100,000 Students!
• Template Download: Download The Model At The End Of The Course
• Create a Financial Model From Start To Finish
• Formulas Used
• Properly Framing Assumptions
• Establishing a Forecasted Income Statement
• Establishing a Forecasted Balance Sheet
• Establishing a Forecasted Statement of Cash Flow
• Forecast Your Inventory Needs
• Summary Report Creation With Highlights From The Model
• Pitfall Avoidance – What Not To Do
• How to Properly Structure a Financial Model
• How to Tie Out Your Model
• Create Realistic Financial Projections
• Create Best/Worst Case Scenario Analysis

課程介紹

Want to work on RENEWABLE ENERGY deals in WIND and SOLAR power?
Want to be part of the global shift to renewable energy? 
Want to break into a sector that is expected to have $10TRILLION poured into it through 2040? 

THIS is the course for YOU!

Go

…[更多細節]

哪些人適合這堂課？

• Students and young professionals interested in supporting commercial and financial deals for solar and wind power plants!

學習目標

• The fundamentals of a power plants’ business, and their key value drivers
• How to model a plant’s cashflow performance in Excel
• How to use this model to assess financing and commercial options for the plant and how they affect its value!