Getting Into MS Excel |
|
Introduction to Excel |
|
00:00:00 |
Job Acceleration Program (JAP) |
|
Knowing JAP |
|
00:00:00 |
|
Elaborating JAP |
|
00:00:00 |
Data |
|
Data Types |
|
00:00:00 |
|
Formulas for Arithmetic Operators |
|
00:00:00 |
Chalo INDIA |
|
All About Chalo INDIA Startup Drive |
|
00:00:00 |
|
AVODHA Official Malayalam 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 – 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 Up Excel-8 (Functions) |
|
00:00:00 |
|
Speeding Up Excel-9 (Dates) |
|
00:00:00 |
|
Excel Extended Practicals -1 |
|
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 |
Basics of ERP9 |
|
Tally Data Processing Structure |
|
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 |
|
Recording GST Transactions – Assets I with Input Tax Credit I without ITC |
|
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 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 |
|
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 |
|
Genarate E-Way Bills Creation, Alter & Cancellation Online/ Offline methods |
|
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 |
|
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 Overview Introduction-2 |
|
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 |
Accounts with Inventory |
|
Stock Group -Create,Alter,Delete |
|
00:00:00 |
Costing in Tally Prime |
|
Cost Category Creation,Alteration,Deletion |
|
00:00:00 |
|
Cost Centre Creation, Alteration, Deletion. |
|
00:00:00 |
|
Stock Items-Create,Alter,Delete |
|
00:00:00 |
|
Job Costing |
|
00:00:00 |
|
Accounting And Inventory Management |
|
00:00:00 |
Getting Started with GST(Goods) |
|
Cost Centre Class Creation |
|
00:00:00 |
|
Enabling GST and Defining Tax Details |
|
00:00:00 |
|
Intrastate Supply of Goods |
|
00:00:00 |
|
Interstate Supply of Goods |
|
00:00:00 |
|
Return of Goods(Purchase and Sales Returns) |
|
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 |
|
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 |
|
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 |
|
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 |
|
Interstate Purchase and sales 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 |
Quiz Section |
|
Tally Installation & General Quiz In Malayalam |
|
00:09:00 |
|
Function-1 Quiz In Malayalam |
|
00:01:00 |
|
Getting into Commerce Quiz In Malayalam |
|
00:04:00 |
|
Tally Groups & Ledgers Quiz In Malayalam |
|
Unlimited |
|
Data Types Quiz In Malayalam |
|
00:01:00 |
|
Basic Excel Internet Research Quiz In Malayalam |
|
00:03:00 |
|
Introduction Quiz In Malayalam |
|
00:02:00 |
|
Excel Concatenate Functions Quiz In Malayalam |
|
00:00:30 |
|
Introduction to Commerce for Accounting Quiz In Malayalam |
|
00:02:00 |
|
Intermediate Excel Quiz -1 In Malayalam |
|
00:02:00 |
|
Intermediate Excel Quiz -2 In Malayalam |
|
00:01:00 |
|
Basic Excel Quiz 2 In Malayalam |
|
00:01:00 |
|
Functions-2 Quiz In Malayalam |
|
00:01:00 |
|
Intermediate Excel Quiz-3 In Malayalam |
|
00:01:00 |
|
Excel Mid Term Quiz In Malayalam |
|
00:03:00 |
|
QUIZ 1 |
|
00:10:00 |
|
QUIZ – 2 |
|
00:10:00 |
|
QUIZ – 3 |
|
00:10:00 |
|
QUIZ 4 |
|
00:10:00 |
|
QUIZ -5 |
|
00:10:00 |
|
QUIZ – 6 |
|
00:10:00 |
BONUS SECTION |
|
Final Test |
|
Unlimited |
|
Congrats ! Submit the course completion form. |
|
00:00:00 |