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 this is the right course for you!

Join over 50,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

Been a financial advisor in multiple M&A deals with sizes ranging from €2 million to €5 billion

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 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 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

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 to understand the course properly and benefit from its content

Unlimited access to all course materials

Emphasis on learning by doing

You can always contact us for any clarification 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 career prospects, positive feedback, and personal growth.

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.

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

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

Beginner to Pro in Excel: Financial Modeling and Valuation - Welcome!

1

What does the course cover?

2

Bonus! Welcome gift

3

Welcome gift number 2

4

The approach to take this course

5

Download all course materials

Introduction to Excel

1

Introduction to Excel - welcome lecture

2

Overview of Excel

3

Overview of Excel

4

Basic manipulations with rows and columns

5

Rows and columns

6

The Excel ribbon

7

Data entry in Excel

8

Introduction to formatting

9

Introduction to Excel formulas

10

Introduction to Excel formulas

11

Introduction to Excel functions

12

Cut, copy, & paste

13

Cut, copy, & paste

14

Paste special

15

Basic operations in Excel - 38 pages

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.

“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

9

Learn how to organize your data with Text to Columns

10

Learn how to use the Wrap Text button

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

11

Create easily printable documents in Excel by using Set Print Area

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

12

Find and select special types of cells with Select Special (F5)

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

·Constants

·Formulas

·Blanks

·Visible cells, etc.

13

Select Special

14

Learn how to assign dynamic names within a financial model

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.

15

Assigning dynamic names

16

Define a named range in Excel

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.

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.

18

Macros are a great timesaver! Here's why!

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

19

Excel Macros - quiz

20

Create a drop-down list by using Data Validation

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.

21

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

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

22

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

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.

23

Fix the top row of your table with Freeze Panes

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

24

Filter by color - an excellent tool

25

Working with conditional formatting

26

Useful tips and tools for your work in Excel - quiz

Keyboard shortcuts in Excel

1

Keyboard shortcuts Save LOTS of time in Excel

2

Keyboard shortcuts 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

Excel's key functions and functionalities made easy

1

Excel's key functions - Welcome lecture

2

Key functions in Excel: If

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)

3

Key Excel functions: Sum, Sumif and Sumifs

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

4

Key Excel functions: Count, Counta, Countif, Countifs

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

5

Key Excel functions: Average and Averageif

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

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

15

Using Excel's Iferror function to trap spreadsheet errors

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

16

Learn how to render your models flexible with Choose

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

17

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

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

18

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

19

Include sensitivity analysis in your models through Data Tables

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

20

Include sensitivity analysis in your models through Data Tables

21

Excel's dynamic and interactive tables: Pivot tables

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

22

Excel's key functions and functionalities made easy

Update! 15 December - Exercise

1

Exercise - Excel's "Sumifs" function - unsolved

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.

2

Exercise - Excel's "Sumifs" function - solved & explained

Financial functions in Excel

1

Future and present values in Excel

2

Calculating the rate of return of an investment with the IRR function

3

Calculating a complete loan schedule in Excel

4

Date functions in Excel

Microsoft Excel's Pivot Tables in Depth

1

Introduction to Pivot Tables and the way they are applied

2

Creating Pivot Tables easily!

3

Give your Excel Pivot Tables a makeover

4

Modifying and pivoting fields to obtain the Pivot Table you need

5

Learn more about GetPivotData - A very important Excel function

6

An introduction to slicers - The modern-day Pivot Table filters

Case study - Building a complete P&L from scratch in Excel

1

Case study - Build a P&L from scratch - Welcome lecture

2

Introduction to the case study

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

3

Understand your data source before you start working on it

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

4

Order the source worksheets

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

5

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

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

6

Learn how to create a database

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

7

Use Vlookup to fill the Database sheet

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

8

50% Completed!

9

Use SUMIF to complete the Database sheet

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.

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!