4.15 (107 reviews)
☑ 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
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?
Business Owners/ Entrepreneurs
Excel for Investment Bankers
Introduction to Excel
Rows and columns
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
Headers and footers
A potential investor list
A company organization chart
Introduction to presentations
Excel: What are we going to build?
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
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.
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.
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!
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.
too basic so far...had higher expectations for excel for investments bankers...this is more like excel for high school students so far
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.
It would be great if there were actual spreadsheets to physically work with while watching the lecture.
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!
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.