Udemy

Platform

English

Language

Microsoft

Category

Excel, PowerPoint & Presentations for Investment Bankers

The mother of all Excel and PowerPoint courses, tailor-made for investment bankers!

4.15 (107 reviews)

Students

9.5 hours

Content

Jul 2018

Last Update
Regular Price

SKILLSHARE
SkillShare
Unlimited access to all SkillShare courses
EXCLUSIVE 30-DAY FREE TRIAL

What you will 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


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

Screenshots

Excel, PowerPoint & Presentations for Investment Bankers
Excel, PowerPoint & Presentations for Investment Bankers
Excel, PowerPoint & Presentations for Investment Bankers
Excel, PowerPoint & Presentations for Investment Bankers

Content

Introduction

Introduction

Excel for Investment Bankers

Introduction to Excel

Spreadsheets

Rows and columns

Cells

Linking cells

Copy and paste options

Sort and filter data

Printing excel files: Page layout

Formulas for M&A analysts: Basic operations

Formulas for M&A analysts: Statistical operations

Formulas for M&A analysts: Conditional statements

Formulas for M&A analysts: Count statements

Formulas for M&A analysts: Database formulas

Formulas for M&A analysts: Text formulas

Formulas for M&A analysts: Financial formulas

Using keyboard shortcuts

PowerPoint for Investment Bankers

Introduction to PowerPoint

View

Texts

Tables

Shapes

Pictures

Slide Master

Headers and footers

A potential investor list

A company organization chart

Presentations

Introduction to presentations

Excel: What are we going to build?

Column charts

Bar charts

Pie charts

Line charts

Scatter charts

Bubble charts

Sum of parts charts

Charts with two vertical axis

Power Point: What are we going to build?

Preparing a teaser - Company overview page

Preparing a teaser - Key investment highlights page

Preparing a teaser - Brands and products page

Preparing a teaser - Key financials page

The End

The End


Reviews

T
Thanitta11 April 2021

Ms.Excel is simple for me. However, the PowerPoint presentation improve my skill a lots but the voice of video was very small although I turn-on volume 100%. It's good for beginner.

M
Marlyse8 May 2020

Good! I feel lke I needed more interaction with the teacher through one or two exercises (or quizzes) to make sure that we got what you explained.

Y
Yulia22 December 2019

Information is given in clear, available way for the complete beginner. I even didn't expect that learning excel can be so exciting! Thank you a lot!

W
Wyatt25 August 2019

Amazing course! Ali is the MAN. Have reccomended this to friends. I am aiming to break into Investment Banking so found it useful to learn at least at a high level what goes into a pitch in addition to the technicals, but can imagine these lessons would be useful from an Excel and PowerPoint perspective for almost any job, especially in finance.

L
Lukas25 September 2018

too basic so far...had higher expectations for excel for investments bankers...this is more like excel for high school students so far

G
Ghers12 February 2018

Awesome course with lots of useful excel and power point tricks! Small details: the red pointer and movement between cells gets very distracting at times, and the subtitles (english) were full of mistakes.

D
Dean8 January 2018

It would be great if there were actual spreadsheets to physically work with while watching the lecture.

M
Momo11 September 2017

I had the chance to take this course, and what can I say! It's the best one on the internet right now. I love the way Ali explain. In my opinion this is the course to have if you are dreaming of having a great understanding o the of excel and PPT for your career. It helped me a lot in my daily tasks and improved my ease with excel and PPT Thank you so much Ali!

F
Francine1 September 2017

The course was well structured with a pace that I can easily follow. The instructor went into enough practical depth that I can use at work. The content was comprehensive enough that I gain value from the investments (time and money). Since I'm already familiar with some of the banking concepts, I did fast forward through some repetitive parts to save time; but I can see how those who are new to the concepts can benefit from the repetitions.


Related Courses

SKILLSHARE
2020 Complete Presentation Skills Masterclass for Every Occasion
2020 Complete Presentation Skills Masterclass for Every Occasion
SKILLSHARE
Presentation Skills -Deliver an Excellent Ceremonial Speech
Presentation Skills -Deliver an Excellent Ceremonial Speech
SKILLSHARE
Presentation Skills For Non-Native English Speakers
Presentation Skills For Non-Native English Speakers

1320508

Udemy ID

8/13/2017

Course created date

11/21/2019

Course Indexed date
Bot
Course Submitted by

Twitter
Telegram