Excel, PowerPoint & Presentations for Investment Bankers

Name: Excel, PowerPoint & Presentations for Investment Bankers
Rating: 4.6 (222 reviews)

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

Highest Rated

Created byAli Ilci

Last updated 7/2018

English

What you'll 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

Course content

5 sections • 43 lectures • 9h 29m total length

Introduction3:52

Introduction to Excel1:23
Spreadsheets13:01
Master managing Excel spreadsheets by renaming, adding, copying, moving, coloring, hiding, and deleting sheets; learn to share workbooks, protect sheets and workbooks with passwords, and use undo and save shortcuts.
Rows and columns6:31
Cells24:45
Linking cells9:47
Copy and paste options16:14
Sort and filter data13:55
Master sort and filter data in Excel to organize large financial data by value, color, city, points, and advanced criteria for efficient analysis.
Printing excel files: Page layout21:23
Learn to format and print Excel workbooks for professional reports by setting the print area, repeating top rows, and using page break preview to ensure clean, print-ready pdfs.
Formulas for M&A analysts: Basic operations9:16
Formulas for M&A analysts: Statistical operations8:18
Explore essential statistical formulas in Excel, including average, median, weighted average, max, and min, using a data table and range selections to analyze boat length data.
Formulas for M&A analysts: Conditional statements11:09
Formulas for M&A analysts: Count statements6:15
Formulas for M&A analysts: Database formulas14:01
Formulas for M&A analysts: Text formulas9:53
Formulas for M&A analysts: Financial formulas7:29
Using keyboard shortcuts8:20
Learn essential keyboard shortcuts for Excel and PowerPoint, including Alt+Tab navigation, sheet navigation with Ctrl/Page Up or Down, and Alt H logic plus Format Painter to boost efficiency.

Introduction to presentations1:52
Learn to combine Excel charts and PowerPoint visuals to create compelling marketing documents, including teasers and information memorandums, for advisory presentations.
Excel: What are we going to build?2:08
Column charts14:16
Bar charts12:28
Pie charts16:10
Line charts7:57
Scatter charts8:16
Explore creating scatter charts in Excel to compare EV/EBITDA multiples across five healthcare companies, visualize investor valuations, and customize axes, titles, and data labels; introduction to bubble charts next.
Bubble charts9:33
Create bubble charts in Excel to compare valuations, using bubble size to represent enterprise value and data labels for multiples, with axis and style refinements.
Sum of parts charts11:03
Charts with two vertical axis12:21
Learn to create charts with two vertical axes in Excel, combining revenues and oil price per barrel using a cluster column and a line with markers on a secondary axis.
Power Point: What are we going to build?2:14
Preparing a teaser - Company overview page36:48
Preparing a teaser - Key investment highlights page12:54
Preparing a teaser - Brands and products page12:50
Preparing a teaser - Key financials page51:04

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 this course is for:

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.

Excel, PowerPoint & Presentations for Investment Bankers

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 4min

Excel for Investment Bankers16 lectures • 3hr 2min

PowerPoint for Investment Bankers10 lectures • 2hr 51min

Presentations15 lectures • 3hr 32min

The End1 lecture • 1min

Requirements

Description

Who this course is for: