Financial Modeling and Valuation – Newbie to Pro in Excel

What will you get from this “Beginner to Pro in Excel: Financial Modeling and Valuation” course?

  • Capability to work confidentially with the Microsoft Excel and the majority of its superior features.
  • Be the best Excel users in your professional team.
  • Complete your regular excel tasks at a much faster rate.
  • Learn about creating a P & L statement by extracting a raw data.
  • Understand how to value an organization.
  • Be capable to create a Cash Flow statement.
  • Understand how to develop a model with a range of scenarios.
  • Know how to develop superior and professionally advanced charts.
  • Learn about building a Valuation model from the bottom.

Program Requirements

Microsoft Excel 2010, Microsoft Excel 2013 or higher version

Program Details

  • Latest update (March 2017)! Lots of new stuff added**
  • Are you looking to know about how to use Excel in real working conditions?
  • Have you just graduated from the university and seeking your first job?
  • Do you want to establish yourself at a new position?
  • Are you seeking to become the top guy in your team when it comes to Excel’s Financial Modeling?
  • If yes, then you have come to the right place and here, we have the perfect course to deal with your requirements!!!
  • More than 17,000 students have successfully completed this course!!

The instructor of this course has a very rich experience in the field of Excel Financial Modeling Valuation course.

Check out his achievements that are mentioned below in detail:

  • Worked as a financial advisor in a multinational consulting company.
  • Rich experience in processing transactions in a range of countries, such as Germany, Italy, Poland, and Switzerland.
  • Worked as the head of the in-house Mergers & Acquisitions department at a top-tier company.
  • An experienced financial analyst who has worked in several M&A deals with sizes that range from US$ 4 million up to US$ 7 million.
  • Complete knowledge of the due diligence analysis, company valuations, bankruptcy proceedings, impairment tests, cash flow analysis and much
  • Trained about the subtleties of Financial Modeling from a well-known personality. Become able to stand above from his colleagues.

Beginner to Pro in Excel: Financial Modeling and Valuation is a complete guide to the Excel Financial Modeling and check out what benefits you can have from it:

  • You will be able to become a true professional in the Excel.
  • You will become capable to build wonderful Financial Models and look different from other members of your team.
  • Gain in-depth knowledge about the basics of the Company Valuation.
  • Become capable to create your excel files in a truly professional manner.
  • Show professional Excel skills at work
  • Be ready for your investment banking, consulting job or Financial advisory from the first day.

What you will get from our end

  • Professionally designed and easy to learn study materials
  • Step by step guide with comprehensive case studies on the basis of real issues.
  • Ready to download course materials.
  • Regular updates about the course.
  • New! Consist of professional chart illustrations, which are used 1:1 by the majority of banks and consulting organizations.

What will you get after completion of course?

  • Capability to work confidentially with the Microsoft Excel and the majority of its superior features.
  • Be the best Excel users in your professional team.
  • Complete your regular excel tasks at a much faster rate.
  • Learn about creating a P & L statement by extracting a raw data.
  • Understand how to value an organization.
  • Be capable to create a Cash Flow statement.
  • Understand how to develop a model with a range of scenarios.
  • Know how to develop superior and professionally advanced charts.
  • Learn about building a Valuation model from the bottom.

Complete Detail about the Beginner to Pro in Excel: Financial Modeling and Valuation course

No need for any past experience for understanding the things mentioned in the course and getting the full advantage of the given content.

Lifetime and full access to all the course content.

Focus on learning by advanced methods.

Contact us anytime for any clarification without paying any money.

Our mission is to take your Financial Modeling and Microsoft skills to a superior level.

You will get high rewards in terms of personal growth, career prospects and positive feedback by just making a small investment.

This Beginner to Pro in Excel: Financial Modeling and Valuation course is perfect for the graduates who want to become a top investment banker because it consists of a well-structured DCF model. Moreover, the course will take you through all the theoretical concepts behind the DCF models. In addition, your confidence will increase while dealing with day to day tasks and will help you in looking better when the organization has to decide about the confirmation for a full-time job.

After completing this course, you will find a dramatic increase in your excel skills. Even, the people who have no knowledge of the Excel will find themselves truly professional.

So, what are you waiting for? Just go ahead and buy this course. If you don’t subscribe to our course now, then it will hurt you badly in the long run if you are looking to stand apart from the others. You should start learning now with our course. You will be able to touch lots of milestones in the near future.

Who is the target audience?

  • Young graduates who want to become financial consultants, professional advisors, investment bankers, etc.
  • People who are looking to enhance their Financial Modeling and Excel skills

BEGINNER TO PRO IN EXCEL: FINANCIAL MODELING AND VALUATION

1
What does the course cover?
2
Study Material and Study Guide

INTRODUCTION TO EXCEL

1
Introduction to Excel – Welcome Lecture
2
Overview of Excel
3
Overview of Excel
4
Basic Manipulations with Rows & Columns
5
Rows & 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
Paste Special
13
Basic operations in Excel

Useful tips and tools for your work in Excel

1
Excel Best Practices – Welcome Lecture
2
Initial formatting of an Excel sheet in order to render it professional
3
Fast scrolling through Excel sheets
4
Fast scrolling through Excel sheets
5
Introduction to fixing of cell references
6
Introduction to fixing of cell references
7
Using the Alt plus Enter combination
8
Learn how to organize your data with Text to Columns
9
Learn how to organize your data with Text to Columns
10
Learn how to Use the Wrap Text Button
11
Create easily printable documents in Excel by using Set Print Area
12
Find and select special types of cells with Select Special (F5)
13
Select Special
14
Learn how to assign dynamic names within a Financial Model
15
Assigning dynamic names
16
Define a named range in Excel
17
Assign custom formats to specific cells within a Financial Model (ex. Multiples)
18
Macros are a great timesaver! Here’s why!
19
Excel Macros – Quiz
20
Create a drop-down list by using Data Validation
21
Using Custom-sort in order to sort multiple columns within a table
22
Create a great Index page at the beginning of your models – Hyperlinks
23
Fix the top row of your table with Freeze Panes
24
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

Excel's key functions and functionalities made easy

1
Excel’s Key Functions – Welcome Lecture
2
Key Functions in Excel: If
3
Key Excel Functions: Sum, Sumif and Sumifs
4
Key Excel Functions: Count, Counta, Countif, Countifs
5
Key Excel Functions: Average and Averageif
6
Key Excel Functions: Average and Averageif
7
Elaborate text efficiently: Left, Right, Mid, Upper, Lower,Proper, Concatenate
8
Elaborate text efficiently: Left, Right, Mid, Upper, Lower,Proper, Concatenate
9
Find the minimum or maximum value in a range of cells in Excel
10
Include Round in your Financial Models
11
Learn how to transfer data efficiently in Excel: Vlookup and Hlookup
12
Index, Match and their combination – the perfect substitute of Vlookup
13
A great Excel technique: Index, Match, Match
14
Index, Match and their combination – the perfect substitute of Vlookup
15
Using Excel’s Iferror function to trap spreadsheet errors
16
Learn how to render your models flexible with Choose
17
Use Goal Seek in order to find the result that you are looking for
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
20
Include sensitivity analysis in your models through Data Tables
21
Excel’s dynamic and interactive tables: Pivot tables
22
Excel’s key functions and functionalities made easy

Exercise

1
Exercise – Excel’s “Sumifs” function – unsolved
2
Exercise – Excel’s “Sumifs” function – explained & solved

Microsoft Excel's Pivot Tables in Depth

1
Introduction to Pivot Tables & Their Application
2
Creating Pivot Tables is easy!
3
Give Your Excel Pivot Tables a Makeover
4
Modifying and Pivoting Fields In Order to Obtain the Pivot Table that You Need
5
Learn More About GetPivotData – A Very Important Excel Function
6
An Introduction to Slicers – The Moden 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
3
Understand your data source before you start working on It
4
Order the source worksheets
5
Create a code: the best way to organize your data and work efficiently with It
6
Learn how to create a Database
7
Use Vlookup in order to fill the Database sheet
8
Use Sumif in order to complete the Database sheet
9
Use Index & Match as a substitute of Vlookup
10
Mapping of the rows in the Database sheet
11
Building the structure of the P&L sheet
12
Formatting sets You apart from the competition in Excel – A Practical Example
13
Populate the P&L sheet with Sumif
14
Learn how to find mistakes with Countif
15
Calculating year-on-year percentage variations the proper way
16
Create professional and good-looking charts – Introduction
17
Build a Column Stacked Chart with a secondary line axis in Excel
18
Learn how to build effective Doughnut Charts in Excel
19
Learn how to build an Area Chart in Excel
20
Learn how to create Bridge Charts
21
Case Study – Building a Complete P&L from scratch in Excel
22
Course Challenge – Apply Your Skills in Practice!

Case Study - Building an FMCG Model from Scratch

1
Introduction to the Case Study
2
Preliminary mapping of the data extraction
3
Working with an SAP data extraction
4
Creating an output structure of the FMCG model
5
Improving the layout and appearance of the FMCG report
6
Inserting formulas and automating calculations
7
Creating a Master Pivot Table: The main data source for the FMCG report
8
GetPivotData is great! Extracting data from the Master Pivot Table
9
Combining Slicers and GetPivotData: The key to our success
10
Getting fancy with Excel slicers – Good-looking Excel slicers
11
This is how the report can be used in practice by high-level executives

Financial Modeling Fundamentals

1
Financial Modeling Basics – Welcome Lecture
2
What is a Financial model?
3
Why use Financial models?
4
Financial modeling: Worst Practices – Things you should avoid
5
Financial modeling: Best practices
6
Financial modeling: The types of models that are built in practice
7
Financial Modeling – Quiz
8
Financial modeling: The right level of detail in a model
9
Financial modeling: Forecasting guidelines
10
Forecasting financials – Quiz
11
Building a complete model – Important considerations
12
Modeling the Income statement
13
Modeling the Balance sheet – Part 1
14
Modeling the Balance sheet – Part 2
15
Building a financial model – Quiz

Introduction to Company Valuation

1
The core theory behind Company Valuation
2
Introduction to Mergers & Acquisitions

Learn how to build a Discounted Cash Flow model in Excel

1
Valuation Case Study – Welcome Lecture
2
Introduction to the DCF exercise
3
The various stages of a complete DCF Valuation
4
Description of the structure of the DCF model
5
A glimpse at the company we are valuing – Cheeseco
6
Modeling the top line
7
Introducing scenarios to the model with Choose
8
Modeling other items: Other revenues and Cogs
9
Modeling other items: Operating expenses and D&A
10
Modeling other items: Interest expenses, Extraordinary items and Taxes
11
Forecasting Balance Sheet items
12
An introduction to the “Days” methodology
13
Calculation of DSO, DPO and DOI for the historical period
14
Forecasting DSO, DPO and DOI
15
Forecasting Property, Plant & Equipment, Other assets and Other liabilities
16
Creating an output P&L sheet
17
Populating the output P&L sheet
18
Populating the output BS sheet
19
Completing the output BS sheet for the historical period
20
Creating a structure for the calculation of Unlevered Free Cash Flows
21
Calculating Unlevered Free Cash Flow
22
Calculating Net Cash Flow
23
Obtaining the rest of the Cash Flows through Find and Replace
24
Introducing Weighted Average Cost of Capital and Perpetuity Growth
25
Discounting Unlevered Free Cash Flows in order to obtain their Present Value
26
Calculating Continuing Value and Enterprise Value of the business
27
Calculating Equity Value
28
Sensitivity analysis for WACC and perpetuity growth
29
A possible application of Goal Seek
30
Using charts in order to summarize the results of the DCF Model
Faq Content 1
Faq Content 2

Productivity Hacks to Get More Done in 2018

— 28 February 2017

  1. Facebook News Feed Eradicator (free chrome extension) Stay focused by removing your Facebook newsfeed and replacing it with an inspirational quote. Disable the tool anytime you want to see what friends are up to!
  2. Hide My Inbox (free chrome extension for Gmail) Stay focused by hiding your inbox. Click "show your inbox" at a scheduled time and batch processs everything one go.
  3. Habitica (free mobile + web app) Gamify your to do list. Treat your life like a game and earn gold goins for getting stuff done!


4
4 out of 5
6 Ratings

Detailed Rating

Stars 5
3
Stars 4
0
Stars 3
3
Stars 2
0
Stars 1
0

{{ review.user }}

{{ review.time }}
 

Show more
Please, login to leave a review
Add to Wishlist
Enrolled: 196 students
Duration: 10 Weeks
Lectures: 151
Video: 48 hours
Level: Advanced

Archive

Working hours

Monday 9:30 am - 6.00 pm
Tuesday 9:30 am - 6.00 pm
Wednesday 9:30 am - 6.00 pm
Thursday 9:30 am - 6.00 pm
Friday 9:30 am - 5.00 pm
Saturday Closed
Sunday Closed