Executive Post-Graduate Certification in Investment Banking Operations

MS-Excel –

1.1 Excel Fundamentals 

• Reading the Data, Referencing in formulas, Name Range, Logical Functions, Conditional Formatting, Advanced Validation, Dynamic Tables in Excel, Sorting and Filtering
• Working with Charts in Excel, Pivot Tables, Dashboards, Data and File Security
• VBA Macros, Ranges, and Worksheets in VBA
• IF conditions, loops, Debugging, etc.

1.2 Excel For Data Analytics 

• Handling Text Data, Splitting, combining, data imputation on text data, Working with Dates in Excel, Data Conversion, Handling Missing Values, Data Cleaning, Working with Tables in Excel, etc.

1.3 Data Visualization with Excel

• Charts, Pie charts, Scatter and bubble charts
• Bar charts, Column charts, Line charts, Maps
• Multiples: A set of charts with the same axes, Matrices, Cards, Tiles

Mergers and acquisitions (M&A) refer to the consolidation of companies through various financial transactions. In a merger, two or more companies combine their operations to form a new entity, while an acquisition involves one company purchasing another company. M&A activities are typically undertaken to achieve strategic objectives, such as expanding market share, entering new markets, gaining access to new technologies or resources, or achieving synergies.

There are different types of M&A transactions:

1. Merger of Equals: This occurs when two companies of similar size and strength merge to form a new entity.
2. Vertical Merger: In this type of merger, companies operating in different stages of the supply chain or production process combine their operations. For example, a car manufacturer merging with a tire producer.
3. Horizontal Merger: This type of merger involves two companies operating in the same industry and market, aiming to increase market share, eliminate competition, or achieve economies of scale. An example would be two competing banks merging.
4. Conglomerate Merger: Companies operating in unrelated industries merge to diversify their business operations and spread risks. For instance, a media company merging with a food processing company.
5. Acquisition: This refers to one company buying another company outright. The acquired company may continue to operate independently or be merged into the acquiring company.
6. Comparable Company Analysis (CCA): It is a process used to evaluate the value of a company using the metrics of other businesses of similar size in the same industry.

M&A transactions involve various stages, including strategic planning, valuation, due diligence, negotiation, and integration. These transactions require careful consideration of financial, legal, operational, and cultural aspects to ensure a successful outcome.

• Job Search Strategy
• Resume Building
• Linkedin Profile Creation
• Interview Preparation Sessions by Industry Experts
• Mock Interviews
• Placement opportunities with 400+ hiring partners upon clearing the Placement Readiness Test.