Logical Functions, Data Management:- 

Data Collection Method With Data Quality, Collaboration and Security Like Share Your Workbook On Share Drive With Quality


Single/Multidimensional Analysis, Like Three Dimensional (3D) Tables Sensitive Analysis Like Data Table, Manual What-If Analysis, Threshold Values, Goal Seek, One-Variable Data Table


Lookup and Reference Functions:-

VLookup, HLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup


Mathematical Functions, Text Functions and Data Validation, Date & Time Functions:

Value Date, Day, Month, Year, Edate, Eomonth, Networkdays, Workday, Weeknum, Weekday, Hour, Minute, Second, Now, Today, Time.


Advanced Chart, Graph and Dashboard:- 

Advanced Chart Technique, How To Make Dynamic Charts, Bar Charts, Pie Charts, Scatter Chart, Line Chart, Column Chart, Speedometer Chart, Gantt Chart, Two-Variable Data Table


Advanced Filter, Validation and Pivot Table:- Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/Font Color), Conditional Formatting, Data Validation, Group and Ungroup, Data Split.


Pivot Table and Charts:- Import and Export data, Protect/Unprotect sheets/workbooks. Worksheet formatting and Print Display


  • GST  accounting considering Intrastate supplies , Interstate supplies of goods & services

  • Accounting of different forms of organizations (sole proprietorship firm , Partnership firm & other than companies)

  • Opening and closing entries accounts

  • Detail study of depreciation under Income Tax act, 1961

  • Practical demo on linking skill of cells in Excel and preparation Financial Statement on multi excel sheet with its other component.



  • Introducing Gateway and its elements

  • Creation of Company

  • Fundamentals of Tally Prime

  • Create Accounting Masters in Tally Prime

  • Financial Statements and Accounting Books and Reports

Tally Prime and Inventory Management
  • Creating Inventory Masters in Tally Prime

  • Inventory Vouchers

  • Generating Inventory Books and Reports

  • Introducing BOM – Bill of Materials

  • Accounting with Inventory

Production and Stock Management through Tally Prime

  • Multiple Price Level

  • Batch – wise Details

  • Bill of Materials (BoM)

  • Price Levels and Price Lists

  • Stock Valuation

  • Zero Valued Entries

  • Job Costing, Job Order Processing

Payroll Management in Tally Prime

  • Generation of Employee Database

  • Salary Structure

  • Calculation Attendance and Leave Details

  • Salary Slip Generation

  • PF, ESI, Gratuity Bonus

  • Professional Tax

  • Various Payroll Reports

Tally Prime and GST Compliance
  • Activating GST for Your Company

  • Setting Up GST Rates

  • Updating Stock Items and Stock Groups for GST Compliance

  • Updating a Services Ledger for GST Compliance

  • Updating Sales and Purchase Ledgers for GST Compliance

  • Updating Party GSTIN

  • Creating GST Ledgers

  • Creating Income and Expense Ledgers

  • Recording Purchases & Sales and Printing Invoices

  • Recording a Tax Payment

  • Other Scenarios

  • Sales – Nil Rated, Exempt, SEZ, and Deemed Export

  • Recording Sales Returns & Purchase Returns

  • Debit Note & Credit Note

Cost Centres and Cost Categories
  • Cost Accumulation

  • Defined cost unit

  • Cost Management

  • Direct Cost Vs Indirect Cost

Budget and Controls

Multiple Currencies
  • Accounting inventory methods

  • Specific identification method.

  • Periodic and Perpetual Inventory Systems

  • Inventory Counting and Reconciliation

  • Overhead Allocation

  • Inventory Transactions

  • Inventory Controls

  • Inventory Budgeting

  • Inventory Measurements

  • Recall the classifications used for inventory.

  • Note the characteristics of the different types of inventory fraud.

  • Describe the situations in which inventory errors can lead to material misstatements.

  • Describe the substantive procedures used by an auditor to audit inventory.

  • Recognize the items to be reviewed as part of an inventory test count.

  • Note the actions to be taken when testing inventory costs.

  • Describe compilation testing.

  • Cite the circumstances under which a physical inventory count can be avoided.

  • Recall the details of the lower of cost or market rule.

  • Note the advantages of the various inventory costing methods.

  • Multi-location Stock Control

  • Comprehensive Recording of Stock Movement

  • Management Reports

  • Aging stock Analysis

  • Batch-wise or lot-wise Inventory with Expiry

  • Re-Order Levels

  • Stock categories

  • Multiple godowns

  • Stock transfers to Locations/godowns

Overview of Model GST Law
  • Overview of Indirect Taxes & GST

  • Important Definitions under GST

GST Migration and Registration under Model GST Law with GST Rules and Formats
  • Migration of Existing Dealer.

  • Registration Structure under GST.

  • Persons required to be registered.

  • Process of Registration.

  • Amendment & Cancellation of Registration.

  • Forms for GST Registration

  • GST REG-01- Application.

  • GST REG-02- Acknowledgement.

  • GST REG-06- Certificate.

  • REG-01 to REG-30

Returns under GST Section (37-48) with GST Rules and Formats
  • Definition and Important Notes to Return.

  • Types of Returns. (Annual Return, First Return, Regular Return)

  • Notice to Return Defaulters.

  • Levy of Late Fee.

  • Goods and Services Tax Practitioners

  • Various Return Form

  • GSTR-I, II ,III, 3B

Refunds – Section 54-58 with GST Rules
  • Refund of Tax (Section-54)

  • Refund in Certain Cases (Section-55)

  • Interest on Delayed Refunds (Section-56)

  • Consumer Welfare Fund (Section-57)

  • Utilization of Fund (section-58)

Input Tax Credit - Section 16-21 with GST Rules
  • Eligibility and Conditions for taking ITC (Section-16)

  • Block Credit (Section-17)

  • Availability of Credit in Special Cases (Section-18)

  • ITC for Job Work (Section-19)

  • ITC Distribution by ISD (section-20)

Job Work and Composition Levy in GST
  • Special Provision for Job Worker

  • Composition Levy Section 10

  • Quarterly Return for Compounding Taxable Person GSTR-4

Other Topics - with GST Rules and Formats
  • Payment of Tax, Interest, Penalty and other charges Section 49

  • Interest on delayed payment of tax Section 50

  • Tax Deduction at source Section 51

  • Tax Invoices Section 31

  • Time and Value of Supply Section (12-15) Chapter IV

  • Transitional Provisions Section (139-142) Chapter XX

  • Identify E-Way Bill Generation Scenarios Under GST

  • Identify -various movements which take place on daily basis

  • Sale, purchase – goods sent for repairs, job work, sales return, purchase return, imports and exports

  • Transactions with unregistered dealers etc.

  • Fix Responsibility For E-Way Bills

  • Agreements with business participants on roles/responsibilities

  • Updating E-Way Bill in case of change in conveyance


Refund under GST

GST payment on due date & Interest on late payment of GST
Annual Return - GSTR-9
  • Objective and Compliance of Annual Return

  • Difference Between GSTR-9, GSTR-9A, GSTR-9B and GSTR-9C

  • Who is required to file GSTR-9

  • Challenges in filing GSTR-9

  • How to meet those Challenges

  • Understanding of 6 Parts and 19 Tables of GSTR-9

  • Consequences of not filing GSTR-9

  • Preparation of GSTR-9 filing

  • Processing of GSTR-9 at Department and Post filing Scenario.



  • Person V/S Assesse

  • Advance Tax

  • Interest under section 234A/B/C

  • Gross Total Income and Its Components

  • Computation of Income from eligible business under presumptive basis U/S 44 AD, 44 ADA, 44 AF

  • Practical case study for filing various income tax returns u/s 44 AD, 44 ADA, 44 AE.


Computation of income from Salary

  • Basic Salary

  • Allowances (Exempted and Non Exempted)

  • Perquisites –(Valuation)

  • Practical case studies of filing various IT returns for salaried person



Computation of income from House Property

  • GAV

  • Municipal Taxes

  • NAV

  • Deduction u/s 24 (Statutory and Interest)

  • Practical case studies of filing various IT returns with income from House Property



Computation of income from Profit and Gains from Business Profession

  • Expenses Allowed and Expenses Disallowed

  • Depreciation and Additional depreciation

  • TDS Compliances and computation of business income

  • Expenses allowed on actual basis

  • Deemed income, Presumptive income

  • Set off and carry forward of Business Loss

  • Carry Forward of unabsorbed depreciation

  • Maintenance of Books of accounts, Audit of Books of accounts

  • Practical case studies of filing various IT returns under income from Business & Profession


Computation of income from Capital Gain

  • Charging Section

  • Intro To Capital Assets, Holding Period and Transfer

  • Full Value Consideration, Cost of Acquisition

  • Capital Gain on Transfer of Shares and Debentures

  • Rates of Taxes on Capital Gain

  • Exemption under section 54, Set off and Carry Forward of capital loss

  • Practical case studies of filing various IT returns under income from Capital Gain

Computation of income from Other Sources

  • Income liable under other Sources

  • Deduction Available

  • Practical case studies of filing various IT returns under income from other sources

Deduction on The Basis Of Payment

  • LIC,F.D, PPF, ELS, Tuition Fee, House Loan ,NPS, etc (Sec 80C/80CCC/80CCD/80CCE)

  • Medical Insurance (Sec 80 D)

  • Deduction under (80DD), (80 E), (80 EE), (80G), (Sec 80U)

  • Other Deductions with practical case studies


  • 2 ways to prepare Return and filing of Return

    • Filing of return through ITR Utility

    • Filing of Return through software

Compulsory maintenance of books of accounts & audit u/s 44 AA, 44 AB

Income Tax Return Preparation ITR-1, 2, 3, 4

Tax Deducted At Sources

  • Introduction to TDS

  • Related and other linked provision

  • Lower TDS

  • TDS on Salary (Sec 192), Interest (Sec 194A), Commission (Sec 194H), Professional Services (Sec 194J), Rent (Sec 194I), Contract (194C)

  • Section 195 to be read with Section 9 for Non Resident

  • Other provisions of TDS



  • Tax Planning by Understanding Your Pay slip

  • Objectives of Tax Planning

  • Types of Tax Planning

  • Results  of good tax planning




  • Broad holistic understanding of the Banking & Finance industry

  • Detailed knowledge about various banking products and services

  • Master the skills and techniques for selling banking and financial products

  • Analysis of the investment needs of customers and customize their portfolios

  • Tools and Techniques of Financial Analysis using Excel

  • How to manage customer relationships

  • How to work in retail banking, corporate investing, consulting, private equity, venture capitalism

  • Work as a Business Analyst, Finance & Insurance Manager, Business Risk Manager, Investment Banker or Finance Controller

  • Bank Risk Management/ Financial Risk Management

  • Banking Operations

  • Corporate Valuation

  • Financial Markets & Institutions

  • Financial Product Design

  • FOREX & Treasury Management

  • International Finance

  • Legal Aspects of Business

  • Microfinance & Developmental Banking

  • Securities Analysis & Portfolio Management



  • Overview of Insurance

  • Principles & Aspects of Insurance

  • Nature & purview of Insurance

  • Documentation & classification of Insurance

  • Financial aspects of Insurance

  • Introduction to underwriting & claims

  • Insurance agent’s role in providing great customer service

  • The proposal stage - Acceptance stage - The claim stage - Grievance Redressal

  • Integrated Grievance Management System (IGMS)

  • Legal aspects of an insurance



  • Learn how to resolve a range of business problems through this Microsoft Excel Training

  • Easily learn how to perform calculations using functions and formulas, creating data visualization and navigating user interface of MS Excel

  • A great opportunity to take your skills to new heights

  • Upgrade your skillset and handle sales/billing tasks easily

  • Help you to learn how to work multiple workbooks and worksheets

  • Unlock Excel shortcuts and secrets through these Basic Microsoft Excel Classes

  • Get familiar with powerful analytics formulas and tools for e.g. FILTERXML, WEBSERVICE, HYPERLINK and INDIRECT

  • You will learn how to handle time-consuming analytics tasks with ease.



  • An overview of Indian GAAP (Generally Accepted Accounting Principles) and Indian AS and its applicability on Finalization of accounts.

  • Analysis of Balance Sheet and its components as per Revised Schedule of Companies Act 2013.

  • Logical Process of preparing balance sheet on Excel of a company registered under companies Act.

  • Comparative Analysis of provisions of Depreciation in Income Tax Act and Companies Act.

  • Bank Reconciliation Statement and its importance for finalization.

  • Year End Adjustment entries, Deferred Tax.

  • Real World demo of Grouping of Heads of income and expenses through trial balance.

  • Financial Analysis (how to read the financial accounts of a Company – important ratio analysis)

  • Accounting operations, patterns, merger of public holding companies

  • Foreign currency operations, changing financial statement prepared in foreign and local currencies.

  • Advanced financial accounting issues such as lease contracts, pension funds, end of service severance payments etc.

  • Financial Reporting

  • Strategy And Governance

  • Management Accounting

  • Audit And Assurance

  • Finance

  • Taxation



  • Conceptualization

  • Forming the governing body

  • Formulation of bylaws

  • Registration of Society & Trust

  • Fundraising

  • Rules and regulations of the trust.

  • Documents required to be submitted

  • Charitable societies procedure

  • Processes of application

  • Memorandum of association 

& many more……


  • Eligibility for PF / ESI registration

  • EPF registration procedure for employers

  • Registration procedure of PF account

  • Documents Required for PF Registration

  • Documents Required for ESI account 

  • Registration procedure of ESI account 

  • Rules of ESI and PF Deduction in detail

  • Deduction amount for both the employee and employer

& many more…….



  • Types of companies

  • How to create a new company

  • Memorandum and register the company

  • Rules regarding issuing share capital, debentures, bonds etc.

  • Company in Promotion Stage

  • Registration or Incorporation Stage

  • Capital Subscription Stage of company

  • Commencement of Business Stage.

  • How to Acquire Director Identification Number(DIN) ...

  • How to Acquire Digital Signature Certificate DSC): ...

  • How to Create  account on MCA Portal



  • Workplace Etiquette

  • Interpersonal skills

  • E-mail Etiquette

  • Interview skills

  • Goal setting & time management



  • Meeting people

  • Asking questions

  • Holiday getaway

  • Food for thought

  • Making friends

  • Buying things

  • Home improvement

  • Know your planet

  • Better than best

  • Leisure time


Maximum 12 Months