What you'll learn
- Master Microsoft Excel from Beginner to Advanced
- Learn the most common Excel functions used in the Office
- Wow your boss by unlocking dynamic formulas with IF, XLOOKUP, VLOOKUP, INDEX, MATCH functions and many more
- Create dynamic reports by mastering one of the most popular tools, PivotTables
- Understanding Supply and applicability of CGST, SGST, IGST along with B2B & B2C Supply
- Understanding Input Tax Credit [ITC] and Understanding Reverse Charge Mechanism [RCM] Provisions
- Discussion on GSTR-3B, GSTR-1 and Discussion on QRMP Scheme
- How to File GST Returns from Tally.ERP9
- Complete Understanding of Filing Income Tax Returns
- Learn the most common Tally functions used in the Office
- How to create GST Computation & Reports in Tally Prime Erp with GST
- RCM - Reverse Charge Mechanism in Tally Prime Erp with GST Training
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 Content
Day 1 - General Discussion & Clause by Clause Analysis of ITR-1
120 MinsGeneral 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 MinsGeneral Discussion & Critical Analysis on ITR-2
Day 4 - General Discussion & Critical Analysis on ITR-2
120 MinsGeneral Discussion & Critical Analysis on ITR-2
Day 5 - Critical Analysis on ITR-4
120 MinsCritical 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 MinsCritical Analysis on ITR-7
Day 8 - Data Cleansing & Date related Calculation Functions :
120 MinsAlt 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 MinsConcatenate & 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 MinsText 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 MinsCalculate 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 MinsTable, 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 MinsPreperation 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 MinsFundamentals of Tally Prime, Accounting Masters in Tally Prime,Tally Prime Shortcuts, Difference Between Tally.ERP9 and TallyPrime,
Day 18 - Tally Prime Shortcuts & Entries
120 MinsPurchase and Sales Entries with GST, Advanced Features in Tally Prime which includes Auto Invoice Series,
Day 19 - Advanced Features in Tally Prime
120 MinsAdvance Entries in Tally Prime like, RCM, Import, Export, SEZ, Ineligible Goods, How to pass entries for TDS, How to deduct TDS Automatically
Day 20 - Difference Between Tally.ERP9 and TallyPrime
120 MinsTally 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 MinsBank 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 MinsHow 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 - Background of TDS provisions and sec 190 to 191
120 MinsBackground of TDS provisions and sec 190 to 191
Day 24 - TDS provisions relating to Salary, Rent, Dividend and Interest
120 MinsTDS provisions relating to Salary, Rent, Dividend and Interest
Day 25 - TDS provisions on payment relating to contract, professionals, Commission and Brokerage.
120 MinsTDS provisions on payment relating to contract, professionals, Commission and Brokerage.
Day 26 - TDS provisions on payment relating to contract, professionals, Commission and Brokerage.
120 MinsTDS provisions on payment relating to contract, professionals, Commission and Brokerage.
Day 27 - TDS on Purchase of immovable property like sec 194IA, 194IB and 194IC and payment to professionals
120 MinsTDS on Purchase of immovable property like sec 194IA, 194IB and 194IC and payment to professionals
Day 28 - Professional/Business Email Writing
120 Mins1. 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 Mins1. Opening and closing structures an email
2. Body of the email
3. Email attachments
4. Polishing your emails
5. Email etiquette at workplace
FAQ
Who can Join this Course?
⭐ 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.
What is the Duration of the Course?
Course will be of more than 60 Hrs.
Whether Course Material will be Provided?
Whether Course Material will be Provided?
Whether Course Recording will be Provided?
Yes Recording will be Provided for 60 Days.
How Can we Join ths Course?
Please register yourself and make the fees.
Terms and Conditions
- Recording will be Valid for 60 Days Only.
- Lecture can be seen Either on Mobile or Desktop.
Requirements
- Need to Have Active Internet Connection
- Lecture will be played either on Mobile, Laptop or Desktop.
This course includes:
- Hindi, English
- 60+ Hours of Video Content
- Recording is Available for 60 Days
- Studycafe Certificate of Completion
- Access on mobile or Computer/Laptop
Certificate to be provided to all the participants.
