Service Entrepreneurship and Data Management with Excel
Track Service Management
Duration 120 hours
Skill Level Advanced
Language English

About this Course

Combine entrepreneurship with practical Excel-based tools for service business data tracking.
Learning Mode: Learn at ALC or at Home

Detailed Course Curriculum

Hands-on module breakdown aligned with MKCL production standards and industry requirements.

  • Role of Services in an Economy Introduction
  • The service sector
  • Facilitation role of services in an economy
  • Economic evolution
  • Development and structure of services sector GDP in India
  • Sectoral growth rate
  • Remarkable growth observation in India’s service sector –an  international comparison
  • Sectoral Composition of GDP Growth
  • Contribution of services sub-sectors to India’s GDP
  • Reasons for the growth of Services in India
  • Employment in the services sector
  • Indian service sector
  • Service sector in India: some issues & challenges
  • Prospects for Growth in the Services Sector
  • Role of Services in an Economy Introduction
  • Hunting-and-Gathering Societies
  • Horticultural and Pastoral Societies
  • Agricultural Societies
  • Preindustrial Society
  • Features Of Pre-Industrial Society
  • Transport Therefore Primitive
  • Industrial Society
  • Industrialisation in India
  • Post-industrial Society
  • Comparison of Societies
  • Theories Explaining the Growth of Services
  • Nature of Service Sector Introduction
  • Nature of the Service Sector
  • The Role of the Service Economy in Development
  • The Defining Characteristics of a service
  • Classification of Service
  • Trivia Time
  • White and Blue Collared Workers & The working class
  • Technology Spawns Workplace Change
  • The Twenty-first Century Career
  • Nature of Service Sector Introduction
  • The Twenty-first Century Career
  • The Experience Economy
  • The Business that sells an Experience
  • Consumer Service Experience
  • Business Service Experience
  • Service Dominant Logic
  • Foundation Premises of Service Dominant Logic
  • Fundamental principles in detail
  • Distinctive Characteristics of Service Operations
  • Customer Participation
  • Simultaneity
  • Perishability
  • Intangibility
  • Heterogeneity
  • Non-transferrable Ownership
  • Service Package
  • Supporting Facility
  • Facilitating Goods
  • Information and Data
  • Explicit Service
  • Implicit Services
  • Grouping Services by Delivery Process
  • Low Labour Intensity
  • High Labour Intensity
  • Low Interaction & Customization
  • High Interaction & Customization
  • Open System View of Service Operations Management
  • Roles in Service Sector Introduction
  • Ways of Identifying Service
  • Consequences of Rapid Growth of Services
  • How recession affects service
  • Human resources in the age of Service
  • Human resources in the age of Service continue
  • Outsourcing
  • Roles in Service Sector
  • The Trade Sector
  • The Tourism Sector
  • The Shipping Sector
  • The Port Services Sector
  • The Storage Services Sector
  • The Telecom Sector
  • The Real Estate Sector
  • The IT Sector
  • The Accounting Sector
  • The Research and Development Sector
  • The Legal Sector
  • The Consultancy Sector
  • The Construction Sector
  • Service Functions
  • IT Operation Management
  • Service Desk - Internal and External
  • Technical Management
  • Applications Management
  • Reporting
  • Functions of the Service Desk
  • Functions in the Service Sector an Interaction
  • Human Resources
  • HRD and HRM as functions of Human Resources
  • Competitive Advantage
  • Competencies, Culture, and Composition
  • Differences in HRD between manufacturing sector and service  sector
  • Human Resource Planning
  • Selection and Recruitment
  • Training and Development of Employees
  • Performance Management
  • Overall Welfare of Employees
  • Information Sharing
  • Survey Management
  • Compliance Management
  • HR Technology Management
  • Change Management
  • Processes in Service Sector Introduction
  • What is a Service Process
  • Characteristics of Service Processes
  • Steps of Managing a Service Process
  • Elements of a Service Delivery System
  • Types of Service Processes
  • Degree or Level of Contact
  • Differences between Service Industry Processes vs
  • Manufacturing/Product-based processes
  • Service Sector in India
  • The IT and Fintech Sector
  • The Travel and Tourism Sector
  • The Media and Entertainment Industry
  • The Logistics Industry
  • Upcoming Trends in the Service Sector
  • Career Path in the Service Sector
  • Classification of Services
  • The Service Sector in the Three-Part Economy
  • Employment Scenario
  • Service process
  • Line operations
  • Job Shop Operations
  • Degree of Contact
  • Service Offering cred fintech
  • Developing and Maintaining the Service Process 1
  • Developing and Maintaining the Service Process 2
  • Service Process
  • The 7 Step Process for Managing Service Processes
  • Delivering excellent service
  • Service Operation Functions
  • Service Process
  • Characteristics of service processes
  • Service Location
  • Customer Participation and Interaction
  • Steps for managing service processes
  • New and Upcoming Sectors: Processes in Service Sector  Introduction
  • Challenges in designing a process
  • Phases of service process
  • Improvement techniques for service industries
  • Cost of delay of service processes
  • What is Service Design by Yosef Shuman
  • Village Volvo
  • Xpresso Lube
  • Walmart
  • Air Deccan
  • OYO Hotels
  • Cloud Kitchens
  • Telecom industry
  • MyGate Application
  • New Age Applications
  • New Age Applications- 2
  • New Age Applications- 3
  • Types of service sectors in India
  • Differentiators of the service sector in India
  • Challenges faced by the service sector in India
  • Service Sector in India
  • Opportunities for the Service Sector in India
  • Advantages of the Service Sector in India
  • What’s New in Services
  • Opportunity Recognition & The Opportunity Assessment Plan
  • Nature of International Entrepreneurship
  • Importance of International Business to the Firm
  • Motivations to Go Global
  • Available Distribution System
  • Strategic Effects of Going Global
  • Foreign Market Selection
  • Entrepreneurial Entry Strategies
  • Entrepreneurial Partnering
  • Implications for the Global Entrepreneur
  • Information Sources
  • International Vs Domestic Business (PESTEL Analysis)
  • Culture
  • Aspects of International Trade
  • The nature of entrepreneurship
  • Entrepreneur background and characteristics
  • Sustainable entrepreneurship
  • Reliance Story
  • Corporate entrepreneurship
  • Managerial versus entrepreneurial decision making
  • Establishing a culture for corporate entrepreneurship
  • Leadership characteristics of corporate entrepreneurs
  • Learning from failure
  • From Opportunity to Business Plan
  • How to Identify an Opportunity
  • Business Opportunity Evaluation
  • New Entry Generation
  • Competitive Advantages in New Entry Opportunity
  • Assessing Attractiveness of Opportunity
  • First Mover Advantages
  • Risk Reduction Strategies
  • Stages of a New Business
  • Concept Stage
  • Product Development Stage
  • Sources of New Ideas
  • Methods of Generating Ideas
  • Does R&D Spending Correlate to Being the Most innovative
  • Trust in Business
  • Trend
  • Important Elements of Business Development
  • Creative Problem Solving
  • Innovation
  • Defining a New Innovation (Product or Service)
  • Classification of New Products or Services
  • Evaluation Criteria
  • E-Commerce
  • What is Skill India initiative?
  • Micro Enterprises
  • MUDRA
  • Roles and Responsibilities of MUDRA
  • Atal Innovation Mission (AIM)
  • Start Up India Initiative
  • Startup India Seed Fund Scheme
  • Aspire - Small Business Ideas for Rural Areas in India
  • Dairy Entrepreneurship Development Scheme (DEDS)
  • Venture Capital Assistance Scheme
  • The Software Technology Park (STP) scheme
  • Micro, Small and Medium Enterprises Development
  • Micro, Small and Medium Enterprises Development - Continue
  • What Is Credit Guarantee?
  • Showcasing
  • Objectives of IREDA
  • Information technology
  • State Govt.mechanisms
  • ESDM Under the scheme
  • Introduction - Continue
  • The 4 Types of Entrepreneurships
  • Success Strategies for Entrepreneurs
  • Strategies for Personal Growth as an Entrepreneur
  • Strategies for Personal Growth as an Entrepreneur
  • Six Entrepreneurial and business growth strategy examples
  • Franchising
  • Franchising
  • Types of Franchisees
  • Joint Ventures
  • Economies of Scale
  • Merger or Acquisition
  • Pros of mergers
  • Cons of mergers
  • Reasons that Cause Failure of Mergers and Acquisitions
  • What is a vision statement?
  • Vision statement
  • Why does a company have to have a vision?
  • Dual Components of the Company Vision
  • Envisioned Future
  • Vision statement sound mystical
  • Developing a company vision Introduction
  • Know your Goals
  • Consider your company’s values
  • Build upon your mission statement
  • Keep it simple and straightforward
  • Keep it Definitive
  • Be forward thinking
  • Establish timeframes
  • Just write your vision statement!
  • How To Use & Communicate Your Vision
  • Measure Progress Toward Your Vision
  • Vision statement templates and resources
  • Visions Don’t Need to Be Set in Stone
  • Interview- Marker Movement Introduction
  • Tell me something about yourself?
  • Tell me little more about your Business?
  • What’s your enterprise called?
  • Can you elaborate entire cycle?
  • How you decide pricing?
  • What is your entire routine?
  • Can you tell me how try to optimize the pricing and time that you  have?
  • How the ideation Process?
  • What is your experience from multiple vendors?
  • Can you take me through the pros and pain points of your business
  • What is your Special experience in Party?
  • Can you give some advice entrepreneur?
  • Cases on New Service Development
  • Cases on the Service Encounter Triad
  • Cases on Supporting Facility & Process Flows
  • Basics of Computer Typing
  • Basics of Data Entry and various formats
  • Different Avenues of Computer Typing & Data Entry
  • Career opportunities in the world of Data Entry
  • Let’s Type Something
  • Please type displayed paragraph
  • Few Questions related to typing
  • Why Learn Typing?
  • What is Keyboarding?
  • Need for Typing
  • Typewriters To Computers
  • Types of keyboards
  • Ergonomic Keyboards
  • PDA Keyboards
  • Keyboard Layout
  • QWERTY Keyboard
  • Data Entry
  • What is Touch Typing?
  • What is Muscle Memory?
  • Names of Fingers
  • Finger Placements
  • Practice Makes Perfect
  • Minimise Hand Movements
  • How to Measure Progress?
  • Correct Posture
  • The Space Bar
  • The Enter Key
  • Learning the G and H Keys
  • Learning the Apostrophe Key
  • Using Keys
  • Learning the E and I Keys
  • Learning the W and O Keys
  • Learning the Q and Y Keys
  • Learning the P and T Keys
  • Using Keys
  • Learning the C and Comma Keys
  • Learning the X and Period Keys
  • Learning the Z and Slash Keys
  • Learning the B and N Keys
  • Learning the Tab Key
  • Using Keys
  • Typing Tips
  • Typing Tips
  • Using Number Keys – 1 to 5
  • Using Number Keys – 6 to 9 and zero
  • Learning the Square Brackets and Back Slash Keys
  • Typing Tips
  • Learning the Minus, Equals and Grave Accent Keys
  • Touch Typing on the Number Pad
  • Num Pad Home Row Positions
  • Index Finger Keys
  • Typing Tips
  • Middle Finger Keys
  • Ring Finger Keys
  • Little Finger Keys
  • Google Docs
  • Adobe PageMaker
  • CorelDRAW
  • Adobe InDesign
  • Microsoft Word
  • Microsoft Excel
  • Open Office Calc
  • Open Office Writer
  • Undoing and Redoing
  • Editing Modes
  • Need for Data Conversion
  • Skills Required for Data Entry
  • Types of Data Entry Jobs
  • Data Entry Jobs in Industrial Sector
  • Data Entry Jobs in Medical Sector
  • Related Jobs
  • Types of Data
  • Data Validation
  • Data Categories
  • Data Correctness
  • Compiling Data
  • Data Entry Tools
  • Scanning
  • OCR
  • Data Conversion for the Web
  • Other Conversions
  • Data Entry Pay Scales
  • Factors affecting Pay Scale
  • Legal Documents
  • Other Documents
  • Medical Transcription
  • Stamp Papers
  • Bank Documents
  • KYC Details
  • Loan Applications
  • Form Entries
  • Publications
  • Types of Typists
  • Google Docs - Voice Typing
  • Introduction to Functions, Common Types of Arguments, Parts of Functions
  • Advanced Aspects of Functions, Searching for a Function
  • Using the Functions
  • Using the SUM and AVERAGE Functions
  • Using the IF Function
  • Analysing the IF Function
  • Using the OR Function
  • Using the AND Function
  • Using the OR Operator Function
  • Nesting the IF Statement
  • Analysing the Nested IF Function
  • Using the NOT Function
  • Using the SUMIF Function
  • Using the SUMIFS Function
  • Using the AVERAGE and MEAN Functions
  • Using the MODE Function
  • Using the MEDIAN Function
  • Area and Volume Calculations
  • Rounding Decimal Places
  • MOD and INT Functions and Uses
  • Using the Random Function
  • Using the RANDBETWEEN Function
  • EMI Calculations
  • Calculating Monthly Instalment and Interest
  • Calculating Principal Amount
  • Calculating Balance Amount
  • Using PV Function
  • Using FV Function
  • The CHOOSE Function
  • Using the MATCH Function
  • Using the INDEX Function
  • Using the MATCH and INDEX Functions Working Together
  • The CELL Function and Determining File or Sheet Names
  • Using the ISBLANK Function
  • Error Checking Using the ISERROR Function
  • Error Checking Using the IFERROR Function
  • OFFSET Function: Display the Value in Cell
  • OFFSET Function: Calculating a SUM
  • OFFSET Function: Creating a Dynamic Named Range
  • Using the INDIRECT Function
  • INDIRECT Function to Build Dynamic Formulas
  • Using the LOOKUP Function
  • Using the VLOOKUP Function
  • Using the HLOOKUP Function
  • VLOOKUP in Live Action
  • Lookups Nested Within Lookups
  • Working with Date and Time in Excel
  • Using the YEAR, MONTH, DAY, HOUR, MINUTE AND SECOND Functions
  • Calculation Between Two Dates
  • Calculating Person’s Age Using Excel
  • Using Functions to Serialize Date
  • Using the TIMEVALUE Function
  • LEFT: Text Manipulation
  • RIGHT: Text Manipulation
  • LEN: String Extractions
  • TRIM: String Extractions
  • Changing Case Function
  • CONCATENATE: Building Strings From Multiple Cells
  • REPLACE and SUBSTITUTE: Two More String Manipulation Function
  • Using the FIND and MID Text Functions
  • FIND and MID: Text Functions Working Together
  • Formatting Numeric and Date Values Using TEXT
  • IF ARRAY Formulas
  • Transpose-Shift
  • What-If Analysis Tools
  • Using Goal Seek
  • What are Scenarios?
  • Possible Scenarios
  • Naming Cells
  • Creating a Scenario
  • Second Scenario
  • Third Scenario
  • Viewing a Scenario
  • Quick Access to Scenarios
  • Merging Scenarios
  • Other Scenarios
  • Merging Process
  • The Merge Scenarios Window
  • Types of Scenario Summaries
  • Creating Scenario Summary
  • Understanding Scenario Summary
  • Creating Scenario PivotTable Report
  • Modifying Scenario PivotTable Report
Eligibility Criteria
• Basic knowledge of computers and keen desire to build skills in this field.
• Open to students, job seekers, and working professionals.
Official Certification
• Official MKCL KLiC Certificate upon successful completion of the course and evaluations.
Work-Centric Learning Approach
• Step 1: Learners are given an overview of the course and its connection to life and work
• Step 2: Learners are exposed to the specific tool(s) used in the course through the various real-life applications of the tool(s).
• Step 3: Learners are acquainted with the careers and the hierarchy of roles they can perform at workplaces after attaining increasing levels of mastery over the tool(s).
• Step 4: Learners are acquainted with the architecture of the tool or tool map so as to appreciate various parts of the tool, their functions, utility and inter-relations.
• Step 5: Learners are exposed to simple application development methodology by using the tool at the beginner’s level.
• Step 6: Learners perform the differential skills related to the use of the tool to improve the given ready-made industry-standard outputs.
• Step 7: Learners are engaged in appreciation of real-life case studies developed by the experts.
• Step 8: Learners are encouraged to proceed from appreciation to imitation of the experts.
• Step 9: After the imitation experience, they are required to improve the expert’s outputs so that they proceed from mere imitation to emulation.
• Step 10: Emulation is taken a level further from working with differential skills towards the visualization and creation of a complete output according to the requirements provided. (Long Assignments)
• Step 11: Understanding the requirements, communicating one’s own thoughts and presenting are important skills required in facing an interview for securing a work order/job. For instilling these skills, learners are presented with various subject-specific technical as well as HR-oriented questions and encouraged to answer them.
• Step 12: Finally, they develop the integral skills involving optimal methods and best practices to produce useful outputs right from scratch, publish them in their ePortfolio and thereby proceed from emulation to self-expression, from self-expression to self-confidence and from self-confidence to self-reliance and self-esteem!

Ready to start Service Entrepreneurship and Data Management with Excel?

Join our upcoming batch at ZICA Kalyani center with certified instructors.