Become a Pro in Excel: Financial Modeling and Valuation

Beginner to Pro in Excel : Financial Modeling and Valuation

What you'll learn

Financial Modeling Office Hour : What is Financial Modeling and A Sample Model
Financial Modelling Office Hour : Understanding and computing financial ratios
Financial Modelling Office Hour : Mastering and Automating Cash Sweep
Financial Modeling Office Hour : How to create guage/speedometer and waterfall charts in Excel
Financial Modeling Office Hour: Creating the general ledger, trial balance & financial statements

Requirements

Basic knowledge of excel
A computer system or phone
Internet connection

Description

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

Are you about to be a graduate and start looking for your first job?

Or are you a professional young man or woman looking for a way to establish yourself in your new position ahead of others?

Would you like to become your team's best and go-to person when it comes to Financial Modeling in Excel?

Then if your answer is yes to any of these questions above, then I want you to know that this is the right course for you!

The instructor of this course has extensive experience in Financial Modeling:

He has Worked in the Financial advisory unit of a top consulting firms.

Experience in transactions carried out in different countries

Worked in the in-house Mergers & Acquisitions department of a large multinational corporation

He has also been a financial advisor in multiple M&A deals with different firms and occasions.

Worked on company valuations, due diligence analysis, impairment tests, bankruptcy proceedings, cash flow analysis, and more.

Learn the subtleties of Financial Modeling from someone who has walked the same path. Beat the learning curve and stand out from your colleagues.

A comprehensive guide to Financial Modeling in Excel:

Become an Excel expert
Learn how to build sound Financial Models and stand out among your colleagues
Gain an in-depth understanding of the mechanics of Company Valuation
Build your files professionally
Demonstrate superior Excel skills at work
Be prepared from day one for your Investment Banking, Financial Advisory or Consulting career

What this course offers:

* A Well-designed and easy-to-understand materials
* Detailed explanations with comprehensive case studies based on real situations
* Downloadable course materials

By completing this course, you will:

* Be able to work comfortably with Microsoft Excel and many of its advanced features
* Become one of the top Excel users in your team
* Be much quicker at carrying out regular tasks
* Be able to build a P&L statement from a raw data extraction
* 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
* Know how to create professional and good-looking advanced charts

Who this course is for:

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
Those who wants to take their excel knowledge to the advanced level
Those who wants to stand out amongst their colleagues