Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Beginner to Pro in Excel: Financial Modeling and Valuation to your Wishlist.

Add to Wishlist

Beginner to Pro in Excel: Financial Modeling and Valuation

Learn Financial Modeling in Excel that would allow you to walk into a job and be a rockstar from day one!
4.5 (1,815 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
16,427 students enrolled
Created by 365 Careers
Last updated 2/2017
English English
$10 $150 93% off
3 days left at this price!
30-Day Money-Back Guarantee
  • 6.5 hours on-demand video
  • 248 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
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
View Curriculum
  • Microsoft Excel 2010, Microsoft Excel 2013, or Microsoft Excel 2016

*Updated for February 2017! Several new lectures have been added*

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

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

Are you a young professional who is looking to establish himself at his new position?

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

If so, then this is the right course for you!

Join over 15,000 successful students taking this course!!

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.

A comprehensive guide to Financial Modeling in Excel:

  • Become an Excel expert
  • Learn how to build sound Financial Models and stand out at your job
  • An in-depth understanding of the mechanics of Company Valuation
  • Build your files in a professional way
  • Demonstrate superior Excel skills at work
  • Be prepared from day one for your Investment Banking, Financial Advisory or Consulting job

What we offer:

  • Well-designed and easy-to-understand materials
  • Detailed explanations with comprehensible Case Studies based on real situations
  • Downloadable course materials
  • Regular course updates

NEW! Includes professional chart examples that are 1:1 with those used by major banks and consulting firms

By the completion of this course you will:

  • 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


Students of this course who complete 50% of the lessons get full, lifetime access to our five-star rated course “Beginner to Pro in PowerPoint: Complete PowerPoint Training”. It has a full price of $150.


Students of this course who complete 100% of the lessons get full, lifetime access to our five-star rated course “Job Search Success Strategies: Proven Job Hunting Strategies”. It has a full price of $95.


About the course:

  • An unconditional Udemy 30-day money-back guarantee – because we believe in the quality of our content
  • No significant previous experience is needed in order to understand the course well and fully benefit from its content
  • Unlimited access to all course materials
  • Emphasis on learning by doing
  • You can always contact us for any clarification completely free of charge
  • Our goal is to take your Microsoft Excel and Financial Modeling skills to the next level

Make an investment that will be highly rewarded in terms of career prospects, positive feedback and personal growth.

This course is particularly 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 help you to be more confident when coping with daily tasks and will provide you with an edge when the firm has to decide whether to confirm you for a full-time position.

People with basic knowledge of Excel who go through the course will dramatically increase their Excel skills.

Just go ahead and subscribe to this course! If you don't acquire these skills now you will miss an opportunity to separate yourself from the others. Don't risk your future success! Let's start learning together now!

Who is the target 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
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 138 Lectures Collapse All 138 Lectures 07:36:47
Beginner to Pro in Excel: Financial Modeling and Valuation - Welcome!
4 Lectures 04:24

Bonus! Welcome gift
1 page

Welcome gift number 2
1 page

The best way to take this course
Introduction to Excel
11 Lectures 28:25
Introduction to Excel - Welcome Lecture

Overview of Excel

Overview of Excel
1 question

Basic Manipulations with Rows & Columns

Rows & Columns
1 question

The Excel Ribbon

Data Entry in Excel

Introduction to Formatting

Introduction to Excel Formulas

Introduction to Excel Formulas
1 question

Introduction to Excel Functions

Cut, Copy & Paste

Cut, Copy & Paste
1 question

Paste Special

This opening section will take you through the basics of Excel. An easy-to-understand introduction that will bring you up to speed in no time.

Some of the topics and concepts discussed in this lesson:

    ·Row and Column references

    ·Name box

    ·Formula bar

    ·The Ribbon

    ·Format cells

    ·Basic operations in Excel: Copy, Paste, Paste Special, Cut, Undo, Redo

Basic operations in Excel - 38 pages
38 pages
Useful tips and tools for your work in Excel
17 Lectures 26:34
Excel Best Practices - Welcome Lecture

Initial formatting is key for the final output of your work in Excel. Through the use of some basic operations, we will learn how to render spreadsheets professional and good-looking

Some of the operations performed in this lesson:

    ·Coloring of cells

    ·Adjusting column width

    ·Modifying Font and Font size

Initial formatting of an Excel sheet in order to render it professional

    Working with Excel data is a whole lot easier when you know how to use a few important shortcuts:

    ·Control plus Arrow key - jump to the last populated cell in that direction

    ·Control plus Shift plus Arrow key – extend the selection of cells to the last nonblank cell

Fast scrolling through Excel sheets

Fast scrolling through Excel sheets
1 question

Understand how fixing cell references properly can save you lots of time when working in Excel

Introduction to fixing of cell references

Introduction to fixing of cell references
1 question

Alt plus Enter – a neat trick that allows you to organize your text content on multiple rows

Using the Alt plus Enter combination

    “Text to Columns” allows you to separate data that is in a single column into multiple columns. You have to pick among two options in order to separate the data:

    ·Delimited Text – there is a character, such as comma or blank space separating each group of text

    ·Fixed-Width Text – each group of text is a set number of characters

Preview 02:00

Learn how to organize your data with Text to Columns
1 question

The “Wrap Text” button is useful when a cell’s text content is greater than its size. It automatically adjusts the row size and fits the content of the cell in its borders

Learn how to Use the Wrap Text Button

Use “Set Print Area” in order to define, which parts of your Excel spreadsheet should be printed and which should not be printed

Create easily printable documents in Excel by using Set Print Area

    Select Special allows Excel users to select a range of cells based on specific criteria. For example, they can choose whether to select:




    ·Visible cells, etc.

Preview 01:37

Select Special
1 question

Dynamic naming allows you to create flexible financial models that can be used multiple times. Link all names within a model to its Input page, in order to modify only once, when you have to use the model in future.

Learn how to assign dynamic names within a Financial Model

Assigning dynamic names
1 question

Using range names is a nice way to describe formulas in Excel. It can make Excel formulas easier to understand and prevent potential errors. For example, the range C4:C7 can be named “Sales12”, which makes it easier to remember and understand.

Define a named range in Excel

Excel has a number of built-in cell formats that you can use: “Number”, “Currency”, “Accounting”, etc. If you cannot find an option that satisfies your needs you can easily create your own “Custom” format.

Assign custom formats to specific cells within a Financial Model (ex. Multiples)

    Certain tasks are repeated a number of times in Excel. Recording Macros is a great way to save time by automating a series of commands that you use frequently. In order to record and run a Macro, you have to:

    ·Work in a Macro-Enabled Excel Workbook

    ·Enable the Developer tab in the Excel Ribbon

    ·Record a Macro and save it

    ·Run the Macro that you saved

Preview 02:59

Excel Macros - Quiz
1 question

Drop-down lists are a common tool used for data validation purposes in Microsoft Excel. They allow Excel users to select from a list of acceptable data entries for a specific cell in a worksheet.

Create a drop-down list by using Data Validation

Custom Sort allows Excel users to organize the data in multiple columns according to the values in one of these columns

Using Custom-sort in order to sort multiple columns within a table

Hyperlinks are references pointing to a specific place in a file. They facilitate the navigation of Excel users by allowing them to “jump” to a specific place with a single click.

Create a great Index page at the beginning of your models - Hyperlinks

Freeze Panes allows Excel users to scroll down or to the right and continue to see the rows or columns that were “frozen”

Fix the top row of your table with Freeze Panes

Useful tips and tools for your work in Excel - Quiz
5 questions
Keyboard shortcuts in Excel
2 Lectures 04:38
Keyboard Shortcuts Save LOTS of time in Excel

Learning how to use keyboard shortcuts is an essential part of your Microsoft Excel training. The slides in this lesson will enable you to pick up a number of useful keyboard combinations that will dramatically increase the efficiency of your work

Keyboard shortcuts in Excel
11 pages
Excel's key functions and functionalities made easy
16 Lectures 49:33
Excel's Key Functions - Welcome Lecture

    The IF function tests whether a certain condition is true or false. It works in the following way:

    1.Excel tests whether the logical test, which is the first argument of the function, is satisfied

    2.If the logical test is satisfied, Excel delivers value A (the second argument of the function)

    3.If the logical test is not satisfied, Excel delivers value B (the third argument of the function)

Key Functions in Excel: If
3 pages

    SUM functions are widely used in Excel. They allow us to add the numbers within a given cell range

    1.SUM has only one argument – the range of cells to be summed

    2.SUMIF allows us to add the cells within a range, which satisfy a given criterion

    3.SUMIFS is able to add up values in a range of cells that satisfy multiple conditions

Key Excel Functions: Sum, Sumif and Sumifs

    This lesson is dedicated to Excel’s COUNT functions. They are applied when we need to count the cells within a range that contain numbers, text, or satisfy specific conditions. In particular we will be examining:

    1.COUNT - counts the number of cells that contain numbers

    2.COUNTA - counts the number of cells that contain text

    3.COUNTIF - returns the number of cells that satisfy a specific condition

    4.COUNTIFS - counts the number of cells within a given cell range, if multiple conditions are satisfied

Key Excel Functions: Count, Counta, Countif, Countifs

    This lesson describes the formula syntax and application of the AVERAGE and AVERAGEIF functions in Excel.

    1.AVERAGE finds the mean of a specified range of cells

    2.AVERAGEIF finds the mean of a specified range of cells, if a given condition is satisfied

Key Excel Functions: Average and Averageif

Key Excel Functions: Average and Averageif
1 question

    Text functions are an indispensable tool for any Excel user. In this lesson, we will focus on three types of text functions:

    1.Text functions extracting a part of a cell - LEFT, RIGHT and MID

    2.Functions changing the case of a text - UPPER, LOWER and PROPER

    3.Combining cell values of multiple cells - & and CONCATENATE

Elaborate text efficiently: Left, Right, Mid, Upper, Lower,Proper, Concatenate

Elaborate text efficiently: Left, Right, Mid, Upper, Lower,Proper, Concatenate
1 question

    In this video tutorial, we will continue to present to you popular functions in Microsoft Excel;

    1.MAX finds the highest value in a range of cells

    2.MIN allows us to obtain the lowest value in a range of cells

Find the minimum or maximum value in a range of cells in Excel

ROUND would allow you to round numbers in Excel

Include Round in your Financial Models

    Transferring data efficiently is at the heart of your success in Microsoft Excel. This lesson provides an easy to understand introduction to two of the venerable functions in Excel:

    1.Vlookup – finds a lookup value in the leftmost column of a table and returns a corresponding value

    2.Hlookup – finds a lookup value in the top row of a table and returns a corresponding value

Learn how to transfer data efficiently in Excel: Vlookup and Hlookup

    The combination of Index and Match is our favorite tool for looking up data. It is a flexible instrument that overcomes some of the shortages of Vlookup and Hlookup;

    1.Index extracts the value lying at the intersection of a particular row and column

    2.Match returns the relative position of an item

    3.The combination of Index & Match - Index needs as an input relative positions within a range, Match delivers those relative positions by finding the lookup value

Index, Match and their combination - the perfect substitute of Vlookup

A great Excel technique: Index, Match, Match

Index, Match and their combination - the perfect substitute of Vlookup
1 question

    Error messages are undesired in Excel spreadsheets for several reasons:

    1.If a range contains a cell with an error, this impedes us from carrying out operations with the entire range

    2.They disturb the eye of Excel Users

    3.A file containing error messages cannot be shown to external users

    IFERROR resolves these issues. The function tests whether a given cell contains an error, and if it does it replaces the error message with a value specified by the Excel user

Using Excel's Iferror function to trap spreadsheet errors

CHOOSE is a great tool for Financial Modeling. It allows Excel users to build various scenarios, which can be critical when dealing with an uncertain environment and building a dynamic model.

CHOOSE has n arguments, which can be divided into two groups – its index number (the first argument) and the rest of the arguments.

    ·The Index Number determines, which argument will be selected

    ·The rest of the arguments are the values from, which CHOOSE selects

Learn how to render your models flexible with Choose

    Goal Seek is part of the “What-if” analysis tool within Excel. It is a nice instrument that allows users to find a desired result for a given parameter by changing other parameters related to it.

    Three inputs are required in order to use the Goal Seek functionality:

    1.A cell to set

    2.The value to which we would like to set the cell

    3.A cell to modify

Use Goal Seek in order to find the result that you are looking for

Use Goal Seek in order to find the result that you are looking for
1 question

This lecture introduces you to Data Tables. A powerful tool enabling you to provide sensitivity analysis for a number of parameters. Data Tables illustrate perfectly the influence that a given parameter has on the final output

Include sensitivity analysis in your models through Data Tables

Include sensitivity analysis in your models through Data Tables
1 question

    Pivot Tables are one of Excel’s most powerful features. They allow us to synthesize and elaborate, with ease, large amounts of data.

    In this lesson we will learn how to:

    1.Create a Pivot Table

    2.Introduce different variables to the Pivot Table Report

    3.Choose the type of calculation that you want to use to summarize data

Excel's dynamic and interactive tables: Pivot tables

Excel's key functions and functionalities made easy
5 questions
Update! 15 December - Exercise
2 Lectures 08:36

An exercise focusing on the practical application of “Sumifs” - a very interesting Excel function that allows you to create dynamic tables in an efficient way.

Exercise - Excel's "Sumifs" function - unsolved
1 page

Microsoft Excel's Pivot Tables in Depth
6 Lectures 20:14
Introduction to Pivot Tables & Their Application

Creating Pivot Tables is easy!

Give Your Excel Pivot Tables a Makeover

Modifying and Pivoting Fields In Order to Obtain the Pivot Table that You Need

Learn More About GetPivotData - A Very Important Excel Function

An Introduction to Slicers - The Moden Day Pivot Table Filters
Case Study - Building a Complete P&L from scratch in Excel
22 Lectures 01:09:57
Case Study - Build a P&L From Scratch - Welcome Lecture

    The next part of the course is structured as a Case Study and would allow you to:

    1.Apply in practice what we have seen so far

    2.Work on a real-world task

    3.Enhance your spreadsheet formatting skills

    4.Learn how to create advanced charts

Introduction to the Case Study

    Before managing big data, you must understand it first. That is why in this lesson we will focus on understanding our data source. The data in the source sheets is structured in the following way:

    1.Name of P&L account

    2.Partner company number (indicates whether a transaction was registered with a related or with an external counterparty)

    3.Name of Partner company

    4.Registered amount

    5.Accounting code

Understand your data source before you start working on It

    The next video of our Case Study we will show you how to order a source worksheet. The operations to be carried out include:

    1.Writing titles on the top of the source tables

    2. Placing filters

    3.Align the data in a coherent way

    4.Eliminate unnecessary rows

Order the source worksheets

When we have a large data extraction, we have to be sure that we will be able to manage it efficiently. A good way to do that is by creating a code, which summarizes the important information about each line item

Create a code: the best way to organize your data and work efficiently with It

Gathering data from different years (and different sheets) on a single sheet is crucial. It allows the user to classify all the data in a coherent way when attributing a P&L category

Learn how to create a Database

In the previous video we were able to organize all of the line item codes in the same sheet. In this lesson we will apply VLOOKUP in order to fill in some of the fields of our Database

Use Vlookup in order to fill the Database sheet

50% Completed!

    The Database sheet unites all three years of data together. The only fields that are missing are the actual amounts that were observed for each line item during the three years.

    In this lesson, we will fill in the amounts observed for each code with SUMIF. In addition to that, we will use a method that would help us understand whether we have worked correctly or not.

Use Sumif in order to complete the Database sheet

    In one of our previous lessons we used VLOOKUP in order to fill some of the fields in the Database sheet. In this video we will show you two things:

    1.INDEX & MATCH is a suitable replacement of VLOOKUP in Microsoft Excel

    2.In certain situations INDEX & MATCH is more powerful than VLOOKUP

Use Index & Match as a substitute of Vlookup

Given that the Database sheet contains a large amount of rows, we have to group such information into categories. This so-called “Mapping” exercise is necessary as it would allow us to produce a concise (and meaningful) P&L statement

Mapping of the rows in the Database sheet

    In this lesson, we will organize all categories obtained in the “Mapping” exercise into a P&L statement. In order to do that we will have to:

    1.Copy all categories into a new sheet

    2.Remove duplicate values

    3.Order the categories in order to form a meaningful P&L format

Building the structure of the P&L sheet

Correct formatting will result in a greater initial and lasting impression of your work. In this lesson we will add a few important formatting details to our existing P&L structure – place units of measurement and financial period on top, add subtotal and total lines etc.

Formatting sets You apart from the competition in Excel - A Practical Example

In this video we will populate the ready P&L structure with the numbers from the Database sheet by using SUMIF

Populate the P&L sheet with Sumif

    We already said that it is very, very important to use checks in order to verify if the result that was obtained is correct. What if it is not?

    In this lesson we will learn how to find mistakes by using COUNTIF.

Learn how to find mistakes with Countif

Percentage variations and incidence on total are useful tools, which highlight the dynamics of a given business. In this lesson we will learn how to add them to our P&L statement.

Calculating year-on-year percentage variations the proper way

Create professional and good-looking charts - Introduction

    Stacked Column charts are perfect for illustrating the development of a variable over time as they provide an additional breakdown, showing the development of each of the variable’s components.

    In this lesson we will:

    1.Create a stacked column chart

    2.Enhance its formatting

    3.Add a line on the chart’s secondary axis

Preview 06:07

Doughnut charts are a great way to provide the breakdown of a given variable. The blank center of doughnut charts can be used in order to display data related to the variable.

In this lesson we will learn how to:

    1.Create a doughnut chart in Excel.

    2.Add a text box with content in the blank center of the doughnut chart

Learn how to build effective Doughnut Charts in Excel

Next, we will learn how to create a combined area and line chart that would illustrate the trend of revenues and the development of Gross Margin

Learn how to build an Area Chart in Excel

Bridge charts, often called waterfall charts, are very popular graphic tools that are frequently used in corporate presentations. A bridge normally shows how an initial value is affected by a series of intermediate positive or negative values. Bridge charts are not native to Microsoft Excel, which slightly complicates their creation. The method, which we will see in this video, is probably the simplest for the creation of bridge charts from scratch.

Learn how to create Bridge Charts

Case Study - Building a Complete P&L from scratch in Excel
5 questions

Course Challenge - Apply Your Skills in Practice!
Case Study - Building an FMCG Model from Scratch
11 Lectures 35:10
Introduction to the Case Study

Preliminary mapping of the data extraction

Working with an SAP data extraction

Creating an output structure of the FMCG model

Improving the layout and appearance of the FMCG report

Inserting formulas and automating calculations

Creating a Master Pivot Table: The main data source for the FMCG report

GetPivotData is great! Extracting data from the Master Pivot Table

Combining Slicers and GetPivotData: The key to our success

Getting fancy with Excel slicers - Good-looking Excel slicers

This is how the report can be used in practice by high-level executives
Financial Modeling Fundamentals
12 Lectures 42:06
Financial Modeling Basics - Welcome Lecture

What is a Financial model?

Financial modeling: Worst Practices - Things you should avoid

Financial modeling: Best practices

Financial modeling: The types of models that are built in practice

Financial Modeling - Quiz
5 questions

Financial modeling: The right level of detail in a model

Financial modeling: Forecasting guidelines

Forecasting financials - Quiz
5 questions

Building a complete model - Important considerations

Modeling the Income statement

Modeling the Balance sheet - Part 1

Modeling the Balance sheet - Part 2

Building a financial model - Quiz
5 questions
3 More Sections
About the Instructor
4.5 Average rating
5,173 Reviews
49,683 Students
15 Courses
Creating opportunities for Business & Finance students

365 Careers is a firm specializing in high-end financial training programs. Our growing list of courses includes Excel (Microsoft Excel for Beginner and Advanced users), PowerPoint, Financial Modeling, Company Valuation, Accounting, Investment Banking, Financial Planning & Analysis, and Job Hunting trainings. Our goal is to provide to our students the practical instruments they will need in order to perform successfully at their future workplace.

Report Abuse