Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
9 Hour(s) 29 Minute(s)
Language
English
Taught by
Ali Ilci
Rating
Course Overview
The mother of all Excel and PowerPoint courses, tailor-made for investment bankers!
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
Course Content
- 5 section(s)
- 43 lecture(s)
- Section 1 Introduction
- Section 2 Excel for Investment Bankers
- Section 3 PowerPoint for Investment Bankers
- Section 4 Presentations
- Section 5 The End
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
Skills covered in this course
Reviews
-
AAnang Nur Prasetya
Great
-
HHarsh Trivedi
excellent course
-
VVinit Parmar
Great course if you want to the exact tools used in an M&A firm.
-
AAnoop Sahota
Very thorough thus far. Learnt about things I did not know existed.
