-
Advance Excel 2013
- Advanced File Tasks
- Working with Formulas and Functions
- Managing Tables in Microsoft Excel
- Data Tools in Excel
- Sparkline
- Grouping & Outlining and Subtotals
- What-If Analysis
- Advanced PivotTables & Charts
- Advanced Excel Tasks
- Creating HLOOKUP and VLOOKUP Functions
- Advanced Conditional Formatting
- Advanced PivotTables & ChartsAdvanced Lookup Functions
- Advanced Functions in Excel
- Bill-wise Details, Cost/Profit Center Management
- Credit Period/Trade Discount/Cash Discount
- Cost Centers and Cost Categories
- Voucher Classes and cost center class
- Multiple Currencies
- Interest Calculation
- Bank Reconciliation
- Cheque Printing
- Budgets and Controls
- Scenario Management
- About Goods and Services Tax (GST)
- Activating Tally in GST
- Setting Up GST (Company Level, Ledger Level or Inventory Level)
- GST Taxes & Invoices
- Understanding SGST, CGST & IGST
- Creating GST Masters in Tally
- Updating GST Number for Suppliers
- Practical on Intra-State Purchase Entry in GST (SGST + CGST)
- Practical on Inter-State Purchase Entry in GST (IGST)
- GST Purchase Entry for Unregistered Dealer in Tally
- Accounting for return of Goods (With Credit Notes)
- Reverse Charge Mechanism Entry for GST in Tally
- Sales Voucher with GST
- Updating GST Number for Suppliers
- Practical on Intra-State Sales Entry in GST (SGST + CGST)
- Practical on Inter-State Sales Entry in GST (IGST)
- Accounting for return of Goods (With Credit Notes)
- GST in Services
- Basic of Services ( Accounts only)
- Creating Masters?
- Recording Transactions
- Tax Deducted at Source (TDS)
- Understanding TDS
- Creating TDS Masters
- Practical Examples
- TDS Payment
- Tax Reports and Tax Forms
- Utilities in Tally ERP 9
- Multi Language
- Data Backup and Restore
- Data Security & Audit
- Invoice Printing In Tally ERP 9
- Sales Invoice
- Printing Payment and Receipt Vouchers
- Printing Various Other Reports Module
- Logo Printing on Sales Invoice
Advanced Accounting in Tally.ERP9
Goods and Services Tax (GST)
Purchase Voucher with GST