+- Softwarez.Info - Software's World! (https://softwarez.info)
+-- Forum: Library Zone (https://softwarez.info/Forum-Library-Zone)
+--- Forum: Video Tutorials (https://softwarez.info/Forum-Video-Tutorials)
+--- Thread: Beginner To Pro In Excel Financial Modeling And Valuation (/Thread-Beginner-To-Pro-In-Excel-Financial-Modeling-And-Valuation)
Beginner To Pro In Excel Financial Modeling And Valuation - OneDDL - 08-08-2024
![[Image: e287a44f99310defb6745efb082ad113.jpeg]](https://i123.fastpic.org/big/2024/0808/13/e287a44f99310defb6745efb082ad113.jpeg)
Free Download Beginner To Pro In Excel Financial Modeling And Valuation
Last updated 6/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 9.90 GB | Duration: 20h 37m
Financial Modeling in Excel that would allow you to walk into a job and be a rockstar from day one!
What you'll learn
Master Microsoft Excel and its advanced features
Become a top Excel users on your team
Execute regular tasks quicker
Build P&L statements from a raw data extraction
Acquire financial modeling skills
Learn how to value a company
Build valuation models from scratch
Create models with multiple scenarios
Design professional advanced charts
Become a proficient user with Excel functions, pivot tables, visualizations, and advanced features
Requirements
Microsoft Excel 2010, 2013, 2016, 2020, or Microsoft Excel 365
Description
*Updated for June 2024*Do you want to learn how to use Excel in a real working environment?Are you about to graduate from a university and look 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 for financial modeling in Excel? Join over 200,000+ successful students taking this course.Your instructor possesses the following extensive experience in financial modeling: Financial advisory unit of a top-tier consulting firmExperience in M&A transactions executed in the UK, Italy, Germany, Switzerland, and PolandEmployed in the in-house Mergers & Acquisitions department of a large multinational corporationA financial advisor in multiple M&A deals ranging from €2 million to €5 billionWorked 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 with this course today. A comprehensive guide to financial modeling in Excel: Become an Excel expertBuild sound financial models in ExcelGain an in-depth understanding of the mechanics of company valuationCreate professionally formatted filesDemonstrate superior Excel skills at workPrepare before employment in investment banking, financial advisory, corporate finance, or consultingWhat We Offer: Well-designed and easy-to-understand materialsDetailed explanations with comprehensible case studies based on real situationsDownloadable course materialsRegular course updatesProfessional chart examples used by major banks and consulting firms.Real-life, step-by-step examplesUpon completing this course, you'll be able to do the following:Work comfortably with Microsoft Excel and many of its advanced featuresBecome a the top Excel users on your teamPerform regular tasks quickerDevelop a P&L statement from a raw data extractionBuild a cash flow statementValue a companyProduce a valuation model from scratchCreate a model with multiple scenariosDesign professional and advanced chartsAcquire Excel proficiency by learning advanced functions, pivot tables, visualizations, and Excel featuresAbout the course:Unconditional 30-day money-back guaranteeNo significant previous experience necessary to understand the course and benefitUnlimited lifetime access to all course materialsEmphasis on learning by doingTake your Microsoft Excel and financial modeling skills to the next levelMake an investment that is rewarded in career prospects, positive feedback, and personal growth. This course is suitable for graduates aspiring to become investment bankers as it includes a well-structured DCF model with its theoretical concepts. Moreover, it motivates you to be more confident with daily tasks and gives you the edge over other candidates vying for a full-time position. People with basic knowledge of Excel who go through the course will dramatically increase their Excel skills. Take advantage of this opportunity to acquire the skills that will advance your career and get an edge over other candidates. Don't risk your future success.
Overview
Section 1: Beginner to Pro in Excel: Financial Modeling and Valuation - Welcome!
Lecture 1 What does the course cover?
Lecture 2 Bonus! Welcome gift
Lecture 3 Welcome gift number 2
Lecture 4 The best way to take this course
Lecture 5 Download all course materials and frequently asked questions (FAQ)
Section 2: Introduction to Excel
Lecture 6 Introduction to Excel
Lecture 7 Overview of Excel
Lecture 8 The Excel ribbon
Lecture 9 Basic operations with rows and columns
Lecture 10 Data entry in Excel
Lecture 11 Introduction to formatting
Lecture 12 Introduction to Excel formulas
Lecture 13 Introduction to Excel functions
Lecture 14 Cut, copy, & paste
Lecture 15 Paste special
Lecture 16 Format cells
Lecture 17 Basic operations in Excel - 38 pages
Section 3: Assignment 1
Section 4: Useful tips and tools for your work in Excel
Lecture 18 Excel best practices - Welcome lecture
Lecture 19 Initial formatting of Excel sheets for a professional layout
Lecture 20 Fast scrolling through Excel sheets
Lecture 21 Be even quicker: F5 + Enter
Lecture 22 Fixing cell references
Lecture 23 Alt + Enter
Lecture 24 Organize your data with text to columns
Lecture 25 The wrap text button
Lecture 26 Set print area
Lecture 27 Custom sort helps you sort multiple columns in Excel tables
Lecture 28 Create drop-down lists with data validation
Lecture 29 Find and select special types of cells with Select special (F5)
Lecture 30 Assign dynamic names in a financial model
Lecture 31 Define a named range in Excel
Lecture 32 Create a great Index page at the beginning of your models - Hyperlinks
Lecture 33 Introduction to custom formatting in Excel
Lecture 34 Apply custom formatting in a financial model
Lecture 35 Macros are a great timesaver! Here's why!
Lecture 36 How to save macros and use them across several workbooks
Lecture 37 Fix the top row of your table with freeze panes
Lecture 38 How to search functionalities in Excel
Lecture 39 Filter by color - an excellent tool
Lecture 40 Working with conditional formatting
Lecture 41 A neat trick - Multiply by 1
Lecture 42 Find and replace - references
Lecture 43 FAQ: Why do we replace external references and how does this help us?
Lecture 44 Find and replace - formatting
Lecture 45 Removing (automatic) green arrows
Lecture 46 Beauty saving - The professional way of saving files
Lecture 47 Formula auditing with F2
Section 5: Assignment 2
Section 6: Keyboard shortcuts in Excel
Lecture 48 Keyboard shortcuts save LOTS of time in Excel
Lecture 49 Keyboard shortcuts in Excel
Section 7: Excel's key functions and functionalities made easy
Lecture 50 Excel's key functions - Welcome lecture
Lecture 51 A helpful consideration
Lecture 52 Key functions in Excel: IF
Lecture 53 Key Excel functions: SUM, SUMIF and SUMIFS
Lecture 54 = and + are interchangeable when you start typing a formula
Lecture 55 Key Excel functions: COUNT, COUNTA, COUNTIF, COUNTIFS
Lecture 56 Key Excel functions: AVERAGE and AVERAGEIF
Lecture 57 Work with text efficiently: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE
Lecture 58 Working with text (continued)
Lecture 59 Find the minimum or maximum value in a range of cells in Excel
Lecture 60 Include ROUND in your financial models
Lecture 61 Key Excel functions: VLOOKUP and HLOOKUP
Lecture 62 How to enlarge the formula bar
Lecture 63 INDEX, MATCH and their combination - the perfect substitute for VLOOKUP
Lecture 64 A great Excel technique: INDEX, MATCH, MATCH
Lecture 65 XLOOKUP: a solid substitute for VLOOKUP and INDEX&MATCH
Lecture 66 Using Excel's IFERROR function to trap spreadsheet errors
Lecture 67 RANK is a valuable tool when using Excel for financial and business analysis
Lecture 68 CHOOSE - Learn how to render your models flexible
Lecture 69 Use Goal Seek to find the result that you are looking for
Lecture 70 Include sensitivity analysis in your models through Data Tables
Lecture 71 Excel's dynamic and interactive tables: Pivot tables
Section 8: Update! SUMIFS - Exercise
Lecture 72 Exercise - Excel's SUMIFS function - unsolved
Lecture 73 Exercise - Excel's SUMIFS function - solved & explained
Section 9: Assignment 3
Section 10: Financial functions in Excel
Lecture 74 Future and present values in Excel
Lecture 75 Calculating the rate of return of an investment with the IRR function
Lecture 76 Calculating a complete loan schedule in Excel
Lecture 77 Date functions in Excel
Section 11: Microsoft Excel's Pivot Tables in depth
Lecture 78 Introduction to Pivot Tables and the way they are applied
Lecture 79 Creating Pivot Tables easily!
Lecture 80 Give your Excel Pivot Tables a makeover
Lecture 81 Modifying and pivoting fields to obtain the Pivot Table you need
Lecture 82 Learn more about GETPIVOTDATA - A very important Excel function
Lecture 83 An introduction to slicers - The modern-day Pivot Table filters
Section 12: Case study - Building a complete P&L from scratch in Excel
Lecture 84 Case study - Build a P&L from scratch - Welcome lecture
Lecture 85 Introduction to the case study
Lecture 86 Understand your data source before you start working on it
Lecture 87 Order the source worksheets
Lecture 88 Create a code: the best way to organize your data and work efficiently with it
Lecture 89 Learn how to create a database
Lecture 90 Use VLOOKUP to fill the database sheet
Lecture 91 Use SUMIF to complete the database sheet
Lecture 92 FAQ: Sum of FY2018 doens't go down to zero
Lecture 93 Use INDEX & MATCH as a substitute for VLOOKUP
Lecture 94 Substituting VLOOKUP with XLOOKUP (Office 365 Only)
Lecture 95 Mapping the rows in the database sheet
Lecture 96 In case you have any doubts about the Mapping exercise
Lecture 97 Building the structure of the P&L sheet
Lecture 98 Formatting sets You apart from the competition in Excel - A Practical Example
Lecture 99 Populate the P&L sheet with SUMIF
Lecture 100 FAQ: Why the sum of the check should be 0?
Lecture 101 Learn how to find mistakes with COUNTIF
Lecture 102 Calculating year-on-year percentage variations the proper way
Lecture 103 FAQ: Why do we subtract -1 when calculating year-on-year growth?
Section 13: Introduction to Excel charts
Lecture 104 How to insert a chart in Excel
Lecture 105 Editing Excel charts
Lecture 106 Excel chart formatting
Lecture 107 How to create a bridge chart in Excel
Lecture 108 New ways to visualize your data - Treemap charts
Lecture 109 Sparklines
Section 14: P&L Case Study continued - Let's create some great-looking professional charts
Lecture 110 Create professional and good-looking charts - Introduction
Lecture 111 Build a column stacked chart with a secondary line axis in Excel
Lecture 112 Learn how to build effective doughnut charts in Excel
Lecture 113 Learn how to build an area chart in Excel
Lecture 114 Learn how to create bridge charts
Lecture 115 Learn how to create bridge charts in Excel 2007, 2010, and 2013
Lecture 116 Course Challenge - Apply your skills in practice!
Section 15: Business analysis techniques applied in Excel
Lecture 117 Trend Analysis in Excel
Lecture 118 Comparative Analysis in Excel
Lecture 119 Value-based analysis in Excel
Lecture 120 Correlation analysis in Excel
Lecture 121 Time series analysis in Excel
Lecture 122 Regression analysis in Excel
Section 16: Case Study - Building an FMCG Model from Scratch
Lecture 123 Introduction to the Case Study
Lecture 124 Preliminary mapping of the data extraction
Lecture 125 Working with an SAP data extraction
Lecture 126 Creating an output structure of the FMCG model
Lecture 127 Improving the layout and appearance of the FMCG report
Lecture 128 Inserting formulas and automating calculations
Lecture 129 Creating a Master Pivot Table: The main data source for the FMCG report
Lecture 130 GETPIVOTDATA is great! Extracting data from the Master Pivot Table
Lecture 131 A potential error with GETPIVOTDATA you might encounter and its fix
Lecture 132 FAQ: My GETPIVOTDATA function doesn't work
Lecture 133 Combining Slicers and GETPIVOTDATA: The key to our success
Lecture 134 Getting fancy with Excel slicers - Good-looking Excel slicers
Lecture 135 This is how the report can be used in practice by high-level executives
Section 17: Financial modeling fundamentals
Lecture 136 Financial modeling basics - Welcome lecture
Lecture 137 What is a financial model?
Lecture 138 Why use financial models?
Lecture 139 Financial modeling - worst practices - things you should avoid
Lecture 140 Financial modeling - best practices
Lecture 141 Financial modeling - The types of models that are built in practice
Lecture 142 Financial modeling: The right level of detail in a model
Lecture 143 Financial modeling: Forecasting guidelines
Lecture 144 Building a complete model - Important considerations
Lecture 145 Modeling the Income statement
Lecture 146 Modeling the Balance sheet - Part 1
Lecture 147 Modeling the Balance sheet - Part 2
Section 18: Introduction to Company Valuation
Lecture 148 Why value a company
Lecture 149 An investor's perspective
Lecture 150 The main value drivers when valuing a business
Lecture 151 How to calculate Unlevered Free Cash Flow
Lecture 152 How to calculate Weighted Average Cost of Capital (WACC)
Lecture 153 How to calculate cost of debt
Lecture 154 How to calculate cost of equity
Lecture 155 Forecasting a firm's financials
Lecture 156 How to obtain Terminal Value
Lecture 157 Discounting cash flows
Lecture 158 How to obtain Enterprise and Equity Value
Section 19: Introduction to Mergers & Acquisitions
Lecture 159 Introduction to Mergers & Acquisitions
Section 20: Learn how to build a Discounted Cash Flow model in Excel
Lecture 160 Valuation Case study - Welcome lecture
Lecture 161 Introduction to the DCF exercise
Lecture 162 The stages of a complete DCF Valuation
Lecture 163 Description of the structure of the DCF model
Lecture 164 A glimpse at the company we are valuing - Cheeseco
Lecture 165 Modeling the top line
Lecture 166 Introducing scenarios to the model with Choose
Lecture 167 Modeling other items: Other revenues and Cogs
Lecture 168 Modeling other items: Operating expenses and D&A
Lecture 169 Modeling other items: Interest expenses, Extraordinary items and Taxes
Lecture 170 Forecasting Balance sheet items
Lecture 171 An introduction to the "Days" methodology
Lecture 172 Calculation of DSO, DPO and DOI for the historical period
Lecture 173 Forecasting DSO, DPO and DOI
Lecture 174 Forecasting Property, Plant & Equipment, Other assets and Other liabilities
Lecture 175 Creating an output P&L sheet
Lecture 176 Populating the output P&L sheet
Lecture 177 Populating the output BS sheet
Lecture 178 Completing the output BS sheet for the historical period
Lecture 179 Creating a structure for the calculation of Unlevered free cash flows
Lecture 180 Bridging Unlevered free cash flow to Net cash flow
Lecture 181 Calculating Unlevered free cash flow
Lecture 182 Calculating Net cash flow
Lecture 183 Obtaining the rest of the cash flows through Find and Replace
Lecture 184 Introducing Weighted average cost of capital and Perpetuity growth
Lecture 185 Discounting Unlevered free cash flows to obtain their Present value
Lecture 186 Calculating Continuing value and Enterprise value of the business
Lecture 187 Calculating Equity value
Lecture 188 Sensitivity analysis for WACC and perpetuity growth
Lecture 189 A possible application of Goal seek
Lecture 190 Using charts to summarize the results of the DCF model
Section 21: Tesla valuation - Complete practical exercise
Lecture 191 Organizing external inputs in a 'Drivers' sheet
Lecture 192 Forecasting Tesla's expected deliveries
Lecture 193 Comparing delivery figures with the ones of industry peers
Lecture 194 Estimating an average selling price of Tesla vehicles
Lecture 195 Calculating automotive revenue
Lecture 196 Peer comparison: Gross profit %
Lecture 197 Calculating automotive gross profit
Lecture 198 Calculating automotive cost of sales
Lecture 199 Forecasting 'energy' and 'services' revenue
Lecture 200 Calculating 'energy' and 'services' gross profit and cost of sales
Lecture 201 Forecasting operating expenses
Lecture 202 Building a fixed asset roll forward: PP&E
Lecture 203 Building a fixed asset roll forward: estimating Capex
Lecture 204 Building a fixed asset roll forward: D&A schedule
Lecture 205 Calculating DSO, DIO, DPO
Lecture 206 Producing a clean P&L output sheet
Lecture 207 Calculating investments in working capital
Lecture 208 Forecasting Unlevered free cash flow
Lecture 209 Forecasting other assets
Lecture 210 Forecasting other liabilities
Lecture 211 Completing Unlevered free cash flow
Lecture 212 Modeling Tesla's financing needs in the forecast period
Lecture 213 Calculating Net income
Lecture 214 Bridging Unlevered free cash flow to Net cash flow
Lecture 215 Balancing the Balance sheet
Lecture 216 Estimating Weighted average cost of capital (WACC)
Lecture 217 Performing discounted cash flow valuation (DCF)
Lecture 218 Calculating enterprise value, equity value, and price per share
Lecture 219 Final comments
Lecture 220 You made it!
Section 22: How to value a company with multiples
Lecture 221 What are valuation multiples and why we use them?
Lecture 222 What types of valuation multiples are there?
Lecture 223 Trading vs transaction valuation multiples
Lecture 224 Main principles of multiples valuation
Lecture 225 Comparison of earnings multiples (P/E vs EV/EBITDA)
Lecture 226 Introduction to the exercise
Lecture 227 High-level assessment of peer companies
Lecture 228 Assessment of P&L data - comparable companies
Lecture 229 How to adjust EBIT - theoretical framework
Lecture 230 How to adjust EV - theoretical framework
Lecture 231 How to adjust EBIT - practical example - Volkswagen
Lecture 232 How to adjust EV - practical example - Volkswagen
Lecture 233 Conclusion of the practical exercise
Section 23: Comprehensive LBO valuation
Lecture 234 Case description
Lecture 235 Introduction to LBO Modeling exercise
Lecture 236 Key drivers in the LBO model
Lecture 237 Constructing the Profit and Loss header
Lecture 238 Analyzing historical Profit and Loss figures
Lecture 239 Valuing the Target company
Lecture 240 Estimating transaction fees
Lecture 241 Sources and uses of funds
Lecture 242 Shaping the Balance sheet at transaction
Lecture 243 Goodwill calculation
Lecture 244 Integrating assumptions into the Drivers sheet
Lecture 245 Building a Fixed asset roll forward schedule
Lecture 246 Forecasting financials using the Drivers sheet
Lecture 247 Completing the Profit and Loss statement (up to EBITDA)
Lecture 248 Modeling Working capital
Lecture 249 Filling in the Balance sheet at transaction sheet
Lecture 250 Add financials to the Balance sheet
Lecture 251 Projecting Fixed asset roll forward
Lecture 252 Developing a Debt schedule
Lecture 253 Creating a Fixed asset amortization schedule
Lecture 254 Structuring Cash Flow
Lecture 255 Designing the Financing sheet
Lecture 256 Calculating Cash Flow
Lecture 257 Building an Equity schedule
Lecture 258 Finalizing the Financing Cash Flow
Lecture 259 Modeling the Revolver facility (first part)
Lecture 260 Completing the Profit and Loss statement
Lecture 261 Modeling the Revolver facility (second part)
Lecture 262 Balancing the Balance sheet
Lecture 263 Exit valuation and IRR comparison
Section 24: Capital budgeting - The theory
Lecture 264 Introduction to Capital budgeting
Lecture 265 Why we need Capital budgeting?
Lecture 266 The time value of money
Lecture 267 Calculating future and present value
Lecture 268 Calculating cost of equity
Lecture 269 Coming up with project-specific beta
Lecture 270 Weighted average cost of capital (WACC)
Lecture 271 The type of cash flows we will have in a project
Lecture 272 Estimating the project's cash flows
Section 25: Capital Budgeting - A complete Case study
Lecture 273 Introduction to the Capital budgeting exercise
Lecture 274 Organizing an "Inputs" sheet
Lecture 275 Forecasting savings: Building a plant in Vietnam vs. producing cars in Italy
Lecture 276 Fixed asset rollforward
Lecture 277 The impact of working capital
Lecture 278 Modeling debt financing
Lecture 279 Adding a P&L sheet
Lecture 280 Calculating project cash flows
Lecture 281 Estimating the weighted average cost of capital (WACC)
Lecture 282 Finding cost of equity
Lecture 283 Discounting the project's cash flows and residual value
Lecture 284 Performing sensitivity analysis and completing the exercise
Lecture 285 FAQ: Data does not change in the DCF sheet, it changes from the Drivers sheet
Lecture 286 Congratulations!!
Section 26: Next steps
Lecture 287 Next steps
Section 27: BONUS - Data Analysis with ChatGPT - Intro
Lecture 288 How ChatGPT Advanced Data Analysis Will Boost Your Productivity
Lecture 289 The Limitations of ChatGPT Advanced Data Analysis
Section 28: BONUS - Data Analysis with ChatGPT - Exploratory Data Analysis (EDA)
Lecture 290 Exploratory Data Analysis - Intro
Lecture 291 Extracting Descriptive Statistics with ChatGPT
Lecture 292 Identifying Outliers
Lecture 293 Correlation Analysis: Hypothesis Formulation and Feature Ideas
Lecture 294 Crafting a Comprehensive EDA Prompt
Section 29: BONUS - Data Analysis with ChatGPT - Deal with Inconsistent Data
Lecture 295 Identifying and Handling Erroneous Data
Lecture 296 Verifying Data for Errors
Lecture 297 Eliminating Duplicate Rows
Lecture 298 Addressing Unit Discrepancies in Data
Lecture 299 Dividing Cell Content into Multiple Cells
Section 30: BONUS - Data Analysis with ChatGPT - Organize Messy Data
Lecture 300 Organize Messy Data
Lecture 301 Data Mapping
Lecture 302 Effective Data Classification
Lecture 303 Order Data with ChatGPT
Section 31: BONUS - Data Analysis with ChatGPT - Working with Functions
Lecture 304 COUNTIFS, SUMIFS
Lecture 305 Data Lookup
Lecture 306 Data Ranking
Lecture 307 Fill Until Non-blank Values
Lecture 308 Translating Logic into Excel Formulas with ChatGPT
Section 32: BONUS - Data Analysis with ChatGPT - Clean Text Data
Lecture 309 Correcting Inverted Names
Lecture 310 Dealing with Trailing and Leading Spaces in Text Data
Lecture 311 Standardizing Letter Capitalization
Lecture 312 Handling Multi-lingual Text Data
Lecture 313 Multiple "Find and Replace" at the Same Time with ChatGPT
Lecture 314 Criteria-based Duplicate Removal
Lecture 315 Removing Duplicates Across Multiple Columns
Section 33: BONUS - Data Analysis with ChatGPT - Dates and Time Data
Lecture 316 Obtain Day and Month From Date
Lecture 317 Converting Hours to Decimals
Lecture 318 Obtaining Age in Years, Months, Days
Lecture 319 Order Dates Chronologically
Section 34: BONUS - Data Analysis with ChatGPT - Complete Practical Example
Lecture 320 Intro to the Exercise and Preprocessing Ideas from ChatGPT
Lecture 321 Preprocessing the 'Free plan users' Sheet (1/2)
Lecture 322 Preprocessing the 'Free plan users' Sheet (2/2)
Lecture 323 Working on the 'Transactions' Sheet
Lecture 324 Dealing with the Country Mapping Issue
Section 35: APPENDIX - Microsoft Excel 2010 - Introduction to Excel
Lecture 325 Overview of Excel
Lecture 326 Basic manipulations with rows and columns
Lecture 327 The Excel ribbon
Lecture 328 Data entry in Excel
Lecture 329 Introduction to formatting
Lecture 330 Introduction to Excel formulas
Lecture 331 Introduction to Excel functions
Lecture 332 Cut, copy, & paste
Lecture 333 Paste special
Section 36: APPENDIX - Microsoft Excel 2010 - Useful tips and tricks
Lecture 334 Initial formatting of an Excel sheet to render it professional
Lecture 335 Fast scrolling through Excel sheets
Lecture 336 Introduction to fixing of cell references
Lecture 337 Learn how to use the Wrap Text button
Lecture 338 Create a drop-down list by using Data Validation
Lecture 339 Using Custom-sort in order to sort multiple columns within a table
Lecture 340 Create a great Index page at the beginning of your models - Hyperlinks
Lecture 341 Fix the top row of your table with Freeze Panes
Lecture 342 Macros are a great timesaver! Here's why!
Lecture 343 Find and select special types of cells with Select Special (F5)
Lecture 344 Assign custom formats to specific cells within a financial model (e.g Multiples)
Lecture 345 Define a named range in Excel
Lecture 346 Learn how to organize your data with Text to Columns
Lecture 347 Learn how to assign dynamic names within a financial model
Lecture 348 Create easily printable documents in Excel by using Set Print Area
Lecture 349 Using the 'Alt + Enter' combination
Section 37: APPENDIX - Microsoft Excel 2010 - Keyboard shortcuts
Lecture 350 Keyboard shortcuts Save LOTS of time in Excel 2010
Section 38: APPENDIX - Microsoft Excel 2010 - Excel functions
Lecture 351 Key Excel functions: SUM, SUMIF and SUMIFS
Lecture 352 Key Excel functions: COUNT, COUNTA, COUNTIF, COUNTIFS
Lecture 353 Key Excel functions: AVERAGE and AVERAGEIF
Lecture 354 Elaborate text efficiently: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATE
Lecture 355 Find the minimum or maximum value in a range of cells in Excel
Lecture 356 Include ROUND in your financial models
Lecture 357 Key Excel functions: VLOOKUP and HLOOKUP
Lecture 358 INDEX, MATCH and their combination - the perfect substitute for VLOOKUP
Lecture 359 Using Excel's IFERROR function to trap spreadsheet errors
Lecture 360 Learn how to render your models flexible with CHOOSE
Lecture 361 Use Goal Seek to find the result that you are looking for
Lecture 362 Include sensitivity analysis in your models through Data Tables
Lecture 363 Excel's dynamic and interactive tables: Pivot tables
Section 39: APPENDIX - Company Valuation
Lecture 364 Why value a company
Lecture 365 An investor's perspective when valuing a company
Lecture 366 Which are the drivers of company value?
Lecture 367 How to calculate UFCF
Lecture 368 What is WACC
Lecture 369 How to find cost of debt
Lecture 370 How to find cost of equity
Lecture 371 Forecasting financials
Lecture 372 Calculating terminal value
Lecture 373 Discounting cash flows
Lecture 374 Calculating enterprise and equity value
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
Homepage
Recommend Download Link Hight Speed | Please Say Thanks Keep Topic Live
No Password - Links are Interchangeable