0

  • No products in the cart.

Excel, Tally and GST in Telugu

Tally is an accounting financial software package

Course Currilcum

      • Basics of excel 00:00:00
      • Format painter 00:00:00
      • Wrap text 00:00:00
      • Merge and centre 00:00:00
      • No borders for table 00:00:00
      • No gridlines removes 00:00:00
      • Pivot table in excel 00:00:00
      • Short cut keys in excel 00:00:00
      • Consolidate 00:00:00
      • Consolidate 00:00:00
      • Conditional formatting with charts & pie charts 00:00:00
      • data table charts in excel 00:00:00
      • Data tab- goal seek 00:00:00
      • Data tab- group, ungroup and sub total 00:00:00
      • create company 00:00:00
      • OPENING TALLY AND COMPANY CREATION 00:00:00
      • Account groups in tally ERP 9 00:00:00
      • Modification, update, alter company details delete company 00:00:00
      • Create multiple groups ( multiple groups) 00:00:00
      • Ledgers in tally ERP 9 00:00:00
      • Creating a single ledger 00:00:00
      • Displaying, altering and deleting ledger accounts 00:00:00
      • Creating a current liabilities/ assets ledger 00:00:00
      • Creating bank account ledger in tally 00:00:00
      • Creating party ledgers ( Sundry debtors and sundry creditors) 00:00:00
      • Inventory maintenance in tally 00:00:00
      • Inventory / items & goods/ stock 00:00:00
      • Capital and revenue items 00:00:00
      • Creating a single stock group 00:00:00
      • Displaying a stock group 00:00:00
      • Modifying, deleting alter a company creation 00:00:00
      • Creating a multiple stock group 00:00:00
      • subsidiary Books and bank reconciliation statement 00:00:00
      • bank reconciliation statement 00:00:00
      • Purchase voucher 00:00:00
      • Local purchase ( within state) 00:00:00
      • Vouchers in tally 00:00:00
      • Price levels and price list 00:00:00
      • Price levels in tally ERP 9 00:00:00
      • DEF OF SUNDRY CREDITORS, DEBTORS 00:00:00
      • Price list in tally ERP 9 00:00:00
      • Use price levels and price list during voucher entry 00:00:00
      • Cost centre and cost category 00:00:00
      • Creating cost centre and cost category 00:00:00
      • Applying cost centre to ledger accounts 00:00:00
      • Cost centre allocation in voucher entry 00:00:00
      • Depreciation in tally 00:00:00
      • Multi currency in tally 00:00:00
      • receipt & delivery note in tally 00:00:00
      • Godown in tally 00:00:00
      • Export data from tally to excel 00:00:00
      • Short cut keys in tally 00:00:00
      • Creation of stock units of measure 00:00:00
      • Simple units of measure 00:00:00
      • Creation of single stock items 00:00:00
      • Sales voucher with Accounting invoice for service ledger 00:00:00
      • Sales return credit-note 00:00:00
      • Item invoice mode 00:00:00
      • Accounting invoice mode 00:00:00
      • Contra vouchers 00:00:00
      • Cash withdrawal voucher 00:00:00
      • Journal voucher 00:00:00
      • Credit-operations in tally 00:00:00
      • Bank to bank transactions 00:00:00
      • Contra and deposit voucher 00:00:00
      • purchase returns in tally 00:00:00
      • inventory vouchers 00:00:00
      • receipt & delivery note in tally 00:00:00
      • GODOWN MAINTAIN PROBLEM-1, AB &CO 00:00:00
      • AVODHA Official Telugu YouTube Channel 00:00:00
      • gst notes -what is gst? 00:00:00
      • Activate gst for your company 00:00:00
      • Activate gst for regular dealers 00:00:00
      • Creating GST ledgers. Cgst sgst, igst under duties and taxes group 00:00:00
      • Creating sales and purchase ledgers for GST compliance 00:00:00
      • Creating a sales ledger Sales – GST / IGST both local and outside state 00:00:00
      • Sales invoice with service charges outside state IGST 00:00:00
      • list finance full form 00:00:00
      • gst purchase with adjustments 00:00:00
      • inventory problem 00:00:00
      • accounting problem 00:00:00
      • Inventory problem 6 with stock groups, items, units of measure 00:00:00
      • GST PURCHASE TABLE IN EXCEL 00:00:00
        • CREATION OF GST INVOICE IN EXCEL 00:00:00
        • Tally new ledgers– loans / advances & assets 00:00:00
        • inclusive of tax gst 00:00:00
        • practical problem -1 00:00:00
        • basic concepts of accounting 2 00:00:00
        • practical problem -2 accounting vouchers 00:00:00
        • practical prob -3 00:00:00
        • practical prob – 4 voucher mode 00:00:00
        • accounting voucher with accounts only problem 00:00:00
        • accounts with inventory cgst & sgst prob- 3 00:00:00
        • accounts with inventory with IGST prob – 1 00:00:00
        • multiple rate with gst 00:00:00
        • students marks sheet in excel 00:00:00
        • QUIZ-1 00:10:00
        • inventory problem -5 with gst 00:00:00
        • inventory problem-6 00:00:00
        • purpose of financial statements and standards 00:00:00
        • creating liabilities & assets ledgers 00:00:00
        • creating party ledgers sundry creditors & debtors 00:00:00
        • creating gst ledgers in tally 00:00:00
        • creating purchase & sales ledgers with gst 00:00:00
        • inventory problem -7 with gst 00:00:00
        • service ledger with gst 00:00:00
        • create company 00:00:00
        • configuration (F12) uses 00:00:00
        • inventory problem 8 00:00:00
        • journalise the following transactions 1 00:00:00
        • Inventory problem 9 00:00:00
        • Uses of excel & new interface of excel 00:00:00
        • introduction to business,COMMERCE 00:00:00
        • INTRODUCTION TO ACCOUNTS 00:00:00
        • difference between Tally erp9 and Tally prime 00:00:00
        • ACCOUNTING PRINCIPLES 00:00:00
        • ACCOUNTING RULES 00:00:00
        • JOURNAL ENTRIES 00:00:00
        • practical assignment 1 00:00:00
        • practical assignment 2 00:00:00
        • practical assignment 3 00:00:00
        • difference between manual and computerized accounting 00:00:00
        • tally software versions 00:00:00
        • tally screen components 00:00:00
        • select company 00:00:00
        • shut company 00:00:00
        • alter company 00:00:00
        • security control 00:00:00
        • change tally vault password 00:00:00
        • Short cut keys in excel Quiz 00:10:00
        • Congrats ! Submit the course completion form. 00:00:00
      top