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

Download Program Brochure            Batch 1 Candidate Profiles

Apply Now

@

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