Beginner to Pro in Excel - Financial Modeling and Valuation, Certificate

Beginner to Pro in Excel - Financial Modeling and Valuation, Certificate

  • Application Deadline
  • 2 days
    Duration
Get Up to 90% Off! The Beginner to Pro in Excel - Financial Modeling and Valuation course offered by Udemy is suitable for graduates who aspire to become investment bankers as it includes a well-structured DCF model and goes through the theoretical concepts behind it. 

About

The Beginner to Pro in Excel - Financial Modeling and Valuation Beginner to Pro in Excel - Financial Modeling and Valuation course offered by Udemy Udemy will help you to be more confident when coping with daily tasks and will provide you with an edge when the firm must decide whether to confirm you for a full-time position.

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

  • Worked in the Financial advisory unit of a top-tier consulting firm
  • Experience in transactions carried out in Italy, Germany, Switzerland and Poland
  • Worked in the in-house Mergers & Acquisitions department of a large multinational corporation
  • Financial advisor in multiple M&A deals with sizes ranging from €2 million up to €5 billion
  • Worked on company valuations, due diligence analysis, impairment tests, bankruptcy proceedings, cash flow analysis, etc.

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

What Will I Learn?

  • 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

Detailed Programme Facts

  • Deadline and start date Application deadline and start date were not specified by the programme.
  • Programme intensity Part-time
    • Average part-time duration 2 days
    • Duration description

      8 hours on-demand video

  • Languages
    • English
  • Delivery mode
    Online

Programme Structure

Courses include:
  • Introduction to Excel 
  • Useful tips and tools for your work in Excel 
  • Keyboard shortcuts in Excel 
  • Excel's key functions and functionalities made easy 
  • Financial functions in Excel 
  • Microsoft Excel's Pivot Tables in Depth 
  • Case study - Building a complete P&L from scratch in Excel 
  • Case Study - Building an FMCG Model from Scratch 

Audience

  • 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

English Language Requirements

This programme requires students to demonstrate proficiency in English.

Academic Requirements

  • Microsoft Excel 2010, Microsoft Excel 2013, or Microsoft Excel 2016

Tuition Fee

  • International Applies to you

    195 EUR/full
    Tuition Fee
    Based on the original amount of 195 EUR for the full programme and a duration of 2 days.
  • EU/EEA Applies to you

    195 EUR/full
    Tuition Fee
    Based on the original amount of 195 EUR for the full programme and a duration of 2 days.
We've labeled the tuition fee that applies to you because we think you are from and prefer over other currencies.
Udemy continuously offers discounts up to 90% off with full lifetime access to the course. Check the discounts available by clicking "Visit Programme Website".

Funding

Check the programme website for information about funding options.

StudyPortals Tip: Students can search online for independent or external scholarships that can help fund their studies. Check the scholarships to see whether you are eligible to apply. Many scholarships are either merit-based or needs-based.

The Global Study Awards: get funded with up to £10,000 to study abroad

Together with the ISIC Association and British Council IELTS, StudyPortals offers you the chance to receive up to £10000 to expand your horizon and study abroad. We want to ultimately encourage you to study abroad in order to experience and explore new countries, cultures and languages.