Skilling India

Sort By:  
CFA - Equity Investments

The course is designed only for Smart Employment Card Holders

CFA Level I – Equity Investments Training Course:

Skilling India brings you the course CFA Level I – Equity Investments Training. In this course we are going to learn different sections of the Equity Investment Module
The sections that will be discussed in this training are:
• Market Organisation And Structure
• Financial Intermediaries
• Positions
• Security Market Indices
• Market Efficiency
• Overview Of Equity Securities
• Introduction To Industry And Company Analysis
• Equity Valuation Concepts And Basic Tools
All this courses are equipped with the complete Equity Investment Curriculum. The way of teaching has been kept highly practical so as to make each and every concept clear.

CFA Level I – Equity Investments Training the requirements

– Computer with Internet for viewing the training material of Equity Investment.
– Passion to learn about Equity Investment

CFA Level I – Equity Investments Training Target Audience

– Students
– Professionals
– Anyone who wants to learn Equity Investment


Course Objective CFA Level I – Equity Investments Training
– Learn all the domains of Equity Investment thoroughly.

Course Curriculum

Section 1: Introduction
1 Introduction
2 Equity Overview
3 Market Overview Part 1
4 Market Overview Part 2
5 Time Value of Money Part 1
6 Time Value of Money Part 2
Section 2: Market Organisation and Structure
Section 3: Security Indices
Section 4: Market Efficiency
Section 5: Overview Of Equity Securities
Section 6: Industry and Company Analysis
Section 7: Valuation



Course Content : 36 Training Video's

NO CERTIFICATE WITH THIS COURSE

The course content only training module and to avail certification, the candidate has to appear for our online diploma certification exam for respective subject. The certificates are issued under "Maharashtra Technical & Self Employment Training Society" approved by Government of India, International Standard ISO Certification. The examination fees shall be additional Rs. 1,999/-

SALES FILE
Sales File  for Business Partners 

Use this file at your center or for marketing purpose.
CAP - Certified Analytics Professional

What is CAP – Certified Analytics Professional ?

CAP was developed in the year 2013. CAP was launched by The Institute for Operation Research and Management Sciences (INFORMS). INFORMS is the first to develop a professional certification program in the field of analytics. CAP is a professional certificate issued for individuals with business analytics experience. CAP program sets standards for the analytics professionals and the organizations can select well qualified analytics professionals. CAP certification will improve the career of the analytics professional and improve the credibility of the analytics professional. CAP examines the knowledge of a person across seven domains

Benefits of being a Certified Analytics Professional
• Helps to improve your career and makes you stand ahead of the competition
• CAP helps to improve your job performance
• CAP makes you an expert in the field of analytics
• Undertaking CAP will help you to get recognized as an analytics expert
• CAP will help to increase your salary as you become an experienced analyst with this certification

Course Objectives
At the end of this course you will be able to
• Know the advantages of getting CAP certificate
• Understand the basics and domains of CAP
• Get one step ahead in your career using CAP
• Gain knowledge about data science and analytics methodology

Pre requisites for taking this course
CAP is designed for professional analytics who are in their early stage or mid stage of development. Participants should have a bachelor or master’s degree with 5 or 3 years of experience in the field of analytics. Others Bachelor degree holders should have at least 7 years of experience in any unrelated area.

Target Audience for this course
Those who pass the eligibility criteria of CAP can undertake this course. Students and professionals who are interested can also take up this course.

Course Description
Section 1: Introduction toCertified Analytics Professional exams
CAP Certification and Benefits
This chapter contains a brief introduction to CAP and lists out all the Benefits of CAP to you and the benefits of CAP for your Employer.
Section 2: Understanding Objectives
Different Objectives and their Weightage
The job task analysis of CPA can be viewed in this section as a outline. The job task analysis in nothing but the blue print of the exam pattern and how the marks are segregated. The JTA of CPA contains seven domains. Each domain is explained in detail under this section with their respective weightage.
• Business Problem Framing
• Analytical Problem Framing
• Methodology Approach
• Data
• Model Building
• Deployment
• Life Cycle Management
What are Knowledge Statements
This section tells you what are knowledge statements and explains about the 16 knowledge statements in CAP.
Section 3: Understanding Business Problem Identification
Business problem identification and stakeholders analysis
This chapter explains the Business problem Framing domain and the topics covered under this section includes
• Receive and Refine the business problem
• Identify stakeholders
• Determine whether the problem is amenable to an analytics solution
• Refine problem statement and delineate constraints
• Define an initial set of business benefits
• Obtain stakeholder agreement on the problem statement
Section 4: Further Reading Business Problem
How to Write a problem Statement
This section gives an introduction to problem statement. The other topics included are
• How to write a problem statement
• Where to get started – Who, What, When, Where, Why
• Issue statement of the problem
• Vision of the problem
• Problem Solving process – Explaining the problem, Costs of the problem, Assertions, Proposing a solution, benefits of the solution, summarizing the problem and solution
The Problem Definition Process
The problem solving steps and processes are explained in detail under this chapter.
Power of Re-framing Problems
This section explains what is reframing, what is the process of reframing the problem and how reframing the problem helps in innovation and creative problem solving methods
Business Problem Framing Questions
Under this chapter you will learn how to frame a business problem and what are the factors to be considered while framing a business problem.
Section 5: Analytical Problem
Analytical Problem Framing
This section explains the Analytics Problem framing domain and the topics included are
• Reformulating the business problem statement as an analytics problem
• Develop a proposed set of drivers and relationship to outputs
• Set of assumptions related to the problem
• Define the key metrics of success
• Obtain stakeholder agreement
Kano’s Requirement Model
Kano Model helps to understand the customer requirements for new products and services. It explains the five categories of customer requirements. This section contains topics like what is a Kano model, why is it used, how it is used and template of Kano model.
Section 6: Certified Analyst Professional Training – Data Science
Data Science Introduction and difference between BI and Data Science
This chapter gives a brief introduction to Data Science and also lets you learn about the basics of data science under four topics
• Data Manipulation
• Data Analysis
• Data at Scale
• Data communication
The section also covers the difference between Data Science and Business Intelligence.
How Data Science Work along with Acquire and Prepare Steps
Here you will learn the data science workflow. There are four main stages in the workflow of data science – Preparation Phase, Analysis Phase, Reflection Phase and Dissemination Phase.
All these phases are explained in detail under this chapter with the help of a pictorial representation. The steps of Data Science involves Acquire, Prepare, Analyze, Visualize and Share.
How to Analyse and Act Data
The main activity of the analysis phase such as writing, executing and refining the programs to analyze the data are explained in detail under this chapter. The different languages used by data scientists are mentioned here along with three main sources of slowdowns.
Guiding Principles and Reasoning and Common Sense
The next step after analyzing the data is to take action. This section contains the guiding principles which will help you to get the output. The key points of the principles are mentioned in this chapter.
Components of Data Science
The components of data science are divided into different categories based on several factors. The main factors are data types, Execution models, Learning models and Analytic Classes. The components under these heading are explained in brief in this section.
Classes of Analytic Techniques Transforming Learning and Predictive Analytics
The classes of analytic techniques are divided into nine analytic classes under three topics
• Transforming analytics – Aggregation, Enrichment, Processing
• Learning Analytics - Regression, Clustering, Classification, Recommendation
• Predictive Analytics – Simulation, Optimization
Learning Models , Execution Models Scheduling and Sequencing
Learning models helps to perform judgements on new data which is based on its history. Learning model consists of two types – Learning style and Training style. Each is explained in this chapter.
Execution models lets you learn how data can be manipulated. Execution model consists
• Scheduling – Batch and Streaming
• Sequencing – Serial and Parallel
Decomposing Analytical Problem
Decomposing is the first step in the analytics selection process. This chapter contains the Fractal Analytic Model and explains what are the things to be considered while decomposing your problem.
Data Science Maturity
In this chapter the following topics are included
• How Data Science Maturity Works
• Data Science Maturity Model
• Stages of Maturity – Collect, Describe, Discover, Predict, Advise
• The art of Data Science
Feature Engineering, Dimensionality Reduction and Model Validation
Here you will learn what is machine learning and its tricks. The other topics covered under this chapter includes the following
• How to deal with feature engineering
• Problems faced with feature engineering
• Example of feature engineering
• Techniques for data dimensionality reduction
• Which model should be used
Section 7: Certified Analyst Professional Training – FIVE E of CAP Exam
The Five E for CAP exam
The five E’s of CAP exam are education, experience, ethics, effectiveness and exam. These five E’s are explained under this section.
Soft Skills for CAP exam
Soft skills are less technical skills that are required for writing CAP exam. This section covers what are the soft skills required and how it is confirmed.
Clarifying the Analytical Process
There are certain code of ethics for all CAP. Here you will learn such code of ethics under the following topics
• Background
• Applicability
• Purpose
• General
• Responsibilities
• Society
• Employers and Clients
• Colleagues
CAP Terminology Yield Vehicle Routing Problem and TSP
This chapter gives the overview of Yield Vehicle Routing Problem, travelling salesman problem and its algorithms
CAP Terminology supply chain six sigma RFM
It explains how six sigma is used in supply chain and what is RFM analysis.
Pattern Recognition, Regression, Predictive and Prescriptive Analytics
In this section you will learn in brief about the Pattern recognition, Regression, Predictive analytics and Prescriptive analytics.
Section 8: Data Visualization – CAP Certification
Data Visualization Definition and Importance
Here you will learn what is data visualization, visualization types, designing a visualization and data visualization tools.
Common Techniques for Data Visualization , Data Cardinality and Velocity
This chapter will help you to learn common visualization techniques, what is data cardinality and velocity. The chapter also explains the different data visualization techniques with an example for each
• Type of Charts
• Decision tree
• Heat map charts
• Type of Graphs
How to write Data Story
Now a day’s data driven stories are gaining more interest. In this chapter you will learn how to write a data story. The first thing you need while writing a data story is to have a clear data. So filtering and cleaning the data is also covered in this chapter.
Quality of Data and Data mart
In this chapter you will learn what is data mart, the objectives and strategy for change to get quality data.
CAP Terminology Optimization and Next Best offer
The topics covered in this chapter are What is Next best action, its leading symptoms and trailing cynicisms and Next best action optimizers.
Section 9: Analytics Methodology and Test Analytics Model
Analytics Methodology Introduction
This tutorial gives a brief introduction about the Analytical methods, its tools, concept and definition.
Different type of Analytics Methodology
In this chapter you will learn the most widely used analytical methods in detail
• BCG matrix
• Brainstorming
• Benchmarking
• Gap Analysis
• Mind Maps
• SWOT analysis
Software Tool Selection
The process of selecting software tools and the criteria for selecting software tools are explained in this section.
• Validating Analytics Model and Testing Results
• This chapter contains the following topics
• Effective model validation
• Techniques for developing analytic models
• Introduction to modelling techniques in predictive analytics
• Predictive modelling – Predictive analysis
Simulation and its Kind
This chapter contains Introduction to Simulation, Languages used for developing a simulation model, Types of Simulation, Terminology and common mistakes in Simulation.
FAQ’s General Questions
• Why should I get certification ?
Getting a certification in the analytics field will help to improve your career and will make you stand ahead of the competition. You can also improve your job performance which will in turn help you to get a higher salary than before.
• Can I waive the eligibility requirements of CAP ?
Only if you have many years of experience in the field of analytics you can waive the requirements of CAP otherwise it is a compulsory.
• What is the validation period of CAP certification ?
It lasts for three years and it must be renewed after three years.

Course Curriculum

Section 1: Introduction to CAP Exams
Section 2: Understanding Objectives
Section 3: Understanding Business Problem Identification
Section 4: Further Reading Business Problem
Section 5: Analytical Problem
Section 6: Certified Analyst Professional training- Data Science
Section 7: Certified Analyst Professional training- FIVE E of CAP Exam
Section 8: Data Visualization- CAP Certification
Section 9: Analytics Methodology and Test Analytics Model

NOTE :

The course content only training module and to avail certification, the candidate has to appear for our online diploma certification exam for respective subject. The certificates are issued under "Maharashtra Technical & Self Employment Training Society" approved by Government of India, International Standard ISO Certification. The examination fees shall be additional Rs. 1,999/-

CFA - Equity Investment

The course is designed only for Smart Employment Card Holders

Skilling India brings you the course CFA Level 1 Equity Investment training. In this course we are going to learn different sections of the Equity Investment Module

The sections that will be discussed in this training are:
• Market Organisation And Structure
• Financial Intermediaries
• Positions
• Security Market Indices
• Market Efficiency
• Overview Of Equity Securities
• Introduction To Industry And Company Analysis
• Equity Valuation Concepts And Basic Tools
All this courses are equipped with the complete Equity Investment Curriculum. The way of teaching has been kept highly practical so as to make each and every concept clear.
What are the requirements?
– Computer with Internet for viewing the training material of Equity Investment.
– Passion to learn about Equity Investment
Who is the Target Audience
– Students
– Professionals
– Anyone who wants to learn Equity Investment
Course Objective
– Learn all the domains of Equity Investment thoroughly.

Course Curriculum

Section 1: Introduction to Accounting
1 Introduction
Section 2: Market Organisation And Structure
Section 3: Financial Intermediaries
Section 4: Positions
Section 5: Security Market Indices
Section 6: Market Efficiency
Section 7: Overview Of Equity Securities
Section 8: Introduction To Industry And Company Analysis
Section 9: Equity Valuation Concepts And Basic Tools

Course Content : 57 Training Video's


NO CERTIFICATE WITH THIS COURSE

The course content only training module and to avail certification, the candidate has to appear for our online diploma certification exam for respective subject. The certificates are issued under "Maharashtra Technical & Self Employment Training Society" approved by Government of India, International Standard ISO Certification. The examination fees shall be additional Rs. 1,999/-

Professional Sales Training

About Sales Training:

Sales are all about working to persuade, influence and enroll people. It is imperative to obtain all the imperative sales skills prior to getting into the sales job. The sales training will assist you in learning the basic facts on sale, basic communication, important things to keep in mind while selling, usage of etiquettes and body language. With the training you will also learn about basic sales, work management, time management, calls, client visits, the difference between selling and telling, Things to do and not to do during visits by clients.
The ability to influence, persuade and enroll people into your projects and the idea is the key to succeeding in all the areas. There are several sales person in the market. However, all of them have a one thing in common that is very essential is the ability to influence people. If you could influence others you could manage to sell the products, sell the ideas, and sell the service. The ability to get the people to say yes is imperative. The direct experience of the value causes the occurrence of the sale. How to sell the service or product is an imperative skill that you should be aware of if you are into selling or into business.
Sales executives need to keep the following things in mind while interacting with a client:
Prepare what to say to the client. Get into a sales call only if you are sure how you are going to close the contract. The call needs to be natural and not a prepared out speech or else the customer would doubt on your service. However, while you meet the customer for the first time a lot of other points needs to be kept in mind.
• Listening is an imperative procedure: One of the most crucial steps in the first few minutes of the sales interaction is listening. It could never be worried enough. You might consider closing deals quickly an utmost priority, however rushing things to meet the timeline would not be an ideal option. Allow the customer to do more of the talking while you be knowledgeable and lively.
• Don’t be a forceful salesperson: In the procedure of buying be more of an adviser to the customer. Take time to engage with the customer they will more likely be certain of your proposition.
• Be curious of your viewpoint: Focus on the details that induce your potential customers to buy the product. Ask about the products they already are using, are they satisfied with its results. You need to note what they actually want. Your questions should be related enough to fetch you the information about the needs of the speaker. Make it seem like a discussion and not a survey.
• Follow up after the meeting: It is an essential point. After several proposals and presentations, the client tends to have second thoughts. You need to maintain the connection that you made during the meeting by following the same points.

Course Description of Sales Training:

Sales Training the Art of persuasion and selling concentrates on all the basic fundamentals of examining from knowing how to outline your target audience to keeping them engaged in a meaningful conversation by asking the correct set of questions. This course is perfect for sales professionals, entrepreneurs, marketing executive and students. The course is suitable for anyone who wants to learn the skill of persuasion.
The course will build the confidence and aid in boosting results in selling the services and products. A proper introduction of the sales world along with selling skills are part of the training course.

Course Overview:

• The psychology and principles of selling
• Building trust and rapport
• First Impression
• Features and Benefits of services/Products
• Listening and questioning to find out customer requirements
• Gaining commitment
• Handling objections and concerns
 
Goals and Objectives of sales training:

The main objective of the course is to make you perfect in the skill of selling, winning people and persuasion. The other objectives of the training is listed below:
• Identified beliefs about selling
• Understand how the customers buy and the process of sales to match the buying cycle.
• How to build rapport with the client to create a trusting relationship.
• How to construct an exceptional first impression and introductory for professional sales conversation
• How to listen and ask questions effectively to find out opportunities and needs of the customer.
• Acquire various successful strategies to handle objections and concerns of the customer.
• Practiced introductory service as aids to meet requirements
• Practiced gaining customer’s commitment.
Target Audience for Sales Training:

• Entrepreneurs
• Business owners, startups
• Sales professionals
• Salespeople in every field
• Consultants
• Anyone looking to involve in sales or looking for enhancement in their sales efficiency.

Pre-requisites for Sales Training:

• No special skill or prior experience is needed in this course. Selling is the basic fact of any kind of business and works perfecting these skills as a professional is a crucial factor to be at the top of the field.
• A desire to learn the skills of persuasion and selling.
Highlights of the Sales Training Course:

• Sales- An art or Science:
Introduction to Sales. Introductory on sales and basic facts on sales.
• Sales- Basics
Sales Basics-an introductory explanation and setting agenda for the module. You- The significance of investing in oneself and knowing how to. Workplace & Road- Handling the office related concerns and work on day to day basis along with the inevitable factors of sales traveling by roads. Calls- Be aware of the sales visits through calls and having an insight of old and new meetings. Clients- How to deal with the views of the customers during the follow-up stage and other stages.
• Communication- Basics
Information- How and why to access information that could aid to acquire better sales results, Expression- Understanding of body language and using it to our advantage. Captivation- Getting the attention of the individual you are addressing with. Conversation- Making people to talk and share their points to acquire their trust. Positioning- Not simply speaking but describing and explaining about the service or product in a sales manner. Convincing and Argument management- It covers the phases of convincing someone and handling angry and irritated views, Closure- Dealing with closing sales calls, managing the situation. Etiquettes- Basic and default manner that needs to be followed in the sales calls.

FAQs

• How can I be sure that the selling method I learn during the sales training course will really work?
The selling methods taught during the training are time-tested and are used by millions of salespeople. One can review the client feedbacks that are posted on the site to be assured before enrolling.
• Will my results be guaranteed if I follow all the study material provided during the training?
Yes, if you give your 100 percent and work completely as per the procedure you absolutely could be assured that the process will work.
• What are the basic qualifications required for joining these courses?
The aspirant should be an intermediate (12th pass). No other qualification is required. The candidate should be willing to learn all the methods and techniques with an open mind. The course will be extremely beneficial if the candidate is willing to take sales or sales marketing as a profession.
• What will be expected of me as a trainee?
A curriculum consisting of E-lessons and worksheets will be provided to the trainee during the course period. The trainee would need to attend the weekly sessions that will wrap your mind around the selling so you easily implement the sales strategy as a part of it. You would have to complete the assignments given to you. So you think about the services/products/company in a way you never considered before the viewpoint obtained from the sales training. Ask questions and get your doubts cleared so that even others could learn from it.
Course Testimonials

Jinesh Vaidya
The training programme is very informative. The fundamental teaching of sales concepts along with different sectors and functions of sales. The course begins with the general overview then stipulates as it develops. The training has allowed me to gain major level knowledge which will enable me to grow further.
Arden
This course has allowed me to understand the ideas of sales promotion and advertising practically. It helped me recognize how choosing the appropriate advertising medium is crucial for making a sale. It also assisted me to acquire knowledge of effective and efficient management and implementation of sales promotions. I can now differentiate between different marketing techniques and know how and when to use these marketing techniques.
Barbara
The content of the course is good and incorporating. The trainer is clear in explaining various topics of sales and marketing. Learned the basics and core of the sales. All the sales factors were covered appropriately under the sales training.
Brett
A good introduction to the world of Sales. The courses go through the basic theories and trends. Starts from the oldest tactics to the newest tactics that could be implemented during the sales process. Easy to understand the explanation of what is Sales, why it is an imperative part of the business and emphasizes on the various factors and opportunities that could be grabbed with great sales strategies. Simple and easy to understand explanation and presentation during the training proves to be extremely helpful.
Career Benefits of Sales Training

• With the recognition and support of the training course, the professionals will be more involved and focused towards the company which will increase the overall the performer holding. It will also tie the person to the loyalty towards the company and work together as a team rather than being left alone and managing all the workplace challenges on their own.
• An increase in the spirit will lead the entire sales team to work together more effectively. An effective coach will work with individuals on resolving conflicts and having effective communication within the team. This does not mean no conflicts will be present but the conflicts can be utilized as an opportunity for growth rather than division.
• The one of the initial measurable prominent changes will be the sales strategies and increase in the use of best practices. The changes could not only be seen in the sales team but also with the coaches. When the management team is conversing with the employees as a coach, or obtaining the feedback from the coaching team, the ditching issues comes out in an obvious manner and is addressed in an effective, structured manner. The increase in the level of understanding of the challenges faced by the sales professionals enables the management team to provide more operative training, to have a better idea of the trends in the market or the industry, to address issues outside of the control of sales team.

Conclusion:

The sales department plays a vital role in the success of the organization or the business. The sales team emphasis on understanding the needs of the customers and involve in a conversation with the customer highlighting about the service or products to create an impression and influence them directly to make the sale. Presently the organizations focus on creating innovative techniques in the sales method to increase the selling. An efficient and well-trained sales executives and the salesperson are essential for the effective functioning of the department.
There are several institutes that offer courses and training in this field, in which they teach individuals the skills and techniques for effective sales. They provide techniques for building the team effectively and make them work as a team. Teach the effective ways of communicating with the customers; various means to retain the loyalty of the customer and how to deal at various stages of sales. These training programs are extremely beneficial for all the professional at different levels of sales job. Anyone can obtain these training as there is no requirement of particular qualification to enroll in the training course. Anyone who wants to make a career in the sales or marketing can attend the courses.

Curriculum

Section 1: An Art or a Science
Section 2: Communications Basics
Section 3: Sales Basics
Section 4: Conclusion

Course Content : 34 Training Video's

NOTE :

The course content only training module and to avail certification, the candidate has to appear for our online diploma certification exam for respective subject. The certificates are issued under "Maharashtra Technical & Self Employment Training Society" approved by Government of India and International Standard ISO Certification. The examination fees shall be additional Rs. 1,999/-

CFA - Derivatives

The course is designed only for Smart Employment Card Holders

Derivatives 2016 course:

The course discusses about the Derivative market and understanding the forward contracts, futures contracts, options, swaps. It also emphasizes on the execution of options strategies. These tutorials will help you kick start your career in this exciting market.
Through this Skilling India’s training course you will be learning about derivatives forward commitments, derivatives types, forwards characteristics, forwards equity contracts, LIBOR, FRA’s, currency forward contracts, futures margin, stock futures investment strategies, stock futures vs traditional stocks, and many more concepts of derivatives which is required to learn for CFA Level I derivative subject.

The online Derivatives 2016 tutorials would help you:

• Understand what Derivatives are and how this market works.
• In depth learn the types of Derivative instruments
• Comprehensive understanding of the Options contract and the strategies involved.
• To design alternative derivatives-Options strategies that would be appropriate for different situations and describe the advantages and disadvantages of each.


Target Audience for Derivatives 2016 Course:

• New entrant in the Derivative market and gain general Derivatives knowledge
• Interested in analyzing various option strategies.
• Students pursuing Degree, Diploma, Engineering and commerce who want to make a career in finance/Derivatives trading
• MBA in Finance, BBA in Finance


Pre-requisites for Derivatives 2016 Course:

• Desire to learn
• Computer with Internet Connectivity

Course Curriculum

Section 1: Derivatives
1 Derivatives Introduction
2 Derivatives Forward Commitments & Contingent claims
3 Derivatives Types
4 Derivatives Purposes
5 Derivatives Criticisms & Pricing
6 Forwards Introduction & Characteristics
7 Forwards Settlement and distinction between end users & dealers
8 Forwards Equity forward contracts
9 Forwards Bonds
10 Forwards LIBOR, FRA’s and Example
11 Forwards Currency Forward Contracts
12 Futures_Introdcution & Characteristics
13 Futures Margins
14 Futures Origin, procedure of futures, Investment strategies
15 Stock Futures Investment strategies
16 Stock futures vs Traditional Stocks
17 Futures Price Limits
18 Futures Margin Balance Computation Question
19 Futures Margin Balance Computation Solution Part 1
20 Futures Margin Balance Computation Solution Part 2
21 Futures Termination, Treasury bills and Eurodollar futures
22 Futures Treasury bonds, stock index and currency futures
23 Options – Introduction & characteristics
24 Options – Types of options
25 Options – Option outcomes, American & European, Moneyness
26 Options – Moneyness, ETO & OTC
27 Options – Interest rate options, caps, floors, collars
28 Options – Figure computation

Course Content : 34 Training Video's

NO CERTIFICATE WITH THIS COURSE

The course content only training module and to avail certification, the candidate has to appear for our online diploma certification exam for respective subject. The certificates are issued under "Maharashtra Technical & Self Employment Training Society" approved by Government of India, International Standard ISO Certification. The examination fees shall be additional Rs. 1,999/-

Travel & Tourism Training

The Module provides highlight about the world Geography and all the arms associated with the Travel industry and defines the various terminologies used in the industry.

If you love travel, then why not make a career of it. People who work in travel and tourism have a passion for travel and a commitment to helping other travellers make the most of their holiday.
In simple terms, people in the travel and tourism industry transport people to new places, assist with accommodation and help with sightseeing and activities. The jobs include travel agents, wholesalers, tour operators, reservations consultants, hotel staff and a variety of executive positions.
So in this course we are going to learn about World Geography and various concepts used in the Travel and Tourism Industry.
 
What are the requirements?

– Basic idea about the world Geography
– Passion to learn continuously
– Having traveled to a destination will be an advantage.
 
What am I going to get from this course?

– Over 26 lectures and 3 hours of content!
– To make the participants understand the world Geography and basic concepts of the Travel industry.
– Learn about arms associated with the Travel industry and defines the various terminologies used in the industry
– Learn how Travel Industry and people associated with it work
What is the target audience?

– Students who want to make their career in Travel and Tourism industry.
– Professionals in Tourism Industry

Course Curriculum

Section 1: Introduction
1 Introduction
Section 2: Tours and Travel Agents
2 Travel Agent Types
3 Types of Tours
4 Role of IATA and UFTAA
5 Oceans Of the world
Section 3: Freedoms of Airlines
Section 4: Types of Journeys
Section 5: Reservations & Ticketing
Section 6: Interline & Codeshare

Course Content : 26 Training Video's

NOTE :

The course content only training module and to avail certification, the candidate has to appear for our online diploma certification exam for respective subject. The certificates are issued under "Maharashtra Technical & Self Employment Training Society" approved by Government of India, International Standard ISO Certification. The examination fees shall be additional Rs. 1,999/-

Website Setup and Design for SEO

The course is designed only for Smart Employment Card Holders

Website Setup And Design For Seo

Website design is more than just about creating a pretty website with all the bells and whistles. While it is important to create a website that is attractive to your viewers and customers, it is also important to make one that attracts search engines. That’s what this course teaches you.

Before we explore this course further and learn more about its benefits and uses, let’s look at the basic steps involved in web design.

The first step is to create the layout design, which can be done with Adobe Photoshop

After the layout is complete, we roll up our sleeves and start coding the site using HTML. This is the development part
This site covers both key steps: layout design and website development. We cover the use of Photoshop, although there are other design tools that you can also use. You also get to know some great features to use in the software for website design.

About Website Setup And Design For Seo

Let’s start off by answering one key question: how important is search engine optimization really? The past few years have seen Google introduce changes to its search engine algorithms that reduce the importance of many things traditionally considered key for SEO. Today, the focus is widely on good website design and originality. If you have both, you are well on your way to getting a good search engine page rank.

But does that mean SEO is dead? Not really. In fact, SEO is still a necessity for a designer to learn and implement. It is important for designers to make it easier for search engines to find their blogs and website.

Why Should You Learn About SEO?

SEO is not a domain exclusive to online marketers. If you want to be a front-end developer or a web designer, a majority of onsite SEO would be under your domain. You can lose a lot of your site is not search engine optimized, even if you are not aware of it. You cannot rely on visitors to directly type in your site address or go through backlink referrals. Most people find websites through search engines, so that has to be biggest focus.

Just take a look at any popular website, and you’ll find that a majority of their traffic comes from search engines. Over time, as you gain more popularity and recognition, you’ll find more people visiting your site directly or coming in via links. Until then, however, SEO will be the only way that people find and visit your site. Without a good page rank, you could be losing on thousands of possible visitors and customers on a daily basis.

Apart from being necessary for web design and development, SEO is also a good value-added service that you can offer separately as an add-on for your clients.

How Search Engines Work?

To understand SEO, let’s quickly look at how search engines work. Search engines use automated ‘web crawler’ or ‘web spider’ programs to crawl the web. These programs scan web pages, read and collect content on the pages, and follow the external as well as internal links. They then send the collected information to the search engines database, or index.

When a user visits Google and types something in the search engine, the query is then matched with the information in Google’s index to find the most relevant results. The effectiveness of a search engine is based on how well it answers the search query, and how closely it matches the results that the viewer wants. This is what the search engine’s algorithm does. The algorithm basically compares the page content with a number of factors to measure relevance. The higher the page scores, the more relevant it is to the viewer’s search and a higher ranking on the search engine results page. Some of these factors are more important than others, and the algorithm changes over time with updates.

Your role in SEO

While different search engines have their own algorithm for ranking pages, it is important to understand the general factors for all algorithms to influence them and improve the search result position of a website. That is what SEO expert do and that is what this course will help you achieve. SEO can be done in two ways: offsite and onsite.

Onsite SEO involves things to do with your website, which is where good website setup and design for SEO comes into the picture. You tweak the target keywords, site structure, HTML markup, internal links and other elements to achieve this.

Offsite SEO involves things that are much less in your control, like the number of people linking to your site and the number of backlinks you get.

This guide is for developers and designers and focuses on the aspect that you have the most control over: onsite SEO. As for offsite SEO, you can achieve it by just basically doing your work well: designing a great website, producing useful content and keeping active.

Course Description

Now that you know the basics about SEO and the role of website setup and design for SEO, let’s take a closer look at the course layout:

Section 1: Website Setup and Design for SEO

In just a single section, we learn all there is to know about good website setup and design on SEO. Starting with the importance of focusing on visitors, which we touched upon in the beginning, to the importance of the theme in general, this section covers all the large aspects of optimized design. It also covers the smaller elements, like HTML tags (headers, alt tags, meta tags, and more).
Outside the website design and development, the section focuses on the importance of website hosting, accessibility and more. It covers latent semantic indexing, a indexing and retrieval method that is vital for document indexing and helps identify patterns of word distribution in documents.
Finally, the section evolves to focus on the technology behind SEO, and the importance of blogging and its role in optimizing your site. And it ends with some really helpful tips on what to do and what to avoid when it comes to website setup and design for SEO.
Focus on Visitors
Focus on Quality and Uniqueness
Focus on Website Theme
Focus On Domain Name Part 1
Focus On Domain Name Part 2
Focus On Website Hosting
Focus On CSS
Focus On Header Tags
Focus On Alt Tags
Focus On Meta Tags
Example Meta Title Tags
Focus On Meta Tags
Example Meta Description Tags
Focus On Meta Tags
Latent Semantic Indexing
Focus On Accessibility
Focus on Validation
Example Accessibility and Validation
Focus On Redirects
Focus On New Technology
Focus on Blogging Part 1
Focus on Blogging Part 2
Example focus on Blogging
Focus On RSS Feeds
Example RSS Feeds
Useful Dos for SEO
Useful donts for SEO
What Are the Pre-Requisites To Website Setup And Design For Seo?
Learning website setup and design for SEO is very useful to make a successful website. Here are some of the requirements and skills that you would need, however, before enrolling in this course:
A basic understand of how to use a computer and how the internet works, particularly how site surfing and moving between sites work
An understanding of basic elements of website design and layout
A basic understanding of HTML is very helpful and speeds up the learning process
Target Audience
The main target audience for this course can include:
Website developers and designers who want to learn SEO
Website owners who want to get more insight on how to improve site SEO
SEO marketers looking to get a hands-on view on how to make an SEO-friendly website
The course is essentially suited for anyone who wants to start learning how to develop a website while optimizing it for search engine visibility.

 

Course Content : 27 Training Video's


NO CERTIFICATE WITH THIS COURSE

The course content only training module and to avail certification, the candidate has to appear for our online diploma certification exam for respective subject. The certificates are issued under "Maharashtra Technical & Self Employment Training Society" approved by Government of India, International Standard ISO Certification. The examination fees shall be additional Rs. 1,999/-

Computer Troubleshooting

Join this wonderful course on Basics of Computer Troubleshooting and get insights into important topics like Motherboard, Pinging IP address, Crimping tool and network tester etc.

Troubleshooting computers can be a little frustrating and a little tricky. With so many parts and software installed, any number of things can go wrong. But when (not if) something happens, this is the best opportunity for you to learn-of course provided that you have a few basics under your belt. Nothing beats experience.

The more you do it, the better you become, and the more your confidence grows. And the best part, you will save yourself a lot of money. Through this course you will be learning about components of motherboard i.e. motherboard parts, installation of RAM, ROM etc. Also you will be learnign about installation of windows, sound & video cards of troubleshooting, network troubleshooting, crimping too and network tester etc. things you will be learning under this course.

Curriculum

Section 1: Understanding about Motherboard Concept
1 Motherboard diagram and parts
2 Installation of Ram‚Rom‚HDD‚optical drive cd rom
3 Assembling of basic computer parts
4 Installation of win xp and assigning ip address
Section 2: Learning about Troubleshooting PC
5 Basic troubleshooting PC
6 Sound and video cards troubleshooting
7 Pinging IP address
8 Network troubleshooting in win7 and 8
9 Keyboard problems-troubleshooting
10 Crimping tool and network tester
11 Northbridge and southbridge and virus and enabling macros in ms office

Course Content : 11 Training Video's

NOTE :

The course content only training module and to avail certification, the candidate has to appear for our online diploma certification exam for respective subject. The certificates are issued under "Maharashtra Technical & Self Employment Training Society" approved by Government of India, International Standard ISO Certification. The examination fees shall be additional Rs. 1,999/-

Advertising and Promotions Training

Why Advertising and Promotions Training?

Advertising and Promotions Training, you get acquainted with the various options that companies have in order to market their products. It takes you through the various forms of communication and media that can be used to reach out to the target audience. It throws light on various aspects of advertising, media and other forms of promotions.
Advertising and Promotions Training is ideal for All marketing professionals and students, media and advertising professionals and enthusiasts, entrepreneurs and brand managers of companies and students. The participant gets a good knowledge of how to market a product/brand using various tools.
The participant also gets a basic understanding of how advertising works and also what are the available options if he/she wants to promote his/her company/brand/product, etc. It also acts as a base for any student aspiring to get in media marketing or advertising.

Highlights of Advertising and Promotions Training:
• Introduction to IMC (Integrated Marketing Communications) -
Explains basic concepts of marketing ,Talks about the concept of imc and the tools,Describes the imc planning process in detail,Case studies to understand IMC better.
• Role of IMC in the marketing Process -
Explains the marketing strategy analysis,Target marketing with examples are highlighted,Market positioning and its strategies with suitable examples are given,Marketing program development,Distribution and pricing decisions in marketing,Promotional strategies and decisions.
• Understanding the communication process -
basic communications model and explanation,Models of Consumer Response in Advertising like AIDA, Hierarchy of Effects,Models of Consumer Response in Advertising like Innovation Adoption and Information processing models,FCB Planning Model,ELM Model.

• Advertising Objectives -
Basics about advertising objectives,DAGMAR Model for seting objectives.
• Structure of Advertising and promotions world -
Concepts like advertiser, ad agency,Centralized and Decentralized agencies,Functions of ad agencies,Types of ad agencies,Agency compensation and evaluation,specialized marketing agencies.
• Advertising and Creative Strategy Execution -
fundamentals of an ad campaign,advertising process explained,advertising creativity,creative risks,creativity process,creative strategy development,approaches to creativity,Creative exectution and appeals in advertising.
• Media Planning & Strategy -
basic media concepts,media planning steps,media planning process contd.
• Various forms of media -
print media – newspapers,newspaper classifications,newspaper advertising,newspaper and ad related terms,magazines and their pros and cons,today and tomorrow of print,broadcast media – Television,Players in TV industry,Tv Buying Methods ,Measuring TV audiences,Radio Industry,Radio pros and cons, buying and costing in radio media,outdoor media,transit media.
• Unconventional and Support media -
sponsorships, merchandising, cinema advertising, branded entertainment,internet advertising.

Advertising and Promotions Training Course Goal and Objectives:
The objective of the course is to make participants aware of various forms of marketing communication and media that can be used to reach out to the target audience

Target Audience for Advertising and Promotions Training
• marketing professionals
• students
• media and advertising professionals
• entrepreneurs
• brand managers

Pre-requisites for Advertising and Promotions Training
• The course starts from very basics and hence no prerequisites technical knowledge is required
• Participants must have strong desire to learn marketing

Course Curriculum

Section 1: Introduction to Advertising
Section 2: Role of IMC in the marketing Process
Section 3: Understanding the communication process
Section 4: Advertising Objectives
Section 5: Structure of Advertising and promotions world
Section 6: Advertising and Creative Strategy Execution
Section 7: Media Planning Strategy
Section 8: Various forms of media
Section 9: Unconventional and Support media

Course Content : 53 Training Video's

NOTE :

The course content only training module and to avail certification, the candidate has to appear for our online diploma certification exam for respective subject. The certificates are issued under "Maharashtra Technical & Self Employment Training Society" approved by Government of India, International Standard ISO Certification. The examination fees shall be additional Rs. 1,999/-

Shop Act Licence
Use this facility in order to apply for Shops and Establishments Registration, Renewal of the Registration, Notification of change, Duplicate Registration Certificate, as well as cancellation of the Registration Certificate.


Documents required to be submitted by the applicant along with the application
In order to view the list of documents, Please Click on the appropriate link as listed below

New Application for Registration : Fill Form A and attach during registration process.

For Renewal : Fill Form B and attach during registration process.

Application for Notification of Change : Fill Form E and attach during registration process. 

All require forms are provided in  File Download Section.


न्यू शॉप अॅक्ट साठी लागणारे कागदपत्र

१. चालू महिन्याचे लाईट बिल / टॅक्स पावती

२. लाईट बिल घरमालकाच्या नावावर असल्यास संमतीपत्र करावे लागेल.

३. ओळख पत्र :- मतदान कार्ड / आधार कार्ड / पॅनकार्ड / ड्रायव्हिंग लायसन्स / पासपोर्ट यापैकी एक 

४. दुकानाचा बोर्ड लावून काढलेला फोटो.



अप्लीकेशन कसे करावे.

१. डाउनलोड सेक्शन मध्ये जाऊन फॉर्म डाउनलोड करावा.
२. संपुर्ण फॉर्म उमेदवाराकडूनच भरून घ्यावा
३. वरील डॉक्युमेंट सह फॉर्म अपलोड करावा.

Skilling India Brochure
Skilling India Brochure for Smart Employment Card

Very helpful for Marketing Smart Employment Card in Education Institution or Colleges. The brochure has complete information about card features, usage, information on free career support for card holder, Additional paid support such as advance courses, certification, external exams, entrance preparation support etc.

Brochure Size : 9" x 6"
Pages : Front Back 4 Page
250 gsm Art Paper

Rate Per Brochure Rs. 16/-
Single Pack contains 50 Brochures
+ Courier Charges Rs. 100/- per pack
Smart Employment Card
Database Application Development

The course is designed only for Smart Employment Card Holders

Database Application Development Training

Interested in learning everything about website development? You cannot miss out on database application development if that’s the case. Databases are an organized means of storing, retrieving and managing information, and form the backbone of a website. This is not for those who want to simply use a CMS to build a simple website. It is also not for those simply interested for good website design. This course delves into the world of hardcore database application development training.

About Databases And Database Applications

The world of databases can be rather confusing, but this course makes it a lot easier. When you develop a database-dependent website or an ecommerce site, data management becomes a critical part of the website development process. Before you look at the more flashy elements of your website, you need to set up your database so that your site retrieves the right data at the right time and puts it up in the right place.
To understand the working of a database, think of a basic Excel file with its usual rows and columns. The columns have specific information types and fields. In case of an ecommerce site, it would contain information types like product price, name, color and other fields. The rows contain the actual information for the columns. Now, if you want your customers to search and sort the different products by fields such as manufacturer/designer, color and price, you need to create a table that includes all those fields.
Visit your favorite ecommerce site and take a look at all the amazing options they have for sorting through mountains of data. That critical ability is what makes them so popular. If you plan on making a site like that or any site that uses lots of data, database application development is absolutely vital. It sounds like hard work and it is hard work, but it is what separates a good site from the rest.
And what if you lack the data in the first place? Well, limited data only lets you do so much. You can still make a great-looking site, but you would limit the ability of a website visitor to browse your site and find the product they want.
As you can see, great data forms the foundation for a good website and user experience. This course helps you learn everything about database application development, from the basics to coding.
Database management systems (DBMS) are software programs that enable a computer to perform these functions of adding, storing, deleting, modifying and retrieving data. Relational database management systems (RDBMS) follow a relational model for tables and relationships. Oracle and Microsoft Access are among the most popular DBMS right now.

This course focuses on one particular DBMS: Oracle 11g.

Oracle Database 11g is a beginner-level database with a small footprint. It is free to develop, distribute and deploy. It is also easy to download and simple to register. For a newbie web developer, this is the perfect starter database to work on XML, .NET, PHP, Java, Python and other languages.
The Oracle 11g is installable on host machines of any size, with any number of CPUs. An Oracle database is an RDBMS, which has object-oriented features like polymorphism, inheritance and user-defined types. It also uses the concept of database schemas, which are collections of logical data structures also known as schema objects. This enables that physical data storage is independent from logical data structures.
All the data operations that are performed in Oracle 11g or any other Oracle database use SQL statements. SQL is a language that offers an interface between user and the database. It is non-procedural, which means that users can specify the result that they want rather than how to derive it.
This course focuses on the use of PL/SQL, which is a procedural extension to the SQL used for Oracle. PL/SQL is integrated with the database, which enables you to use Oracle database SQL functions, data types and statements. One major benefit of PL/SQL is that it allows you to store application logic within the database. With this server-side programming, you can deploy the inbuilt functionality anywhere.


Oracle Database Architecture

An Oracle database requires a server for information management and to manage the huge amounts of data present in an online environment. In Oracle, a database server consists of one database and one or more ‘instances’. An instance and database are very closely connected, which is why both terms can be used interchangeable in normal parlance. However, a database instance is different in that it is a set of memory structures for managing database files.


Course Description

With the basics of databases clear, here is a look at what you get to learn with this course:
Section 1: Introduction
We start with the downright basics, exploring what databases are in greater detail and what is the role of database applications. We look into how databases help run websites, and their critical role in the overall online experience you are trying to build. The section concludes with a discussion of all the languages used for database development, including SQL, Java, Python and more. The key language to learn here would be SQL.

1. Course Overview
2. What Is Database And Application
3. Languages Used For Development


Section 2: Oracle Environment

Next, we get introduced to the DBMS that you will be using extensively for the rest of this course: Oracle. We explore the structure of an Oracle database, which we very briefly touched upon in the previous segment. We go further into database and database instance structures, storage structure and the application architecture which will be the computing environment where the database application connects to the Oracle database. The section covers the languages and tools used for working on Oracle, with a special focus on the most important language: SQL.

4. Environment For Oracle Database
5. Languages And Tools For Oracle Database
6. Structured Query Language
7. Advantages Of SQL

Section 3: Properties

Now, we have ended the basics. You should be familiar with the fundamentals of databases and the tools and languages to be used. With that clear, this section jumps into further details regarding databases an SQL properties and database application operations. It introduces the key concept of Atomicity, Consistency, Isolation, Durability (ACID) properties for databases.

8. Database, SQL Properties
9. ACID property
10. Case Study for Atomic Property
11. Database Application Operation

Section 4: Creation of Database

With the theory complete, we begin with the first step for database application development training: creating a database. We learn how to use tablespaces, which are logical file storage locations for an Oracle database. Tablespaces are closely related to databases and datafiles, and are key to understand how data is stored and utilized.

12. Creation of Database
13. Creation of database user tablespace
14. Creation of database user tablespace continued
15. Creation of Tables
16. Creation of Tables continued

Section 5: Data Types & Constraints

In an SQL statement, each column constant and value has a data type associated with specific format for storage, constrains and valid value range. In this section, we explore the various inbuilt data types in an Oracle database, such as character, numeric, DATE, LOB and others. Constraints here are key to enforcing a relationship between two tables.

17. Data Types
18. Data Types continued
19. Types Of Constraint
20. Define Constraint
21. Foreign Key Constraint
22. Not null, unique and check constraint
23. Creating and Altering Table example
24. Displaying and droping the table columns and table

Section 6: Triggers

In this section, we cover database triggers, which are procedures stored in a database and executed, or fired, implicitly when a table is modified. We get an introduction to triggers and their use in database applications as a way to develop a customized database management system, to improve security and information auditing, and more.

25. What is Trigger
26. Designing Triggers
27. Naming and creating Triggers
28. Types of Trigger and restrictions
29. Compiling Triggers
30. Examples of Trigger Application

Section 7: Stored Procedures

While the above sections covered using SQL to interact with a database, this section covers using PL/SQL, a third-generation language with expected namespace and procedural constructs. You can use PL/SQL to create and use database-stored procedures as building blocks for various applications.

31. Stored Procedure
32. Stored Procedure Creation with Example
33. Calling Procedure and features
34. Return value of procedure and restriction

What Are The Requirements?

As you can see from the overall course structure, this course covers more than just the fundamentals of database application development. As such, there are some prerequisites if you want to succeed in this course:

1. An understanding of databases and web application development
2. An interest in learning about how to create your own database
3. A moderately fast computer with more than 10 GB of space to set up a server
4. A understanding of how web applications work
5. Knowledge about SQL, especially hands-on coding knowledge

Target Audience For This Training

This database application development training course is suited for just about anyone interested in learning this topic, and with the aptitude for coding and understanding data logic. The course is also suited for database administrators looking to expand their skillset and learn more about Oracle databases and how to use them.
While the course goes into detail about creating, using and managing Oracle databases for developing database applications, it does not explore SQL alone in that much detail. And if you have a little background knowledge about this vast, powerful and important web development language, you will get to learn a lot more from this course.

FAQs

• What am I going to get from this course?
Once you complete this course, you will get a very clear understanding of the Oracle 11g database, and its use in web application development. You will learn how to create one, and learn some key elements of the language and tools for managing such databases, including SQL, constraints, data types and triggers.

• I do not have any experience in coding. Would this course be suitable?
If you are looking to learn more about the fundamentals of Oracle databases, then this course should be suitable. You would complete it knowing the inner workings of an Oracle 11g database and PL/SQL. However, you may not be able to put that knowledge onto an actual project unless you explore more about SQL, and learn to code. It is highly advisable that you learn how to code using SQL, before or after completing this course. Although before would be better, since it gives you a better foundation.

• Does this go into details about managing Oracle databases?
The course focuses the fundamental elements of Oracle databases, which is itself a vast area of study. What you get from this course is a complete theoretical and baseline operational understanding of Oracle databases. This alone can help you in two ways. For one, it helps you understand how databases in general are managed and created. Secondly, it gives you the tools and knowledge to create your own database, and to get into the wonderful world of Oracle.

Career Benefits Of This Training
While this course just scratches the surface of database application development, it opens the doors to the highly lucrative world of web application development. With enough knowledge and real-world experience, you can play a key role in developing and designing web or network applications. You can even create your own applications. If your idea is good and your application well-designed, you stand to earn quite a lot.
If you opt for focusing on your career as a web application developer, you will open yourself up to a rather rewarding career with attractive opportunities and benefits. Developers have a very critical role, and with most companies focusing on the internet these days, the field will only get bigger and more important.

 

Course Content : 34 Training Video's

 

NO CERTIFICATE WITH THIS COURSE

The course content only training module and to avail certification, the candidate has to appear for our online diploma certification exam for respective subject. The certificates are issued under "Maharashtra Technical & Self Employment Training Society" approved by Government of India, International Standard ISO Certification. The examination fees shall be additional Rs. 1,999/-

Senior Citizen Certificate
Senior Citizen Certificate

अप्लीकेशन कसे करावे.

१. डाउनलोड सेक्शन मध्ये जाऊन फॉर्म डाउनलोड करावा.
२. संपुर्ण फॉर्म उमेदवाराकडूनच भरून घ्यावा
३. वरील डॉक्युमेंट सह फॉर्म अपलोड करावा.


Master of Commerce (M.Com.)
Master of Commerce (M.Com.)
10th External Exam
Approved Under MHRD, Government of India

Medium : English / Hindi / Marathi / Urdu

Eligibility : 7th/ 8th/ 9th Pass or Fail Candidate

Age Limit : Should be above 14 years

Subject : Any Five to be chosen from below list.

1) English* (Compulsory)2) Marathi / Hindi / Urdu (Choose any one)3) Economics*4) Business Studies*5) Home Science*6) Data Entry*7) Painting*8) Social Science*9) Maths*10) Science & Technology 11) Psychology.

Features :-

  • Course curriculum for selected subjects shall be sent by post. The candidate has to learn the subject by self study. Support available for queries / questions / guidelines for all above subjects.

Please Note:-

Candidate's require regular class room training support should click on Call room training fees which shall be additional Rs. 10,000/- for a year.

Documents Require :-
  • Earlier Mark sheet or Passing Certificate if any
  • School leaving certificate
  • Recent Passport size photograph (2 Nos.)
  • Cast Certificate in case of SC & ST
  • Address Proof (Adhaar Card / Electricity Bill / Residence Agreement Copy)

All above documents required in Original form during admission confirmation. 3 Attested copies of each above document is compulsory.


Passing Mark : 33% mark in aggregate, Passing in 5 Subjects and one language require for certification.
Pan Card
Registration for PAN CARD

  • Individual
  • Company


पॅनकार्ड साठी लागणारे कागदपत्र

  • ओळखपत्र :- मतदान कार्ड,आधार कार्ड,पासपोर्ट, ड्रायव्हिंग लायसन्स, नगरसेवकाचे पत्र यापैकी एक

 

  • पत्त्याचा पुरावा :- मतदान कार्ड,आधार कार्ड,पासपोर्ट, ड्रायव्हिंग लायसन्स,नगरसेवकाचे पत्र यापैकी एक

 

  • जन्माचा पुरावा :- जन्म दाखला,शाळेतून दुसरे मिळालेले बोर्ड सर्टिफिकेट,प्रतिज्ञापत्र, पासपोर्ट, ड्रायव्हिंग लायसन्स, या दोन कागदपत्र वर पूर्ण जन्म तारीख पाहिजेल :- मतदान कार्ड,आधार कार्ड, यापैकी एक


अप्लीकेशन कसे करावे.

१. डाउनलोड सेक्शन मध्ये जाऊन फॉर्म डाउनलोड करावा.
२. संपुर्ण फॉर्म उमेदवाराकडूनच भरून घ्यावा
३. वरील डॉक्युमेंट सह फॉर्म अपलोड करावा.

VBAs and Macros

The course is designed only for Smart Employment Card Holders

Excel VBAs and Macros – Basic and Advanced

Skilling India brings you the course on Excel VBAs and Macros. This course is for everyone who wants to know and learn about VBA and Macors right from scratch to the advanced level.

Course Curiculum

Module 1: VBA & Macros: Part (1 & 2) Introduction
1 VBA & Macros: Course Introduction

Module 2:
Introduction to VBA
2 What are VBA & Macros?
3 Advantages of using VBA and Macros

Module 3: My First Macro
4 Protocols in creating Macros
5 Creating My First Macro

Module 4: VBA Environment
6 VBA Environment – Project Explorer
7 VBA Environment – Properties
8 VBA Environment – Run Break Reset and Design
9 VBA Environment – Debug – Toggle
10 VBA Environment – Debug – Local Window
11 VBA Environment – Debug – Watch and Immediate Window

Module 5: Macros with IF Condition
12 Macros with IF Condition
13 Macros with IF Condition (Continued)

Module 6: Data Filter

14 Data Filter using VBA – Introduction
15 Data Filter using VBA – Macro Recording
16 Data Filter using VBA – Dynamic Update
17 Data Filter using VBA – Command Buttons
18 Data Filter using VBA – Command Buttons – Modifying
19 Data Filter using VBA – Command Buttons – Final touches

Module 7: Charting using VBA
20 Charting using VBA – Introduction
21 Charting using VBA – Creating codes for charts
22 Charting using VBA – Recording Macro
23 Charting using VBA – Chart in another sheet
24 Charting using VBA – Dynamic Inputs
25 Charting using VBA – Creating Dynamic charts
26 Charting using VBA – Checking the codes

Module 8: Userform
27 Userforms – Introduction
28 Userforms – Textbox
29 Userforms – Textbox Printing

Module 9: VBA Introduction
30 VBA Introduction

Module 10: Userform - EMI
31 EMI Userform – Introduction
32 EMI Userform – Creating the userform
33 EMI Userform – Creating basic Combo Box
34 EMI Userform – Activating the userform
35 EMI Userform – Recreating Combo Box
36 EMI Userform – Function of List Box
37 EMI Userform – Create and testing the List Box
38 EMI Userform – Inserting the List box
39 EMI Userform – Radio Button and its usage
40 EMI Userform – Enabling command button
41 EMI Userform – Creating option buttons
42 EMI Userform – Checkbox

Module 11: Looping
43 Looping – Meaning of Looping and For Next Loop
44 Looping – For Next Loop
45 Looping – For Next – Exit For and Step
46 Looping – For Next – Nested Loops
47 Looping – Do Until Loops
48 Looping – Do While Loops

Module 12: Last Row and Column
49 Last Row and Column – Identification of last row and last column
50 Last Row and Column – Dynamic

Module 13: Referencing Sheets
51 Referencing from the Same Workbook
52 Referencing from the Another Open Workbook
53 Referencing from the Another Closed Workbook
54 Referencing from the Another Closed Workbook with Dynamic Ranges

Module 14: Calculator - Update Now
55 Calculator – Update Now

Module 15: Writing Formulas
56 Writing Formula – RowColumn Method
57 Writing Formula – Range Formula and Worksheet fn

Module 16: Calculator - EMI Calculations
58 PMT formula
59 Recording Macros
60 Modifying Code and Linking to user inputs
61 Modifying Code and Linking to user inputs – Update dynamically
62 New Sheet with selected user inputs
63 New Sheet with selected user inputs and coding
64 Debugging the code – VLOOKUP function
65 Debugging the code – EMI and processing charges

Module 17: Arrays
66 Introduction to Sort EMI – Button
67 Arrays basics
68 Populating arrays in Worksheet
69 Sorting Numbers using Arrays
70 Sorting Numbers using Arrays (Continued)
71 Sorting Numbers using Arrays – Understanding the code
72 Sorting Strings using Arrays

Module 18: Sort EMI Button
73 Assign Bank Details to Arrays
74 Assign Bank Details to Arrays (Continued)
75 Sort Bank Details Arrays
76 Sort Bank Details Arrays (Continued)
77 Sorted Array in New Worksheet

Module 19: EMI Calculator - Create Graph
78 Introduction

Module 20: Create Graph
79 Create graphs using Macros
80 Copying Bank Details to Graph Sheet
81 Creating Static Graph
82 Creating Dynamic Graph
83 Positing Graph at customized location
84 Dynamic graph Conclusion

Module 21: Print using VBA
85 Print – user defined sheet number or name
86 Print – Dynamic Range
87 Print – Dynamic Range (Continued)

Module 22: EMI - Calculator - Print Report
88 Print Report – Dynamic table and graph
89 Print Report (Continued)
90 Print Report – Tackling errors

Module 23: EMI - Calculator - Email Report
91 Creating PDF
92 Creating PDF and integrating the userform
93 Email Report with PDF
94 Email Report with PDF – EMI calculator
95 Print and email report

Module 24: VBA & Macros: Part (1 & 2) Conclusion

96 VBA & Macros: Part [1 & 2] Conclusion.

Major topics included in this course includes;
• Introduction to VBAs and Macros- This is an introductory section to understand VBA and its functions
• My First Macro- This section deals with understanding the Protocols in creating Macros and creating your first macro
• VBAs and Macros Environment- This section deals with understanding Project Explorer, properties, debug etc.
• Macros with IF Condition- This section is for you to understand macros with IF condition and how it works
• Data filter- This section will deal with understanding Macro Recording, Dynamic update and command buttons
• Charting using VBA- This section is for to learn about the Creating codes for charts, recording macro, Dynamic Inputs etc
• Userform- This section you would understand userform textbox and textbox printing
• EMI Userform- Here you would learn creating and activating list box, combo box, working with radio buttons etc.
• Looping- This section deals with Meaning of Looping and For Next Loop, do until loops and do while loops
• Referencing- This section deals with Referencing from the Same Workbook, open workbook, closed workbook etc.
• Calculator- This section deals with calculator update now and EMI calculations
• Arrays- This section deals with array basics, populating arrays, sorting numbers using arrays etc.
• Creating Graphs- This section deals with static, dynamic graphs, posting graph in customized locations etc.
• Printing using VBA- This section deals with user defined sheet number or name along with printing and emailing reports


About Excel VBAs and Macros – Basic and Advanced

Visual Basic for Applications (VBA) is user friendly programming language developed by Microsoft. With VBA we can design a very good interactive screen with all label, text boxes and buttons; and by doing proper coding with Macros, we can make this work very simpler and systematic.
A macro consists of instructions that the user can record as per his/her need & associate with a shortcut key combination or a macro name. Then whenever that shortcut key is pressed or macro name is clicked, computer automatically carries out those set of instructions.

What am I going to get from this course?

• Over 96 lectures and 15 hours of content!
• Conceptual and practical understanding of VBA features
What are the requirements for Excel VBAs and Macros – Basic and Advanced?
• There are no pre-learning required.This course is structured in a manner that is easily understood.
• Passion to learn

What is the target audience for VBAs and Macros Course?

• Suitable for students pursuing Degree, Diploma, Engineering, commerce and all general studies.
• MBA, BBA students from all specializations
• Charted Accountant (CA)
• Also suitable for working professionals.
• People who want to work as Finance Analyst, Market Analyst, Research Analyst, Investment Banker for them Excel is the language that they should speak.

 

Course Content : 95 Training Video's

NOTE :

The course content only training module and to avail certification, the candidate has to appear for our online diploma certification exam for respective subject. The certificates are issued under "Maharashtra Technical & Self Employment Training Society" approved by Government of India, International Standard ISO Certification. The examination fees shall be additional Rs. 1,999/-

Master of Science (M. Sc. )
Master of Science (M. Sc. )

2 Years
Organic Chemistry, Electronics & Zoology
Per Page      1 - 20 of 168