fbpx
0

  • No products in the cart.

Excel, Tally and GST in Tamil

Course Currilcum

    • Elaborating JAP 00:00:00
    • Knowing JAP 00:00:00
    • All about Chalo India Startup Drive 00:00:00
    • INTRODUCTION ON ACCOUNTING BASICS 00:00:00
    • ACCOUNTING TERMINOLOGIES 00:00:00
    • ACCOUNTING CONCEPTS AND CONVENTIONS 00:00:00
    • GOLDEN RULES OF ACCOUNTING 00:00:00
    • RECORDING OF TRANSACTIONS: JOURNAL, LEDGER AND TRIAL BALANCE 00:00:00
    • EXAMPLES ON RECORDING OF TRANSACTIONS 00:00:00
    • FINANCIAL STATEMENTS: TRADING, PROFIT AND LOSS ACCOUNT AND BALANCE SHEET 00:00:00
    • EXAMPLES ON FINANCIAL STATEMENTS 00:00:00
    • REVISION ON THE ACCOUNTING BASICS 00:00:00
    • DOWNLOADING, INSTALLATION AND LICENSING IN TALLY 00:00:00
    • OPENING TALLY AND COMPANY CREATION 00:00:00
    • ASSIGNMENTS ON COMPANY CREATION in Tamil Unlimited
    • ACCOUNTING MASTERS – GROUPS AND LEDGERS: CREATION, ALTERATION AND DELETION OF SINGLE AND MULTIPLE LEDGERS AND GROUPS 00:00:00
    • ASSIGNMENTS ON ACCOUNTING MASTERS in Tamil Unlimited
    • INVENTORY MASTERS : STOCK ITEM, STOCK CATEGORY, STOCK GROUP, GODOWN AND UNITS: CREATION, ALTERATION AND DELETION 00:00:00
    • ASSIGNMENTS ON INVENTORY MASTERS in Tamil Unlimited
    • ACCOUNTING VOUCHERS – I 00:00:00
    • ACCOUNTING VOUCHERS – II 00:00:00
    • VOUCHER CLASS, INVENTORY VOUCHERS 00:00:00
    • BUSINESS CASE STUDY – I 00:00:00
    • BUSINESS CASE STUDY – II 00:00:00
    • BUSINESS CASE STUDY – III 00:00:00
    • ASSIGNMENT ON ACCOUNTING VOUCHERS AND INVENTORY VOUCHERS in Tamil 1 week, 5 days
    • BANK RECONCILIATION STATEMENT 00:00:00
    • BUSINESS CASE STUDY – IV 00:00:00
    • CHEQUE PRINTING 00:00:00
    • DEPOSIT SLIP 00:00:00
    • PAYMENT ADVICE 00:00:00
    • CHEQUE REGISTER 00:00:00
    • POSTDATED CHEQUE MANAGEMENT 00:00:00
    • ASSIGNEMENTS IN TALLY WITH BANKING FEATURES in Tamil 1 week, 5 days
    • RECEIVABLES AND PAYABLE MANAGEMENT – I : MAINTAINING BILL WISE DETAILS, TYPES OF REFERENCES, OUTSTANDING REPORTS 00:00:00
    • RECEIVABLES AND PAYABLE MANAGEMENT – II : CREDIT LIMITS, BILLS SETTLEMENT AND AGEING REPORTS 00:00:00
    • BUSINESS CASE STUDY – V 00:00:00
    • PURCHASE ORDER MANAGEMENT 00:00:00
    • SALE ORDER MANAGEMENT 00:00:00
    • PRECLOSURE OF ORDERS 00:00:00
    • REORDER LEVEL 00:00:00
    • BUSINESS CASE STUDY – VI 00:00:00
    • ASSIGNMENTS IN ORDER MANAGEMENT in Tamil Unlimited
    • COSTCENTRES AND COST CATEGORIES, ALLOCATION OF COST CENTRES ON VOUCHERS 00:00:00
    • COST CENTRE REPORTS 00:00:00
    • BUSINESS CASE STUDY – VII 00:00:00
    • ASSIGNMENTS ON COST/PROFIT CENTRES MANAGEMENT in Tamil Unlimited
    • ASSIGNMENTS ON JOURNAL, LEDGER, TRIAL BALANCE AND FINANCIAL STATEMENTS in Tamil Unlimited
    • INTRODUCTION, ACTIVATION, TRANSACTION WITH ADDITONAL COST DETAILS 00:00:00
    • BUSINESS CASE STUDY – VIII 00:00:00
    • ASSIGNMENTS ON ADDITIONAL COST in Tamil Unlimited
    • ACTIVATION, TRANSACTION ON BATCH WISE IN PURCHASE AND SALE VOUCHER, EXPIRED BUDGETS AND REPORTS 00:00:00
    • ACTIVATION OF PRICE LISTS AND DEFINING PRICE LEVELS, CREATION, USAGE AND REVISING OF PRICE LISTS 00:00:00
    • BUSINESS CASE STUDY – IX 00:00:00
    • ASSIGNMENTS ON BATCHWISE ACCOUNTING AND PRICE LEVELS in Tamil Unlimited
    • INTRODUCTION, ACTIVATION, CREATION OF BUDGETS AND REPORTS 00:00:00
    • BUSINESS CASE STUDY – VIII 00:00:00
    • ASSIGNMENTS ON BUDGETS in Tamil Unlimited
    • INTRODUCTION, SECURITY CONTROL, ACTIVATION, CREATION OF SECURITY LEVELS, CREATION OF USERS, CHANGE USERS 00:00:00
    • BUSINESS CASE STUDY – IX PART 2 00:00:00
    • ASSIGNMENTS ON DATA SECURITY in Tamil Unlimited
    • INTRODUCTION , BACK UP, RESTORE OF DATA, REPAIR AND MIGRATION 00:00:00
    • ASSIGNMENTS ON BACKUP AND RESTORE in Tamil Unlimited
    • INTRODUCTION 00:00:00
    • EXPORT AND IMPORT OF DATA. 00:00:00
    • EXPORT AND IMPORT OF TRANSACTIONS FROM ONE COMPANY TO ANOTHER IN XML FORMAT 00:00:00
    • EXPORTING OF DATA IN OTHER AVAILABLE FORMATS 00:00:00
    • EXPORTING OF REPORTS IN EXCEL. 00:00:00
    • BUSINESS CASE STUDY – X 00:00:00
    • ASSIGNMENT ON EXPORTS AND IMPORTS in Tamil Unlimited
    • ACCOUNTING REPORTS AND PRINTING 00:00:00
    • BUSINESS CASE STUDY – XI 00:00:00
    • ASSIGNMENTS ON REPORTING AND PRINTING in Tamil Unlimited
    • USING MULTI CURRENCIES ON TALLY 00:00:00
    • BUSINESS CASE STUDY – XII 00:00:00
    • ASSIGNMENT 17 – FOREX MANAGEMENT (1) Unlimited
    • BUSINESS CASE STUDY – XIII 00:00:00
    • ASSIGNMENTS ON DISCOUNT AND INTEREST Unlimited
    • BUSINESS CASE STUDY – XIV 00:00:00
    • ASSIGNMENTS ON AUDIT Unlimited
    • JOB WORK IN ORDER, OUT ORDER, ACTIVATION, PROCESS AND REPORTS 00:00:00
    • BUSINESS CASE STUDY – XV 00:00:00
    • ASSIGNMENTS ON JOB WORK Unlimited
    • INTRODUCTION 00:00:00
    • E-WAY BILL 00:00:00
    • EWAY BILL IMPORTANT POINTS 00:00:00
    • E-WAY BILL – NOTIFICATION HIGHLIGHTS 00:00:00
    • E-INVOICING 00:00:00
    • HIERARCHY OF APPLYING TAX RATE DETAILS 00:00:00
    • ENABLING GST AND DEFINING TAX DETAILS 00:00:00
    • Quiz 2 – Introduction on Tally software 00:05:00
    • RECORDING GST TRANSACTIONS 00:00:00
    • ACCOUNTING INTRASTATE SUPPLY OF GOODS AND SERVICES 00:00:00
    • ACCOUNTING INTERSTATE SUPPLY OF GOODS AND SERVICES 00:00:00
    • Inter state and Intra state purchase of goods 00:00:00
    • Other Transactions 00:00:00
    • INPUT TAX CREDIT SET OFF 00:00:00
    • GST TAX PAYMENT 00:00:00
    • PAYMENT OF GST 00:00:00
    • Quiz 1 – Basics of Accounting 00:05:00
    • MODES OF PAYMENT 00:00:00
    • CHALLAN RECONCILIATION 00:00:00
    • GSTR-1 00:00:00
    • GSTR-3B 00:00:00
    • QUIZ ON GST – PART 1 00:20:00
    • EXPORT FOR E-WAY BILL REPORT 00:00:00
    • Composition Dealer – Introduction 00:00:00
    • Conditions to be satisfied for Composition Scheme 00:00:00
    • Quiz 3 – Accounting Masters 00:05:00
    • ENABLING GST AND DEFINING TAX DETAILS 00:00:00
    • ACCOUNTING INTRASTATE SUPPLY OF GOODS AND SERVICES 00:00:00
    • GST TAX PAYMENT 00:00:00
    • GENERATING GSTR-4 RETURN IN TALLY 00:00:00
    • Quiz 4 – Inventory Masters 00:05:00
    • INTRODUCTION 00:00:00
    • BASIC CONCEPTS OF TDS 00:00:00
    • TDS IN TALLY 00:00:00
    • ACTIVATION OF TDS FEATURE IN TALLY 00:00:00
    • TDS STATUTORY MASTERS 00:00:00
    • CONFIGURING TDS AT GROUP LEVEL 00:00:00
    • QUIZ ON TDS 00:20:00
    • CHANGES IN TDS RATES FROM 14TH MAY 2020 00:00:00
    • CONFIGURING TDS AT LEDGER LEVEL 00:00:00
    • BOOKING OF EXPENSES IN PURCHASE VOUCHER 00:00:00
    • EXPENSES PARTLY SUBJECT TO TDS 00:00:00
    • BOOKING EXPENSES AND DEDUCTING TDS LATER 00:00:00
    • ACCOUNTING MULTIPLE EXPENSES AND DEDUCTING TDS LATER 00:00:00
    • Quiz – 5 – Quiz on Vouchers 00:05:00
    • TDS ON EXPENSES AT LOWER AND ZERO RATE 00:00:00
    • TDS ON EXPENSES AT LOWER RATE 00:00:00
    • TDS ON EXPENSES AT ZERO RATE 00:00:00
    • TDS ON EXPENSES AT HIGHER RATE 00:00:00
    • RECORDING TRANSACTION WHEN TDS EXEMPTION LIMIT IS CROSSED 00:00:00
    • GENERATING TDS CHALLAN (ITNS 281) 00:00:00
    • FORM 26Q 00:00:00
    • ASSIGNMENT ON TDS in Tamil Unlimited
    • Introduction 00:00:00
    • Features of Tally 00:00:00
    • Downloading the installable software 00:00:00
    • Installing Tally 00:00:00
    • Types of Licenses 00:00:00
    • Working in Educational Mode 00:00:00
    • Getting Started with Tally 00:00:00
    • Navigate from anywhere to anywhere 00:00:00
    • Shortcut Keys on Reports 00:00:00
    • Voucher Shortcut keys and others 00:00:00
    • Company Creation and setting up Company Features 00:00:00
    • Configuration 00:00:00
    • Introduction 00:00:00
    • Chart of Accounts 00:00:00
    • Sample Chart of Accounts of a company 00:00:00
    • Creation of Masters in Tally 00:00:00
    • Accounting Masters 00:00:00
    • Inventory Masters 00:00:00
    • Alteration of Masters in Tally 00:00:00
    • Display of Chart of Accounts in Tally 00:00:00
    • ACCOUNTING MASTERS – GROUPS AND LEDGERS: CREATION, ALTERATION AND DELETION OF SINGLE AND MULTIPLE LEDGERS AND GROUPS 00:00:00
    • INVENTORY MASTERS : STOCK ITEM, STOCK CATEGORY, STOCK GROUP, GODOWN AND UNITS: CREATION, ALTERATION AND DELETION 00:00:00
    • ACCOUNTING VOUCHERS – I 00:00:00
    • ACCOUNTING VOUCHERS – II 00:00:00
    • VOUCHER CLASS, INVENTORY VOUCHERS 00:00:00
    • BUSINESS CASE STUDY – I 00:00:00
    • BUSINESS CASE STUDY – II 00:00:00
    • BUSINESS CASE STUDY – III 00:00:00
    • BANK RECONCILIATION STATEMENT 00:00:00
    • BUSINESS CASE STUDY – IV 00:00:00
    • CHEQUE PRINTING 00:00:00
    • DEPOSIT SLIP 00:00:00
    • PAYMENT ADVICE 00:00:00
    • CHEQUE REGISTER 00:00:00
    • POSTDATED CHEQUE MANAGEMENT 00:00:00
    • RECEIVABLES AND PAYABLE MANAGEMENT – I : MAINTAINING BILL WISE DETAILS, TYPES OF REFERENCES, OUTSTANDING REPORTS 00:00:00
    • RECEIVABLES AND PAYABLE MANAGEMENT – II : CREDIT LIMITS, BILLS SETTLEMENT AND AGEING REPORTS 00:00:00
    • BUSINESS CASE STUDY – V 00:00:00
    • PURCHASE ORDER MANAGEMENT 00:00:00
    • SALE ORDER MANAGEMENT 00:00:00
    • PRECLOSURE OF ORDERS 00:00:00
    • REORDER LEVEL 00:00:00
    • BUSINESS CASE STUDY – VI 00:00:00
    • COSTCENTRES AND COST CATEGORIES, ALLOCATION OF COST CENTRES ON VOUCHERS 00:00:00
    • COST CENTRE REPORTS 00:00:00
    • BUSINESS CASE STUDY – VII 00:00:00
    • INTRODUCTION, ACTIVATION, TRANSACTION WITH ADDITONAL COST DETAILS 00:00:00
    • BUSINESS CASE STUDY – VIII 00:00:00
    • ACTIVATION, TRANSACTION ON BATCH WISE IN PURCHASE AND SALE VOUCHER, EXPIRED BUDGETS AND REPORTS 00:00:00
    • ACTIVATION OF PRICE LISTS AND DEFINING PRICE LEVELS, CREATION, USAGE AND REVISING OF PRICE LISTS 00:00:00
    • BUSINESS CASE STUDY – IX 00:00:00
    • INTRODUCTION, ACTIVATION, CREATION OF BUDGETS AND REPORTS 00:00:00
    • BUSINESS CASE STUDY ON BUDGETS 00:00:00
    • INTRODUCTION, SECURITY CONTROL, ACTIVATION, CREATION OF SECURITY LEVELS, CREATION OF USERS, CHANGE USERS 00:00:00
    • BUSINESS CASE STUDY ON DATA SECURITY 00:00:00
    • INTRODUCTION ON EXPORT AND IMPORT OF DATA. 00:00:00
    • EXPORT AND IMPORT OF TRANSACTIONS FROM ONE COMPANY TO ANOTHER 00:00:00
    • ACCOUNTING REPORTS AND PRINTING 00:00:00
    • INVENTORY REPORTS AND PRINTING 00:00:00
    • BUSINESS CASE STUDY – XI 00:00:00
    • USING MULTI CURRENCIES ON TALLY 00:00:00
    • BUSINESS CASE STUDY ON FOREX MANAGMENT 00:00:00
    • GST THEORY – PART 1 00:00:00
    • GST THEORY – PART 2 00:00:00
    • GST THEORY – PART 3 00:00:00
    • REVERSE CHARGE MECHANISM (RCM) 00:00:00
    • COMPOSITION SCHEME 00:00:00
    • Function-1 Quiz in Tamil 00:03:00
    • Activation of GST on Tally Prime 00:00:00
    • Update Sales and Purchase Ledgers for GST 00:00:00
    • Creation of GST Ledgers 00:00:00
    • Creation of Party Ledgers 00:00:00
    • GST Classifications in TallyPrime 00:00:00
    • Update service ledger for GST 00:00:00
    • ]Ledgers For Expenses, Incomes, Non-Revenue Accounts, Invoice Rounding Under GST 00:00:00
    • Update Stock Items and Stock Groups for GST 00:00:00
    • Hierarchy of tax calculation – l 00:00:00
    • Hierarchy of Tax Calculation – II 00:00:00
    • Purchases Transactions Under GST – I 00:00:00
    • Purchases Transactions Under GST – II 00:00:00
    • Purchases Transactions Under GST – III 00:00:00
    • Sales Transactions Under GST – I 00:00:00
    • Sales Transactions Under GST – II 00:00:00
    • Sales Transactions Under GST – III 00:00:00
    • GST Adjustment Transactions 00:00:00
    • GST Reports – Part 1 00:00:00
    • GST Reports – Part 2 00:00:00
    • Introduction to Excel 00:00:00
    • Data Types 00:00:00
    • DATA TYPES 00:00:00
    • FORMULAS FOR ARITHMETIC OPERATORS 00:00:00
    • FUNCTIONS (I) 00:00:00
    • FUNCTIONS (II) 00:00:00
    • FUNCTIONS (III) 00:00:00
    • PIVOT TABLES 00:00:00
    • Intermediate Excel Quiz -1 in Tamil 00:02:00
    • CONDITIONAL FORMATTING 00:00:00
    • Functions-1 00:00:00
    • Functions-2 00:00:00
    • Data Types Quiz In Tamil 00:03:00
    • Data Entry for Practice 00:00:00
    • Speeding up Excel ��� 1 00:00:00
    • Speeding up Excel-2 00:00:00
    • Speeding up Excel-3 00:00:00
    • Speeding up Excel-4 00:00:00
    • Speeding up Excel-5 00:00:00
    • Speeding Up Excel -6 00:00:00
    • Speeding Up Excel-7 (Cells) 00:00:00
    • Speeding Excel -8 00:00:00
    • Speeding Up Excel-9 (Dates) 00:00:00
    • Excel Extended Practicals -1 00:00:00
    • Getting into Forms in Excel ��� Part 1 00:00:00
    • Functions-2 Quiz in Tamil 00:03:00
    • Getting into Forms in Excel ��� Part 2 00:00:00
    • Getting into Forms in Excel ��� Part 3 00:00:00
    • Finalising our Form in Excel ��� 4 00:00:00
    • General Excel Learning ��� 1 00:00:00
    • General Excel Learning ��� 2 00:00:00
    • General Excel Learning ��� 3 00:00:00
    • Intermediate Excel Quiz -2 In Tamil 00:03:00
    • General Excel Learning ��� 4 00:00:00
    • Indian Rupee Symbol in Excel 00:00:00
    • General Excel Learning-5 00:00:00
    • V LOOK UP 00:00:00
    • VLOOKUP Functions & its Uses-1 00:00:00
    • VLOOKUP Function & its Uses-2 00:00:00
    • VLOOKUP Function& its Uses-3 00:00:00
    • VLOOKUP Function & its Uses-4 00:00:00
    • VLOOKUP Function & its Uses-5 00:00:00
    • VLOOKUP Function & its Uses-6 00:00:00
    • VLOOKUP Function & its Uses-7 00:00:00
    • VLOOKUP Function & its Uses-8 00:00:00
    • H LOOK UP 00:00:00
    • Intermediate Excel Quiz-3 In Tamil 00:03:00
    • Introduction to Google Sheets 00:00:00
    • Google Sheets & Add-ons 00:00:00
    • Excel Concatenate Functions Quiz in Tamil 00:02:00
    • Maximising Forms using Sheets 00:00:00
    • Google Sheets & Forms Assignment in Tamil Unlimited
    • Left() Right() and Mid() Functions 00:00:00
    • Len & Search 00:00:00
    • Concatenate 00:00:00
    • Speeding Excel Assignment-9 in Tamil Unlimited
    • Quiz on Excel 00:10:00
    • FINAL TEST Unlimited
    • Congrats ! Submit the course completion form. 00:00:00
top