Course Details
Tally
- Accounting in Tally ERP 9 of Real GST Purchase,Sales and Expense Bill
- Understanding Different GST and TDS Features
- Billing through Tally of Tax Invoices,Bill of Supply and Revised Invoice
- Generating GST Reports from Tally like GSTR1,GSTR2 and GSTR3B after Clearing Mismatch
- Debtor Aging in Tally ERP and Cost Center Reporting in Tally
- Inventory and Godown Maintenance in Tally
- Manufacturing Company Features in Tally
- Use of Different Tally Shortcuts
- Accounting in Tally of TDS Payable and Receivable Transactions
- Bank Statement Accounting in Tally and Preparing Bank Reconciliation Statement
- How to check different errors in Tally and Export Data
- How to E-Mail Copy and Reload and Backup Tally Data
Advanced Excel
Practical Assignments in Application of Advanced Excel formulas in different situations
- Basic Excel and Excel Shortcuts
- V-lookup and H-lookup
- Pivot tables, Goal Seek and Simple Macros
- If Command, Nested If
- Count if, Sum if and Filters etc
- Mixed Excel Assignments