Self Analysis

     Introduction to module | Ice breaking | Who am I- Make a note | SA: questionnaires | SWOT analysis | Detailed Self-introspection | Johari window – Self-awareness | self-confidence

Attitude

     Factors influencing attitude | Influence of attitude on behaviour | KSA – Knowledge skills and attitude | Personal social and professional etiquette.

Interpersonal skills

     Need for interpersonal skills | Gratitude | Being thankful | Understanding anger and ways to deal with it | Secret of happiness | Morals | Values and Ethics | Integrity | Work Ethics | Civic Virtue | Respect for Others | Living Peacefully | Caring | Sharing | Honesty | Courage | Valuing Time| Cooperation| Commitment | Empathy |Team Work | Networking | Importance of teamwork | Teamwork activity | Leadership qualities | Importance of decision making | Weighing positives and negatives | Process and practical way of decision making.

Stress Management and Motivation

     Stress Management: Stress | Reasons and effects | Identifying stress | Stress diaries | The four A’s of stress management | Techniques | Approaches: action-oriented | Emotion-oriented | Acceptance oriented | Resilience | Gratitude Training | Coping with emotions: Identifying and managing emotions | Harmful ways of dealing with emotions | Relaxation techniques | Self-Motivation | Factors | Self-motivation methods and activities | Tapping and tuning inner voice

Creativity

     Need for Creativity in the 21st century | Thinking out of the box | Creative and Lateral Thinking | Torrance test of creative thinking | Creative challenges and activities.

Goal setting

     Wish list | SMART goals | Short | long | lifetime goals | Blueprint for success | 5W1H | Time management | Value of time | Test your Time management skill Weekly planner | TODO list | Prioritizing work | Time management matrix | Psychometric tests

Speaking

     Rate my language-I | Common speaking issues and tips | Verbal and Non-Verbal Communications | Effective use of body language | Let us start Speaking | Tips for the beginners | Tests | Activity 1 – Group discussion | GD Assessment | Activity 2 – Talk for 2 min | Assessment | Activity 3 – Online/Offline face-to-face Speaking skills | Assessment

Reading

     Importance of reading | reading practice I | Assessment | Reading Practice II | Assessment | Reading Practice III | Assessment

Writing

     Rate my skill – I | Beginner’s activity | Rate my skill – I | Beginner’s activity | Technical Writing: Differences between technical and literary style | Elements of style; Common Errors | Letter Writing: Formal | Informal and demi-official letters; business letters | Job Application: Cover letter | Differences between biodata | CV and Resume | Rate my skill- II

Listening

     Importance of Listening | Listening practice I | Assessment | Listening practice II | Assessment | Listening practice III | Assessment

Preplacement Training

     Summing up life skills qualities | Email- Business Communication | Professional profiles in digital platforms | Grooming | What is a Structured Interview? Preliminary Preparation | Do’s & Don’ts of an Interview | Discussion of frequently asked questions in the interview | Real-world interviews examples | Personal Interview Assessment with constructive feedback

Introduction | Accounting terms

     Accounting | Event and transaction | Bookkeeping and accounting | Stakeholders in business | Important business terms

Capital and revenue transactions | Accounting principles

     Capital and revenue expenditure | Capital and revenue receipt | Accounting concepts and conventions | Double entry system of bookkeeping

Account | Traditional and modern rules

     Account | Classification of account | Debit and credit | Traditional and modern rules relating to accounts

Journal

     What is journal | Journal preparation

Ledger | Trail balance

     What is ledger | Ledger posting | Ledger balancing

Cash book and its types

    Types of cash book and discount

Bank reconciliation statement

Depreciation

     Depreciation and its causes | Needs for charging depreciation | Factors considered for depreciation | depreciation methods.

Inventory valuation

     FIFO | LIFO

Trail balance

     Trail balance preparation

Trading and profit and loss account

     Trading account and its preparation | Profit and loss account and its preparation

Yearend adjustment entries

     Adjustments regarding final accounts

Balance sheet

     Preparation of balance sheet | Problems with final accounts

  1. Introduction to Excel 365
  2. Editing sheet | Formatting | Project1
  3. Worksheet view
  4. Viewing worksheet | Filling series | Flash fill
  5. Conditional formatting | Data validation
  6. Conditional formatting- new rule | Data validation
  7. Lookup and cell reference
  8. FILTER, UNIQUE, SORT, SORTBY, SEQUENCE, RANDARRAY, XMATCH, and XLOOKUP.
  9. Important functions in Excel
  10. Remove duplicate values | Hyperlink | Important functions in excel
  11. Logical operations | sum and count functions
  12. Logical functions | sum | sumif | sumifs | count | countif | countifs
  13. Working with formulas
  14. Statistical functions and mathematical functions | Date related functions
  15. Text functions
  16. Text functions in excel | Match and index functions
  17. Database functions and subtotal functions
  18. Dsum | dcount | Subtotal functions
  19. Classic pivot table and chart
  20. Chart element | Pivot table and pivot chart
  21. Data extraction
  22. Filter and advanced filter
  23. Graphics and insert object function
  24. Custom view | Graphics | Insert object
  25. Print area setup
  26. Header and footer | Print area setup | Text to column function
  27. Important tools in excel
  28. Form data | Auditing tool | Web data
  29. Goal seak | Solver | Scenario manager
  30. Speak cell | Camera tool | Sparkline chart
  31. People graph | Data forecast | Import text file
  32. Mail merge | Consolidating data
  33. Macro | Password protection