Practical Filing Certification Course on GST, ITR, TDS, Tally Prime & Excel

Last updated: Thursday July 22, 2021

4.9 by 35 Users | 68 Students Enrolled | Languages: Hindi, English

2599 25999

Hurry up, few days left at this price!

Starts at Monday August 16, 2021 - 19:00

What you'll learn

Course Description

Certification Course on GST, ITR, TDS, Tally Prime & Excel


In our continuous endeavor to empower more and more finance professionals, this Certification Course on GST, ITR, TDS, Tally Prime & Excel has been designed for you.  Detailed 60 Hrs course has been designed where more than 2 hrs sessions have been organized. This Course contains Videos along with study material, Excel Files. Live training will be given.

How I will get the course:


This is an online Certification Course on GST, ITR, TDS, Tally Prime & Excel so there will not be any physical delivery of the lectures. After the purchase of the Certification Course on GST, ITR, TDS, Tally Prime & Excel you can see the Certification Course on GST, ITR, TDS, Tally Prime & Excel under my account option under purchased courses. All the videos, stydy materials, PDF files, PPT’s, excel files will be uploaded there for quick access of participants. This Certification Course on GST, ITR, TDS, Tally Prime & Excel is valid for 60 Days.

Who is Eligible to Join Certification Course on GST, ITR, TDS, Tally Prime & Excel:


There is no bound on the eligibility from our side for Certification Course on GST, ITR, TDS, Tally Prime & Excel. Any person who want to learn and master in GST, ITR, TDS, Tally Prime & Excel can join this course. However, it will be more beneficial for the below-mentioned persons:

⭐Commerce Graduates/CA/CS/CMA/Law students

⭐Tax professionals whether in JOB or Practice

⭐Qualified CA/CS/CMA/LLB

⭐Semi-qualified CA/CS/CMA working in CA Firms or in Industry

⭐Any other person not covered above can join course if interested.

Course Duration:


The course duration is around 60+ hours.

Certificate:


A Certificate of Participation from Studycafe will be provided on completion of the Certification Course on GST, ITR, TDS, Tally Prime & Excel.

Views Limitation:


This is a Completely online course, no bar on the number of views. During 60 days you can access this Certification Course on GST, ITR, TDS, Tally Prime & Excelfrom anywhere at any time with unlimited views.

Course Start Date:


Microsoft Excel Certification Course is starting from Aug 16, 2021 and will be completed on Sep 15, 2021.

Course Timing:


Timing: 07:00 PM to 09:00 PM.

Course Content

Day 1 - General Discussion & Clause by Clause Analysis of ITR-1

120 Mins

General Discussion & Clause by Clause Analysis of ITR-1

Day 2 - General Discussion & Clause by Clause Analysis of ITR-1

120 Mins

• General Discussion on Filing of ITR's

• Applicability & issues of ITR-1

• Significance of proper & correct filling of fields in the ITRs

• New fields and changes made in ITR-1

• Discussion on important provisions pertaining to ITR-1

• When to File ITR 1

Day 3 - General Discussion & Critical Analysis on ITR-2

120 Mins

General Discussion & Critical Analysis on ITR-2

Day 4 - General Discussion & Critical Analysis on ITR-2

120 Mins

General Discussion & Critical Analysis on ITR-2

Day 5 - Critical Analysis on ITR-4

120 Mins

Critical Analysis on ITR-4

Day 6 - Critical Analysis on ITR-3, ITR 5 & ITR-6

120 Mins

• Applicability & Issues in Filing of ITR-6 & ITR-7

• Significance of proper & correct filling of fields in the ITRs

• Discussion on important provisions pertaining to ITR-6 & ITR-7

• New fields and changes made in ITR-5, ITR-6 & ITR-7

Day 7 - Critical Analysis on ITR-7

120 Mins

Critical Analysis on ITR-7

Day 8 - Data Cleansing & Date related Calculation Functions :

120 Mins

Alt Function, Excel Smart Shortcuts, Edit Tool Bar, Randomdata, Smart Copy Paste, Smart Paste special, Transpose, now, date function, Format Cell, Concatenate, Trim & Clean, Proper, Upper, Lower, Left, Right, Mid & Len, Filter, Advance Filter, Format Painter.

Day 9 - Advanced Features in Excel :

120 Mins

Concatenate & Text Join, Giving password to excel and back up, Advance Find & Replace, Smart Sorting, Skip Blank, TDS Working Check list, GST Late Fees Calculator, Import 26 AS data and converting in to excel

Day 10 - Advanced Excel Functions :

120 Mins

Text to Columns, Flash Fill, Remove Duplicate, Data Validation, Consolidation, Conditional Formatting, if functions, Goto Special, Macro of Spell Number, etc.

Day 11 - Advanced Excel Functions :

120 Mins

Calculate Drs Ageing, Sumif, Sumifs, Advance Subtotal, Iferror, Match Function, Vlookup, IF Error+Vlook up, IFError+Vlookup, Hlookup, Xlookup, How to Record Macro, Relative Size factor Theory (RSF) in Excel to identify red flags or fraudulent transactions in audit,

Day 12 - Advanced Excel Functions :

120 Mins

Table, Vlookup, Hlookup, X Lookup Funcation, How to Create Pivot Table, USe of Pivot Table Pivot Table, Advance Pivot Table Features, Pivot Charts, Sparkline Chart,

Day 13 - Advanced Excel Functions :

120 Mins

Preperation of Balance Sheet from trial, CFO or Management Dashboard, Extract data in Excel from NET, Excel worksheet to corporate (or Tally) database & extract any data that you want, Connect your Excel worksheet to live data on the Internet to track (for e.g.) current value of investments, Reconcillation of GSTR2A with GSTR3B ,

Day 14 - GST Returns: GSTR-1, GSTR3B & QRMP Scheme

120 Mins

• Discussion on GSTR-1, GSTR-3B, QRMP Scheme

• Discussion on Eligibilty & new updates of QRMP Scheme

• Filing GST Return with Tally

Day 15 - GST Returns: GST Annual Return

120 Mins

• Discussion on GST Annual Return

• Filing GST Return with Tally

Day 16 - E-Invoicing & E-Way Bill

120 Mins

• Process of generating E-Invoice and E-Way Bill

• Procedure its applicability

• Document to be carried with goods in movement

Day 17 - Fundamentals of Tally Prime

120 Mins

Fundamentals of Tally Prime, Accounting Masters in Tally Prime,Tally Prime Shortcuts, Difference Between Tally.ERP9 and TallyPrime,

Day 18 - Tally Prime Shortcuts & Entries

120 Mins

Purchase and Sales Entries with GST, Advanced Features in Tally Prime which includes Auto Invoice Series,

Day 19 - Advanced Features in Tally Prime

120 Mins

Advance Entries in Tally Prime like, RCM, Import, Export, SEZ, Ineligible Goods, How to pass entries for TDS, How to deduct TDS Automatically

Day 20 - Advanced Features in Tally Prime

120 Mins

Tally Back up & Restore, Technological Advantages of Tally.ERP 9, Tally.NET and Remote Capabilities, Email Facility in Tally, How to add the logo in invoices, Backup, Restore & Splitting of Company,

Day 21 - Application Management and Controls

120 Mins

Bank Reconciliation, Audit feature of How to Check who has passed the entry, Extract Report from tally in Excel with TALLY ODBC Server, Export and Import GL from XML File.

Day 22 - How to File GST Returns from Tally & How to Merge Group Companies in Tally

120 Mins

How to File GST Returns from Tally, Tally.ERP9 Audit Features, How to Generate JSON File of E-way Bill, How to Create Cost Centres, Cost Categories in Tally, How to merge branch and HO in Tally, How to Merge Group Companies in Tally

Day 23 - TDS Return Filing

120 Mins

TDS Fundamentals

Important Forms, Due Dates, Penalties

TAN & PAN No.

Day 24 - TDS Return Filing

120 Mins

TDS Salary Section 192B

Complete Exemption & Deductions

TDS Computation of Employees

TDS Return filing in Form 24Q

Day 25 - Complete TDS Non Salary Sec.194

120 Mins

Complete TDS Non Salary Sec.194

TDS Return filing in Form 26Q

Day 26 - TDS Return Filing

120 Mins

Complete TCS Sec. 206

TDS & TCS Book in the System

TDS & TCS Online Payment in Challan 281

TDS & TCS Online Return Filing

Day 27 - TDS Return Filing

120 Mins

Form 16 & Form 16A online generate form traces

Form 15G, 15H, Form 26AS

TDS on payment of purchase of property 194IA / 194IB

Day 28 - Professional/Business Email Writing

120 Mins

1. Introduction to Business Emails

2. Salutation in an Email

3. Formatting of your Emails

4. Effective subject lines

5. Other components in an email

Day 29 - Professional/Business Email Writing

120 Mins

1. Opening and closing structures an email

2. Body of the email

3. Email attachments

4. Polishing your emails

5. Email etiquette at workplace

FAQ

Terms and Conditions

Requirements

This course includes:

  • Hindi, English
  • Recording is Available for 60 Days
  • Studycafe Certificate of Completion

Certificate to be provided to all the participants. Certificates will be sent on your email id.

In case of any Query Please Call us or Whats App

About Authors

Studycafe

CA: Business

Studycafe
(4.7)

This Account belongs to the Administrator of Studycafe.

Feedback