EXCEL DAY 6 (PIVOT TABLE) | SP EDUSKILLS

Autoplay
Autocomplete

Previous Lesson Complete and Continue

TAX PRACTITIONER COURSE- ALL IN ONE

ITRODUCTION SESSION

INTRO SESSION (64:24)

CANVA USE

How To Use Canva (47:12)

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 LICENSE (79:24)
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)
PTEC REGISTRATION (61:04)
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 REGISTRATION AND PROCESS

DOCUMENTS FOR GST REGISTRATION & PROCESS (88:02)
GST REGISTRATION (14 SEPTEMBER) (74:47)
GST PRACTITIONER REGISTRATION (GSTP) (24:52)
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 SUSPENSION AND CANCELLATION- REASONS AND REVOCATION (77:52)
GST CANCELLATION APPLICATION AND FINAL RETURN (GSTR 10) (72:53)

GST PRACTICAL COURSE (UPDATED)

GST BASIC CONCEPTS-1 (71:21)
GST BASIC CONCEPTS-2 (69:15)
PLACE OF SUPPLY-GST (75:01)
GST COMPUTATION (72:08)
GST PORTAL OVERVIEW (75:49)
ITC RULES (INPUT TAX CREDIT) (49:51)
GST- INPUT TAX CREDIT (ITC) (98:50)
GST CALCULATION AND ADJUSTMENT (76:15)
GST CREDIT/DEBIT NOTE CONCEPTS AND REVISION (60:58)
GSTR RETURNS, DUE DATES, LATE FEE (99:16)
GST-RCM 19 OCT (85:04)
GSTR 1 CONCEPTS & FILING (99:27)
GSTR 1- OFFLINE UTILITY (92:34)
GSTR 1 ( TALLY PRIME) (73:52)
GST- IFF RETURNS, GSTR 3B OVERVIEW (68:22)
IMS DASHBOARD / GSTR 1A & GSTR 2B CONCEPTS (87:24)
ITC SETOFF RULES AND GSTR 3B (87:59)
PRACTICAL- GSTR 3B FILING (65:47)
GSTR 3B FILING- PORTAL (77:52)
GSTR 2A/2B ITC RECONCILIATION (79:01)
GST COMPOSITION SCHEME (CMP-08) (69:51)
COMPOSITION SCHEME- CMP 08 (QRTLY PAYMENT) (37:12)
GSTR 9 CLASS -1 (76:12)
GSTR 9 CLASS-2 (86:07)
DRC 03 (VOLUNTARY PAYMENT) (28:27)
GST REFUND PROVISIONS (22 NOV) (86:56)
GST SUSPENSION AND CANCELLATION- REASONS AND REVOCATION (77:52)
GST CANCELLATION APPLICATION AND FINAL RETURN (GSTR 10) (72:53)
EWAY BILL (47:59)
EXPORT & LUT (44:27)
GST NOTICES- 1 (56:04)
GST NOTICES-2 (50:08)
TAX POWER GST SOFTWARE DEMO (75:40)
GSTR 3B FILING- TAX POWER GST SOFTWARE (47:03)

INCOME TAX COURSE FY 23-24 (OLD)

BUDGET 2024 - CHANGES IN TAXATION (FY 24-25 AY 25-26) (59:22)
IMP FILES
INCOME TAX -BASIC- 1 (87:12)
INCOME TAX- BASIC- 2 (103:03)
SALARY INCOME-BASIC (95:46)
SALARY INCOME- FORM 16 (81:27)
INCOME FROM HOUSE-PROPERTY (73:32)
PGBP (BUSINESS) INCOME - BASIC- 1 (88:39)
PGBP (BUSINESS) INCOME 44AD/44ADA/44AE CONCEPTS (94:59)
DEDUCTIONS UNDER OLD & NEW TAX REGIME (106:30)
INCOME TAX- FOR PARTNERSHIP (BASIC) (68:01)
ITR-1 FILING ONLINE (109:27)
ITR-1 FILING CLASS 2 (75:54)
CAPITAL GAIN -1 (88:46)
CAPITAL GAIN -2 (85:16)
CAPITAL GAIN - SHARES & MUTUAL FUND (83:55)
ITR 2 ONLINE FILING (SALARY + CAPITAL GAIN) (103:10)
ITR 4 ONLINE FILING (44AD) (108:47)
INCOME TAX FOR - SHARES F&O AND INTRA DAY TRADING (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)
COMPUTAX SOFTWARE DEMO & DEFECTIVE NOTICE U/S 139(9) (93:26)
BUDGET 2025 - HIGHLIGHT (71:24)

TDS (UPDATED)

NEW CHANGES FROM 1 APRIL 2025 (FY 25-26)
NEW UPDATES FY 2024-25 (UPDATES)
BLOGS
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)

TDS 3 DAY WORKSHOP (FAST TRACK)

TDS WORKSHOP DAY 1 (89:05)
TDS WORKSHOP DAY 2 -TDS RETURN PREPARATION (116:27)
TDS WORKSHOP DAY 3 - TDS RETURN UPLOAD (83:09)

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)

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)

TALLY PRIME (UPDATED)

TALLY PRIME BASIC - DAY 1 (66:04)
TALLY PRIME DAY 2 (TALLY PRIME OVERVIEW) (68:14)
TALLY PRIME DAY 3 (67:55)
TALLY PRIME DAY 4 (77:27)
TALLY PRIME DAY 5 - GST REPORT (72:08)
TALLY PRIME CLASS 6 (TDS, BANK RECO) (78:03)
TALLY PRIME DAY 7 (BACKUP) (49:37)
TALLY PRIME DAY 8 (75:10)
TALLY PRIME DAY 9 (83:37)
TALLY PRIME DAY 10 (79:09)
TALLY PRIME -ADDITIONAL SESSIONAL (08 FEB) (80:43)

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 (81:37)
EXCEL DAY 6 (PIVOT TABLE) (40:13)
EXCEL DAY 7 (PIVOTE TABLE & PAGE LAYOUT) (78:20)
EXCEL DAY 8 (PAGE LAYOUT) (75:10)
DAY 9- GST RECONCILIATION IN EXCEL (97:28)
DAY 10- MS EXCEL (86:32)

MENTORSHIP SESSION

MENTROSHIP + BUSINESS ASSOCIATES SESSION (90:31)

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 (61:13)
ESIC- WORKING (84:44)
PF ESIC - DAY 1 (PF) (77:33)
PF ESIC- DAY 2 (PF RETURN PREPARATION) (88:56)

LAST LIVE SESSIONS RECORDING (INCOME TAX FY 24-25)

IMP FILES - INCOME TAX
INCOME TAX INTRODUCTION FY 24-25 (86:39)
INCOME TAX BASIC - CLASS 1 (66:24)
INCOME TAX BASIC - CLASS 2 (98:17)
INCOME TAX BASIC - CLASS 3 (81:31)
CLASS 4- SALARY INCOME BASIC (99:50)
CLASS 5 - HRA CALCULATION , TAX CALCULATION FOR SALARY INCOME (81:36)
CLASS 6- DEDUCTIONS - FOR TAX SAVING (105:25)
CLASS 7 - DEDUCTIONS 2 (89:18)
CLASS 8 - INCOME FROM HOUSE PROPERTY (107:04)
CLASS 9- BUSINESS & PROFESSION INCOME _ 44AD & 44ADA SCHEME (100:19)
44AD SCHEME- SESSION 2 (100:25)
BAL SHEET PREPARE IN EXCEL (102:00)
BAL SHEET PREPARE IN EXCEL -2 (102:50)
CAPITAL GAIN 1 - BASIC CONCEPTS (91:15)
CAPITAL GAIN- INDEXATION FOR LTCG (93:36)

Teach online with

EXCEL DAY 6 (PIVOT TABLE)

Lesson content locked

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

Enroll in Course to Unlock