4.6 Upto 4 Month
English / हिंदी में सीखें

Tally ERP + GST + Adv. Excel

Tally ERP 9 is the most popular software on the market. In the course content, participants will learn in detail how to manage accounts, inventory, and payment slips at Tally.

Rs.12500 51% off Rs.25500

Free Tally & GST Demo Class Complimentary class with Certificate

Duration

Tally ERP + GST + Adv. Excel is upto 4 Month Course

Instructor Led

Interact with real trainers to clear your doubts

Real Life Assignment

Learn-by-doing model for real-life problem-solving skills

Expert Faculties

Get trained by industry experts for in-depth learning experience

Certification

Get Digital and Physical course completion certificate

SYLLABUS Tally ERP + GST + Adv. Excel

Tally ERP.9 25 Topics

  • Getting Familiar with Tally Prime

  • Fundamentals of Tally Prime

  • How to create a Company in Tally Prime

  • Working with Ledgers and Groups

  • Recording day to day Entries in Tally Erp.9

  • Inventory Management in Tally Erp.9

  • Inventory Masters

  • Inventory Books & Reports

  • Create Purchase & Sales Voucher

  • Order Processing

  • Reorder Levels

  • Maintain Bill Wise Details in Tally Prime

  • Debit & Credit Notes

  • Delivery, Receipt & Stock Rejection in Tally

  • Cost Center & Cost Categories

  • Create Budget in Tally Prime

  • Payment, Receipt & Contra Voucher

  • TDS Tax Deducted at source

  • TCS Tax Collected at source

  • Setting Price list for Wholesalers, Semi-Wholesalers & Retailers

  • Optional & Quotation vouchers

  • POS (Point of Sales) method for multi-mode payment

  • Getting Familiar with Payroll Management

  • BOM (Bills of Material) in Tally Prime

  • Cost of a particular project in Tally Prime

  • How to create Company & Set Rate in GST

  • Creating Tax Ledgers

  • Recording GST Local Purchase

  • Recording GST Interstate Purchase

  • Recording GST Local Sales

  • Recording GST Interstate Sales

  • Record Payments and Receipts

  • Recording an Advance Payment to Supplier

  • Purchase from Unregistered Dealers

  • Sale of Composite and Mixed supplies under GST

  • GST Sales Nil Rated, Exempt, SEZ, Deemed Export and Consumer sales

  • Creating GST invoices for E-commerce operators

  • Creating GST Export Taxable invoices with currency change

  • Import of goods & services

  • Creating E-way Bills

  • Exporting GSTR-1, GSTR-2, GSTR-3B data to excel

  • Import data from Tally to Tally

  • GST Offline Tool

  • Concatenate Function

  • Logical Functions like Nested IF, Complex IF-ELSE-IF, IFERROR, AND & OR

  • Dynamic Transpose

  • Criteria Based Functions: Sumif and sumifs, Countif and Countifs, Averageif and Averageifs functions

  • Advance Filters

  • Absolute, Relative & Mixed Reference

  • Advance Conditional Formatting

  • Index, Match function

  • Data Validation

  • Data validation with Dependent List

  • PMT function

  • PPMT and IPMT Function

  • What if Analysis (Scenario, Goal seek, Data Table, Forecast)

  • Pivot Table

  • Consolidate data Sheets

  • Dsum, Dmax, Dmin & Daverage

  • Vlookup Function

  • Double Vlookup Function

  • Advance Vlookup with Max-Min, Vlookup with IfError, Vlookup with Validation, Intersheet Vlookup with Referencing

  • Hlookup Function

  • How to Export Sheet into PDF

  • Basic Macros

  • Advance Charts(Donut Chart, Speedometer Chart, Trend Arrows, Target vs Actual, Scatter chart, Thermometer Chart, Gantt chart with conditional Forma

  • Protect worksheet & Formulas

  • Advance Conditional Formatting with Form Control

  • Triple VLookup

  • VLookup & HLookup with Match Function

  • Solver Function

  • Dynamic Offset with Sum & Average Function

  • Forecast Sheet

What you'll learn Tally ERP + GST + Adv. Excel

  • Basics of Financial Statements - Trial balance, Balance Sheet, Income statements, Cash flow statements.
  • How to manage Inventory and Tax administration
  • Understand all aspects of GST law from practical point of view.
  • Accounting with every type of transaction such as payment, receipt, sale, purchase
  • Filing of GST returns in GSTR1,GSTR2 and GSTR3B offline
  • How To Exactly Calculate Employee's Total Earnings ,Deduction And Net Salary By Using Microsoft Excel
  • How To Get The Pay Slip , Pay Sheet And Payroll Statement On Tally ERP9?
  • How to export data from Tally to Excel
  • Create GST reports, adjust input tax credit and make GST payments

Get Free Participation Certificate

Take a demo class & get the FREE Certificate

Upcoming Batches

  • JOIN NOW And Get 51% Scholarship

  • Friday 01-Nov-2024

    Upto 4 Month

    Classroom / Online

    Weekday & Weekend

  • Monday 04-Nov-2024

    Upto 4 Month

    Classroom / Online

    Weekday & Weekend

  • Wednesday 06-Nov-2024

    Upto 4 Month

    Classroom / Online

    Weekday & Weekend

  • Thursday 07-Nov-2024

    Upto 4 Month

    Classroom / Online

    Weekday & Weekend

About Tally ERP + GST + Adv. Excel Course in about

ISPL Academy brings you the comprehensive certification program in Tally Erp9 and GST . Whether you are a professional or a beginner in the field of accounting, our training will give you the expertise you need in a Computer Accounting Tally and Taxation in GST. By registering for this course with us, you will learn Bookkeeping basics like bills and credits to help you understand and confidently issue records. Learn how to transfer account information from physical books to Tally, Customize inventory details and filter reports such as availability of specific inventory with specific functionality. Find out more about applying important and advanced topics to GST, such as GST interception, chargebacks, shipping agents, and how to enter appropriate entries in the calculation diary. Learn about full payroll (employee attendance) arrangements according to the government specified reduction rate. Find out about manufacturing processes that allow you to determine the price of the items you manufacture from the cost of the various parts/components used to assemble the product.

In addition you will learn how to maintain your large data in Excel, this course is tremendously comprehensive and the best part is you will learn advance functionalities in small chunks of real practical industry scenario based assignments that is easier for you to digest and follow along. Not by discussing only the functionalities but discussing the functionalities and possibilities in excel. 
 

Exam & Certification Tally ERP + GST + Adv. Excel

An online verifiable certificate of completion will be issued based on your performance from ISPL Academy. Student would go through an online examination after completion of the course to evaluate the skills gathered during the course.

Competition is tough when applying for a job, having a proof of successful completion of the course is an effective way to stand out and succeed. Your certificate will give the trust to the employers that you are dedicated and have required skills to become a suitable employee for them.

ISPL Academy Certificate Sample

Tally & GST Alumni

Frequently Asked Questions

Tally ERP+ GST + Advance Excel is a short term course of 4 months.

The fee of course Tally ERP + GST is Rs.12500/-

This course covers Accounting in Tally & GST (Goods & Services Tax) and Advance Excel.

Tally ERP is not just an accounting software but it also acts as the perfect business management solution for all small and medium business organizations. This inventory management software provides various facilities to its users including GST filing, Ratio analysis, Cheque printing, Cash and funds flow statements, Comparative analysis, Journal vouchers and Generating Reports. Advanced excel helps the user to perform complex and large calculations, data processing on the huge amount of data, performs data analysis, better representation of data, etc. It allows the business to increase their productivity and performance by easily sorting and filtering relevant data and using it for better decision making.

Bulk Training for Corporates, Government and Institutions

Classroom Learning

GMS Road Dehradun 99974-11884

Tilak RoadDehradun 99974-11885

Start your own centre Become a Partner