0

  • No products in the cart.

Advanced Excel, Tally and GST in Malayalam

Course Currilcum

  • Excel, Tally, Gst 00:19:05
  • Data 00:37:32
  • Data Types – Part 1 Unlimited
  • Formulas for Arithmetic Operators Unlimited
  • Functions-1 00:32:03
  • Functions-2 00:31:55
  • Speeding up Excel – 1 00:36:22
  • Speeding up Excel – 2 00:27:09
  • Short Cut Keys Part 1 00:26:41
  • Short Cut Keys Part 2 00:27:31
  • Short Cut Keys Part 3 00:40:28
  • Short Cut Keys Part 4 00:31:33
  • Short Cut Keys Part 5 00:24:33
  • Short Cut Keys Part 6 00:27:44
  • Short Cut Keys Part 7 00:36:45
  • Short Cut Keys Part 8 00:31:54
  • Important Shortcut Keys Overall 00:22:48
  • Government Challan – Part 1 00:34:41
  • Government Challan – Part 2 00:39:25
  • V – LOOKUP 00:24:28
  • DGET Function 00:34:14
  • What is commerce | Introduction 00:56:26
  • Accounting System | Accounting 00:57:58
  • Journal, Ledger, Trial Balance Part 1 00:32:07
  • Journal, Ledger, Trial Balance Part 2 00:50:40
  • Journal, Ledger, Trial Balance Part 3 00:40:44
  • Trading, Profit & Loss a/c and Balance Sheet Part 1 00:42:21
  • Trading, Profit & Loss a/c and Balance Sheet Part 2 00:33:56
  • Trading, Profit & Loss a/c and Balance Sheet Part 3 00:40:58
  • Quiz-1 00:02:00
  • Tally.ERP9 – Download , Install , Activation Unlimited
  • Opening Tally & Company Creation 00:31:41
  • Groups & Ledgers Unlimited
  • Understanding Tally Pre-defined Vouchers Unlimited
  • Quiz-2 00:02:00
  • Tally Data Processing Structure 00:27:35
  • Accounts Management Installments Bills Receivables and Payables 00:32:37
  • Understanding Installments/OutStanding Concept 00:25:04
  • Recording & Maintaining Installments in Tally.ERP9 I Billwise Accounts 00:26:48
  • Recording & Maintaining Supply against Advances – Advances Management 00:27:13
  • Tracking OverDue Supply – Credit Sales 00:26:29
  • Cheque Book Configuration in Tally.ERP9 00:25:05
  • Post Dated Cheques Management in Tally.ERP9 I PDC’s 00:26:26
  • Transaction Types 00:29:54
  • Bank Reconciliation In in Tally.ERP9 I Case Study 2 00:40:33
  • Function Keys 00:37:05
  • Quiz-3 00:02:00
  • GST Revenue Sharing Ratios between Center & State Govt’s 00:36:17
  • GST Classifications – Part 1 00:00:00
  • Recording GST Transactions Unlimited
  • GST Tax Invoice Configuration – Voucher Numbering – Sales Unlimited
  • GST tax Invoice Configuration, Auto Billing – purchase Unlimited
  • GST Tax Invoice, Bank Details-Cus Seal &Signature, Jurisdiction -Printing Confinguration Unlimited
  • Rate Inclusive of GST I Enabling Item Description in Tally.ERP9 Unlimited
  • Recording GST Transactions – Assets I with Input Tax Credit I without ITC Unlimited
  • Quiz-4 00:02:00
  • Recording GST Transactions – Services Part 1 00:25:23
  • Recording GST Transactions-Services-Part2 Unlimited
  • Recording GST Transactions – Expenses with & without Input Tax Credit 00:40:30
  • Recording GST transactions-Expenses with or without ITC-Part2 Unlimited
  • Recording GST Transactions – Sales with Additional Expenditure 00:35:24
  • GST- Recording RCM in Tally.ERP9 Unlimited
  • GST Recording RCM in Tally ERP 9-1 Unlimited
  • GST Recording RCM in Tally ERP 9-2 00:28:28
  • Genarate E-Way Bills Creation, Alter & Cancellation Online/ Offline methods Unlimited
  • Quiz-5 00:02:00
  • GST Common Portal – Online Lectures 00:30:34
  • GST Overview Introduction 00:32:29
  • GST Overview Introduction – 1 Unlimited
  • Key Points about GST Council Unlimited
  • Introduction to GST Returns Unlimited
  • GSTR – 3B Filing Unlimited
  • GSTR-1 Filing ( GST-Regular) Offline / Online Methods Explained with Live Data 00:51:11
  • GST Overview Introduction-2 00:31:51
  • GST Registration – Filing Clarifications Unlimited
  • GST Registration – Tracking Submitted Applications Unlimited
  • Viewing Submitted Applications – GST Registration Unlimited
  • GST Registration – Core Field Amendments Unlimited
  • GST Registration – Non-Core Field Amendments Unlimited
  • GST Application for Refund Unlimited
  • GST Tax Practitioner Registration Unlimited
  • Opting / Withdrawal of Composition Levy in GST Portal Unlimited
  • GST Transactions Assets with or without ITC Unlimited
  • Quiz-6 00:02:00
  • Recording TDS Transaction in Tally.ERP9 00:29:20
  • Supply and Non-supply vouchers 00:12:23
  • Purchase Returns & Sales Returns in Tally.ERP9 00:38:45
  • Delivery Notes & Receipt Notes in Tally.ERP9 00:23:43
  • Sales Orders/Quotations in Tally.ERP9 00:30:12
  • Sales management 00:28:46
  • Tally.ERP9 Discounts I TradeDiscounts & Cash Discounts 00:51:54
  • PriceList’s in Tally.ERP9 I Party Level & Product Level 00:30:07
  • Auto-Interest Calculation on Overdue Installments 00:32:08
  • Manufacturing and Production Management 00:35:12
  • Standard Manufacturing Practicals in Tally.ERP9 00:35:40
  • Branch wise Accounts 00:31:49
  • Cost Centres in Tally.ERP9 (Departments Handling) 00:28:14
  • Branch-Wise Accounts-Using Cost Centers & Godowns in Tally.ERP9 00:26:09
  • Tally Audit 00:27:19
  • Bill Voucher Unlimited
  • Multi User Creation in Tally.ERP9 Unlimited
  • Security , Password for Users in Tally.ERP9 Unlimited
  • Tally Internal Data Verification & Tally Audit Unlimited
  • Tally ERP9 Adjustments 00:34:50
  • Recording – Year End Adjustments in Tally.ERP9 00:01:39
  • Capital Adjustments I Drawings Adjustments & Closing I Profit Sharing I Split Unlimited
  • Payroll in Tally ERP9 00:23:36
  • Payroll – in Tally.ERP9 Introduction to Steps Unlimited
  • Payroll-Complete Setup Monthly Process & Stop Computation – Overall Coverage Unlimited
  • Downloading &Installing Tally Prime 00:25:44
  • Opening Tally Prime, Create,Alter,Delete Company in Tally Prime 00:48:49
  • Create,Alter,Delete Ledger Groups in Tally Prime. 00:24:09
  • Create ,Alter,Delete Ledgers in Tally Prime. 00:26:28
  • Accounting Vouchers in Tally Prime 00:23:31
  • Voucher Type Creation 00:21:34
  • Accounts with Inventory 00:23:27
  • Stock Group -Create,Alter,Delete 00:25:01
  • Costing in Tally Prime 00:13:51
  • Cost Category Creation,Alteration,Deletion 00:20:43
  • Cost Centre Creation, Alteration, Deletion. 00:11:01
  • Stock Items-Create,Alter,Delete 00:01:55
  • Job Costing – Part 1 00:33:21
  • Accounting And Inventory Management 00:26:34
  • Cost Centre Class Creation 00:23:03
  • Enabling GST and Defining Tax Details 00:28:37
  • Intrastate Supply of Goods 00:33:41
  • Interstate Supply of Goods 00:01:16
  • Return of Goods(Purchase and Sales Returns) 00:38:10
  • E-Way Bill 00:36:36
  • Supplies Inclusive of Tax 00:16:51
  • Defining GST Rates at Master and Transaction Level 00:42:02
  • GST Reports 00:39:55
  • Input Tax Credit Set Off 00:51:04
  • Getting Started with GST(Goods) 00:26:17
  • GST Tax Payment 00:44:55
  • Recording Advanced Entries(Goods) 00:31:31
  • Purchases from Composition Dealer 00:52:22
  • Exports 00:28:18
  • Imports 00:30:20
  • Supply of Goods to Sez 00:37:25
  • Supply of Exempted Goods 00:33:35
  • Advance Receipts and Payments 00:27:10
  • Getting Started with GST(Services) 00:48:32
  • Activation of GST and defining tax at company level 00:40:24
  • Intrastate supply of services 00:28:21
  • Interstate Purchase and sales of services 00:31:35
  • Cancellation of Services 00:29:21
  • Recording Advanced Entries(Services) 00:18:05
  • Accounting Multiple Services in a Single Supply 00:28:26
  • Recording Outward Supply with Additional Expenses 00:31:33
  • B2C Supply of Services 00:31:43
  • Exempt supply of services under GST 00:25:20
  • Composition Dealer 00:25:16
  • Intrastate Inward Supply 00:26:19
  • Interstate inward supply for composition dealer 00:32:54
  • Quiz-7 00:02:00
  • Quiz-8 00:02:00
  • Excel Interface & Overview; 00:34:48
  • AI Introduction: Using ChatGPT & Excel Copilot 00:38:20
  • AI-based Excel Help (formula suggestions, explanations) 00:28:00
  • Excel Syntax 00:43:43
  • Ranges 00:32:14
  • Move, Add & Delete 00:29:36
  • Data Types – Part 2 00:21:06
  • Data Validation 00:23:57
  • AI Use Case – Part 1 00:26:04
  • Auto-generate sample datasets using AI 00:32:10
  • Arithmetic Operators (+, −, *, /, Parentheses) 00:28:39
  • Excel Formulas 00:26:28
  • Relative & Absolute References 00:23:12
  • Natural-language to Formula conversion 00:39:36
  • Error detection using AI 00:30:37
  • Speeding up Excel (Part 1 & 2) 00:46:39
  • Shortcut Keys (Basic to Advanced) 00:59:55
  • Flash Fill 00:28:53
  • Linking Worksheets & Workbooks 00:34:17
  • Protecting Sheets & Cells 00:32:10
  • AI Automation 00:09:03
  • IF, IFS, AND 00:37:18
  • SUM, SUMIF, SUMIFS 00:31:42
  • LEFT, RIGHT, MID, LEN, SEARCH, CONCAT 00:31:59
  • AI Use Case: AI-recommended functions 00:35:03
  • Pivot Tables 00:31:28
  • Charts (Bar, Column, Pie, Line, Stacked) 00:11:40
  • Chart Customization 00:29:50
  • Conditional Formatting 00:30:27
  • Sorting 00:32:19
  • Filtering 00:32:03
  • AI Integration 00:33:49
  • Auto-insights & AI-driven chart suggestions 00:17:32
  • Introduction to Google Sheets 00:23:22
  • Add-ons & Automation 00:28:59
  • Google Forms Integration 00:32:15
  • Smart formulas 00:29:32
  • AI-powered data cleaning 00:24:45
  • Mini Project 00:33:44
  • AI-Based Excel Dashboard for Business Reporting 00:28:18
  • Introduction to Commerce 00:15:58
  • Accounting Systems 00:29:12
  • Journal 00:22:43
  • Ledger 00:26:14
  • Trial Balance 00:27:10
  • Trading Account 00:25:48
  • Profit 00:23:42
  • Loss Account 00:08:11
  • Balance Sheet 00:28:29
  • AI explanations of accounting entries 00:28:02
  • Auto-checking journal accuracy 00:25:00
  • Install & Activate Tally Prime 00:26:48
  • Company Creation 00:26:12
  • Groups 00:09:11
  • Ledgers 00:27:28
  • Voucher Types 00:22:51
  • Accounting Vouchers 00:20:55
  • AI Use Case – Part 2 00:18:36
  • ChatGPT as Tally Learning Assistant 00:40:00
  • Bill-wise Accounting – Part 1 00:30:46
  • Installments & Outstanding Management 00:28:04
  • Banking (Cheque, PDC, Bank Reconciliation) 00:28:45
  • Cost Centres 00:32:48
  • Cost Categories 00:30:50
  • Inventory 00:29:57
  • Manufacturing 00:14:32
  • Payroll 00:34:47
  • AI Integration: Error detection 00:25:02
  • AI-generated audit insights 00:31:54
  • GST Overview & Council 00:31:26
  • GST Registration 00:31:16
  • GST Classifications – Part 2 00:24:58
  • Intrastate 00:31:33
  • AI Use Case: GST concept clarification using AI chatbots 00:31:01
  • Enabling GST 00:29:27
  • Tax Configuration; 00:21:26
  • GST Transactions (Goods & Services) 00:26:28
  • Input Tax Credit (ITC) 00:29:44
  • RCM Transactions 00:29:35
  • E-Way Bill Generation 00:27:03
  • GST Returns (GSTR-1, GSTR-3B) 00:32:16
  • AI Integration: Auto-classification 00:26:23
  • GST deadline reminders 00:17:41
  • Imports & Exports 00:21:31
  • SEZ Transactions 00:24:46
  • Advance Receipts & Payments 00:26:00
  • Exempt & Nil-rated Supplies 00:17:29
  • AI Use Case: AI-based compliance checklist 00:19:41
  • Excel Basics & Interface Navigation 00:23:38
  • Excel Ribbon & Toolbars 00:33:44
  • Cell Referencing & Formatting 00:28:57
  • Data Entry, Sorting & Filtering 00:29:45
  • Basic Formulas & Functions 00:27:51
  • Installation & Setup 00:24:01
  • Company Creation & Security 00:23:32
  • Data Backup & Restore 00:22:52
  • Accounting Principles & Terminology 00:36:22
  • Journal, Ledger, Trial Balance 00:30:33
  • Final Accounts (P&L, Balance Sheet) 00:34:50
  • ERP Concepts & Business Workflows 00:25:28
  • Ledgers, Groups & Voucher Entries 00:25:18
  • Bank & Cash Transactions 00:24:47
  • Bill-wise Accounting – Part 2 00:27:34
  • Accounts Payable & Receivable 00:24:23
    • Logical Functions: IF, AND, OR, IFERROR 00:32:34
    • Lookup Functions: VLOOKUP, HLOOKUP, XLOOKUP 00:36:19
    • Text Functions: LEFT, RIGHT, MID, CONCATENATE 00:46:23
    • Date & Time Functions 00:26:54
    • Financial Functions: PMT, NPV, IRR 00:29:16
    • Creating Pivot Tables & Pivot Charts 00:28:24
    • Power Pivot & Advanced Data Modeling 00:31:48
    • Creating Interactive Financial Dashboards 00:28:38
    • Using Conditional Formatting & Charts 00:26:07
    • Recording & Running Macros 00:34:59
    • Automating Data Entry & Reports 00:28:09
    • GST Configuration & Registration 00:29:35
    • GST Invoices, Payments & Returns 00:39:31
    • GST Input/Output Adjustments 00:36:00
    • E-Way Bill & Online GST Filing 00:31:06
    • TDS Configuration & Deduction 00:26:37
    • TDS Return Filing (Form 26Q, 27Q) 00:34:34
    • Income Tax Computation in Tally 00:19:43
    • Employee Database & Salary Structure 00:32:20
    • PF, ESI, Professional Tax Handling 00:29:44
    • Interest Calculations & Loans in Tally 00:28:34
    • Connecting Excel & Tally Data 00:27:33
    • Data Cleaning & Transformation 00:27:44
    • Creating Interactive BI Dashboards 00:31:18
    • SQL Queries for Financial Data 00:31:34
    • Automated Report Generation 00:25:35
    • Excel-based Financial Forecasting 00:28:28
    • Cloud-based Excel & Tally Solutions 00:24:55
    • Inventory Management in Excel & Tally 00:30:43
    • Real-world Business Accounting Project 00:24:05
    • Tax Audit Simulation in Tally 00:26:41
    • Financial Analysis using Excel 00:30:30
    • Advanced Tally & Excel Final Project 00:25:20
top