Excellence With Excel 2.0 Highlights

This is the condensed version of this outline. Click Here for the full version.

Master Excel for Investment Banking and Private Equity

Learn the fundamnetals such as navigation and formatting all the way up to advanced topics like formulas, macros and pivot tables.

Excellence With Excel 2.0 lets you gain all the real-world knowledge via video based training created by Investment Bankers.

We base everything in Excellence With Excel 2.0 on what investment bankers actually do in real life:

  • There are 63 videos with accompanying Excel files as well as quick reference guide PDFs on key topics. That amounts to 23 hours of video altogether – but you also get full transcripts, so you can quickly skip to anything you need to review.
  • All the content is downloadable to your preferred device (works with all media players and on common devices, including desktops, laptops, tablets, and smartphones).
  • Easily keep track of your progress: As you move through the lessons, you can check off what you’ve completed and what’s still on your “to-do” list.
  • Fast answers to all your questions: Our expert support team is standing by to answer any questions you have about any of the content, 365 days a year.
  • Quizzes and Certifications. After you have completed each course, you will be eligible to take our challenging Certification Quiz. Once you pass the Quiz, you’ll be issued a Certificate that you can add to your resume / CV and refer to in interviews.
  • Included Lifetime Access: You also get lifetime access, so you can come back to the course whenever you need it – whether that’s in 1 month, 1 year, or 10 years.

What Others Are Saying About Our Modeling Courses...

They Helped Me More Than Finance Courses That I Had Taken in my MBA Program.

I have taken all modelling courses. They are more practical and they helped me more than finance courses that I had taken in my MBA program. Thank you Brian.

The BIWS Courses I Took Helped Me Significantly in Different Ways.

What about this as an answer. I am pretty much too busy to write a lot since I am now full time employed as an equity research analyst – straight out of University. So I keep it short.

The BIWS courses I took helped me significantly in different ways:

  1. Improving my Excel and PowerPoint skills which I need on a daily basis.
  2. Understanding different valuation methodologies which I need on a daily basis as well
  3. Networking with colleagues and customers
  4. Getting to know how the IB-Industry is working and by doing so understanding that it is not rocket science.

As you might have noticed from the aboe I took all courses and am pretty statisfied which what learned .

Breaking Into Wall Street Has Given Me a Very Well Needed Crash Course in What the People on the Opposite Side of the Table From Me Are Looking At.

As I work with due diligence of hedge fund managers, But with no financial background – never having traded or worked as an investment bank analyst. Breaking into wall Street has given me a very well needed crash course in what the people on the opposite side of the table from me are looking at in this sense. I guess I’m a bit of an odd bird among yur clients. Nevertheless, the material that you – in a pedagogic, understandable to the novice way – have provided me has been worth way more than the money spent.

The courses are created in a way that gives precious hands on knowledge by people who successfully have done this for a living. What I was after was not academical fluffy esoteric sturff, but something I could make use of as soon as the video clip ends. You provided me with this in a way that a beginner can understand and utilize, speeding up my process of becoming a professional in this field.

So many thanks for all the great stuff you have delivered so far, and I llok forward to the things to come.

Module 1: Overview & Excel Setup
  • In this module, you’ll watch the lessons and make sure that you’ve set up Excel correctly on your own computer, so we do not dive into the case study in much detail yet. If you already know Excel quite well and you’re taking this course to refresh your memory of certain topics, skip to the last lesson and the quick start guide so you can decide what to focus on.
Module 2: Navigation & Data Manipulation
  • In this module, you’ll skip between the two case study files and complete portions of both of them to master different features of Excel related to navigation and data manipulation.
  • You’ll learn how to insert, edit, and delete rows, columns, cells, worksheets, and workbooks, and how to enter formulas, text, and numbers properly, as well as how to use absolute and relative references and name and jump to cells.
Module 3: Formatting, Importing & Sorting Data
  • In this module, you’ll fix much of what’s incorrect in both case study files by applying proper formatting and changing around the background colors, font colors, fonts, font sizes, alignment, and more.
  • You’ll also learn key formatting mistakes to avoid, and how to perform common tasks such as color-coding your financial models and “cleaning up” data by using text, date, and time functions in Excel.
Module 4: Grouping, Hiding, Zooming & Printing
  • This module will teach you how to group and hide rows and columns, when it’s appropriate and inappropriate to do so, and also how to freeze panes and zoom in and out in Excel – so that you can print out exactly what you want and nothing more.
  • You’ll learn how to change the print and worksheet settings to change everything from headers and footers to grid lines and even the order that pages get printed in.
Module 5: Formulas, Lookups & Calculations
  • In this module, you’ll learn how to use Excel’s built-in arithmetic, logical, and financial functions and how to write and manipulate your own formulas for calculation and lookup purposes.
  • In addition, you’ll learn how to validate data, set up scenarios, audit formulas and handle errors, work with circular references, and use features such as sensitivity tables, goal seek, and pivot tables to analyze the output of models under different assumptions.
Module 6: Graphs and Charts
  • You’ll learn how to create the most important graphs and charts that you use in investment banking, private equity, and related fields in this course, from simple line and column graphs to combination graphs to valuation metrics and multiples and the “football field” graph. You’ll also learn how to create price-volume graphs for stock analysis and how to create “waterfall graphs” for EBITDA bridge analysis or a Sum-of-the-Parts valuation.
Module 7: Intro to VBA, Macros, Form Controls, Custom Shortcuts, and User-Defined Functions
  • In this module, you’ll get an introduction to the more advanced and programming-like features of Excel, such as macros, VBA (Visual Basic for Applications), user-defined functions, form and ActiveX controls, interactive charts, and custom keyboard shortcuts.
  • You’ll learn how to use these features to save time and perform common operations, such as color-coding your financial models, more efficiently. If you want to learn more, you’ll learn about recommended resources for learning these features in greater depth.
Module 1: Accounting Fundamentals
  • In this module, we'll cover accounting fundamentals - including the 3 major financial statements, how to link them together, and common interview questions on accounting.
  • We'll start out by looking at Apple's financial statements and building a 3-statement model from the ground up, going through the Income Statement, Balance Sheet, and Cash Flow Statement, and then linking them together.
  • After we've created the basic model, we'll go through a set of common interview questions on accounting, including how changes to different line items affect the statements.
Module 2: Creating 3-Statement Projections
  • In this module, we’ll show you how to create a 3-statement projection model from the ground up, starting with a blank sheet in Excel and progressing all the way to a finished model.
  • We'll start by using Apple's Income Statement, Balance Sheet, and Cash Flow Statement we created previously and to analyze the historical numbers and determine trends.
  • Then we'll use those trends to determine the company's profile in future years and project all 3 statements.
Module 3: Equity Value, Enterprise Value & Multiples
  • In this sequence of videos, we'll explain Equity Value, Enterprise Value, and common valuation multiples to bridge the gap between accounting and valuation and financial modeling.
  • Buying a company is just like buying house: there are always hidden costs, and the "real" price you pay is different from the list price. Throughout this sequence, we'll use this house analogy to explain the key concepts of Equity Value and Enterprise Value.
  • Then, we'll show you how to calculate key valuation metrics and multiples and answer common interview questions.
Module 4: Valuation Overview & Comparables
  • In this module, we'll begin our discussion of Valuation with an overview of how we use public company comparables, precedent transactions, and discounted cash flow analysis to value a company.
  • We start by showing you how to select comparable companies and transactions, then how to find the data in filings, and finally how to calculate and display all the relevant metrics.
Module 5: Discounted Cash Flow Analysis
  • In this module, we'll extend our valuation model by projecting our company's cash flow into future years and building a Discounted Cash Flow Analysis from the ground up.
  • We'll start with an overview of the analysis and our basic assumptions, and then move into the projections and how to combine their net present value and the terminal value to arrive at an overall valuation.
  • Then we'll take a detailed look at how to calculate the Weighted Average Cost of Capital and go through possible interview questions on all these topics.
Module 6: Valuation Summary
  • In this module, we'll link together the valuation methodologies we've created in previous modules and use them to arrive at an overall idea of what our company is worth.
  • Once we've done that, we'll go through each methodology and summarize the conclusions we can draw and what the model tells us about whether this company is over-valued or under- valued.
  • Finally, we'll answer a set of sample interview questions on the topic of valuation, focusing on the overall methodology as well as public company comparables and precedent transactions.
Module 7: Merger Model
  • In this module, we'll create a merger model between Apple and Research in Motion from the ground up and show how you combine the income statements of the buyer and seller and the purchase assumptions to get a view of the combined company.
  • We'll start by extending our house analogy to explain the concept of a merger model, and then go into the mechanics of the model and the key acquisition effects.
  • Then, we'll take a look at some advanced additions: revenue and expense synergies, combining the balance sheets, goodwill, intangible assets, and deferred tax liabilities, and sensitivity tables.
Module 8: LBO Model
  • In this module, we'll show you how to build an LBO model from the ground up, starting with an overview of the concepts behind the model and proceeding from assumptions to finished model.
  • We'll use the analogy of buying a house to explain LBO models, and then go through the transaction and operating assumptions necessary to complete the model. Then, we'll project Apple's financial statements 5 years and get a view of what it looks like when investors sell it.
  • Finally, we'll link together the entire model, project debt and interest payments, and look at investor returns over a range of values using sensitivity tables.
Module 9: More Advanced LBO Model
  • In this module, you'll learn how to build a more advanced LBO model that incorporates all 3 financial statements, pro-forma balance sheet adjustments, and 5 tranches of debt from the revolver to PIK notes.
  • We'll start by explaining how this model differs from the more basic one that we looked at, and then go into transaction assumptions, sources & uses, purchase price allocation and balance sheet adjustments.
  • Then, we'll cover how to set up a more advanced debt schedule, build in a cash flow sweep and revolver borrowing, and conclude by linking everything together and calculating returns and sensitivity tables.

Our Promise To You...

  • Get Immediate Access. The instant you sign up, you'll have immediate access to 178 lessons, 43 hours of video and all the PDF Quick Start Guides.
  • Unlimited, 365-Day Per Year Support. We have a team of experienced bankers standing by to respond to your questions, comments, and emails 365 days per year, for as long as you need.
  • Money-Back Guarantee. Breaking Into Wall Street is the first and only financial modeling training program that comes with an unconditional 12-Month Money-Back Guarantee.
  • Course Certifications. After completing the course material, you’re eligible to take our Certification Quiz. Once you pass the quiz, you’ll be issued a Certificate that you can add to your resume / CV and refer to in interviews.