0

  • No products in the cart.

Course Curriculum

  • Learning Google Drive for Assignments & More in Kannada 2 weeks, 6 days
  • Real Number Assignment -11 in Kannada 1 week, 5 days
  • Google Sheets & Forms Assignment – 12 in Kannada 1 week, 5 days
  • Tally Assignment – 13 in Kannada 1 week, 5 days
    • Introduction of Excel 00:00:00
    Job Acceleration Program (JAP)
    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
    Chalo INDIA Startup Drive
    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
    Data Types 00:00:00
    Formulas for Arithmetic Operators 00:00:00
    AVODHA Official Kannada YouTube Channel 00:00:00
    Functions
    Functions-1 00:00:00
    Functions-2 00:00:00
    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
    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
    Learning Internet Tools
    Introduction to Google Sheets 00:00:00
    Google Sheets & Add-ons 00:00:00
    Maximising Forms using Sheets 00:00:00
    Continuing with Functions
    Left() Right() and Mid() Functions 00:00:00
    Len & Search 00:00:00
    Concatenate 00:00:00
    Introduction to Commerce
    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
    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
    Basics of ERP9
    Tally Data Processing Structure 00:00:00
    Tally Data Processing Structure2 00:00:00
    Accounts Management Installments Bills Receivables and Payables
    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
    Tally with Banking
    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
    Tally with GST
    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 Common Portal - Online Lectures
    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
    Tally with TDS
    Recording TDS Transaction in Tally.ERP9 00:00:00
    Supply and Non-supply vouchers
    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
    Sales management
    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
    Manufacturing and Production Management
    Standard Manufacturing Practicals in Tally.ERP9 00:00:00
    Branch wise Accounts
    Cost Centres in Tally.ERP9 (Departments Handling) 00:00:00
    Branch-Wise Accounts-Using Cost Centers & Godowns in Tally.ERP9 00:00:00
    Tally Audit
    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
    Tally ERP9 Adjustments
    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
    Payroll ��� in Tally.ERP9 Introduction to Steps 00:00:00
    Payroll-Complete Setup Monthly Process & Stop Computation – Overall Coverage 00:00:00
    Tally Prime
    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
    Accounts with Inventory
    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
    Getting Started with GST(Goods)
    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
    Getting Started with GST(Goods)
    GST Tax Payment 00:00:00
    Recording Advanced Entries(Goods)
    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
    Getting Started with GST(Services)
    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
    Recording Advanced Entries(Services)
    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
    Composition Dealer
    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
    QUIZ SECTION
    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
    BONUS SECTION
    Congrats ! Submit the course completion form. 00:00:00
    top