top of page




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

Retrieve approximate matched value instead of position, find the value in the last non-empty cell in a row or column, etc.

How to retrieve the value at the position returned by MATCH & INDEX function?

How to map cell values directly to cell ranges

Retrieving value, based on a text string.


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

Storing and manipulating dates and times in Excel, inserting days and months to particular dates; create dynamic date-based fields; and perform complex time-based calculations.

Mathematical calculations, including basic arithmetic, conditional sums & products, exponents & logarithms, and the trigonometric ratios.


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


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

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

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

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

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


Tally Prime PLUS+

Accounting with GST in Tally Prime
  • Tally Gateway and its elements

  • Company formation

  • Working in Accounts Master in Tally Prime

  • Finalizing and reporting of various accounts books and financial statement

  • Working in Inventory Masters & Inventory Vouchers in Tally Prime

  • Generating Inventory Books and Reports

  • Introducing BOM – Bill of Materials

  • Setting Up GST Rates for Your Company

  • Working in Inventory items with effect of GST

  • Updating Party GSTIN

  • Creating GST Ledgers

  • Other Scenarios

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

  • Working in Debit Note & Credit Note

  • Cost Accumulation & Cost Management

  • Recording Direct Cost & Indirect Cost

  • 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


Registration Structure under GST

  • When GST is required?

  • Voluntary registration & compulsory registration

  • Guidelines and principles in the process of Registration under GST

  • Amendment &Cancellation of Registration.

  • Various Forms for GST Registration

  • Practical case study of registration under GST from virtual documents.


GST charging sections

  • How GST is charged?

  • When GST is charged?

  • Where GST is charged?

  • On which goods & services GST will be charged?

  • Exempted services


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

  • Rules regarding Block Credit (Section-17)

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

  • Guidelines of ITC for Job Work (Section-19)

  • ITC Distribution by ISD (section-20)


Time of supply of Goods & Services

Place of supply of Goods & Services

Valuation of supply of Goods & Services


GST bills / E-Way bills / Accounts & records to be maintained in GST

  • How to generate E-way bills?

  • Concepts of HSN code, Turnover and many more…..

  • Journal entries of adjustment of ITC and many more……

Returns under GST Section (37-48) with GST Rules and Formats
  • Overview on return filing procedure, rules & formats

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

  • Regulations & Actions for Return Defaulters.

  • Levy of Late Fee.

  • Various Return Form (GSTR-I, II ,III, 3B)



Overview of IT law

How to apply PAN card

Practical cases of applying PAN card




Computation of income from Salary

  • Computation of  Salary

  • Valuation of salary concerning Allowances (Exempted and Non Exempted) and Perquisites

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


Computation of income from House Property

  • How to compute income from House Property

  • Standard Deduction

  • Interest on borrowed capital

  • 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

  • Rules regarding Depreciation and Additional depreciation

  • TDS Compliances and computation of business income

  • Set off and carry forward of Business Loss

  • Carry Forward of unabsorbed depreciation

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



Computation of income from Capital Gain

  • Introduction To Capital Assets, Holding Period and Transfer

  • Full Value Consideration, Cost of Acquisition

  • Capital Gain on Transfer of Shares and Debentures

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




E-filing & uploading of various returns

Tax planning

Various deductions & rebate to save tax with Practical case studies



  • Tax Planning by Understanding Your Pay slip

  • Objectives of Tax Planning

  • Types of Tax Planning

  • Results  of good tax planning




  • Introduction to Banking

  • Retail Banking

  • Wholesale Banking

  • KYC Norms

  • How to Get Various Types of Loan Like CC, OD, Housing Loan, Mortgage Loan Etc.

  • Project Analysis

  • Risk Management

  • MIS Reporting

  • Record Keeping of Banks

  • Project


  • Overview

  • Life Insurance

  • General Insurance

  • Health Insurance

  • Reinsurance

  • How to Start Insurance Business

Advance Excel

  • Advance Number Formatting

  • Advance Conditional Formatting

  • Match & Index

  • Financial Functions

  • Array Formulas

  • Power Pivot

  • Power View

  • Power Map

  • Power Query

  • Dashboard 

  • Macro

  • Google Drive

  • VIVA

Advance Accounting

  • Accounts Reconciliation

  • Bank Reconciliation

  • Advanced Journal Entries

  • Ledger Scrutiny

  • Accounts

  • Finalisation

  • Company Final Accounts

Formation of Society & Trust

  • Overview of Society & Trust

  • Rules & Regulations of Society & Trust

  • Co-Operative Society

  • Charitable Society

  • Registration of Society & Trust

  • Retirement or Joining of a Member & Trustee

  • How to Make Changes 

  • Public Trust

  • Charitable Trust

  • Project

ESI & Provident Fund

  • Basic Concept of ESI & PF

  • Applicability

  • Employees Contribution

  • Employer's Contribution

  • Methods of Payment 

  • Maintenance of Register under ESI & PF

  • Returns

  • Penalties

  • Benefits to Employee & Their Family

  • Exemptions 

  • Project

Business Communication & Interview Preparation

  • Resume Building

  • Workplace Etiquette

  • Interper-Sonal Skills

  • E-mail Etiquette

  • Interview Skills

  • Goal Setting & Time Management

Personality Development

  • Meeting People

  • Asking Questions

  • Holidays Getaway

  • Food for thought

  • Making Friends

  • Buying Things

  • Home Improvement

  • Know Your Planet

  • Better Than the Best

  • Leisure Time

  • Who's This

Maximum 12 Months

bottom of page