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

Tally Prime + GST with Advance Excel (For Non-commerce)

Maintain Accounts of any Business with Confidence and Conviction. A Step-by-Step Guide to help you understand Tally. This course is available in both online & Classroom mode at our Dehradun Computer Training center.

Rs.15900 55% off Rs.35500

Free Tally & GST Demo Class Complimentary class with Certificate

Duration

Tally Prime + GST with Advance Excel (For Non-commerce) 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 Prime + GST with Advance Excel (For Non-commerce)

Accounting Fundamentals (Theory) 21 Topics

  • Introduction to Accounting

  • Accounting Concepts & Objectives

  • Advantages & Limitations

  • Types of accounting information

  • Uses of accounting information and their needs

  • Qualitative Characteristics of Accounting Information

  • Role of accounting in Business

  • Basic Accounting Terms- Business Transaction, Capital, Drawings

  • Liabilities (Non-Current and Current)

  • Assets (Non-Current and Current)

  • Fixed Assets (Tangible and Intangible)

  • Expenditure (Capital and Revenue)

  • Expense, Income, Profit, Gain, Loss, Purchase, Sales

  • Goods, Stock, Debtor, Creditor, Voucher, Discount (Trade discount and Cash Discount)

  • Recording of Business Transactions

  • Voucher and Transactions: Source documents and Vouchers, Preparation of Vouchers

  • Accounting Equations

  • Rules of Debit and Credit

  • Recording of Transaction: Books of Original Entry-Journal

  • Ledger Format, posting from journal and subsidiary books, Balancing of accounts

  • Preparation of Trial Balance, Trading A/c, Profit & Loss A/c & Balance Sheet

  • Getting Familiar with Tally Prime

  • Fundamentals of Tally Prime

  • How to create company in Tally Prime

  • Working with Ledgers and Groups

  • Recording day to day Entries in Tally Prime

  • Inventory Management in Tally Prime

  • Inventory Masters

  • Inventory Books & Reports

  • How to 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 and Retailers

  • Optional or Quotation vouchers in Tally

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

  • Payroll management in Tally Prime

  • 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

  • Charts

  • Multicategory Chart

  • Static Transpose

  • Find Depreciation of an Asset

  • Logical Functions like IF, IF-Else

  • Text Functions like Find, Replace, Len, Right, Left, MID, Proper, Text, Trim

  • Lookup

  • Subtotal Function

  • Rank Function

  • Rand and Randbetween

  • Sumproduct

  • Choose

  • Format as table

  • Conditional formatting

  • Page setup & Print

  • Freeze Panes

  • Date & Time Functions like Edate, Now, Eomonth, Workday, Weekday,

  • Error Handling with ISBLANK, ISTEXT, ISERROR, ISNUMBER, IFERROR functions

  • 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 Prime + GST with Advance Excel (For Non-commerce)

  • Learn how to prepare the Trial Balance, Trading Account, Profit & Loss Account & Balance Sheet.
  • Learn how to analyze business transaction.
  • Bookkeeping | Rules of recording transactions
  • Introduction of Tally Prime
  • Godown and Stock Creation in Tally Prime
  • Different types of taxes i.e. SGST, CGST, IGST
  • Functions explained in most logical and simplest manner
  • Become more creative, efficient and accurate & Fast in Excel
  • Use of Logical functions like IF Functions, Nested IFs, IF AND, IF OR from Basic IF to complex IF functions.
  • We are learning arrays formula from the basic level and unleashing their extreme advance side gradually.

Get Free Participation Certificate

Take a demo class & get the FREE Certificate

About Tally Prime + GST with Advance Excel (For Non-commerce) Course in

Tally Prime is simple and designed to be used by people from non-IT and non-accounts background as well. Ease of discovering information, consistent options, navigating without the need to remember the paths and much more makes you start using Tally Prime right away. The course content is going to teach students in detail on how to manage accounting, Inventory, orders and payroll in Tally.
Tally is one such course in Accounting that can help you climb your career ladder at a faster pace. We have tried explaining complete information that can be useful for you related to Tally Course. This course is beneficial to every accounting student who wants to have Practical Experience in the subject. The course covers every detail of tally starting from basics to advance. 

We at ISPL Academy dehradun are committed to the mission of providing quality and authoritative training at reasonable cost to trade, industry and other stake holders. We have launched various Courses in computer accountancy; Certificate in Tally Prime, Certificate in Tally Prime and GST, Taxation in Excel courses will give a detailed understanding about basic concepts, rules and terminologies in a simple way.

Learners can attend classes at ISPL Academy where you can get Professional Training from Certified Faculties. We always strive for quality in anything and everything we do. 

Exam & Certification Tally Prime + GST with Advance Excel (For Non-commerce)

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

Frequently Asked Questions

The fee of course Tally Prime + GST + Advance Excel is Rs.15,900/-

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

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

Tally Prime 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