EXCEL DAY 4 (23 MARCH) | SP EDUSKILLS

Autoplay
Autocomplete

Previous Lesson Complete and Continue

TAX PRACTITIONER COURSE (All In One)

ITRODUCTION SESSION

INTRO SESSION (64:24)

HOW TO DECIDE FEES & CREATE VISITING CARD

HOW TO DECIDE FEES-1 (81:12)
HOW TO DECIDE FEES & MAKE VISITING CARD (72:36)
DOCUMENTS LIST FOR DIFFERENT WORKS

BUSINESS TYPES

ALL ABOUT- SOLE PROPRIETORSHIP (68:28)
ALL ABOUT- PARTNERSHIP FIRM (92:03)
HUF- HINDU UNDIVIDED FAMILY (32:10)
LLP & COMPANY (35:27)
DIFFERENT TYPES OF PERSONS IN TAXATION (Summary of Above) (77:54)

REGISTRATIONS & LICENSE - COURSE

TAN APPLICATION (28:36)
PAN CARD APPLICATION (25:50)
PAN CARD -2 (28:01)
SHOPACT- UPTO 9 EMPLOYEES (63:39)
SHOPACT - FOR 10 AND MORE EMPLYEES (55:39)
CHANGES IN SHOPACT (17:50)
UDYAM REGISTRATION/ MSME (27:31)
FOOD LICENSE AND TAN APPLICATION (77:45)
PF ESIC REGISTRATION (72:34)
PARTNERSHIP FORMATION (65:27)
PT REGISTRATION (57:52)
RENT AGREEMENT (NOTARISED) (56:24)
RENT AGREEMENT ( ONLINE REGISTERED) (71:07)
DIGITAL SIGNATURE (DSC) (39:09)
IEC CODE (IMPORT EXPORT LICENSE) (42:02)
GST PRACTITIONER REGISTRATION (24:52)

GST (GOODS & SERVICE TAX) - COURSE

GST BASIC CONCEPTS (85:24)
GST BSIC CONCEPT-1 (77:15)
GST BASIC CONCEPTS -2 (95:35)
GST PORTAL OVERVIEW (UPDATED) (57:51)
GST PRACTITIONER REGISTRATION (GSTP) (24:52)
GST REGISTRATION (91:28)
GST REGISTARTION CLASS 2 (60:22)
GST REGISTRATION- QUERY BY DEPARTMENT / CLARIFICATION (11:56)
PROCESS AFTER GST REGGISTRATION APPROVAL (FIRST TIME LOGIN) (6:25)
GST AMENDMENT/CHANGES (CORE/NON CORE DETAILS) (11:31)
GST- BUSINESS PLACE/ADDRESS CHANGE (28:44)
GST TYPES & COMPUTATION (UPDATED) (70:12)
RCM - Reverse Charge Mechanism (42:30)
GSTR 1 (BASIC CONCEPTS AND FILING ON PORTAL) (80:05)
GSTR 1 (WITH OFFLINIE UTILITY) (76:44)
GSTR 1 ( TALLY PRIME) (73:52)
GST- IFF RETURNS, GSTR 3B OVERVIEW (68:22)
GSTR 2A/2B ITC RECONCILIATION (79:01)
ITC RULES (INPUT TAX CREDIT) (49:51)
ITC SETOFF RULES AND GSTR 3B (87:59)
GSTR 3B (COMPUTATION, FILING, CHALLAN PAYMENT) (58:58)
GSTR 3B CLASS 1 (60:26)
GSTR 3B- CLASS 2 (95:02)
GTSTR 3B- CLASS 3 (64:06)
COMPOSITION SCHEME- CMP 08 (QRTLY PAYMENT) (37:12)
GSTR 10, CMP-08 FOR COMPOSITION (65:41)
EWAY BILL (47:59)
EXPORT & LUT (44:27)
GST ANNUAL RETURN (GSTR 9) OVERVIEW (61:47)
GST ANNUAL RETURN (GSTR 9) CLASS 2 (114:03)
DRC 03 (28:27)
GST NOTICES- 1 (56:04)
GST NOTICES-2 (50:08)
GST SUSPENSION AND CANCELLATION- REASONS AND REVOCATION (77:52)
GST CANCELLATION APPLICATION AND FINAL RETURN (GSTR 10) (72:53)

GST EXTRA SESSIONS

GST COMPUTATION 09 FEB 24 (90:01)
GST COMPUTATION 2 -SETOFF/ CREDIT-DEBIT NOTE (103:09)
GSTR RETURNS DUE DATES - 17 FEB 24 (88:43)
GST DUE DATES, LATE FEE AND ITC RULES (89:53)
GST RETURNS ON PORTAL (1 MARCH) (92:02)
GST RETURNS ON PORTAL 2 (75:28)
GSTR 1 WITH OFFLINE TOOL (08 MARCH) (86:17)

INCOME TAX COURSE - NEW FY 23-24

IMP FILES
INCOME TAX -BASIC- DAY 1 (24 MAY) (87:12)
INCOME TAX- BASIC- DAY 2 (25 MAY) (103:03)
SALARY INCOME-BASIC DAY 3 (31 MAY) (95:46)
SALARY INCOME- FORM 16 DAY 4 (1 JUNE) (81:27)
INCOME FROM HOUSE-PROPERTY (5 JULY) (73:32)
PGBP (BUSINESS) INCOME - BASIC 1 (7 JUNE) (88:39)
PGBP (BUSINESS) INCOME 44AD/44ADA/44AE CONCEPTS (9 JUNE) (94:59)
DEDUCTIONS UNDER OLD & NEW TAX REGIME (4 JULY) (106:30)
INCOME TAX- FOR PARTNERSHIP (BASIC) (68:01)
ITR-1 FILING ONLINE (14 JUNE) (109:27)
ITR-1 FILING CLASS 2 (15 JUNE) (75:54)
CAPITAL GAIN -1 (21 JUNE) (88:46)
CAPITAL GAIN -2 (22 JUNE) (85:16)
CAPITAL GAIN - SHARES & MUTUAL FUND (83:55)
ITR 2 ONLINE FILING (SALARY + CAPITAL GAIN) 28 JUNE (103:10)
ITR 4 ONLINE FILING (44AD) 29 JUNE (108:47)
INCOME TAX FOR - SHARES F&O AND INTRA DAY TRADING (07 JULY) (95:16)
SET OFF AND CARRY FORWARD OF LOSSES (86:47)
ITR 3- ONLINE FILING (SALARY+CG+F&O) (113:51)
ITR 3- ONLINE FILING (BUSINESS+CG+F&O) CLASS 1 (90:38)
ITR 3- ONLINE FILING (BUSINESS+CG+F&O) CLASS 2 (107:34)
ITR 4= 44AD/44 ADA- DISCUSSION (96:20)
ITR 5- PARTNERSHIP/LLP CLASS 1 (97:55)
ITR 5 - ONLINE FILING CLASS 2 (99:46)
WHAT IS BELATED, REVISE RETURN & DEFECTIVE NOTICE (69:45)
ADVANCE INCOME TAX (49:27)
UPDATED RETURN (ITR U) - CLASS 1 (88:06)
UPDATED RETURN (ITR U) - CLASS 2 (97:15)
INCOME TAX- NOTICES (57:25)
ITR 3 FILING- THROUGH COMPUTAX SOFTWARE (104:21)
BUDGET 2024 - CHANGES IN TAXATION (FY 24-25 AY 25-26) (59:22)
COMPUTAX SOFTWARE DEMO & DEFECTIVE NOTICE U/S 139(9) 10 AUGUST 2024 (93:26)

TDS (UPDATED)

TDS - SESSION 1 (BASIC CONCEPTS) (53:49)
TDS - SESSION 2(BASIC CONCEPTS SECTIONS) (58:38)
TAN APPLICATION- FOR TDS (28:36)
TDS - DUE DATES, LATE FEE AND INTEREST CALCULATION (80:48)
TDS WORKING - FOR RETURNS (64:12)
TDS RETURN PREPARATION - THROUGH UTILITY (FVU,27A) (90:38)
TDS RETURN FILING/UPLOAD (58:08)
TDS NILL RETURN/ NON FILING STATMENT (2:58)
TDS CERTIFICATE REQUEST AND DOWNLOAD (FROM TRACES) (26:11)
TCS AND SPECIAL SECTIONS (40:55)
TRACES OVERVIEW AND TDS CORRECTION -1 (49:18)
TDS CORRECTION-2 AND QUESTIONS (51:54)
194-IA TDS ON PROPERTY (72:23)

TRADEMARK COURSE

TRADEMARK CLASS - 1 (55:55)
TRADEMARK CLASS-2 (35:47)
TRADEMARK CLASS-3 (54:08)

PROFESSIONAL TAX RETURNS (PT) - COURSE

PTEC & PTRC BASIC CONCEPTS (82:54)
PTEC & PTRC REVISION AND PAYMENT, RETURN FILING (107:37)

TALLY PRIME

TALLY PRIME CLASS-1 (69:34)
TALLY PRIME CLASS-2 (63:20)
TALLY PRIME CLASS-3 (67:22)
TALLY PRIME CLASS-4 (Ledger creation, receipt, voicher) (60:08)
TALLY PRIME CLASS- GST (57:40)
TALLY PRIME CLASS- TDS (49:06)
TALLY PRIME CLASS- BANK RECONCILIATION (58:57)
TALLY PRIME CLASS- DATA IMPORT-EXPORT,COST CENTRE (55:12)
TALLY PRIME- ADJUSTMENT ENTRIES, PURCHASE & SALE ORDERS (74:34)

ACCOUNTING WITH TALLY PRIME

ACCOUNTING WITH TALLY PRIME -1 (BASIC ACCOUNTING) (51:19)
ACCOUNTING WITH TALLY PRIME - 2 (COMPANY CREATION AND LEDGERS) (65:44)
CLASS 3 - SALE PURCHASE ENTRIES WITH INVENTORY (43:03)
CLASS 4 (36:45)
CLASS 5 (63:36)
CLASS 6- GST IN TALLY PRIME (45:56)
CLASS 7- TDS IN TALLY PRIME (59:51)
CLASS 8- ACCOUNT FINALIZATION 1 (68:05)
CLASS 9- ACCOUNT FINALIZATION 2 (82:02)
TALLY PRIME- BANK RECONCILIATION (65:01)

MS-EXCEL (CURRENTLY GOING ON)

EXCEL SHORTCUTS PDF
EXCEL BASIC - DAY 1 (91:49)
EXCEL- DAY 2 (87:23)
EXCEL- DAY 3 (90:16)
EXCEL DAY 4 (23 MARCH) (97:54)
EXCEL DAY 5-PASTE SPECIAL (29 MARCH) (81:37)
EXCEL DAY 6 (PIVOT TABLE) 30 MARCH (40:13)
EXCEL DAY 7 (PIVOTE TABLE & PAGE LAYOUT) 05 APRIL (78:20)
EXCEL DAY 8 (PAGE LAYOUT) 06 APRIL (75:10)
DAY 9- GST RECONCILIATION IN EXCEL (13 APRIL) (97:28)
DAY 10- MS EXCEL (14 APRIL) (86:32)

MENTORSHIP SESSION

MENTROSHIP + BUSINESS ASSOCIATES SESSION (90:31)

CANVA USE

How To Use Canva (47:12)

PF & ESIC PRACTICAL COURSE

DAY 1- PF ESIC BASIC CONCEPTS (58:57)
PF ESIC REGISTRATION (72:34)
DAY 2- PF ESIC (68:55)
DAY 3- PF ESIC (55:25)
DAY 4- PF ESIC (46:39)
DAY 1-ESIC- BASIC CONCEPTS (45:22)
ESIC -BASIC - 17 MAY (61:13)
ESIC- WORKING - 18 MAY (84:44)
PF ESIC - DAY 1 (PF) 21 APRIL (77:33)
PF ESIC- DAY 2 (PF RETURN PREPARATION) 22 APRIL (88:56)

LAST SESSION RECORDING

ADVANCE TAX (16 AUGUST 24) (84:42)
HOW TO DECIDE FEES (18 AUGUST) (81:12)
HOW TO DECIDE FEES & VISITING CARD CREATION (23 AUG) (72:36)
TAX POWER GST SIFTWARE-DEMO (24 AUG) (71:00)
DOCUMENTS FOR GST REGISTRATION & PROCESS (30 AUGUST) (88:02)
SHOPACT LICENSE (31 AUGUST) (79:24)
PTEC REGISTRATION (13 SEPTEMBER) (61:04)
GST REGISTRATION (14 SEPTEMBER) (74:47)

Teach online with

EXCEL DAY 4 (23 MARCH)

Lesson content locked

If you're already enrolled, you'll need to login.

Enroll in Course to Unlock