NEW VIDEOS |
EXCEL |
|
Basics of excel |
|
00:00:00 |
|
Format painter |
|
00:00:00 |
|
Wrap text |
|
00:00:00 |
|
Merge and centre |
|
00:00:00 |
|
No borders for table |
|
00:00:00 |
|
No gridlines removes |
|
00:00:00 |
|
Pivot table in excel |
|
00:00:00 |
|
Short cut keys in excel |
|
00:00:00 |
|
Consolidate |
|
00:00:00 |
|
Consolidate |
|
00:00:00 |
|
Conditional formatting with charts & pie charts |
|
00:00:00 |
|
data table charts in excel |
|
00:00:00 |
|
Data tab- goal seek |
|
00:00:00 |
|
Data tab- group, ungroup and sub total |
|
00:00:00 |
TALLY |
|
create company |
|
00:00:00 |
|
OPENING TALLY AND COMPANY CREATION |
|
00:00:00 |
|
Account groups in tally ERP 9 |
|
00:00:00 |
|
Modification, update, alter company details delete company |
|
00:00:00 |
|
Create multiple groups ( multiple groups) |
|
00:00:00 |
|
Ledgers in tally ERP 9 |
|
00:00:00 |
|
Creating a single ledger |
|
00:00:00 |
|
Displaying, altering and deleting ledger accounts |
|
00:00:00 |
|
Creating a current liabilities/ assets ledger |
|
00:00:00 |
|
Creating bank account ledger in tally |
|
00:00:00 |
|
Creating party ledgers ( Sundry debtors and sundry creditors) |
|
00:00:00 |
|
Inventory maintenance in tally |
|
00:00:00 |
|
Inventory / items & goods/ stock |
|
00:00:00 |
|
Capital and revenue items |
|
00:00:00 |
|
Creating a single stock group |
|
00:00:00 |
|
Displaying a stock group |
|
00:00:00 |
|
Modifying, deleting alter a company creation |
|
00:00:00 |
|
Creating a multiple stock group |
|
00:00:00 |
|
subsidiary Books and bank reconciliation statement |
|
00:00:00 |
|
bank reconciliation statement |
|
00:00:00 |
|
Purchase voucher |
|
00:00:00 |
|
Local purchase ( within state) |
|
00:00:00 |
|
Vouchers in tally |
|
00:00:00 |
|
Price levels and price list |
|
00:00:00 |
|
Price levels in tally ERP 9 |
|
00:00:00 |
|
DEF OF SUNDRY CREDITORS, DEBTORS |
|
00:00:00 |
|
Price list in tally ERP 9 |
|
00:00:00 |
|
Use price levels and price list during voucher entry |
|
00:00:00 |
|
Cost centre and cost category |
|
00:00:00 |
|
Creating cost centre and cost category |
|
00:00:00 |
|
Applying cost centre to ledger accounts |
|
00:00:00 |
|
Cost centre allocation in voucher entry |
|
00:00:00 |
|
Depreciation in tally |
|
00:00:00 |
|
Multi currency in tally |
|
00:00:00 |
|
receipt & delivery note in tally |
|
00:00:00 |
|
Godown in tally |
|
00:00:00 |
|
Export data from tally to excel |
|
00:00:00 |
|
Short cut keys in tally |
|
00:00:00 |
|
Creation of stock units of measure |
|
00:00:00 |
|
Simple units of measure |
|
00:00:00 |
|
Creation of single stock items |
|
00:00:00 |
|
Sales voucher with Accounting invoice for service ledger |
|
00:00:00 |
|
Sales return credit-note |
|
00:00:00 |
|
Item invoice mode |
|
00:00:00 |
|
Accounting invoice mode |
|
00:00:00 |
|
Contra vouchers |
|
00:00:00 |
|
Cash withdrawal voucher |
|
00:00:00 |
|
Journal voucher |
|
00:00:00 |
|
Credit-operations in tally |
|
00:00:00 |
|
Bank to bank transactions |
|
00:00:00 |
|
Contra and deposit voucher |
|
00:00:00 |
|
purchase returns in tally |
|
00:00:00 |
|
inventory vouchers |
|
00:00:00 |
|
receipt & delivery note in tally |
|
00:00:00 |
|
GODOWN MAINTAIN PROBLEM-1, AB &CO |
|
00:00:00 |
|
AVODHA Official Telugu YouTube Channel |
|
00:00:00 |
GST |
|
gst notes -what is gst? |
|
00:00:00 |
|
Activate gst for your company |
|
00:00:00 |
|
Activate gst for regular dealers |
|
00:00:00 |
|
Creating GST ledgers. Cgst sgst, igst under duties and taxes group |
|
00:00:00 |
|
Creating sales and purchase ledgers for GST compliance |
|
00:00:00 |
|
Creating a sales ledger Sales ļæ½ļæ½ļæ½ GST / IGST both local and outside state |
|
00:00:00 |
|
Sales invoice with service charges outside state IGST |
|
00:00:00 |
|
list finance full form |
|
00:00:00 |
|
gst purchase with adjustments |
|
00:00:00 |
|
inventory problem |
|
00:00:00 |
|
accounting problem |
|
00:00:00 |
|
Inventory problem 6 with stock groups, items, units of measure |
|
00:00:00 |
|
GST PURCHASE TABLE IN EXCEL |
|
00:00:00 |
Old Videos |
GST IN EXCEL |
|
CREATION OF GST INVOICE IN EXCEL |
|
00:00:00 |
|
Tally new ledgers– loans / advances & assets |
|
00:00:00 |
loans & liabilities |
|
inclusive of tax gst |
|
00:00:00 |
|
practical problem -1 |
|
00:00:00 |
basic concepts 2 |
|
basic concepts of accounting 2 |
|
00:00:00 |
practical problem 2 accounting vouchers |
|
practical problem -2 accounting vouchers |
|
00:00:00 |
practical problem - 3 accounting vouchers |
|
practical prob -3 |
|
00:00:00 |
|
practical prob – 4 voucher mode |
|
00:00:00 |
|
accounting voucher with accounts only problem |
|
00:00:00 |
|
accounts with inventory cgst & sgst prob- 3 |
|
00:00:00 |
|
accounts with inventory with IGST prob – 1 |
|
00:00:00 |
|
multiple rate with gst |
|
00:00:00 |
excel - students marks sheet calculation |
|
students marks sheet in excel |
|
00:00:00 |
|
QUIZ-1 |
|
00:10:00 |
Inventory problem -5 |
|
inventory problem -5 with gst |
|
00:00:00 |
|
inventory problem-6 |
|
00:00:00 |
|
purpose of financial statements and standards |
|
00:00:00 |
|
creating liabilities & assets ledgers |
|
00:00:00 |
|
creating party ledgers sundry creditors & debtors |
|
00:00:00 |
|
creating gst ledgers in tally |
|
00:00:00 |
|
creating purchase & sales ledgers with gst |
|
00:00:00 |
|
inventory problem -7 with gst |
|
00:00:00 |
|
service ledger with gst |
|
00:00:00 |
|
create company |
|
00:00:00 |
configuration (F12) uses |
|
configuration (F12) uses |
|
00:00:00 |
inventory problem 8 |
|
inventory problem 8 |
|
00:00:00 |
|
journalise the following transactions 1 |
|
00:00:00 |
|
Inventory problem 9 |
|
00:00:00 |
|
Uses of excel & new interface of excel |
|
00:00:00 |
|
introduction to business,COMMERCE |
|
00:00:00 |
|
INTRODUCTION TO ACCOUNTS |
|
00:00:00 |
|
difference between Tally erp9 and Tally prime |
|
00:00:00 |
|
ACCOUNTING PRINCIPLES |
|
00:00:00 |
|
ACCOUNTING RULES |
|
00:00:00 |
|
JOURNAL ENTRIES |
|
00:00:00 |
|
practical assignment 1 |
|
00:00:00 |
|
practical assignment 2 |
|
00:00:00 |
|
practical assignment 3 |
|
00:00:00 |
|
difference between manual and computerized accounting |
|
00:00:00 |
|
tally software versions |
|
00:00:00 |
|
tally screen components |
|
00:00:00 |
|
select company |
|
00:00:00 |
|
shut company |
|
00:00:00 |
|
alter company |
|
00:00:00 |
|
security control |
|
00:00:00 |
|
change tally vault password |
|
00:00:00 |
BONUS SECTION |
|
Congrats ! Submit the course completion form. |
|
00:00:00 |