Take this
course

Business / Accounting & Finance

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!

Description

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 8,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 “PowerPoint MasterClass: Beginner to Pro in PowerPoint”. It has a full price of $255. +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 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 $255. +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ About the course: ·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!
Full details

Curriculum

  • Beginner to Pro in Excel: Financial Modeling and Valuation - Welcome!
    What does the course cover?
    2:27
  • Introduction to Excel
    Overview of Microsoft Excel
    3:44
    The Excel Ribbon
    2:48
    Data entry in Excel
    3:08
    Basic operations with Rows & Columns
    1:57
    Introduction to Formatting
    5:38
    Introduction to Excel Formulas
    3:08
    Applying Paste Special
    1:34
    Introduction to Excel Functions
    3:56
    Working with Cut, Copy & Paste
    2:18
    PDF - Excel's Basic Features
  • Useful tips and tools that will make a difference for you
    Formatting a worksheet
    2:14
    This is how you can be five times faster in Excel - Fast Scrolling
    1:36
    Fixing of cell references properly is the key to your success in excel
    2:09
    Using Alt + Enter
    1:04
    Learn how to organize your data with Text to Columns
    2:01
    Learn how to use the "Wrap Text" button
    0:44
    Be one step ahead of the others: learn how to use excel's "select special" tool
    1:38
    Create easily printable documents in Excel by using "Set Print Area"
    1:12
    Sorting has never been easier in Excel - sorting of multiple columns
    1:24
    The effective way of assigning dynamic names within a financial model in excel
    1:22
    This is how you can start working with named cells or ranges in Excel
    1:34
    The proper way to assign custom formats to given cells within a financial model
    1:38
    Work at the speed of light! Learn how to record macros and be really efficient
    3:00
    Add style to your Excel files! Learn how to create an effective drop-down list
    1:52
    Learn how to keep the top line in Excel always in front of you - freeze panes
    1:27
    Learn how to create an Index sheet & impress with the first page of your model
    1:13
    Work 3x faster! Microsoft Excel Shortcuts
    4:39
    PDF with Shortcuts - Download
    PDF - Useful tips & tools
  • Excel's Key Functions Made Easy
    The If function
    Average and Averageif
    1:54
    Elaborating text in Excel - The professional super effective way
    4:25
    Master Excel's key functions: Count, Counta, Countif, Countifs
    4:01
    Master Excel's key functions: Sum, Sumif and Sumifs
    4:21
    Find The highest and the lowest in a set of values: Max and Min
    0:52
    Learn how to round numbers in Excel
    1:02
    Using Excel's Iferror Function to Trap Spreadsheet Errors
    1:43
    See how Vlookup is applied in practice in Excel
    7:32
    Adding Sensitivity Analysis to a Financial Model - Data Tables
    4:07
    Excel tools in practice - an application of Goal Seek
    2:13
    An example of how Index and Match can replace Vlookup in your Excel models
    7:19
    This Is how you can build flexible Financial Models in Excel
    2:19
    Become familiar with Excel's dynamic and interactive tables: Pivot Tables
    2:13
    PDF - Key functions in Excel
  • Case Study - Building a Complete P&L from scratch in Excel
    Learning by doing - Build a P&L from scratch
    0:43
    Understand your data source before you start working on It
    2:43
    Order the source worksheets
    2:14
    Create a code: the best way to organize your data and work efficiently with It
    2:05
    Learn how to create a Database
    2:06
    Applying Vlookup in practice
    5:33
    Applying Sumif in practice
    4:23
    An example of how Vlookup can be replaced by Index & Match
    4:15
    A fundamental lesson for every Excel user - The mapping exercise
    2:23
    Building the structure of the P&L sheet
    2:16
    Formatting sets you apart - Creating a great layout of the P&L sheet
    3:32
    Populating the P&L sheet
    2:55
    Countif is great if the numbers in your model don't add up
    2:33
    Calculating Year-on-Year percentage variations in an effective way
    3:16
    Create professional and good-looking excel charts? Yes, please!
    0:21
    Learn how to build a neat stacked column chart in Excel
    6:08
    Learn how to build effective doughnut charts in excel
    4:22
    Learn how to build an impressive Area chart
    4:17
    Here is the real deal: Create Bridge charts from scratch
    10:57
  • Practical Exercise - Sumifs
    Practical Exercise - Sumifs
    8:37
  • Pivots & Slicers
    Introduction to Pivot Tables
    1:36
    Creating Pivot Tables is easy!
    3:48
    Formatting Pivot Tables
    2:15
    Modifying and pivoting fields In order to obtain the Pivot Table that you need
    4:34
    Learn More About GetPivotData - A Very Important Excel Function
    3:46
    An Introduction to Slicers - The moden day Pivot Table filters
    4:21
  • Case Study - Building an FMCG model from scratch
    Introduction to the Case Study
    2:10
    Preliminary mapping of the data extraction
    3:24
    Working with an SAP data extraction
    2:11
    Creating an output structure of the FMCG model
    2:30
    Improving the layout and appearance of the FMCG report
    4:00
    Inserting formulas and automating calculations
    2:31
    Creating a Master Pivot Table: The main data source for the FMCG report
    1:56
    GetPivotData is great! Extracting data from the Master Pivot Table
    5:46
    Getting fancy with Excel slicers - Good-looking Excel slicers
    3:13
    Combining Slicers and GetPivotData: The key to our success
    3:21
    This is how the report can be used in practice by high-level executives
    4:00
  • Introduction to Company Valuation
    PDF - Company valuation
  • Learn how to build a Discounted Cash Flow model in Excel
    Learning by Doing - learn how to value a company
    1:24
    The various stages of a complete DCF exercise
    6:31
    Description of the structure of the DCF model
    2:54
    A glimpse at the company we are valuing - Cheeseco
    1:10
    Modeling the Top Line of the financial model
    3:40
    This Is how you can build flexible financial models in Excel
    2:13
    Modeling other Items: Other Revenues and Cogs
    3:47
    Modeling other Items: Opex and D&A
    2:34
    Modeling other Items: Interest expenses, Extraordinary items, and Taxes
    2:29
    Forecasting Balance Sheet Items
    0:44
    An introduction to the "Days" methodology
    1:36
    Here is How to Calculate "Days" in Practice
    1:31
    How to use "Days" in order to project the future development of some BS items
    2:24
    Forecasting the future development of PP&E, Other Assets and Other Liabilities
    2:28
    Creating an output P&L sheet
    2:37
    Populating the P&L sheet
    2:15
    Populating the Balance Sheet
    1:50
    Completing the output Balance Sheet for the historical period
    3:42
    Creating a structure for the calculation of Unlevered Free Cash Flows
    3:06
    Bridge UFCF to Net Cash FLow
    1:56
    Calculating Unlevered Free Cash Flow
    6:02
    Obtaining the rest of the Cash Flows through Find and Replace
    3:53
    A possible application of Goal Seek
    1:41
    Sensitivity analysis for WACC and perpetuity growth
    4:18
    Using charts in order to summarize the results of the DCF Model
    4:39
    Calculating Equity Value
    1:22
    Introducing Weighted Average Cost of Capital and Perpetuity Growth
    1:57
    Discounting Unlevered Free Cash Flows in order to obtain their Present Value
    2:51
    Calculating Net Cash Flow
    3:57
    Calculating Continuing Value and Enterprise Value of the business
    2:18

Skills

  • Corporate Valuation
  • Financial Modeling
  • Financial Valuation
  • Microsoft Excel

Similar Courses