Excel & VBA for Financial Analysis

Excel & VBA for Financial Analysis

 

  • Advance Excel for Financial Analysis

    Can choose alternate dates and times at checkout

    Sale Date Ended

    INR 7000
    Sold Out
  • Equity Research Analyst Program

    Can choose alternate dates and times at checkout

    Sale Date Ended

    INR 26000
    Sold Out
  • Advance Equity Valuation

    Can choose alternate dates and times at checkout

    Sale Date Ended

    INR 14000
    Sold Out
  • Financial Modeling using Excel

    Can choose alternate dates and times at checkout

    Sale Date Ended

    INR 12000
    Sold Out

Invite friends

Contact Us

Page Views : 980

About The Event

About Us

JPFIS 
is an independent equity research firm we offer unbiased and independent opinion on Indian stock markets to Indian diaspora spread across the globe.  JPFIS is also engaged in providing Financial Modeling consulting to various infrastructure companies focused on NHAI road projects across India. 


Training, Internship and Freelancing.
 

JPFIS also provided executive education on Equity Research and Analysis via classroom and live online learning medium.  Our program is focused on imparting strong fundamental and practical skills required to master company valuation and financial modeling.

All our valuation sessions are conducted on live projects that JPFIS is currently engaged in; post training delegates also get a chance to enhance their understanding & exposure by way of contributing in our current projects via offsite internship, although internship is completely options but is highly encouraged. Select delegates may also get a chance to work on paid freelancing projects.

Download Program Details 

Important Note:

All programs are condcuted in classroom and Online Virtual sessions, programs have multiple start dates and weekday and weekend session. Please choose appropriate ticket corresponding to dates and times you wish to attend the session. You'll have the opportunity to choose online or classroom session on the registration page.

Weekday Schedule (Mon-Fri 08AM to 10AM or 06Pm to 08PM)

 

October

December

January

Program

Date

Date

Date

Equity Valuation

28-Oct-13

9-Dec-13

20-Jan-14

Excel

11-Nov-13

23-Dec-13

3-Feb-14

Financial Modeling

25-Nov-13

6-Jan-14

17-Feb-14

Program End

9-Dec-13

20-Jan-14

3-Mar-14

 



 

Weekend Schedule (Sat & Sun 12PM to 04PM)

 

October

November

January

Program

Date

Date

Date

Excel

6-Oct-13

30-Nov-13

25-Jan-14

Financial Modeling

26-Oct-13

21-Dec-13

15-Feb-14

Equity Valuation

16-Nov-13

11-Jan-14

8-Mar-14

Program End

30-Nov-13

25-Jan-14

22-Mar-14

Program Date & Time can be choosen at the time of checkout.

Advance Excel for Financial Analysis  - 20 Hours

The program is conducted in Work-shop format with strong emphasis on learning by doing. The program starts with basics of Ms-Excel and moves on to cover advance features of Ms-Excel in the context of financial analysis and data interpretation. The program emphasis will be on effectively navigating Ms-Excel, using shortcuts to perform actions faster, automating routine tasks using Macros & VBA and data analysis using pivot tables, data tables etc.

Learning Objectives
- Excel Environment and Useful Features
- Excel Functions & Useful Features
- Advance Functions (Finance, Statistical, forecasting etc.,)
- Data / Financial Analysis
- Dynamic Sheets / User Controls
- VBA Introduction
- Build Dynamic Charts for Excel Dashboards.
- Integrate dynamic controls and objects.

More details about the program in can be downloaded from here Download Program Details 

 

 

Internship (Optional)

Post Training delegates can participate in real time Equity Research Analysis projects JPFIS is currently covering.  A three month internship certificate will be issued to delegates completing 4 research reports. Inorder to participate in internship program delegate must be registered for our all 3 modules. 

 


Other Related Programs by JPFIS on Meraevents.com

Equity Research Analyst
Advance Equity Valuation
Excel & VBA for Financial Analysis
Financial Modeling using Excel

 


For a detailed structure of the program please download the brochure.
J P Financial & Investment Services
Website: www.jpfis.com ; Facebook: www.facebook.com/JPFIS

Weekday Schedule
  October December January
Program  Date Date Date
Equity Valuation  28-Oct-13 9-Dec-13 20-Jan-14
Excel  11-Nov-13 23-Dec-13 3-Feb-14
Financial Modeling 25-Nov-13 6-Jan-14 17-Feb-14
Program End 9-Dec-13 20-Jan-14 3-Mar-14
 

 
Weekend Schedule
  October November January
Program  Date Date Date
Excel  6-Oct-13 30-Nov-13 25-Jan-14
Financial Modeling 26-Oct-13 21-Dec-13 15-Feb-14
Equity Valuation 16-Nov-13 11-Jan-14 8-Mar-14
Program End 30-Nov-13 25-Jan-14 22-Mar-14

Venue Map