Excel & VBA for Financial Analysis

Excel & VBA for Financial Analysis

 

  • Advance Excel for Financial Analysis

    Sale Date Ended

    INR 7000
    Sold Out
  • Equity Research Analyst Program

    Sale Date Ended

    INR 26000
    Sold Out
  • Advance Equity Valuation

    Sale Date Ended

    INR 14000
    Sold Out
  • Financial Modeling using Excel

    Sale Date Ended

    INR 12000
    Sold Out
  • By clicking "Book Now" you agree to the Terms & Conditions

Invite friends

Contact Us

Page Views : 782

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


Terms & Conditions

Enrollment Policies Refund & Cancellation Policy: All registrations are final and are not entitled for refund in full or part under any circumstances. However, delegates can transfer or substitute another delegate for the training program, and such a transfer or substitution will attract a transfer fee of 10% of the registration fee. Transfer fee, if any, must be paid prior to the start of the training program. JPFIS reserves the right to cancel programs and courses for any reason including when not enough delegates are enrolled for the program. In an event where the program is cancelled by JPFIS, a full refund will be issued or an alternate date will be offered for delegate to attend the program. Disclaimer & Limitation of Liability: While JPFIS endeavors to provide training and analytical insights that are current and up-to-date, the training programs, the associated courseware, the related worksheets or financial models are provided on an “as is” basis. JPFIS disclaims all warranties of any kind, either expressed or implied, including, without limitation, implied warranties of merchantability, or fitness for a particular purpose, or of a particular result, or for particular job role. JPFIS does not warrant that any program, or its courseware, the related worksheets or financial models will meet any particular requirements or needs, or that the content of courseware, the related worksheets or financial models for any program will be error-free. JPFIS shall not have any liability with respect to any loss or damage caused or alleged to have been caused directly or indirectly by reliance on the content or the courseware, the related worksheets or financial models for any program provided by JPFIS, including, but not limited to, loss of consulting or anticipatory profits, or consequential damages. In addition, JPFIS endeavors to provide programs that are current and up-to-date, by enrolling in the program(s) identified on this form, you acknowledge that this/these program(s), and the associated courseware, the related worksheets or financial models are provided on an “as is” basis, and that JPFIS makes no warranties of any kind that such program(s), the courseware, the related worksheets or financial models will meet any particular requirements or needs, or that they will be error-free. The legal terms on our website contain additional important disclaimers regarding our programs, courseware, the related worksheets and financial models, and by completing this enrollment form, you acknowledge that you have read and understood those disclaimers. Placement, Internship & Freelancing: JPFIS as an institution only imparts training in modules listed on our website and does not take any responsibility for job placement, internship or employment. Unpaid offsite internship program offered by JPFIS is only intended at providing real life exposure to training participants and does not guarantee employment or an internship certificate unless required coursework is completed and accepted by JPFIS. Paid freelancing projects will be assigned only to qualifying candidates’ post unpaid internship and the selection for the same will be at sole discretion of JPFIS.