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
Tally Prime 25 Topics
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
GST (Goods & Service Tax) 18 Topics
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
Essential Excel 18 Topics
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
Advance Excel 30 Topics
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.
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.
Frequently Asked Questions
What is the fee of Tally Prime + GST + Advance Excel (For Non-commerce)?
The fee of course Tally Prime + GST + Advance Excel is Rs.15,900/-
What is the duration of course Tally Prime + GST + Advance Excel (For Non-Commerce)?
Tally Prime + GST + Advance Excel is a short-term course of 4 months.
What topics are covered in Tally Prime + GST + Advance Excel (For Non-commerce)?
This course covers Accounting Theory, Tally & GST (Goods & Services Tax) and Advance Excel.
What is Tally Prime + GST + 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.