No products in the cart.
Course Curriculum
| 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 | ||