Tuesday, June 27, 2017

Get register for "DATA ANALYSIS AND FINANCIAL MODELING" from XLRI Jamshedpur

Last Date:- 30 Jun 2017

DATA ANALYSIS AND FINANCIAL MODELING USING EXCEL



In the present day situation, availability of data is not a constraint. However, analyzing data and using it for decision making is becoming a challenge. While there are several software packages available for analyzing the data, Excel is the most popular software used by the analysts to use business data in real life. The objective of this program 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 making efficient analysis of the data in Excel.

Who Should Attend
This program is primarily intended for people whose job involves analysis of data using spreadsheet packages like Excel. The program 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 program.

Eligibility
  • For Indian Participants - Graduates (10+2+3) or Diploma Holders (only 10+2+3) from a recognized university (UGC/AICTE/DEC/AIU/State Government) in any discipline.
  • For International Participants - Graduation or equivalent degree from any recognized University or Institution in their respective country
Pedagogy
The program will be conducted as a workshop, where the participants will get hands-on experience in analyzing data using Excel.

Certification
The qualified students will be award an MANAGEMENT DEVELOPMENT PROGRAM IN Data Analysis and Financial Modeling Using Excel.

Methodology
Evaluation by: XLRI Jamshedpur

Program Contents
Data Analysis Using Excel
  • Mastering formulas and functions in Excel
  • Formatting, Conditional and Advanced Formatting of Data
  • Data Analysis using Excel
  • Preparing Charts in Excel
  • Preparing Dynamic Charts in Excel
  • Understanding basic Macros
Financial Modeling Using Excel
  • Building Integrated Financial Statements Model
  • Building Corporate Valuation Model (for a manufacturing company)
  • Building Project Finance Models
  • Using Macros to make the models dynamic and professional
Duration & Schedule
Duration of the Course: 8 to 10 weeks from July 2017 to September 2017
Schedule of Classes: Sunday (03:00 – 06:00) pm 

Program Co- ordinator
For any other clarification Contact - Piyush Garg @ 9717938151

Payment & Installment Schedule

 Application Fee Rs. 18,000 + Tax
 Last Date: 30th June 2017
 Installment I Rs. 18,000 + Tax
 On or Before: 7th August 2017
 Installment II Rs. 5,000 + Tax
 On or Before: 17th August 2017
 Total Fee Rs. 41,000 + Tax

@


ICICIdirect Centre for Financial Learning
Authorised Learning Centre
                                     Plot No. 2, Kapil Vihar, Pitampura, Delhi -110034 
                                      Mob. No.#97179 35182, Tel: 011 2735 5339
Email: learning@icfldelhi.com