Excel, PowerPoint & Presentations for Investment Bankers
4.3 (2 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
7 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Excel, PowerPoint & Presentations for Investment Bankers to your Wishlist.

Add to Wishlist

Excel, PowerPoint & Presentations for Investment Bankers

The mother of all Excel and PowerPoint courses, tailor-made for investment bankers!
4.3 (2 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
7 students enrolled
Created by Ali Ilci
Last updated 8/2017
English
Current price: $10 Original price: $145 Discount: 93% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 9.5 hours on-demand video
  • 9 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • GET the general structure of Excel and what it is capable of
  • MANAGE Excel spreadsheets
  • MANAGE Excel rows and columns
  • MODIFY excel cells
  • CREATE links that save significant time and lower error margins
  • COPY and paste with various options
  • SORT and filter big data to work efficiently
  • Print excel files properly
  • USE basic operation formulas
  • USE statistical formulas
  • USE conditional formulas
  • USE count formulas
  • USE database formulas
  • USE text formulas
  • USE financial formulas
  • USE the most common excel keyboard shortcuts
  • MANAGE views, texts, tables, shapes and pictures in Power Point
  • USE PowerPoint Slide Master
  • MANAGE headers and footers in PowerPoint
  • MAKE 20+ graphs and charts in Excel that are widely used in investment banking presentations
  • MAKE some first class, clean and beautiful presentations including a teaser for Starbucks Corporation
View Curriculum
Requirements
  • There is absolutely no prerequisite!
  • The course will cover everything from scratch with extensive video explanations.
  • You will need Microsoft Excel and Power Point (in PC or Mac) and to be eager to learn.
Description

About this Course

Excel, PowerPoint and Presentations for Investment Bankers covers the soft skill parts of Become an M&A Analyst: The Complete Skillset series. 

This course offers 41 lectures across 3 sections and everything is done with almost 10 hours of extensive video content. There is also 9 supporting Excel and PowerPoint supporting documents including some first class presentations.

In this course, we will be covering all the Excel and Power Point skills necessary become an investment banking analyst.

What should you expect from this course?

Students/Career Changers

  • You will be able use Excel like a pro, as if you have been working in the industry for a few years
  • Deliver first class presentations using the most well-know methods and tricks

Junior Employees

  • You will get better and faster in Excel and PowerPoint, eyeing your promotion

Business Owners/ Entrepreneurs

  • You will develop super useful Excel and PowerPoint skills to make your daily business much more efficient
Who is the target audience?
  • Ambitious undergraduate and masters students - regardless of their major - who want to pursue a career in investment banking/ M&A advisory.
  • Junior investment bankers, consultants, venture capitalists and equity analysts who want to hone their skills.
  • Business executives / owners / entrepreneurs who want to learn about corporate finance and M&A process.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
43 Lectures
09:29:48
+
Introduction
1 Lecture 03:52
+
Excel for Investment Bankers
16 Lectures 03:01:40
Introduction to Excel
01:23

Spreadsheets
13:01

Rows and columns
06:31

Cells
24:45

Linking cells
09:47

Copy and paste options
16:14

Sort and filter data
13:55


Formulas for M&A analysts: Basic operations
09:16

Formulas for M&A analysts: Statistical operations
08:18

Formulas for M&A analysts: Conditional statements
11:09

Formulas for M&A analysts: Count statements
06:15

Formulas for M&A analysts: Database formulas
14:01

Formulas for M&A analysts: Text formulas
09:53

Formulas for M&A analysts: Financial formulas
07:29

Using keyboard shortcuts
08:20
+
PowerPoint for Investment Bankers
10 Lectures 02:50:55
Introduction to PowerPoint
01:20

View
11:46

Texts
11:49

Tables
22:30

Shapes
27:33

Pictures
19:27


Headers and footers
08:13

A potential investor list
36:41

A company organization chart
20:08
+
Presentations
15 Lectures 03:31:54
Introduction to presentations
01:52

Excel: What are we going to build?
02:08

Column charts
14:16

Bar charts
12:28

Pie charts
16:10

Line charts
07:57

Scatter charts
08:16

Bubble charts
09:33


Charts with two vertical axis
12:21


Preparing a teaser - Company overview page
36:48

Preparing a teaser - Key investment highlights page
12:54

Preparing a teaser - Brands and products page
12:50

Preparing a teaser - Key financials page
51:04
+
The End
1 Lecture 01:27
The End
01:27
About the Instructor
Ali Ilci
4.2 Average rating
32 Reviews
2,581 Students
3 Courses
Investment Banking I 2,500+ students

Hi everyone my name is Ali and I am a former M&A analyst and later associate who worked on various M&A deals ranging from thirty million up to over a billion dollars.

I worked on the sell-side and on the buy-side in deals across 8 countries including the UK, the US, Italy, Spain, France, the Netherlands, Dubai and Turkey. I have deal experience in various industries including power generation, electricity and natural gas distribution, hospitality, food & beverage and tender process of concession assets such as tool roads, ports and marinas.

I graduated with a degree in economics and finance from a top-tier university in the UK and started my career in a US based Bulge Bracket investment bank and worked at several institutions before I quit advisory business and moved to buy-side. 

Remembering the struggles I had until I made way into investment banking, I decided to create courses like never created before - single stop shops for everything you will ever need to become a star investment banking analysts / associates.

With days and nights (very, very late nights) of hands on experience for more than 6 years, I will teach you all the necessary skills to land a job on and to survive in investment banking!