Diploma course in Computerized Financial Application

 

EGH’s Diploma course in Computerized Financial Application (MIS) aims at providing individuals advanced training in the field of Financial Application. This course can be taken up by students after 12th, HS or any such equivalent. EGH’s Diploma course in Computerized Financial Application (MIS) is a professional course and has numerous career options in the It industry.

EGH provides individual based training at our centres, no batches, students can schedule their training as per their time schedule and then maintain the same. This course could take approx. one year for completion, however a fast-track option is also available. We also assist with placement options after completion of this Advance Diploma Course in Computer Application.

Course Fees: Rs. 22000 /-

Course Duration: 80 Hrs.

COURSE MODULE:

  • MySQL

MySQL is one of the most popular open source database management system recognized for its speed and reliability. It is commonly used with web pages. More than 11 million Websites are built around MySQL.

Current MySQL customers such as eBay, Google, Twitter, Yahoo, Facebook, and YouTube, Slashdot, LiveJournal are perfect examples of how MySQL is used to organize and store multiple databases that can be quickly accessed by millions of people at once.

  • Excel – Level I

Microsoft Excel for Windows is a powerful electronics spreadsheet application that can be used for managing, analysing and presenting data in graphical manner.

Salient Features

  • Excel has three components that perform in three different manners:
  1. The Spreadsheet.
  2. The Data sheet
  3. The Chart
  • Create formulas on worksheets. It’s easy and fast.
  • Enhanced formatting and layout features help you get the printed report or online form with the look you want.
  • You can quickly find the information you need and create automatic subtotals of your data.
  • Increased capacity, high-end formatting options, and a mapping feature give you powerful ways to analyse your data visually.
  • Explore the power of the Internet from your familiar Microsoft Excel spreadsheet.
  • When you want to analyse data from outside Microsoft Excel, there’s no need to retype. In a few keystrokes, you can bring the data right onto your worksheet.

Application

  • Excel is used for preparing Company profiles in the form of Charts and Graphs.
  • Excel stores the accounting spreadsheets in Electronic form.
  • MACROS VBA

This course will help to write macros in Excel using programming language Visual Basic Application (VBA). Recorded macro can have edited to customize it to fulfil our requirement and one can directly go for coding to accomplish the required tasks. One can write his own functions and procedures, design forms and working with add-ins.

Program Objectives:

After completion of this program, the participants will be able to the following: –

  • Write macros to automate routine work.
  • Create functions and procedures.
  • Design and use forms for data entry.
  • Create add-ins to deploy at client machines.
  • Create simple reports.

Audience:

Program is scheduled for Advanced Microsoft Excel users. VBA is a programming language, requires aptitude for programming.

Prerequisites:

Participants attending this training should be familiar with the advanced operations in Microsoft Excel & Programming (Basics of C).

  • Advanced Excel

Course Title: Microsoft Advanced Excel

This program is designed for executives who are already familiar with the basics of Microsoft Excel, and who would like to work with more advanced features of Microsoft Excel that help in improving their efficiency of working with worksheets, analysing data, creating MIS reports, and automating various tasks.

Program Objectives:

This Advanced Excel training program will empower the participants to be able to do the following:

  • Performing complex calculations more efficiently, using various Excel functions.
  • Organizing and analysing large volumes of data.
  • Creating MIS reports.
  • Designing and using templates.
  • Consolidating and managing data from multiple workbooks.

Audience:

Executives and managers who have already been using Microsoft Excel, but now feel the need for learning more powerful features and options of Excel, to manage their worksheet-related tasks more efficiently.

Prerequisites:

Participants attending this training should be familiar with the basic operations in Microsoft Excel, such as simple calculations, formatting and printing.

BENEFITS

Financial modelling is one of the most desired skills in today???s corporate world. The demand of a financial modelling analyst is increasing day by day. It is no surprise that the essential skills required by finance professionals is proficiency in financial modelling.

  • Importance of Financial Modelling:

Financial Modelling is the main core element to take the major business decisions in a corporate world. Financial models are the most valuable tools for executing business choices to get perfect solutions. A model can advise you regarding the grade of risk associated with implementing certain decisions. They can also be utilized to devise an effective financial statement that reflects the finances and operations of company. These models help online internet businesses take quick decisions more confidently.

  • Uses of Financial Modelling:
    • In the finance industry, the value of financial modelling is increasing rapidly.
    • Financial modelling acts as an important tool which enables business ideas and risks to be estimated in a cost-effective way.
    • Financial modelling is an action of creating attractive representation of a financial situation of company.
    • Financial Models are mathematical terms aimed at representing the economic performance of a business entity.
    • Financial Modelling are widely used in Various Sectors like:
    • Investment Banks
    • Credit Rating Agencies
    • Equity Research
    • Mutual Funds
    • Financial KPOs
    • Project Finance companies.
    • Career opportunities:
    • Financial Modelling is the main component of business decision-making program. The Financial model allows corporate industries to explore the outcome under different scenarios.
  • Some of the skills/areas that you can learn and work in after pursuing financial modelling are:
    • Merger and acquisition
    • Project finance
    • DCF Modelling
    • Venture Capital
    • IP Valuation- Option Based Method
    • IP Valuation- Market Based Method
    • Ratio Analysis
    • Aesthetics
    • Asset Allocation
    • Qualitative Analysis
    • Sensitivity Analysis
    • Revenue Driver
  • Financial Modelling Jobs:

There are various jobs available after learning Financial Modelling course from a reputed Institute. There is a huge demand of finance professionals having such necessary skill sets. With the proper skill, experience, network, education and knowledge you can expect good offers from companies. There is a wide range of roles and opportunities available after the completion of this course. You can work as a ???

  • Financial Analyst
  • Financial Manager
  • Business Analyst
  • Market Research Analyst
  • Associate Analyst
  • Equity Analyst

FAQ:

Do you Provide Placements?

Yes, we provide 100% placement support to our students. Our curriculum is so extensive that our students rarely are unsuccessful in Job interviews.


How Can I be eligible for Paid Internship?

All undergraduates will be eligible for paid internships in our mother organisation Innovative Media Services. The stipends will vary from INR 4500 to INR 10,000. Graduates and above will be eligible for Job placements.


Can we pay the fees through Instalments?

Yes, Fees can be paid in instalments.


If I miss any class will you provide me backup classes?

Yes, backup classes are provided but up to 12 hrs.


Will trainers be available over phone?

Yes, trainers are available over phone but the students are advised to use discretion when calling up the trainers.


Will I be able to work on Live Projects?

Yes, we offer live project exposure to students after the end of every module.


Do I need to hire Professional to develop my website?

No, you will be able to develop your website by yourselves.


Where should I contact during any problem regarding study in non-office hours?

You may contact the administration for any queries regarding study in non-office hours.


How many certificates will I be getting on completion of the course?

You will be eligible for 12 certifications.


What is the eligibility required to do this course?

A standard 10+2 with basic computer operational knowledge is sufficient for eligibility.


What are the criteria to gain certified status?

A minimum of 75% marks and an attendance of 80% is mandatory to gain certified status.


Is there any flexible timing for working professionals?

We have flexible batch timings for all students including working professionals.


Are there any training materials available with the course?

we offer training materials in the form of study books to our students. E-books/PDF formats are free but hard bind books will incur a small charge for printing.


I could not understand some of the topics well. Will I get training on those subjects again? If yes will there be a charge for that?

Doubt clearing sessions are held from time to time. Students may avail these sessions and if the doubt is regarding an entire module then student needs to co-ordinate with the admin for a class change.


Will I get any support in terms of software, themes, plugins from the institute?

Yes, you will receive $100 worth of free software, tools, plugins and themes from the institute.

Send an Enquiry