Word | Excel | PowerPoint | OneDrive  

Unit 1: 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

Mentoring Day

Unit 2: Attitude

Factors influencing attitude | Influence of perspective on behaviour | KSA – Knowledge skills and attitude

Personal social and professional etiquette.

Unit 3 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 | Teamwork | Networking | Importance of teamwork | Teamwork activity | Leadership qualities

Importance of decision making | Weighing positives and negatives | Process and practical way of decision making.

Unit 4 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

Unit 5: Creativity

Need for Creativity in the 21st century | Thinking out of the box | Creative thinking and Lateral Thinking

Torrance test of creative thinking | Creative challenges and activities.

Unit 6: 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

Introduction to Excel

     Introduction to Excel 365 | Editing sheet | Formatting | Project1

Worksheet view

     Viewing worksheet | Filling series | Flash fill

Conditional formatting | Data validation

     Conditional formatting- new rule | Data validation

Lookup and cell reference


Important functions in Excel

     Remove duplicate values | Hyperlink | Important functions in excel

Logical operations | sum and count functions

     Logical functions | sum | sumif | sumifs | count | countif | countifs

Working with formulas

     Statistical functions and mathematical functions | Date related functions

Text functions

     Text functions in excel | Match and index functions

Database functions and subtotal functions

     Dsum | dcount | Subtotal functions

Classic pivot table and chart

     Chart element | Pivot table and pivot chart

Data extraction

     Filter and advanced filter

Graphics and insert object function

     Custom view | Graphics | Insert object

Print area setup

     Header and footer | Print area setup | Text to column function

Important tools in excel

Form data | Auditing tool | Web data

Goal seak | Solver | Scenario manager

Speak cell | Camera tool | Sparkline chart

People graph | Data forecast | Import text file

Mail merge | Consolidating data

Macro | Password protection

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


     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 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


Accounting Introduction | Terms | Expenditures 

   Introduction to accounting | Basic accounting terms | Expenditures and Their Types

Accounting Concepts 

  Accounting concepts | Different Accounting Concepts

Accounting Rules

  Types of Accounts | Traditional and Modern Rules of Accounting 


   Preparation of Journal | Journal Entry Test (JET) 

Ledger & Cash Book

   Ledger | Ledger Posting and Balancing | Cash Book | Types of Cash Books

Trail balance, Adjustments

   Trail Balance | Format and preparation of trial balance | Adjustments 

Final accounts

   Preparation of Final accounts

Introduction to Tally Prime 

   Installing Tally | Tally Introduction | Types of License in Tally Prime | Activation & Deactivation of License | Work in Education Mode

Company Creation

   Company Creation | Alteration| Shut Company | Select Company | Delete Company | Company Features | Company Configuration | Ledger Creation | Alteration | Display | Delete(Single & Multiple) | Navigation(top,right) | Swich to | Go to

Chart of Accounts

   Introduction to Chart of Accounts| Master Creation- Ledger | Group- Both Single and Multiple – Deletion | Alteration

Inventory Master

   Creation- Alteration – Deletion Of -Inventory Group | Inventory Category | Unit | Stock Item | Location | Sub Group | Sub Category 


Vouchers- Recording and Maintaining Accounting Transactions

   Voucher | Voucher Creation

Bill Wise Allocation & Practice Question Including All

Completed Portions

   Bill Wise Allocation of Sundry Debtors and Sundry Creditors


   Banking – Cheque Printing| Deposit Slip Printing | Bank Payments | Payment Advice | BRS- Manual and Auto

Reports Generation

   Generating reports in tally | MIS Reports Generation

Data Security

   Data Security- Backup | Restore | Activation of Security Control in Tally | Creation of Security Levels | Creation of Passwords for Company | Activation of Company Vault | Auto Login




Inventory Storage | Maintaining Batch

   Storage and classification of inventory ( Godown transfer and management) | maintain batch-wise details

Price level

   Price List | Practice

Additional Features In Tally Prime | Voucher Class Settings

   Credit Limit | Zero Value Voucher | Actual and Billed Quantity Column | Separate Discount Column | Additional Cost of Purchase | Sales Invoice Logo | Banking Details in Invoice | Voucher Class Settings

Purchase Order -Quotation | Re-order level

   Purchase Order Processing | Re-Order Level

Sales order- proforma invoice

   Sales Order Processing | Proforma Invoice

Cost centre | profit centre management

   Cost centre | Pre-Defined Cost Centre | Profit Centre Management

Budget & scenario | sales invoice numbering


Debtors – creditors’ interest calculation


Non-accounting vouchers and generating | printing reports | forex conversion

Full portion practice day 




GST introduction 

   Introduction of GST | GST Components | GST rates 

Activating GST in Company

   Activating GST in Tally Prime, GST master creation, inward and outward supply of goods / local and interstate GST reports 

GST Purchase and Sales of Goods & Service

   Purchase and sales of goods and services & practice

ITC and GST payments  

  ITC in Tally | GST Payments | Practice



Live projects


Basic concepts | Supply | Composition scheme | Forward charge and reverse charge Mechanism | Time of supply | Place of supply | Value of collection | Input tax credit | General Procedures | E way bill | GST accounting and GSTin | GST using tally | GST online

Debtors’ creditor’s Reconciliation | Projected balance sheet and P & L a/c | Branch Accounting | Hospital Accounting | Educational Institute Accounting | Exporting & Importing Company Accounting | TCS | Payroll Accounting | Franchise Accounting | Company Board Corporation Accounting | Transporting Agency Accounting | E commerce Accounting | Hotel Accounting | IT Company Accounting | Accounts Finalisation using Tally

Basic Concepts

     Income-tax law: An introduction | Important definitions in the Income-tax Act, 1961 | Concept of the previous year and assessment year | Basis of Charge and Rates of Tax

Residential status and scope of Total Income

     Residential status | Scope of Total Income

Incomes which do not form part of total income (other than charitable trusts and institutions, political parties and electoral trusts)

     Incomes not included in total income | Tax holiday for newly established units in Special Economic Zones

Heads of Income and the provisions governing computation of income under different heads

     Salaries | Income from house property | Profits and gains of business or profession | Capital gains | Income from other sources

Income of other persons included in assessee’s Total Income

     Clubbing of Income: An introduction | Transfer of Income without transfer of assets |

     Income arising from revocable transfer of assets | Clubbing of Income arising to spouse | Minor child and son’s wife in some instances

Aggregation of Income; Set-off, or carry forward and set off of losses

     Collection of income | Concept of set-off and bring forward and set-off of losses | Provisions governing set-off and carry on and set-off of losses under different heads of payment | Order of set-off of losses

Deductions from total gross Income

     General provisions | Deductions in respect of certain payments | Specific deductions in respect of certain income | Deductions in respect of other income | Other deductions

Computation of Total Income and tax liability of individuals

     Income to be considered while computing the total income of individuals | Procedure for calculation of total income and tax liability of individuals

Advance tax, tax deduction at source and introduction to tax collection at source

Provisions for filing return of Income and self-assessment

     Return of Income | Compulsory filing of return of income | Fee and Interest for default in furnishing return of income | Return of loss | Provisions relating to belated Return, revised Return etc | Permanent account number | Persons authorized to verify Return of income | Self-assessment | ITR 1 Return filing (Registration & Return filing) | DT

TDS | Basic Concepts & Important Sections

SAP Introduction

     ERP | SAP SE | SAP partners | ASAP | T-code

Organisational Elements

     Define Company | Company Code | Business Area

Define Chart of Account & Account Group

     COA Meaning | Company Accounts

Define retained earnings | Fiscal Year variant | Posting Period Variant

     Setting year for the Company code

Define Field Status Variant | Tolerance Group

     TG for the GL Account | Employee | Assignment

Define Document type for GL Account & Ledger Creation

     Define Document Type SA for GL Account | Creation of ledger

Parking the Document | Reverse Document | GL Account Adjustment

     Reverse Document | GL Account Adjustment

AP Process

     Vendor Creation | Posting Purchase Entry | Outgoing Payment

AR process

     Customer Creation | Sales Entry Posting

Credit Memo AP

     Credit Memo with Clearing Entry

Credit Memo AR

     Credit Memo with Clearing Entry

Advance Payment in AP Process

Advance Receipt in AR Process


Define Dunning area | Define Dunning Procedure |

House Bank Creation

     Automatic Payment Process | Cheque Management


     Define Controlling Area | Number Range Settings for the controlling Area | Maintain version | Cost Centre Creation

Asset Management

     Define Depreciation Area | Define Asset Class | Asset Creation | Asset Posting


Configuration for GS

Cash Journal Preparation

SAP Introduction

     ERP|SAP SE|SAP partners|ASAP| T-code

Enterprise Structure

     Defining Organizational Units

Define Company

     Define Company Code

Define Controlling Area

     Define Plant

Valuation Area

     Define Storage Location

Assigning Organizational Units

     Assign company code to the company

Assign company code to controlling area

     Assign plant to company code

Assign purchasing organization to co-code

     Assign purchasing organization to plant

Master Data-Material Master data


Material Master

Material Type

Material Group

     Material Class

Master Data: Vendor

     Vendor|Vendor Master|Vendor Master Record|Vendor Account|Vendor Account Group

Procurement Cycle

     IMG setting for Purchasing Requisition| Purchase Info Record – IMG settings

IMG settings – Purchase Orders

     Goods Receipt (GR)| Entering of Invoice (in MIRO)


Introduction to GCC VAT Supplies under UAE VAT Federal Tax Authority Tax payable Types of registrations under VAT Reverse charge mechanism Types of transactions under VAT Penalties Maintenance of accounts GCC VAT in Tally Prime VAT reports generation using  Tally Prime

  • Daily attendance record in excel
  • Income& Expense tracker in Excel
  • Automatic inventory control application in Excel
  • Invoice preparation in Excel
  • Salary slip automation in Excel
  • Student report card in Excel
  • Mobile installment scheme in Excel
  • Visitors’ entry register in Excel
  • Students’ admission form in Excel
  • Attendance tracker in Excel ( Employees)

Unit I:  Speaking

Rate my language-I | Common speaking issues and tips | Verbal and Non-Verbal Communications | Effective use of body language | Let’s 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

Unit 2:  Reading

Importance of reading | reading practice I | Assessment

Reading Practice II | Assessment

Reading Practice III | Assessment

Unit 3 Writing

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

Unit 4 Listening

Importance of Listening | Listening practice I | Assessment

Listening practice II | Assessment

Listening practice III | Assessment

Summing up life skills qualities
Email- Business Communication
Professional profiles in digital platforms
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