Advanced Excel

Corporate Bridge’s Computer Based Comprehensive Course on www.corporatebridge.
net
Basic & Advanced MS Excel For Registrations Contact:
92222 87738, 92222 87739, 92232 33568,
Corporate Bridge’s Computer Based Comprehensive Financial Modeling 92232 33569, 3222 5058
Workshop
The main goal of the course is to enable professionals to enhance their MS excel
mail us at: mail@corporatebridge.net
skills through exercise and gaining hands-on experience on various techniques. The
course covers step-by-step lessons ranging from basic fundamentals to more
advanced features and program applications. It is a highly practical course that will What to Bring:
lead to learning powerful features and options of excel to manage their worksheet-
Who should attend? Laptop
related tasks more efficiently. The course will help delegates gain Excel Proficiency –
Calculator
calculations, functions, formulas, and Excel Best Practices. Also, the focus will be
Investment bankers
given on formatting.
Fund managers
Equity analysts Contact us at:
Agenda and Schedule Equity traders Corporate Bridge Academy
318, A Block
Equity Sales
Session 1: Basic Excel Session 2: Charts & Layouts Sagar Tech Plaza, Sakinaka,
Credit analysts Andheri East
Excel overview Creating Chart using Chart Wizard
Excel navigation & Menu commands o Changing Chart Options Strategists Mumbai 400 072
Entering, moving, & manipulating o Formatting Chart info@corporatebridge.net
Useful graphs and charts Treasurers www.corporatebridge.net
data
Managing worksheet & workbook o Two-axis graphs Executive Level
information o Multiple kind of charts Managers
Formatting worksheets Setting up Page and Print
Adjusting Column Width / Row Height o Setting Up Page Students
Formatting Cell Using Toolbar o Previewing and Printing
Formatting Cell Using Menu Options
Session 4: Using Excel Tools Team at Corporate Bridge Academy:

Session 3: Basic Excel Functions Dheeraj Vaidya (IITD, IIML)
Data filter
Logical functions : AND, IF, OR Sort D. Balasubramaniam (AIM Manila)
Arithmetic functions : ABS, INT, Pivot Tables: Creating Pivot Table, Gaurav Singh (IITD, IIMC)
LARGE, MAX, MIN, SMALL, Updating Pivot Table, Modifying S. Premananda (IITD, IIMC)
TRUNC Calculated Field in Pivot Table K. Kayideni (IITD, IIMA)
Date functions : DATE, WEEKDAY Advanced formatting Bharat Rathi (IIMI)
Aggregation: COUNT, COUNTA, o Customizing Data
COUNTBLANK, COUNTIF, SUMIF, Kavish Sarawgi (IIML)
o Advance Formatting
SUMPRODUCT o Conditional Formatting 40+ faculty from IIT-IIM with significant experience in
Strings: LEFT, RIGHT, MID, FIND, o Format Consistency Investment Banking, Equity Research, Private Equity, Risk
PROPER, CONCATENATE o Data Outlining Management etc.
Session 5: Advanced Formulae Session 6: Multiple Sheets &

Auditing form Auditing features Our Advisory Team:
Auditing Worksheets And Dr. T. R. Madan Mohan (Ex Prof. IIM Bangalore)
Multiple Sheets
Tracing Cell References Linking worksheets using 3-D Prof. B. K. Mohanty (IIM Lucknow)
Tracing Errors formulas, Consolidating data, Prof. A.K. Mishra (IIM Lucknow)
Advanced referencing functions Creating hyperlink, Creating links Prof. Pranay K Swain (IIM Calcutta)
CHOOSE, COLUMNS, MATCH, between different worksheets Romil Pant (National Head, Future Capital Financial)
ROWS, VLOOKUP, HLOOKUP Auditing
Tracing errors in worksheet,
Workgroup collaboration, Tracking
changes
About Corporate Bridge
Session 7: Data form & Macros
Data Form Session 8: What-if Analysis Founded by graduates from leading institutes (IITs, IIMs),
o Add a record Corporate Bridge is a global full-service financial training
Goal-seek command
o Modify a record firm, providing instructor-led training and e-learning
Using Data Tables
o Delete a record
o One input data table services to professionals from investment banks and
Macros
o Two input data table financial institutions. Also, it has conducted seminars at
o Recording a macro
Create a scenario some of the most prestigious academic institutions and
o Running a macro using
Merger scenario from another
menu command corporations in the world, including IIM Lucknow, IIM
worksheet
o Assign a macro to a Indore, IIT Delhi, IIT Kanpur, MDI Gurgaon, FMS Delhi,
Protecting Scenarios
button
NITIE, NMIMS, BSE, Indian Institute of Capital Markets etc..
EXCEL FINAL ASSIGNMENT
Highly Practical, never had before experience - Chetan, Yes Bank

Advanced Excel

Uploaded by

Copyright:

Available Formats

Advanced Excel

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Advanced Excel

Uploaded by

Copyright:

Available Formats

Corporate Bridge’s Computer Based Comprehensive Course on www.corporatebridge.

Session 4: Using Excel Tools Team at Corporate Bridge Academy:

Session 5: Advanced Formulae Session 6: Multiple Sheets &

Highly Practical, never had before experience - Chetan, Yes Bank

You might also like