0

  • No products in the cart.

Excel, Tally and GST in Hindi

Course Currilcum

    • Introduction of Excel 00:00:00
    • Entering Data & Saving Workbook 00:00:00
    • Formula Application 00:00:00
    • Worksheet’s Structure 00:00:00
    • Using Find, Replace & Spell Check Options 00:00:00
    • Application of Fonts, background colors, and borders 00:00:00
    • Numbers and Dates Formatting 00:00:00
    • Using Headers & Footers and Repeating Rows 00:00:00
    • Handling Large Workbooks 00:00:00
    • Writing Formula(VERY IMPORTANT) 00:00:00
    • Sumif & Sumifs 00:00:00
    • Count Function 00:00:00
    • Averageif & AverageIfs 00:00:00
    • Change Case (Upper, Lower, Proper) 00:00:00
    • Separating Text on Symmetrical Data 00:00:00
    • Separating Text on Non-Symmetrical Data 00:00:00
    • If Functionality 00:00:00
    • If with AND 00:00:00
    • If with OR 00:00:00
    • If with AND & OR 00:00:00
    • Nested If 00:00:00
    • Vlookup 00:00:00
    • Vlookup -Type of References 00:00:00
    • Vlookup Exact Match 00:00:00
    • Double Vlookup 00:00:00
    • Vlookup on Duplicate Values 00:00:00
    • Vlookup Approximate Match 00:00:00
    • Vlookup with If Condition Vlookup 00:00:00
    • Hlookup 00:00:00
    • Vlookup and Match 00:00:00
    • Match 00:00:00
    • Index & Match 00:00:00
    • AVODHA Official Hindi YouTube Channel 00:00:00
    • How Excel Records Date & Timer 00:00:00
    • Now, Today & Autofill 00:00:00
    • DateValue & TimeValue 00:00:00
    • Calculate Working Days 00:00:00
    • Dated If 00:00:00
    • Loan Calculation (PMT, PPMT, IPMT etc.) 00:00:00
    • Creating a Loan Table 00:00:00
    • Calculate Depreciation 00:00:00
    • Basic Sorting & Shortcut keys 00:00:00
    • Sorting Using Custom List 00:00:00
    • Horizontal Sorting 00:00:00
    • Basic Filter & Shortcut Keys 00:00:00
    • Filter Problem 00:00:00
    • Advanced Filter 00:00:00
    • Advanced Filter Example 00:00:00
    • Understanding pivot Table 00:00:00
    • Using Pivot Table 00:00:00
    • Excel Charts Introduction 00:00:00
    • Types of Charts-1 00:00:00
    • Types of Chart-2 00:00:00
    • Chart Design Tab Options 00:00:00
    • Grouping in Pivot Table 00:00:00
    • Using Slicers 00:00:00
    • Consolidate Data using Excel Inbuilt Function 00:00:00
    • Applying Data Validation 00:00:00
    • Dependent Dropdown List 00:00:00
    • Using Data Validation with Vlookup & Match 00:00:00
    • Other Data Validation Examples 00:00:00
    • Worksheet Level Protection 00:00:00
    • Cell Level Protection 00:00:00
    • Hiding Formulas from Formula Bar 00:00:00
    • Protecting Workbook Structure 00:00:00
    • Workbook Level Protection 00:00:00
    • Protection of workbook – Assignment 4 in Hindi 1 week, 5 days
    • Record your first Macro 00:00:00
    • Record Another Macro 00:00:00
    • Assigning Macros to a Shape, Button, Picture 00:00:00
    • Editing or Deleting a Macro 00:00:00
    • Security Settings of a Macro 00:00:00
    • Introduction 00:00:00
    • How to Create a Company 00:00:00
    • Assignment 2 in Hindi 1 week, 5 days
    • How to Create and Alter Ledger 00:00:00
    • Types Of Vouchers 00:00:00
    • Contra, Receipt and Payment Voucher Entry 00:00:00
    • Journal, Sales and Purchase Voucher Entry 00:00:00
    • Voucher Mode 00:00:00
    • Purchase Order Processing with GST 00:00:00
    • Sales Order Processing with GST 00:00:00
    • Purchase Entry with GST Rate 00:00:00
    • Sales Entry with GST Rate 00:00:00
    • Automatic Round Off Invoice value 00:00:00
    • Bill Wise Accounting in Tally 00:00:00
    • Bills Payable & Receivable Reports 00:00:00
    • Outstanding Checking 00:00:00
    • Banking Transactions 00:00:00
    • Backup of Data 00:00:00
    • Accounting with Inventory 00:00:00
    • Stock Summary Report 00:00:00
    • Stock Category in Detail 00:00:00
    • How to Create Stock Group, Stock Item and Stock Unit 00:00:00
    • Alternate Unit Creation in Tally Prime 00:00:00
    • Compound Unit in Tally Prime 00:00:00
    • Godown Management in Tally Prime 00:00:00
    • Price Level and Price List in Tally Prime_1 00:00:00
    • Price Level and Price List in Tally Prime_2 00:00:00
    • Price Level and Price List in Tally Prime_3 00:00:00
    • Bill of Material in Tally Prime_1 00:00:00
    • Bill of Material in Tally Prime_2 00:00:00
    • Business Started Entry with Cash 00:00:00
    • Inter-State Purchase with GST 00:00:00
    • Central Purchase with GST 00:00:00
    • Discount Received Entry with GST 00:00:00
    • Purchase Entry of Exempted Item_1 00:00:00
    • Purchase Entry of Exempted Item _1 00:00:00
    • Purchase Entry of Exempted Item_2 00:00:00
    • Purchase Return(Debit Note) Entry with GST 00:00:00
    • How to Check GST Purchase Report in Tally 00:00:00
    • Outstanding Report of Bills Payable 00:00:00
    • Intra-State Sale with GST 00:00:00
    • Central Sale with GST 00:00:00
    • Discount Allowed Entry with GST 00:00:00
    • Sale Entry of Exempted Item 00:00:00
    • Sales Return(Credit Note) Entry with GST 00:00:00
    • How to Check GST Sale Report in Tally 00:00:00
    • Outstanding Report of Bills Receivable 00:00:00
    • Cash Sales Entry With GST 00:00:00
    • Assignment 3 in Hindi 2 weeks, 1 day
    • Bank Reconcilation Statement 00:00:00
    • E-Way Bill 00:00:00
    • Freight Charges Accounting in Purchase Invoice 00:00:00
    • Freight Charges Accounting in Sale Invoice 00:00:00
    • Bank Charges Entry with GST 00:00:00
    • Point of Sales Invoice 00:00:00
    • Stock Items with Services Accounting in Single Invoice 00:00:00
    • Lookup function – Assignment 1 in Hindi 1 week, 5 days
    • Inclusive of Tax Accounting 00:00:00
    • Expenses Payable Entry in Tally Prime 00:00:00
    • Nil-Rated, Exempted, Non GST Supply Entry 00:00:00
    • Multi Slab Tax Rates in Stock Item 00:00:00
    • Ineligible Input Tax Credit Entry 00:00:00
    • Fixed Assets Purchase Entry 00:00:00
    • Audit Fees Accounting Entry 00:00:00
    • Capital Goods Entry with GST 00:00:00
    • Import Goods Under GST 00:00:00
    • NEFT,RTGS Payment Entry 00:00:00
    • Customer Turnover in Tally Prime 00:00:00
    • How to Maintain Multiple GSTIN and Address 00:00:00
    • Goods Sold on Finance Accounting 00:00:00
    • Delivery Note Accounting Entry 00:00:00
    • Depreciation Accounting Entry 00:00:00
    • Bad-Debts and Provision for Doubtful Debts Entry 00:00:00
    • Double Discount Entry 00:00:00
    • Cost Category and Cost Centre 00:00:00
    • Cost Centre Class 00:00:00
    • Budget Management for Businesses 00:00:00
    • Backup, Restore and Split of Tally Data 00:00:00
    • Avoid mistake while making entries 00:00:00
    • Basic Excel Internet Research Quiz in Hindi 00:03:00
    • Ledger Group 00:00:00
    • Exception Report 00:00:00
    • How to use Filter Range Option 00:00:00
    • Post-Dated Cheque Entry 00:00:00
    • Discount Entries 00:00:00
    • How to Export-Import Tally Data 00:00:00
    • FINAL TEST Unlimited
    • Congrats! Submit the course completion form 00:00:00
top