Hide Notes 

Slide 1: Corporate Bridge’s Computer Based Comprehensive Course on www.corporatebridge.net For Registrations Contact: 92222 87738, 92222 87739, 92232 33568, 92232 33569, 3222 Corporate Bridge’s Computer Based Comprehensive Financial Modeling Workshop 5058 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 lead to learning powerful features and options of excel to manage their worksheetrelated tasks more efficiently. The course will help delegates gain Excel Proficiency – calculations, functions, formulas, and Excel Best Practices. Also, the focus will be given on formatting. Basic & Advanced MS Excel Who should attend? Investment bankers Fund managers What to Bring: Laptop Calculator Agenda and Schedule Session 1: Basic Excel Excel overview Excel navigation & Menu commands Entering, moving, & manipulating data Managing worksheet & workbook information Formatting worksheets Adjusting Column Width / Row Height Formatting Cell Using Toolbar Formatting Cell Using Menu Options Equity analysts Equity traders Equity Sales Credit analysts Strategists Treasurers Executive Level Managers Students Contact us at: Corporate Bridge Academy 318, A Block Sagar Tech Plaza, Sakinaka, Andheri East Mumbai 400 072 info@corporatebridge.net www.corporatebridge.net Session 2: Charts & Layouts Creating Chart using Chart Wizard o Changing Chart Options o Formatting Chart Useful graphs and charts o Two-axis graphs o Multiple kind of charts Setting up Page and Print o Setting Up Page o Previewing and Printing Session 3: Basic Excel Functions Logical functions : AND, IF, OR Arithmetic functions : ABS, INT, LARGE, MAX, MIN, SMALL, TRUNC Date functions : DATE, WEEKDAY Aggregation: COUNT, COUNTA, COUNTBLANK, COUNTIF, SUMIF, SUMPRODUCT Strings: LEFT, RIGHT, MID, FIND, PROPER, CONCATENATE Session 4: Using Excel Tools Data filter Sort Pivot Tables: Creating Pivot Table, Updating Pivot Table, Modifying Calculated Field in Pivot Table Advanced formatting o Customizing Data o Advance Formatting o Conditional Formatting o Format Consistency o Data Outlining Team at Corporate Bridge Academy: Dheeraj Vaidya (IITD, IIML) D. Balasubramaniam (AIM Manila) Gaurav Singh (IITD, IIMC) S. Premananda (IITD, IIMC) K. Kayideni (IITD, IIMA) Bharat Rathi (IIMI) Kavish Sarawgi (IIML) 40+ faculty from IIT-IIM with significant experience in Investment Banking, Equity Research, Private Equity, Risk Management etc. Session 5: Advanced Formulae Auditing form Auditing Worksheets And Tracing Cell References Tracing Errors Advanced referencing functions CHOOSE, COLUMNS, MATCH, ROWS, VLOOKUP, HLOOKUP Session 6: Multiple Sheets & Auditing features Multiple Sheets Linking worksheets using 3-D formulas, Consolidating data, Creating hyperlink, Creating links between different worksheets Auditing Tracing errors in worksheet, Workgroup collaboration, Tracking changes Our Advisory Team: Dr. T. R. Madan Mohan (Ex Prof. IIM Bangalore) Prof. B. K. Mohanty (IIM Lucknow) Prof. A.K. Mishra (IIM Lucknow) Prof. Pranay K Swain (IIM Calcutta) Romil Pant (National Head, Future Capital Financial) Session 7: Data form & Macros Data Form o Add a record o Modify a record o Delete a record Macros o Recording a macro o Running a macro using menu command o Assign a macro to a button About Corporate Bridge Founded by graduates from leading institutes (IITs, IIMs), Corporate Bridge is a global full-service financial training firm, providing instructor-led training and e-learning services to professionals from investment banks and financial institutions. Also, it has conducted seminars at some of the most prestigious academic institutions and corporations in the world, including IIM Lucknow, IIM Indore, IIT Delhi, IIT Kanpur, MDI Gurgaon, FMS Delhi, NITIE, NMIMS, BSE, Indian Institute of Capital Markets etc.. Session 8: What-if Analysis Goal-seek command Using Data Tables o One input data table o Two input data table Create a scenario Merger scenario from another worksheet Protecting Scenarios EXCEL FINAL ASSIGNMENT Highly Practical, never had before experience - Chetan, Yes Bank