Investment Banking & Financial Modelling Course with Certificate 

Investment Banking Overview

Introduction & History of Investment Banking

Core areas of Investment Banking Activity

Investment Banking Strategies

Dates & Logical Functions

Capital Markets – Equity & Debt (IPO, SEO, etc.)

Advisory Services – M&A and Restructuring

Pivot Tables

Trading & Brokerage

Asset Management

Capstone Project

 

Corporate Finance: Practical Aspects

Mastering Time Value of Money using Excel

Cost of Capital: Dealing with challenges in the practical world

Capital Budgeting Techniques: Applied on project

Key Concepts: Free Cash Flow, Enterprise value, etc

Valuation Techniques

Capstone Project

 

Financial Statements Analysis

Interpreting FS of Listed Companies

Cash Flow statement

Computing Depreciation using Excel formulae

Working capital: Practical aspects

Capital Markets – Equity & Debt (IPO, SEO, etc.)

Ratio Analysis: Forming Basis for Comparables Valuation

DuPont Analysis

Common-sizing

Asset Management

Capstone Project

 

Building Financial Models

Financial Modeling Process

Best Practices in Financial Modeling

Build a model from a Blank Excel sheet

Projection of financial statements

Inter-linking the statements

Sensitivity Analysis

Football Field Chart

 

STOCK MARKET THE BEGINNING

Introduction To Markets

Introduction of Stock Market

Next Step In Stock Market

Corporate Actions & Its Impact On Stock Prices

Introduction To Derivatives

Introduction To Trading

Getting Familiar With Trading Terminal

Introduction To Charts

 

TECHNICAL ANALYSIS

Price Action Concept

Candlestick Patterns & Forms

Types of Trends

Support & Resistance Concept

Price Action Strategies

What are Breakouts & Reversals

Time Frame Analysis

 

Excel A-2-Z

Basics of Excel

Formatting Data in Excel

Sort & Filter Option

Dates & Logical Functions

Everything about LOOKUP Formulas

Conditional Aggregation & Formatting

Pivot Tables

Analysis using What-If

Report Consolidation

Capstone Project

 

Data Analysis via Pivot Tables

Getting Started with Pivot Tables

Formatting Data with Pivot Tables

Sorting, Grouping and Filtering Data

Pivot Table Calculated Values & Fields

Visualization using Pivot Tables

Excel Pivot Table Case Studies

Capstone Project

 

Visualization in Excel

Getting Started with Visualization

Data Visualization Best Practices

Excel Chart Formatting & Customization

Mastering Excel Charts and GraphsI

Making Dashboard on Real World Data

Amazon Data Dashboard

Election Comission Data Dashboard

Wrapping Up

Capstone Project

 

Mastering Excel VBA & Macros

Starting via First Macro

The object Model

Working with Variables

Controlling Flow of Code

Working with Arrays

Working with Files, Folders & Text Files

Interacting with Other Applications

Workbook and Worksheet Events

Working with Userforms & ActiveX Controls

Creating Custom Functions

Capstone Projects