A Unit of Health & Education Society (Regd.)

Govt Logo
  • Recognized Under Sec. 2(f) of UGC Act 1956,
  • Approved by AICTE, Ministry of Education, Govt. of India,
  • Affiliated to Guru Gobind Singh Indraprastha University.

Add-On courses

INTRODUCTION

The Bachelor of Business Administration from Tecnia Institute of advanced studies provides the students with the knowledge and provide tools they need to succeed. BBA is a three years bachelor’s level degree program that prepares student’s skills in business, finance, economics, marketing, human resource management, analytics develop the ability to think critically, logically, analytically and to use and apply current management concepts and practices for providing business solutions in the multiple domains which are required for any BBA student to succeed in today’s business environment. In broader perspective the mission of teaching BBA is to produce employable managerial workforce, that will have sound knowledge of business fundamentals that can be applied to develop and customize solutions for various Enterprises.

Advance Excel Credits
2

Pre-Requisites​​

  1. Basic understanding of MS excel shall be added advantage.

Objectives​​

The objective of this course is to provide conceptual and Practical understanding of Excel and how to set up the chart function of Excel to represent numeric data in multiple formats. The course helps to understand Differentiate between formulas and functions in Excel. It helps to Access and manipulate data using the database functions of Excel. • Create simple & complex macros in Excel.

Learning Outcomes​​

At the end of the course, the students will be able to:

  1. Apply advanced formulas to lay data in readiness for analysis.
  2. Use advanced techniques for report visualizations.
  3. Leverage on various methodologies of summarizing data.
  4. Understand and apply basic principles of laying out Excel models for decision making.

Detail Contents

S.No. TOPIC DESCRIPTION DURATION
Overview of the Basics of Excel
  1. Customizing common options in Excel .
  2. Absolute and relative cells
  3. Protecting and un-protecting worksheets and cells
Working with Functions
  1. Writing conditional expressions (using IF) .
  2. Using logical functions (AND, OR, NOT) .
  3. Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX).
  4. VlookUP with Exact Match, Approximate Match.
  5. VlookUP with Tables, Dynamic Ranges .
  6. Nested VlookUP with Exact Match .
  7. Using VLookUP to consolidate Data from Multiple Sheets.
Data Validations
  1. Designing the structure of a template.
  2. Using templates for standardization of worksheets.
Working with Templates
  1. Specifying a valid range of values for a cell.
  2. Specifying a list of valid values for a cell.
  3. Specifying custom validations based on formula for a cell .
Sorting and Filtering Data
  1. Sorting tables .
  2. Using multiple-level sorting.
  3. Using custom sorting .
  4. Filtering data for selected view (AutoFilter) .
  5. Using advanced filter options .
—-
Working with Reports
  1. Creating subtotals
  2. Multiple-level subtotals
—-
Creating Pivot tables
  1. Formatting and customizing Pivot tables
  2. Using advanced options of Pivot tables
  3. Pivot charts .
  4. Consolidating data from multiple sheets and files using Pivot tables .
  5. Using external data sources
  6. Using data consolidation feature to consolidate data
  7. Show Value As ( % of Row, % of Column, Running Total, Compare with Specific Field)
  8. Viewing Subtotal under Pivot
  9. Creating Slicers ( Version 2010 & Above)
—-
More Functions
  1. Date and time functions
  2. Text functions.
  3. Database functions .
  4. Power Functions (CountIf, CountIFS, SumIF, SumIfS) .
—-
Formatting
  1. Using auto formatting option for worksheets.
  2. Using conditional formatting option for rows, columns and cells .
—-
What If Analysis
  1. Goal Seek .
  2. Data Tables .
  3. Scenario Manager .
—-
Charts
  1. Using Charts .
  2. Formatting Charts .
  3. Using 3D Graphs .
  4. Using Bar and Line Chart together .
  5. Using Secondary Axis in Graphs .
  6. Sharing Charts with PowerPoint / MS Word, Dynamically.
  7. (Data Modified in Excel, Chart would automatically get updated).
—-

List of Suggested Books​​

  1. Microsoft Excel 2019 Bible: The Comprehensive Tutorial Resource.
  2. Excel 2019 ALL-IN-ONE for Dummies.
  3. Excel: Quickstart Guide from Beginner to Expert.
  4. Excel 2019: Pivot Table Data Crunching.
Corporate Etiquettes Credits
2

Pre-Requisites​​

  1. Basic communication skill is required.
  2. Exposure to corporate environment shall be added advantage

Objectives​​

The core objectives of this Corporate Etiquette Training Course is to enable you to —

  1. Set the best impression by your professional corporate skills
  2. Understand Body language and the influence of it
  3. Sharpen your office skills including telephonic, letter and email communications
  4. Learn details of business dining skills and mannerisms
  5. Understand dress codes for different occasions
  6. Learn about multi-cultures and managing people
  7. Develop skills to effectively interact with International and government diplomats

Learning Outcomes​​

At the end of the course, the students will be able to:

  1. Better inter-personal skills
  2. Help gain mannerisms that could align with the corporate culture and values
  3. It enhances healthy relationships and understanding
  4. Directly and indirectly, it promotes the growth of the business and individuals at different levels.
  5. Enhanced non-verbal communication within the corporate set-up.
  6. Professionals become more confident with communicating and networking
  7. The overall customer experience of the clients and business partners is improved
  8. Inter-personal skills are sharpened and developed to build class and excellence
  9. Individuals become more efficient in handling and communicating with other
  10. Self-Confidence and positive energy become evident by the mannerisms
  11. These skills are effective in day-to-day social life to become a better person
  12. You get recognized for growth and developments for the next levels in the organization
  13. Better understand people from different cultures and foreign associates

Detail Contents

S.No. TOPIC DESCRIPTION DURATION
Why Etiquette Matters
  1. Effective professional introduction, Making a first impression, the first time,
2 Hours
Meetings and Introductions
  1. Do’s and Don’ts in an office meeting, Eye contact, body language.
4 Hours
The Common Courtesies of Life
  1. Basic Manners, Language Tips, Using technology appropriately.
4 Hours
Polite Conversation
  1. Polite Requests, Polite Suggestions, Saying ‘NO’, Tactics to Improve your skills
4 Hours
Telephone Etiquette
  1. Appropriate greetings and Introduction, Sensitivity to the tone of voice, Professional business communication, Active listening, Telephonic Interruptions, Dealing with voicemail, mobile phone- Do’s and don’ts
4 Hours
Correspondence
  1. E-mails, Notices, Formal and informal Letters, Note sheets, Business tone, Heading and introductions, Focus points
2 Hours
Basic Table Manners
  1. Eating out ordering in a restaurant, Handling the napkin, plates and glassware, Dining- Do’s and Don’ts, Body language at a business lunch or dinner, Host and guest etiquettes, Handling table Mishaps, Paying the bill, Tipping
2 Hours
Moments of Sorrow
  1. Deaths and Funerals, Flowers, Appropriate clothing, Serious Illnesses, Hospital Visits, Terminal Illnesses, Divorce
2 Hours
The Rules of the Workplace
  1. Office conduct and respect, Communications and Professionalism, Time Management, Working out of the office, Eating at the workplace
2 Hours
Appropriate Behavior for an Apprentice
  1. Regulations and Compliance, Business Awareness, Ethical Standards, Communication, Leadership, Team Work and Collaboration, Adaptability, Proactivity.
2 Hours
Corporate Etiquette
  1. Importance, Types of Corporate Etiquettes, Tips to improve corporate etiquettes .
2 Hours

List of Suggested Books​​

  1. Bindra V. Everything About Corporate Etiquette. Bloomsbury, 2015.
  2. Gulati S., Corporate Grooming and Etiquette. Rupa Publications India, 2010
  3. Axelrod A., My First Book of Business Etiquette, Quirk Books, 2004.
  4. Kay Dupont M., Business Etiquette and Professionalism, Crisp Learning, 2000.
NISM – mutual Fund Module Credits
2

Pre-Requisites​​

  1. Awareness about basic financial terms.
  2. Awareness about Financial Products
  3. Exposure about Financial market

Objectives​​

The Objective of this course was having operational and conceptual knowledge of Mutual Fund to become employable in the organizations dealing in Mutual Fund segment, also to crack NISM – Mutual Fund distributors Module exam organised by SEBI-NISM

Learning Outcomes​​

From this Course Students

  1. Have conceptual framework – functional, legal, and organisational aspect of Mutual Fund.
  2. By Passing NISM Mutual Fund Module students can become SEBI approved (Valid ARN) Mutual Fund Advisor
  3. Become employable in Banking sector, broking houses etc

Detail Contents

S.No. TOPIC DESCRIPTION DURATION
Concept and Role of a Mutual Fund
  1. Know the concept of securities markets and its role in the Indian Economy
  2. Understand the concept of mutual fund and compare and contrast with conventional investment avenues such as Bank Deposits, Post Office Deposits, Public Provident Fund.
  3. Understand the mutual fund industry and related concepts
  4. List the advantages and limitations of a mutual fund
  5. Understand the two plans or routes for investors to invest in a mutual fund
  6. Know about the different kind of investment options available to the investors
  7. Explain the role of new cadre of mutual fund distributors
(—)
Fund Structure and Constituents
  1. Know the basic legal structure of mutual funds in India and understand their role
  2. Understand the role and support functions of service providers of mutual funds.
  3. Understand the organisation structure of Asset Management Company.
(—)
Mutual Fund Products
  1. Understand the classification of mutual fund schemes
  2. Explain the categorization and definition of open-end mutual fund schemes
(—)
Performance of Mutual Funds
  1. Understand the classification of mutual fund schemes
  2. Understand the concepts of Entry Load and Exit Load and their application in calculating the Net Asset Value (NAV)
  3. Understand the calculation of returns for an investor investing in mutual fund schemes
  4. Understand the concept of risk in a mutual fund investment
  5. Understand the measures of risk adjusted return
  6. Understand the concept of benchmark for some of the mutual fund schemes
(—)
Mutual Funds Taxation
  1. Understand the different types of taxes associated with mutual fund schemes
  2. Select different schemes of mutual funds based on their tax implication
(—)
Investment Services
  1. Describe the mutual fund investment plans
  2. Understand the systematic transaction processes
  3. Describe the contents and periodicity of Statement of Account (SoA) and Consolidated Account Statement (CAS) to the investor
  4. Explain the process for nomination and pledge
  5. List investor services and facilities offered by AMCs
(—)
Asset Classes
  1. Understand the objective behind investing in different asset classes through mutual funds
(—)
The Rules of the Workplace
  1. Understand the basics of Financial Planning
  2. Relate financial planning to financial goals and the time horizon for their achievement
  3. Relate Financial Goals with Investment Requirements
(—)
Helping Investors with Financial Planning
  1. Understand the steps of financial planning
  2. Know various stages of Life Cycle and investment needs
  3. Know various stages of Wealth Cycle and investment needs
  4. Understand the importance of risk profiling
  5. Understand financial planning with the help of model portfolios
  6. Understand the important parameters for selecting mutual fund schemes
  7. Understand taxation and liquidity aspects while selecting growth and dividend option within a mutual fund scheme
  8. Identify the sources of data to track mutual fund performance
(—)

List of Suggested Books​​

  1. Study Material prepared by NISM for NISM – Mutual Fund Module
Digital Marketing Credits
2

Pre-Requisites​​

  1. Students should have knowledge of online marketing fundamentals and advertising via online media such as print, digital, internet marketing

Objectives​​

The main objective of this course to make participants understand the online business models and digital marketing methodology from the point of view of consumers, entrepreneurs. Moreover, the course aims at understanding the student’s different techniques of digital marketing so that they can utilize this technique to support organization’s marketing activities

Learning Outcomes​​

On successful completion of the course, the students will be able to:

  1. Different techniques of promotion on online platforms
  2. Internet marketing communication techniques
  3. Interpret the traditional marketing mix within the context of a changing and extended range of digital strategies and tactics.
  4. Comprehend the importance of conversion and working with digital relationship marketing

Detail Contents

S.No. TOPIC DESCRIPTION MODULE DURATION
Introduction Digital Marketing Evolution, Consumer Behavior, STP, E-Marketing Mix, Content of Digital Marketing Theory 5 Hours
Google My Business Introduction, Create business, Profile generation, creation of website, promotion, keyword selection Theory+Practical 5 Hours
Search Engine Optimization Introduction, On page SEO, Offpage SEO Theory+Practical 4 Hours
Content Writing Introduction, different forms of content writing skills Theory+Practical 1 Hours
Ads Marketing Facebook, Instagram, Google Ads Marketing Practical 5 Hours
Google Analytics Google Analytics, evaluating traffic, cost/ lead Theory+Practical 2 Hours
Blog/Videos Writing impactful blogs and video creation Theory+Practical 2 Hours
Website Building and Marketing WordPress, Shopify, HTML Theory+Practical 4 Hours
Website Building and Marketing WordPress, Shopify, HTML Theory+Practical 4 Hours
Freelancing/Job How to become a digital marketing freelancer and how to get jobs in the field of digital Marketing Theory 2 Hours

List of Suggested Books​​

  1. 1. Chaffey, D, Ellis-Chadwick, F, Johnston, K. and Mayer, R, (4th Ed.,2009) Internet Marketing: Strategy, Implementation and Practice, Third Edition, Pearson Education, New Delhi.
  2. Strauss, Judy and Frost, Raymond (6th Ed, 2011), E-Marketing, 5th Edition, PHI Learning, New Delhi.
  3. Roberts, M, L,.(3rd Ed, 2013) Internet Marketing, 1st Indian Edition, Cengage Learning, New Delhi
  4. Shainash G, and Jagdish N Sheth (1st Ed, 2008). Customer Relationship Management- A Strategic Perspective, Macmillan India Ltd
Skip to content