PRESENTS

ICICIdirect Centre for Financial Learning (ICFL) is an initiative of ICICI Securities Ltd.

set up with the objective of simplifying financial knowledge and increasing financial

literacy amongst prospective or experienced investors and knowledge seekers. ICFL

training programmes are categorised under Investment Education Programmes and

Professional Certification & Development Programmes. The repository of domain

knowledge includes a host of in-house developed seminars, workshops,

certifications and training programmes leading to reputed certifications. These

programmes are in the area of Stock Investing, Derivatives, Mutual Funds, Financial

Planning, Wealth Management, Corporate Finance, etc.

ICICIdirect Centre for Financial Learning has been conferred with the Award for

Innovation in Learning and Best Online Learning Solution at the World Education

Congress. It also won the Emerging Brand Award at CMO Asia in Singapore.

About Xavier School of Management Jamshedpur (XLRI)

Founded in 1949, XLRI, managed by Jesuit Fathers, has always striven to be a

management school with a difference. Pursuing academic excellence and fostering

whole-person integral growth - intellectual, emotional, spiritual and social persona of

students, has been the hallmark of XLRI for over six decades.

About ICICIdirect Centre for Financial Learning (ICFL)

Prof. Pitabas Mohanty was a Senior Visiting Scholar at Stern School of Business,

New York University in 2009-10. He is a Fellow of the Indian Institute of Management

Bangalore. A Gold Medalist in MA (Applied Economics), he is also a Chartered

Financial Analyst and a Cost Accountant.

He has got more than fifteen years of teaching experience in Investments and

Corporate Finance. He has conducted numerous training programmes for companies

in India and abroad, including companies from Dubai, Qatar, and Kuwait in Company

Valuation and Financial Modeling. He is the co-author of books on ‘Investments’ and

‘Principles of Corporate Finance’ published by McGraw Hill Education. He is actively

into research in corporate finance and investments with many publications in books

and refereed journals. He has consulted for a few companies in their valuation of

companies. He has won numerous research awards at various research conferences.

About the Faculty

This programme aims to impart spreadsheet and financial modeling skills among the participants. The programme will particularly look at spreadsheet skills for corporate finance professionals. Then the programme will help the participants understand how corporate finance models are built.

Programme Overview

In the present day situation, availability of data is not a constraint. However, analysing data and using it for decision making is becoming a challenge. While there are several software packages available for analysing the data, Excel is the most popular software used by the analysts to use business data in real life. The objective of this programme is to expose the managers to the different ‘built-in’ data analysis features in Excel. The participants will get exposure to the different basic and advanced features in Excel that can help them make efficient analysis of the data in Excel.

Programme Objective

The programme will be conducted as a workshop, where the participants will get hands-on experience in analysing data using Excel.

Pedagogy

Data Analysis using Excel• Mastering Formulas and Functions in Excel• Formatting, Conditional and Advanced Formatting of Data• Preparing Charts in Excel• Understanding Basic Macros

Financial Modeling using Excel• Building Integrated Financial Statements Model• Building Project Finance Models• Online exam at the end of the programme

Programme Differentiators Participants get hands-on experience in analysing data using Excel.

Who Should Attend?This programme is primarily intended for people whose job involves analysis of data using spreadsheet packages like Excel. The programme does not presume any prior knowledge about Excel by the participants. However, participants who have exposure to the basic functions of Excel will get the maximum benefits out of this programme.

Eligibility Criteria• For Indian Participants - Graduates (10+2+3) or Diploma Holders (only 10+2+3) from a recognised university

(UGC/AICTE/DEC/AIU/State Government) in any discipline• For International Participants - Graduation or equivalent degree from any recognised University or Institution in

their respective country

Topics to be Covered

The entire programme will be delivered through virtual classrooms. ICFL virtual classrooms will be enabled with technology whereby the programme faculty will deliver the lectures from one or more studios and the students enrolled in the programme could attend it from different points. For e.g. - ICFL classrooms (owned and franchisees) and even from their locations through any device like desktop, laptop, tablet or mobile. However for a better learning experience, a student would be advised to attend the programme from the ICFL classrooms.

Programme Delivery

• ‘Participation Certificate’ for those who attend 80% of the sessions• ’Successfully Completion Certificate’ for those who appear for the exam and successfully complete it, along with 70% of attendance

Award of Certificate

Programme Details:

Last Date for Submission of Application: June 30, 2017

Programme Start Date: July 23, 2017

Programme Fees: Total Course Fee: `36,000 + service tax

Payment Structure: • Application Fee - `18,000 + service tax on submission of application• Installment 1 - `18,000 + service tax on or before August 7, 2017• Exam Fee - `5,000/- + service tax at the time of registration for exam

Total Programme Duration: 30 hours spread over 8 to 10 weeks

Programme Schedule: Every Sunday, from 3:00pm to 6:00pm

Sananda MajumderSystems Assistant, West Bengal Infrastructure Development Finance Corporation Limited (Kolkata) In a nutshell, the faculty and content of the MDP program are just excellent. Explanations and lectures given by Prof. Pitabas Mohanty are actually effective and extensively explicit to understand

Ravi Wadhwani Commercial Coordinator, Oriflame (Mumbai)Overall this programme was worthwhile for me, time well spent, knowledgeable faculty, well organised, excellent reference notes and clearly leading edge technology.

Shivadatha ReddyBTech, Bharath Institute of Engineering and Technology (Hyderabad)• Prof. Pitabas Mohanty is a very knowledgeable person and is very supportive. Though I am a beginner, he

patiently clarified all my doubts and rectified my mistakes. Content was also very useful as I have got a perfect exposure of financial topics along with some spreadsheet skills

• Through this latest technology which is being imbibed among many corporate professionals globally, I have gained career-oriented guidance and a very optimistic approach to learning. The Adobe Platform is a great tool for digital virtual class room experiences

• It is truly a high-level programme experience. I'm also very keen and looking forward to learn many more such programmes from XLRI.

Dr. Alka JayaswalConsultant, George Majjo Industries Private Limited (Kolkata)• It has been an overall good programme with an excellent faculty. The last exercise on bluetooth speakers is

excellent and more such real life simulations are required• One or two sessions at Jamshedpur, face-to-face with the faculty, for those who want to attend on their own cost

and lodging could have been done for more efficacy.

asnt

e

Ome

s and

lopment Finance Corporation Limited (Kolkata) rogram are just excellent. Explanations and lectures given by

tensively explicit to understand

)or me, time well spent, knowledgeable faculty, well organised, excellent

e technology.

Engineering and Technology (Hyderabad)• Prof. Pitabas Mohanty is a very knowledgeable person and is very supportive. Though I am a beginner, he

patiently clarified all my doubts and rectified my mistakes. Content was also very useful as I have got a perfect exposure of financial topics along with some spreadsheet skills

• Through this latest technology which is being imbibed among many corporate professionals globally, I havegained career-oriented guidance and a very optimistic approach to learning. The Adobe Platform is a great tool for digital virtual class room experiences

• It is truly a high-level programme experience. I'm also very keen and looking forward to learn many more suchprogrammes from XLRI.

Dr. Alka JayaswalConsultant, George Majjo Industries Private Limited (Kolkata)• It has been an overall good programme with an excellent faculty. The last exercise on bluetooth speakers is

excellent and more such real life simulations are required• One or two sessions at Jamshedpur, face-to-face with the faculty, for those who want to attend on their own cost

and lodging could have been done for more efficacy.

SSSanSS rtant, W

shell, the Prof. Pitabas

SaSaSanananddaa MajumderSySyststems AssistantIn a nutshell,Prof

t,t, WWhehe f

ababass M

t,t, WWWhehe

ababass

nfrasontent

tually e

ordinator, Ohis programme

reference notes and

, WWWest t Bengal Inee ffacaculltyty and cont

ss MMoMohantnty are actua

RRavi WWadadhhwani Commercial CoordinOverall this prorefe

aasstructctctuure Develontnt of thhhe e MDP pro

eeffectititivee and exte

OOriflamememe ((MMumbai)meme was wwworrththwhile for

s anandd clearlrlrlyyy leeaading edge t

ShShiv ddad tathhha RRRededdydyBTech, Bharath Institute of Engi• Prof. Pitabas Mohanty is

Testimonials by the Previous Batch

ec). Registered office of I-Sec is at ICICI Securities Ltd. - ICICI Centre, H. T. Parekh Marg, Churchgate, Mumbai - 400020, India, Tel Noed officececeee of I-Scececeece oof Iccec -SecSSSe iSSSS si at ICIurities Ltd.( I-SeecuritSecuSecICICI SSS nd0, IndiInd0, In0000000 0, 02220,000,00,0,00000000- 4400000bai - Noo : 02 8822 2 - 2282 028888 8 22460, 888 222222222 - nts herein above shall not be considered as an invitation or persuasion to trade or invest. These programmes do not guarantee any job or placements with ICe shae shallall ne sha ot bnott be conb. The contents470. Th42288 24724474 tuarantee anteentaranteennnuuaauuaanot guarantee any jaot guguuuaaado nonnooo job ot guarantee any jo oror plar naccemecc nnnn ICnnnntts withnn CCICCC CCCI

organization. Participants should make independent judgment with regard suitability, profitability, and fitness of any program offered herein aboverticipant shoulother orr any otherGroup or ar a y program offeram ofamproogragram m offmamm ofmof a yy ppyof any program offered y program offeref anyny y y gram offered ereoo hd hereih n aboveininn n abovn eeee c aeee. I-I Sec nnnddabilities for any loss or damage of any kind arising out of any actions taken in reliance thereon.This mail is not directed or intended for distribution tomaliabilities focept no liaaffiliates accepcep or intendr intended oror intinteentinteeirected or intended foendededected eddd ororor intintendendene ede forddndendeednot direire r distribor dr drr did stribddddd n tobubbution bb ttoo se booo, oor us bbbbbbyy,

citizen or resident of or located in any locality, state, country or other jurisdiction, where such distribution, publication, availability or uentity who is a entitany person or entent tion, publication, aon, pubblilication, astributiotiooo publicati ,tiotiooo availabila, avaavaailabbbillbbill r uiilitlilitl yy or uus uld ssese wou bbbbewhich would subject I-Sec and affiliates to any registration or licensing requirement within such jurisdictcontrary to law, regulation or wcontrary to law, re ldc iction.

ICFL Branches:

Contact Us

Bengaluru - Cunningham Road +91 9108683683

Delhi - Jhandewala Extension +91 8588816146

Mumbai - Andheri East +91 8451943442

Pune - F C College Road +91 8390904865

Hyderabad - Somajiguda +91 9908414441

Kolkata - Shakespeare Sarani Road +91 8697748207

ICFL Authorised Learning Centres:

Bengaluru - Kormangala +91 9742273109

Chennai - T Nagar +91 9742273109

Delhi - Gurgaon +91 7838352716

Delhi - Pitampura +91 7838352716

Hyderabad - Kukatpally +91 9742273109

Indore - Khajarana Road +91 9619359592

Kolkata - Kankurgachi +91 9477884429

Kolkata - Kasba +91 9477884429

Bhubaneswar - Satyanagar +91 9477884429

Mumbai - Kharghar +91 9619359592

Maharashtra - Sangli +91 9619359592

Kochi - Gold Souk Grande +91 9742273109

ICFL Contact Details:

Email Id: learning@icicisecurities.com

Website: learning.icicidirect.com

XLRI Contact Details:

Email Id: emdp@xlri.ac.in

Website: learning.icicidirect.com

Our Authorised Learning Centre / Business Associate: