0

  • No products in the cart.

Excel, Tally and GST in Kannada

Course Currilcum

    • Introduction of Excel 00:00:00
    • Knowing JAP 00:00:00
    • Elaborating JAP 00:00:00
    • Entering Data & Saving Workbook 00:00:00
    • Formulas Application 00:00:00
    • Worksheet’s Structure 00:00:00
    • Using Find, Replace & Spell Check Options 00:00:00
    • AVODHA Official Kannada YouTube Channel 00:00:00
    • All about Chalo India Startup drive 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 00:00:00
    • Sum & Sumif 00:00:00
    • Count Function 00:00:00
    • Average & AverageIf 00:00:00
    • Change Case 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
    • Hlookup 00:00:00
    • Match 00:00:00
    • Vlookup and Match 00:00:00
    • Index & Match 00:00:00
    • Now, Today & Autofill 00:00:00
    • Calculate Working Days 00:00:00
    • Dated If 00:00:00
    • Introduction to Excel 00:00:00
    • Data Types 00:00:00
    • Formulas for Arithmetic Operators 00:00:00
    • AVODHA Official Kannada YouTube Channel 00:00:00
    • Functions-1 00:00:00
    • Functions-2 00:00:00
    • Learning Google Drive for Assignments & More in Kannada 2 weeks, 6 days
    • Data Entry for Practice 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
    • Excel Extended Practicals ��� 2 00:00:00
    • Getting into Forms in Excel ��� Part 1 00:00: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
    • Real Number Assignment -11 in Kannada 1 week, 5 days
    • General Excel Learning – 1 00:00:00
    • General Excel Learning ��� 2 00:00:00
    • Printing a Worksheet / Workbook in MS Excel? 00:00:00
    • General Excel Learning – 3 00:00:00
    • General Excel Learning – 4 00:00:00
    • Indian Rupee Symbol in Excel 00:00:00
    • General Excel Learning-5 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 & its Functions ��� 5 00:00:00
    • VLOOKUP & it���s Functions ��� 6 00:00:00
    • VLOOKUP & it’s Functions – 7 00:00:00
    • VLOOKUP & it���s Functions ��� 8 00:00:00
    • Introduction to Google Sheets 00:00:00
    • Google Sheets & Add-ons 00:00:00
    • Maximising Forms using Sheets 00:00:00
    • Google Sheets & Forms Assignment – 12 in Kannada 1 week, 5 days
    • Left() Right() and Mid() Functions 00:00:00
    • Len & Search 00:00:00
    • Concatenate 00:00:00
    • What is commerce | Introduction| Accounting System| Accounting 00:00:00
    • Introduction to Commerce ��� Part 2 00:00:00
    • Double Entry Accounting Systems 00:00:00
    • Double Entry Accounting Problem ��� Part 1 00:00:00
    • Double Entry Accounting Problem – Part 2 00:00:00
    • Tally.ERP9 ��� Download , Install , Activation 00:00:00
    • Opening Tally & Company Creation 00:00:00
    • Groups & Ledgers 00:00:00
    • Understanding Tally Pre-defined Vouchers 00:00:00
    • Job Costing 00:00:00
    • Tally Data Processing Structure 00:00:00
    • Tally Data Processing Structure2 00:00:00
    • Understanding Installments/OutStanding Concept 00:00:00
    • Recording & Maintaining Installments in Tally.ERP9 I Billwise Accounts 00:00:00
    • Recording & Maintaining Supply against Advances ��� Advances Management 00:00:00
    • Tracking OverDue Supply ��� Credit Sales 00:00:00
    • Cheque Book Configuration in Tally.ERP9 00:00:00
    • Post Dated Cheques Management in Tally.ERP9 I PDC���s 00:00:00
    • Transaction Types 00:00:00
    • Bank Reconciliation In in Tally.ERP9 I Case Study 2 00:00:00
    • Function Keys 00:00:00
    • GST Revenue Sharing Ratios between Center & State Govt���s 00:00:00
    • GST Classifications 00:00:00
    • Recording GST Transactions 00:00:00
    • GST Tax Invoice Configuration – Voucher Numbering – Sales 00:00:00
    • GST tax Invoice Configuration, Auto Billing – purchase 00:00:00
    • GST Tax Invoice, Bank Details-Cus Seal &Signature, Jurisdiction -Printing Confinguration 00:00:00
    • Rate Inclusive of GST I Enabling Item Description in Tally.ERP9 00:00:00
    • Setting MRP Details 00:00:00
    • Recording GST Transactions – Services Part 1 00:00:00
    • Recording GST Transactions-Services-Part2 00:00:00
    • Recording GST Transactions – Assets I with Input Tax Credit I without ITC 00:00:00
    • Recording GST Transactions-Assets with or without ITC-Part2 00:00:00
    • Recording GST Transactions ��� Expenses with & without Input Tax Credit 00:00:00
    • Recording GST transactions-Expenses with or without ITC-Part2 00:00:00
    • Recording GST Transactions – Sales with Additional Expenditure 00:00:00
    • Genarate E-Way Bills Creation, Alter & Cancellation Online/ Offline methods 00:00:00
    • GST- Recording RCM in Tally.ERP9 00:00:00
    • GST Recording RCM in Tally ERP 9-1 00:00:00
    • GST Recording RCM in Tally ERP 9-2 00:00:00
    • Activity 00:00:00
    • ACTIVITY 2 00:00:00
    • shortcut keys 00:00:00
    • GST Overview Introduction 00:00:00
    • GST Overview Introduction ��� 1 00:00:00
    • GST Overview Introduction-2 00:00:00
    • Key Points about GST Council 00:00:00
    • Introduction to GST Returns 00:00:00
    • GSTR ��� 3B Filing 00:00:00
    • GSTR-1 Filing ( GST-Regular) Offline / Online Methods Explained with Live Data 00:00:00
    • GST Registration ��� Filing Clarifications 00:00:00
    • GST Registration ��� Tracking Submitted Applications 00:00:00
    • Viewing Submitted Applications ��� GST Registration 00:00:00
    • GST Registration ��� Core Field Amendments 00:00:00
    • GST Registration ��� Non-Core Field Amendments 00:00:00
    • GST Application for Refund 00:00:00
    • GST Tax Practitioner Registration 00:00:00
    • Opting / Withdrawal of Composition Levy in GST Portal 00:00:00
    • GST Transactions Assets with or without ITC 00:00:00
    • Recording TDS Transaction in Tally.ERP9 00:00:00
    • Purchase Returns & Sales Returns in Tally.ERP9 00:00:00
    • Delivery Notes & Receipt Notes in Tally.ERP9 00:00:00
    • Sales Orders/Quotations in Tally.ERP9 00:00:00
    • Tally.ERP9 Discounts I TradeDiscounts & Cash Discounts 00:00:00
    • PriceList���s in Tally.ERP9 I Party Level & Product Level 00:00:00
    • Auto-Interest Calculation on Overdue Installments 00:00:00
    • Standard Manufacturing Practicals in Tally.ERP9 00:00:00
    • Cost Centres in Tally.ERP9 (Departments Handling) 00:00:00
    • Tally Assignment – 13 in Kannada 1 week, 5 days
    • Branch-Wise Accounts-Using Cost Centers & Godowns in Tally.ERP9 00:00:00
    • Bill Voucher 00:00:00
    • Multi User Creation in Tally.ERP9 00:00:00
    • Security , Password for Users in Tally.ERP9 00:00:00
    • Tally Internal Data Verification & Tally Audit 00:00:00
    • Recording – Year End Adjustments in Tally.ERP9 00:00:00
    • Capital Adjustments I Drawings Adjustments & Closing I Profit Sharing I Split 00:00:00
    • Payroll ��� in Tally.ERP9 Introduction to Steps 00:00:00
    • Payroll-Complete Setup Monthly Process & Stop Computation – Overall Coverage 00:00:00
    • Downloading &Installing Tally Prime 00:00:00
    • Opening Tally Prime, Create,Alter,Delete Company in Tally Prime 00:00:00
    • Create,Alter,Delete Ledger Groups in Tally Prime. 00:00:00
    • Create ,Alter,Delete Ledgers in Tally Prime. 00:00:00
    • Accounting Vouchers in Tally Prime 00:00:00
    • Voucher Type Creation 00:00:00
    • Voucher Type Creation Part – 2 00:00:00
    • Stock Group -Create,Alter,Delete part-1 00:00:00
    • Stock Group -Create,Alter,Delete part-2 00:00:00
    • Costing in Tally Prime 00:00:00
    • Cost Category Creation,Alteration,Deletion 00:00:00
    • Cost Centre Creation, Alteration, Deletion. 00:00:00
    • Stock Items-Create,Alter,Delete 00:00:00
    • Cost Centre Class Creation 00:00:00
    • Job costing 00:00:00
    • Accounting And Inventory Management part 1 00:00:00
    • Accounting And Inventory Management Part – 2 00:00:00
    • Enabling GST and Defining Tax Details 00:00:00
    • Intrastate Supply of Goods part 1 00:00:00
    • Interstate Supply of Goods part 2 00:00:00
    • Intrastate Supply of Goods Part – 3 00:00:00
    • Return of Goods(Purchase and Sales Returns) 00:00:00
    • Return of Goods(Purchase and Sales Returns) Part – 2 00:00:00
    • E-Way Bill 00:00:00
    • Supplies Inclusive of Tax 00:00:00
    • Defining GST Rates at Master and Transaction Level 00:00:00
    • Defining GST Rates at Master and Transaction Level Part – 2 00:00:00
    • GST Reports 00:00:00
    • Input Tax Credit Set Off 00:00:00
    • GST Tax Payment 00:00:00
    • Purchases from Composition Dealer 00:00:00
    • Purchases from Unregistered Dealer 00:00:00
    • Exports 00:00:00
    • Imports 00:00:00
    • Supply of Goods to Sez 00:00:00
    • Supply of Exempted Goods 00:00:00
    • Advance Receipts and Payments 1 00:00:00
    • Advance Receipts and Payments Part – 2 00:00:00
    • Advance Receipts and Payments Part – 3 00:00:00
    • Mixed Supply and Composite Supply under GST 00:00:00
    • Activation of GST and defining tax at company level 00:00:00
    • Intrastate supply of services 00:00:00
    • Cancellation of Services 00:00:00
    • Accounting Multiple Services in a Single Supply 00:00:00
    • Recording Outward Supply with Additional Expenses 00:00:00
    • B2C Supply of Services 00:00:00
    • Exempt supply of services under GST 00:00:00
    • Intrastate Inward Supply 00:00:00
    • Interstate inward supply for composition dealer 00:00:00
    • Interstate Purchase and sales of services 00:00:00
    • Notes 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
    • Understanding pivot Table 00:00:00
    • Using Pivot Table 00:00:00
    • Excel Charts Introduction 00:00:00
    • How to Create a Chart 00:00:00
    • Link a Chart Title 00:00:00
    • How to Show Axis Title 00:00:00
    • How to Show Data Label 00:00:00
    • Column Chart 00:00:00
    • Bar Chart 00:00:00
    • Line Chart 1 00:00:00
    • Area Chart 00:00:00
    • Pie Chart 00:00:00
    • Pie of Pie or Bar of Pie Chart 00:00:00
    • Line Chart with Log Scale 00:00:00
    • Modifying Chart & Plot Area 00:00:00
    • Modifying 3-D Charts 00:00:00
    • Creating a Chart Templates 00:00:00
    • Creating Picture Charts 00:00:00
    • Modifying Data Series 00:00:00
    • Bubble Chart 00:00:00
    • How to handle Missing Data 00:00:00
    • Applying Data Validation 00:00:00
    • Dependent Dropdown List 00:00:00
    • Protecting Workbook Structure 00:00:00
    • Introduction Quiz in Kannada 00:05:00
    • Data Types Quiz in Kannada 00:03:00
    • Function-1 Quiz in Kannada 00:05:00
    • Functions-2 Quiz in Kannada 00:03:00
    • Basic Excel Internet Research Quiz in Kannada 00:03:00
    • Basic Excel Quiz in Kannada 00:02:00
    • Intermediate Excel Quiz – 1 in Kannada 00:03:00
    • Intermediate Excel Quiz -2 in Kannada 00:02:00
    • Intermediate Excel Quiz-3 in Kannada 00:03:00
    • Excel Concatenate Functions Quiz in Kannada 00:05:00
    • Excel Mid Term Quiz in Kannada 00:03:00
    • Introduction to Commerce for Accounting Quiz in Kannada 00:03:00
    • Getting into Commerce Quiz 00:04:00
    • Tally Installation & General Quiz in Kannada 00:02:00
    • Tally Company Creation Quiz in Kannada 00:02:00
    • Tally Groups & Ledgers Quiz in Kannada 00:02:00
    • Congrats ! Submit the course completion form. 00:00:00
top