Follow Us :

#AD Join Self-Learning Certification Course on GST, GST Compliances, Excel For professionals, Income Tax and Customs including Import & Export by TaxGuru Edu. 

Special 60%  discount till 15th October 2022. Discount code GST60. 

The new normal has opened up new frontiers for all of us. The challenges of present times have created new possibilities. To comprehend the opportunities, new perspectives and a fresh outlook, we need to do de-learning and re-learning. Our Self learning programs can play an important role to impart desired learnings to mitigate various challenges of present times.

TaxGuru Edu, an educational wing of TaxGuru, announces Self Learning Certification Courses on GST Complete Course, GST Compliance Course, Income Tax, Customs incl. Export and Import and Advanced Excel Course –2021 Batches.

In Self learning Courses, we follow a blended learning approach, wherein you will be given an access to our Learning Management System. Sessions shall be pre-recorded from our latest Online Professional Development Course to give you the real class experience followed by our query resolution forum.

Course 1 – Self-Learning Certification Course on GST

The Course covers GST from Basic to Advanced level covering legal aspects, major compliances, amendments, precautions to minimize disputes with the GST department, Handling assessments, GST Health Check-up, along with case studies. Certificate from Taxguru Edu shall also be given after the completion of course.

The batch shall be delivered by CA Raman Singla, who has trained more than 30,000 professionals across India and has authored the best-selling book namely “Complete Analysis on GST” which runs in 5000+ pages. He is a well-known GST Expert and National Level Eminent Speaker in seminars and workshops on GST.

Link for Registration and Detailed coverage of GST Course

Course Coverage for GST

Batch covers detailed analysis of Major Aspects of GST law with special focus on

1) Constitutional Aspects, Basic Concepts of GST, Taxes Subsumed in GST, GST Illustrations

2) Concept of Central Sales Tax (CST), Compensation Cess, Valuation, Marginal Scheme

3) GST Set Off Rules (Sec 49 & 49A, Rule 88A), GST Amendment Act, GSTR 2A Reco with GSTR 3B, ITC @ 120%/110%/105%. of GSTR 2A or GSTR 2B

4) Form GSTR – 3B, GSTR – 1, GST Return Filing Procedure

5) Taxable/Exempt/Non Taxable/Zero Rated/Non GST Supply, Exemptions and Rate for Goods & Services, Schedule 3

6) Registration (Sec 22), Aggregate Turnover

7) Input Tax Credit, Conditions for taking ITC, Time limit for ITC, Negative List of Tax Credit

8) Definitions of Capital Goods, Inputs and Input Services, Types of Invoices, Time of Supply, GST on Advances, Time of supply for Builder, Continuous Supply of Services, Non-payment within 180 days

9) Input Tax Credit Reversal on Exempt and Taxable Supply, Proportionate Reversal of ITC and Formula, ITC in case of Sale of Business, etc

10) Zero Rated Supply, Export, Options under Zero Rated Supply

11) Refund of ITC and Formula, Refund Mechanism and complete procedure

12) Fake Invoice Menace and consequent amendment by Finance Bill 21

13) Supply to SEZ, Deemed Export

14) Inverted Duty Structure

15) Reverse Charge Mechanism, Section 9(3) and 9(4), Goods Transport Agency (GTA), Rent-a-cab, Self-invoicing

16) Audit and Annual Return

17) Transitional Issues

18) Interest, Assessment, Appeals, Demand & Recovery, Advance Ruling, Penalty, Search seizure, etc

19) Levy & Collection, Definition of Supply, Definition of Goods and Services, Schedule 1 (Related and Distinct person)

20) Valuation provisions, Valuation in Pure Agent and Reimbursements, Free supply of goods and services, Stock Transfer, Valuation Rules

21) Composite and Mixed Supply, Place of Supply, Bill to – Ship to, Composition Scheme, Anti Profiteering, Input Service Distributor (ISD), Cross Charge, Job Worker, TDS and TCS

Course 2 – Self-Learning Certification Course on Income Tax

The course covers Income Tax from Basic to Advanced level covering major compliances, Filing of Income Tax Return and TDS forms along with precautions to minimize CASS Scrutiny Selection, Handling Faceless assessments, Income tax Health Check-up, etc. Certificate from Taxguru Edu shall also be given after the completion of course.

The batch shall be delivered by CA. Pankaj Saraogi. He is a practicing Chartered Accountant with 10th Rank in CA Final and highest marks in Direct Tax Law in NIRC-ICAI. He is an eminent speaker in seminars, workshops and trainings on Direct Taxes organized by ICAI, PSUs, Corporates and has proven track record in handling complex Direct Tax matters.

Link for Registration and Session wise detailed coverage for Income Tax

Course coverage for Income Tax

Batch covers detailed analysis of Major Aspects of Income-tax law with special focus on

1. Tax planning for salaried individuals, businessman, capital gains, succession planning with minimum taxes, Taxation of Gifts, Cash Transactions, etc

2. Definition of Income and principles thereof, Capital vs Revenue receipts and expenditure, Diversion of income by overriding title, Taxability – who earned and who received

3. Is Income-tax Department Faceless? Discussion in perspective of assessee’s rights and responsibilities.

4. Income from House Property & relevant provisions of Clubbing of Income

5. Filing of ITR Forms along with precautions to minimize CASS Scrutiny Selection

6. Advance Tax

7. TDS and its Compliances. TDS by business man and non-businessman

8. Real Estate related provisions. Section 50C, 43CA, 269SS, 269T, Interest vs Cost of Acquisition, Section 54 & 54F – exemption on investment

9. NR Taxation/International Taxation/ Taxability of Cross Border Transactions, Section 9 & 195, TRC, Form 15CA & 15CB, Section 90 & 91, DTAA – UN Model read with MLI, Concept of PE

10. Transactions where not quoting PAN may invite enquiry

11. Types of assessment with special focus on scrutiny assessment and income escaping assessment along with Safeguards, Drafting skills, Powers and procedure thereof

12. Interest and penalty provisions under Income-tax Law

13. Assessment and Appeals – Rights and Procedure

14. How to create database of judgements

15. Tax planning, Tax avoidance

16. Maintenance of documents under Income Tax and period thereof

17. Scrutiny by self before scrutiny by Income-tax Department

18. Handling Faceless Assessments and Limiting Taxation Disputes

19. Income tax Health Check-up Techniques

20. Finance Act, 2021

Course 3 – Self-Learning Certification Course on Customs Incl Export and Import

The Course covers Export and Import Management, Custom laws and Foreign Trade Policies from Basic to Advanced level covering major compliances, procedures, treatments, Export Import benefits and relevant RBI/FEMA guidelines, etc

The batch shall be delivered by Mr. SN Panigrahi. A Versatile Practitioner, an International Consultant-Corporate Trainer, Mentor & Author. He has authored over 500 articles published in various journals & periodicals, done more than 150 Workshops Globally including PMP, FIDIC & Lean Six Sigma. Among other professional achievements, he is a Member PMI (USA) & PMI PCC, Member Board of Studies – IIMM, Co-Chairman – Indirect Taxes & Foreign Trade Committee – FTCCI.

Link for Registration and Detailed coverage of Customs Course

Course Coverage for Customs Incl Export and Import

Batch covers detailed analysis of Major Aspects of Import and Export law with special focus on

1) Overview of International Trade; What – Where &Why &How to Start Export – Import Business, How to Identify Business Opportunities & Contact Overseas Customers; Trade Associations, Federations & Chambers; Product X Market Selection; Online Marketing – Identifying Buyers, Overview of FTP, Export Promotion Councils (EPC)& their Role in Export Promotion

2) An Introduction to Customs Act, 1962 – Customs Valuation, Import – Export Restrictions, Prohibitions Under Customs Law, Customs Tariffs & Duties, SEZ / FTWZ / EOU &Customs Bonded Warehousing, Manufacture and Other Operations in Customs Warehouse, Anti-Dumping Duty; Safeguard Duty; Anti-Subsidy Duty

3) Treatment of Exports & Import under GST, Export Without Payment of Tax under LUT, Export with Payment of IGST, Export Refunds, ITC Refund / IGST Refund, Other Provisions of GST Related to Export & Import

4) Export Order – Fulfilment, Export- Import Procedures & Documentation, Indian Customs – EDI System: ICES &ICEGATE, Self-Assessment &Risk Management System (RMS), Container Stuffing & Sealing : RFID, e-Sanchit & Customs Faceless Clearances, Import Duty Calculation – Other Formalities, International Logistics, 3 PL & 4 PL; INCOTERMS; Multimodal Transport; IMO Provisions, Port & Shipping Formalities;

5) Foreign Trade Policy & Handbook of Procedures, ITC (HS), Concept of Digital Signature and e-filing in DGFT, Export Promotion Schemes MEIS, Adv. Authorization, EPCG – Duty Drawback, Export Obligation Fulfilment – EODC

6) Service Exports & Imports, Export Refund for Service Export, Free Trade Agreements – FTAs, Tariff & Non-Tariff Barriers, New Rules of Origin- CAROTAR 2020

7) Merchant Exports, Third Country Exports, High Seas Exports, Deemed Exports, How to Send Samples, Import & Re-export of Rejected Goods, Project Imports

8) RBI – FEMA, Export Payment Methods –Documentary Collection & Letter of Credit, Export Payment Methods – Risks : L/C Check List, Export Finance: Pre & Post Export, Banking Formalities- Realization of Export Proceeds

9) Export Costing – Pricing, Negotiating & Drafting International Contracts, Risks in International Market; Country – Currency – Customer Risks, Understanding Importing Country Regulations, Mitigating Risks, Customer Credential Verification – DnB & Bank Verifications, Insurance & ECGC Cover & Others Means;

10) Export & Import Miscellaneous Provisions & Regulations, Trade Fairs & Exhibitions, WTO / WB / ICC / WCO etc, Tips for Export & Import, Case Laws & Case Studies.

Course 4 – GST Compliance Course

The course covers GST Compliances concerning registrations, returns, refunds, E Invoicing, E way Bills etc. The detailed coverage is written below.

The batch shall be delivered by CA Deepika Agrawal. She is a Practicing CA and did multiple post qualification courses offered by the institute viz, DISA (ICAI), Certified Forensic Accounting & Fraud detection Auditor (ICAI), Certified Concurrent Auditor (ICAI) and Certified Indirect Tax Consultant (ICAI). She was involved in reporting to the worldwide organisation, making MIS, trackers, presentations etc.

Course Coverage

Batch covers compliances aspects under GST Law with special focus on

1. Registration

i) Applying for New Registration

a) Regular dealer

b) Composition dealer

ii) Amendment in core fields of Registration

iii) Amendment in non-core fields of Registration

iv) Applying for cancellation of Registration

v) Application to opt & to withdraw from the composition levy scheme.

vi) How to download and view Certificates

2. Varies Applications

i) Refund Application

ii) Application for LUT

3. How to file GST Returns

i) GSTR-3B

ii) GSTR-1

iii) TDS and TCS

iv) ITC-04

v) GSTR-9

vi) GSTR-9C/Reconciliation statement

vii) How to opt Quarterly return Monthly Payment Scheme (QRMP).

4. Reconciliation with GSTR-2A & GSTR-2B, Books and 3B

5. How to create E-invoice

6. E-Way Bill

i) How to create E-Way Bill.

ii) Application for unblocking of E-way Bill.

7. How to submit response to notices issued by the department

8. Payments

i) Create challans

ii) Saved Challans

iii) Challans History

iv) Intimation of Voluntary Payment- DRC-03

v) Application for Deferred payment/ payment in instalments

9. How to download ledgers-

i) Cash Ledgers

ii) Credit Ledgers

iii) Liability ledgers

10. How to search a registered dealer on GST portal & what information should be looked upon before dealing with the party.

11. Miscellaneous Issues

Course 5 – Advanced Excel Course

Working as a CA or an Article in any company, it is always expected that we are perfect in numbers. The one tool which is quite common and useful in every industry is MS-Excel. The batch shall cover advanced excel techniques.

The batch shall be delivered by CA Deepika Agrawal. She is a Practicing CA and did multiple post qualification courses offered by the institute viz, DISA (ICAI), Certified Forensic Accounting & Fraud detection Auditor (ICAI), Certified Concurrent Auditor (ICAI) and Certified Indirect Tax Consultant (ICAI). She was involved in reporting to the worldwide organisation, making MIS, trackers, presentations etc.

Course Coverage

1. Filling & Formatting:

Excel has the ability to auto-fill cells and add special formatting to cell batches more easily than ever. We will learn the shortcut keys and pay attention to Excel’s new automation features to accelerate our work rate in the platform immensely.

2. Collection & Verification of Business data:

Businesses often employ multiple systems (i.e., CRM, inventory) each with its own database and logs. All of which can be exported into Excel for easy access. The program can also be used to clean up data, by removing incomplete or duplicate entries; eliminating such data from the beginning is necessary as it can impact later analysis and reporting.

3. Data Analysis:

So you’ve been dumped with a giant pile of data and charged with drawing insights from it. Not to worry as Excel can also help you manage and synthesize clear communicable results from it. One of the best features to do this is called Pivot Tables. They allow users to consolidate and focus on certain segments of data from a large data set, creating concise snapshots that can be used as an interactive summary report. By applying filters or swapping out data segments, the table can be effortlessly changed to display desired data fields.

4. Reporting + Visualizations:

Data from both raw data sets and Pivot tables can even be used create charts and graphs. Which can be used for formal reports, presentations, or aid in one’s data analysis. As they can provide another perspective on trends and performance. Visual reporting can be used in all sectors of business. For instance, marketing teams can use a column chart to report the efficacy of an ad campaign over time and compare it to previous campaigns.

5. Inventory Tracking:

Tracking inventory can be a headache. Fortunately, Excel can help to keep employees, business owners, or even individuals organized and on top of their inventory—before any major problems crop up.

6. Calenders & Schedules:

For Chartered Accountants, multiple deadlines are there every month. With the help of Excel, they need not worry about the deadlines approaching. Excel can help in determining the deadlines based on their priorities.

7. Automation of Financials from Tally

Preparation of balance sheets, profit & loss, month wise analysis, quarterly analysis for the management directly through the tally reports with the help of excel.

8. Balance Sheet Consolidations:

Consolidation of Multiple Balance sheets for various branches of a unit. Excel makes it easy to update the consolidated the balance sheet just with a few clicks.

9. ERP implementations.

Shifting data from one software to another, how excel helps in managing the data and making it readable for the new software and how it makes it easy to work on the new software from the very first day.

10. Calculation of interest, depreciation, penalty, taxes

With the help of date and time functions, these values can be calculated just with the help of inputs. Excel helps in the same with the understanding of the concept of date and time as numerical figures.

11. Reporting to the management:

Huge Data makes no sense to the top management. Excel helps in drafting the reports in such a concise manner that the management is able to derive the financial health of the company from a single page report.

12. Assistance in Bank and Other Audits:

Determining which accounts have to be selected as samples depending upon the grey areas highlighted by Excel utility. With the help of Excel one can easily determine the accounts where the problem persists such as late payment of interest, non-payment of EMIs, Non-renewal of accounts etc.

13. Filling of GST Returns:

With the help of Excel, the data dump from the financial softwares of the client can be processed in such a manner that the GSTR-3B summary can be prepared automatically thereby resulting in saving the time involved in processing of returns.

14. Sparkline Charts:

A chart line is a feature that allows you to embed charts inside cells, greatly improving your ability to consolidate large amounts of information into a single spreadsheet.

15. Making charts visually appealing

Excel Charts has many features for not only creating reports but also making them look attractive to readers.

a. Time Series Charts

b. Scatter plotting

c. Trend Line

16. Sharing data with teammates or clients depending on the user rights to be given to the audience.

17. Creating forms for specific data entry from the audience/ clients.

18. Use of special functions such as Conditional Formatting, Paste Special, Advance Sorting, Text to Columns, Advance Filters, etc.

Links for Registration of Courses

Special Features of Self Learning Course

1. Self-Learning Course is the recorded version of our latest Online Professional Development Courses to give you the real class experience and clear maximum doubts.

2. Detailed study to let you become a taxation Expert.

3. Study in the comfort and privacy of your home.

4. Certificate by Taxguru Edu after successful completion of course.

5. Course Material in E-Form.

6. Access to the course valid for 3 Months each

7. Detailed Courses.

Read our Reviews of previous Online Batches

Click here to read our previous reviews

Who can attend Self Learning Certification Course?

  • Finance professionals like CA/CS/CMA/Lawyers who deal in taxation to meet their professional need.
  • Business Heads, Business Owners, CEO, CFO, Finance Directors, Tax Directors, Analysts, Department Heads and Project Heads
  • SMEs, Traders, Tax Officials, Finance and Accounts Officers,
  • Professionals who want to shift from finance to Taxation domain.
  • GST Practitioners and Income Tax Practitioners.
  • Individuals/beginners seeking career opportunity in the taxation domain.

Access to the Course and Material

We have developed a Learning Management System (LMS) wherein are the recordings shall be placed. The material shall also be shared in E-Form. Complete Details shall be shared after registration along with user id and password.

Online Test and Certification

There will be online tests to evaluate your performance. The Online Test link has been given in the LMS. The certification will not depend upon the clearance of test. The candidates shall be awarded an Online Certificate by Taxguru Edu.

Mode of Communication

The Courses shall be deliberated in English as well as Hindi as the users are from across India.

Fees for the Courses

GST Course Fee Rs. 8,000 + GST @ 18%.
Income Tax Course Fee Rs. 8,000 + GST @ 18%.
Customs Course Fee Rs. 8,000 + GST @ 18%.
GST Compliance Course Rs. 6,000 + GST @ 18%.
Advanced Excel Course Rs. 6,000 + GST @ 18%.
Special Offer Special 60%  discount till 15th October 2022. Discount code GST60. 

Links for Registration of Courses

For any assistance, call us at 88-99-11-77-01 or give a missed call on 80-10-487-487 or mail us on

We’ll truly be a partner in your progress

Join Taxguru’s Network for Latest updates on Income Tax, GST, Company Law, Corporate Laws and other related subjects.



    Hello sir,

    i am interested to learn certificate online course of GST, INCOME TAX, TDS & TCS RETURN, ADVANCE EXCEL


  2. BUDDHA DEB DAS says:

    Good afternoon Sir,
    I am interested to learn TDS return filing and advance excel ,Please let me know how much minimum amount have to pay as a combined course
    Thank you,
    With regards,
    Buddha deb Das

  3. BUDDHA DEB DAS says:

    very much interested to certificate course for Income Tax and advance excel ,Please confirm after discount how much minimum amount have to pay as right now job less

Leave a Comment

Your email address will not be published. Required fields are marked *

Search Post by Date
May 2024