Name: Introduction To Income Tax Plus Course in Kanpur | Henry Harvin
Uploaded: 2023-12-09 17:13:29
Description: 100% Practical Income Tax Course| India's Best Certified Income Tax Course | Get Exposure to 11+ projects | Learn to Apply Advanced Formulas, Perform Data Analysis and Data Visualization, and Create Pivot Tables and dashboards | Live Online Classroom Core and Brush-up Training Sessions

Module 1: Litigation Management (Assessment / Appeal / Offences)
In this module, a professional will learn about security notice
- The Validity of Scrutiny Notice
- Information Collect, Documents Collect- What to Send and What Not?
- Reply to Questions Under Income Tax Law, Assessment Order (Tax, Interest, Penalty)
- Commissioner Appeal Filing(How to File the Appeal before the Commissioner's Appeal, Appeal Process, Documents to Submit, How to Handle Litigation before Commissioner's Appeal, Rules, and Regulations of Appeal- Process, Documents)
- Income Tax Appellate Tribunal (How to File the Appeal before Income Tax Appellate Tribunal, Appeal Process, Documents to Submit, How to Handle Litigation before Income Tax Appellate Tribunal, Rules, and Regulations of Appeal- Process, Documents)
Module 2: TDS/TCS
In this module, a professional will learn about TDS
- How to Handle TDS Survey?
- How to Manage TDS?
- How to Manage TCS?
- Compliance related to Equalization Levy
- Prosecution under the IT Act for Default in TDS
- Compounding Provisions
Module 3: Income Tax from Other Sources and House Property
In this module, a professional will learn about taxation
- Taxation
- Exemption
- Deduction
Module 4: Capital Gain
In this module, a professional will learn about exemption
- Exemption
- Taxation
- Deduction
Module 5: Business Income
In this module, a professional will learn about deductions and allowance
- Deductions
- Allowance
- Books of Account
- Method of Accounting
- Tax Audit
Module 6: Income Tax
In this module, a professional will learn about income tax
- Recent Changes in Income Tax
- Advanced Level Issues in Income Tax
Module 7: Filing of Income Tax Return / Tax Audit
In this module, a professional will learn about problems in return filing.
- Problems in Return Filing: Latest
- Problems in Audit: Latest
Module 8: Working With Tables
In this module, a professional will learn about advantages of converting data into tables
- Advantage of Converting data into tables
- Structured formula
- Use of Slicers
- Dynamic Range
Module 9: Understanding Cell References
In this module, a professional will learn about absolute references
- Absolute Reference
- Relative Reference
- Mixed Reference
- 3D Reference
Module 10: Basics Functions of Excel
In this module, a professional will learn about the basic functions of Excel
- Text to Column
- Flash Fill
- Auto Fill
Module 11: Data Consolidation/ Basics of Formula/ Functions
In this module, a professional will learn about Syntax, Intellisense, Suggestion box
- Form multiple Sheets
- Form multiple Files
- Understanding Syntax, Intellisense, Suggestion box & optional argument
- Basic Calculations & BODMAS Rule
- Calculate Square, cube & Raise Number to Power
Module 12: If Functions and Test Functions
In this module, a professional will learn about Combination of If with OR, AND & NOT
- Simple If
- Combination of If with OR, AND & NOT
- Nested If Function
- LEN, TRIM, LEFT, RIGHT, MID, FIND, SEARCH, CONCATENATE, UPPER, LOWER, PROPER
- REPLACE, SUBSTITUTE, SEARCH, FIND
Module 13: Working With Dates, Countlifs, and Sumlfs
In this module, a professional will learn about COUNTIF, SUMIF, SUMIFS
- Date & Time Formula
- COUNTIF, COUNTIFS, SUMIF, SUMIFS
Module 14: Lookup and Information Functions
In this module, a professional will learn about Lookup Functions - VLOOKUP. HLOOKUP. LOOKUP
- Lookup Functions - VLOOKUP. HLOOKUP. LOOKUP
- Disadvantage / Limitations of Vlookup
- Reference Functions - MATCH INDEX
- Simple XLookup
- Exact Match
- Approx Match
- Nested XLookup
- Case Sensitive Xlookup
- Multiple Answer column Xlookup
- Lookup Repeating Value (Using Filter)
Module 15: Using Named Ranges
In this module, a professional will learn about Using Range Names
- Defining and Using Range Names
- Using Named Ranges in Functions
Module 16: Complimentary Module 1: Soft Skills Development
- Business Communication
- Preparation for the Interview
- Presentation Skills
Module 17: Complimentary Module 2: Resume Writing
- Resume Writing

Income Tax Plus Course in Kanpur

27 Jan 2025

Book a Live Class, For Free!

Accreditations & Affiliations

Know the complete offerings of our Income Tax Plus Course in Kanpur

About Income Tax Plus Course in Kanpur

Income Tax Plus Course

AGOTA™ Framework

Trainers at Henry Harvin®

Alumni Status

Gold Membership Benefits

Learning Benefits

Why Choose Henry Harvin® Accounts Academy for Income Tax Course?

Recognitions of Henry Harvin® Education

Key Highlights

56 Hours of Instructor-Led Sessions

19 Hours of Live Interactive Doubt Solving Sessions

10 Hours of Live Master Sessions by Industry Experts

192 Hours of Self-Paced Learning

Job-Ready Portfolio of 6+ Capstone Projects

64 Auto-Graded Assessments

12+ Industry Case Studies

84 Guided Hands-On Exercises

6+ Assignments and Mini Projects

2 Mock Interviews and 2 Hackathons

Get 1-Year Gold Membership of Henry Harvin® Accounts Academy

Get a guaranteed Internship with Henry Harvin® and in top MNCs like J.P. Morgan, Accenture & many more via Forage

Get 3 in 1 Placement support through Placement Drives, Premium access to Job portal & Personalized Job Consulting

7 Hours of Mentorship by Industry Experts

Earn Certification of Course from Henry Harvin®, Govt of India recognized & Award-Winning Institute and NSDC Certification

Our Placement Stats

Access the best jobs in the industry

Agota™ Framework

Curriculum For Income Tax Plus Course in Kanpur

Module 1: Litigation Management (Assessment / Appeal / Offences)

Module 2: TDS/TCS

Module 3: Income Tax from Other Sources and House Property

Module 4: Capital Gain

Module 5: Business Income

Module 6: Income Tax

Module 7: Filing of Income Tax Return / Tax Audit

Module 8: Working With Tables

Module 9: Understanding Cell References

Module 10: Basics Functions of Excel

Module 11: Data Consolidation/ Basics of Formula/ Functions

Module 12: If Functions and Test Functions

Module 13: Working With Dates, Countlifs, and Sumlfs

Module 14: Lookup and Information Functions

Module 15: Using Named Ranges

Module 16: Complimentary Module 1: Soft Skills Development

Module 17: Complimentary Module 2: Resume Writing

Admission Closes On 27 Jan 2025

null

Henry Harvin® Ranks #1

Upcoming Cohort

Henry Harvin® Ranks #1

Starts in 5 day. 27 Jan 2025

Upcoming Cohorts

Skills Covered

Certifications

Get Ahead with Henry Harvin® Income Tax Plus Course in Kanpur Certification

What you'll Learn in this course

Creating Macros in Microsoft Excel

Various Functions in Excel

Creating Financial Statements

Tables & Charts

Planning and Strategies

Compliance Management & Litigation Operations

Our courses and Course Certificates are trusted by these industry leaders

Career Services By Henry Harvin®

Placement Drives

Premium access to Henry Harvin® Job portal

Personalized Job Consulting

Job Profiles

Related Jobs

Popular Programs

GST Practitioner Course Training

Income Tax Course

Tax Practitioner Course

Mini MBA Course