Beginner to Pro in Excel: Financial Modeling and Valuation

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 your new position? Would you like to become your team’s go-to person when it comes to Financial Modeling in Excel?

If you answered yes to any of these, then the Udemy course “Beginner to Pro in Excel: Financial Modeling and Valuation” is for you! Join over 71,000 successful students taking this course!

Beginner to Pro in Excel: Financial Modeling and Valuation – Course Content

This course 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. Moreover, it will encourage you to be more confident when coping with daily tasks and will give you the edge when the firm must decide whether to take you on for a full-time position.

It provides a comprehensive guide to Financial Modeling in Excel, enabling you to 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, and be prepared from day one for a career in Investment Banking, Financial Advisory or Consulting.

The course has well-designed and easy-to-understand materials, detailed explanations with comprehensible case studies based on real situations, downloadable course materials, regular course updates, and includes professional chart examples that are 1:1 with those used by major banks and consulting firms.

The course comprises 275 lectures organized into the following sections:

Beginner to Pro in Excel: Financial Modeling and Valuation – Welcome!
Introduction to Excel
Useful tips and tools for your work in Excel
Keyboard shortcuts in Excel
Excel’s key functions and functionalities made easy
Update! SUMIFS – Exercise
Financial functions in Excel
Microsoft Excel’s Pivot Tables in Depth
Case study – Building a complete P&L from scratch in Excel
Introduction to Excel charts
P&L Case Study continued – Let’s create some great-looking professional charts
Case Study – Building an FMCG Model from Scratch
Financial Modeling Fundamentals
Introduction to Company Valuation
Introduction to Mergers & Acquisitions
Learn how to build a Discounted Cash Flow model in Excel
Tesla valuation – Complete practical exercise
Capital budgeting – The theory
Capital Budgeting – A Complete Case Study
Bonus lecture

Requirements

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

Summary of Course Main Features

Instructor: 365 Careers – Creating opportunities for Business & Finance students
Lectures: 275
On-demand video: 13 hours
Articles: 10
Downloadable resources: 600
Includes
- 30-Day Money-Back Guarantee
- Full lifetime access
- Access on mobile and TV
- Assignments
- Certificate of Completion