About Course
FAQ's
This course is for candidates aiming to join Investment Banking.
All you need is Excel basis.
Are you aiming M&A position ? If yes, this course suits you.
Immediately after your payment, you can login to the site and access the video in your user account. You can also download the Excel template to practice.
A one-time payment of €299 gives you an illimited access to this course and the Excel models
No, just a computer, an internet connection, and office 365 (Excel).
You can follow this course if you have a Mac but to be sure to perform at the client, you will need a PC to model your model on Excel
By online transaction with a bank card or by PayPal.
Yes. Payment by credit card and PayPal are secure.
Only if you paid for the course less than 48 hours ago and viewed less than 20% of the course.
You can contact us by email contact@alumneye.fr
We ask our users to use two-step authentication to ensure the security of their account and to prevent possible fraudulent actions. Thank you for your understanding
No. When you have purchased the course, access is strictly personal. Your username and password are unique.
No, this course does not allow you to receive a certificate at the end of the training
No, this course is not eligible for the CPF.
However if you are an investment professional, you should ask approval to expense the training fee as part of your professional development. You will automatically receive a VAT invoice at your name or at the company’s name.
You can contact us by email contact@alumneye.fr or by phone (+33) 01 76 39 01 09
What Will You Learn?
- How to present outputs in a clean and readable Excel sheet and PowerPoint
- How to present Excel file
- How to present Powerpoint
- How to use key formulas such as iferror, if, some if, choose, countif..
- How to create different tabs like football field, sum of the part, trading comparables output...
- How to create a shell
- How to assign shortcuts on Excel and PowerPoint
- The best practices to organize your emails and folders
Course Content
Presentation
-
01:25
Organise Folder
-
Organise Folder
02:46
Excel Training – How to present an excel file
-
Cover Page
01:56 -
Colour Coding and Number Formating
03:06 -
Print Area
01:32 -
Naming and Organising Tabs
01:33 -
Sourcing Information
02:11
Excel Training – How to format output tabs
-
General Formatting
06:00 -
Alignment
01:08
Excel Training – Best Practices
-
Important Shortcuts (Lines)
02:54 -
Important Shortcuts (Alt + A + E)
02:15 -
Important Shortcuts (Font Color – Font Size)
03:14 -
Important Shortcuts (Line formatting)
02:43 -
Setting up your own shortcuts
02:25
Excel Training – Introduction to most common output tabs
-
Forecast Tabs
02:17 -
Broker Consensus
03:02 -
Trading Comparables Output
03:16 -
Fully Diluted number of shares
08:17 -
Equity to EV Bridge
04:04 -
Transaction Comparables
03:53 -
DCF
06:51 -
DCF Sensi Tables
06:40 -
Share Price Performance
03:26 -
High Level LBO
06:17 -
Sum Of The Part (SOTP)
02:58 -
Football Field
04:02 -
At Various Prices Analysis
03:27 -
Capital Increase
03:28
Excel Training – Key Formulas
-
IF, IFERROR, AND, OR
04:07 -
SUM, SUMIF, SUMPRODUCT
04:16 -
XLOOKUP, INDEX MATCH, SUMIF V2
03:00 -
CHOOSE, OFFSET
03:14 -
COUNTIF, ISBLANK
03:08
Powerpoint – Best Practices
-
Starting with a Template
01:58 -
Creating a Shell
01:41 -
When to Create a New Version
01:47
Powerpoint – Most common slides
-
Profil Slide
05:58 -
Management Overview Slide
02:47 -
Financial Overview Slide (1/2)
05:05 -
Financial Overview Slide (2/2)
02:23 -
Share Price Performance Slide
02:47 -
Short Profiles Slide
03:18 -
Trading Comparables Slide
07:10 -
Transaction Comparables Slide
05:11 -
DCF Slides
04:43 -
LBO Slides
04:19 -
Football Field
02:50 -
Shell Overview
02:53
Powerpoint – Setting up your shortcuts
-
Setting up your shortcuts
02:21
Outlook – Best Practices
-
How to Organise Folders
02:37 -
Sending Emails and Invitations
04:36 -
Delaying Emails You Send + Recalling an Email
02:43
Attitude
-
Attitude
04:30