Short Duration Programme

 
 
 
 
 
 
 
 
 

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.

The program will be conducted as a workshop, where the participants will get hands-on experience in analyzing data using 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

Graduates (10+2+3) or Diploma Holders (only 10+2+3) from a recognized university (UGC/AICTE/DEC/AIU/State Government) in any discipline.

Pedagogy

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

Certification

  • "Prticipation Certificate" for those who attend minimum 80% of sessions
  • "Sucessfully Completion Certificate" for those who appear for the exam & suessfully complete it, along with 70% of attendance.

Methodology

Evaluation by: XLRI Jamshedpur

Applicable Channel

Retail and Direct to Corporate

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

Duration of the Course: 8 to 10 weeks from July 2017 to September 2017
Schedule of Classes: Sunday (03:00 – 06:00) pm

Payment & Installment Schedule
 Application Fee Rs. 18,000 + Tax
 Last Date: 15th July 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

Click here for ALC centres details

Click here to Register