Are there good career opportunities after successfully completing the GST Plus Course?

GST is a comprehensive indirect tax that is levied on manufacture, sale, and consumption of goods as well as services at the national level has opened up an ocean of opportunities for all practitioners. So be it Tax or Account Professionals, Account Managers, CFOs, Revenue Officials, CAs or even Finance & Commerce Students, all of them will benefit from a GST Plus Course and Certification.

Can one expect a professional and an industry relevant curriculum in such GST Plus course?

This GST Plus Course is specially designed by GST experts with knowledge of Advanced Excel for GST Accountants that shall help you in understanding the day-to-day practical concerns of GST and GST Course law including E-Way Bills, Return filing, Refund, ITC, ITC 04, Tax Invoice, Bill of Supply, Export, Supply, Registration, Zero Rated, Impact on various business departments, etc. and more.

Is it mandatory to have a finance or commerce background for such advanced GST Plus Course?

It is not essential for you to be a CA or hold a degree in finance or accounting to take up GST Plus Course, Advanced or otherwise, they will just be helpful in following and grasping better. But even an entrepreneur, who possesses a basic understanding of taxes and is inclined to learn about taxes, can take up the GST Plus Course or Indirect Taxation Course successfully.

Can I become a GST professional by completing this GST Plus Course only?

Yes, you can become a GST Course professional by completing this GST plus Course, then start practicing and serving the clients.

What are the benefits of GST Plus course and Certification in India?

A GST Plus course will help you to become GST ready for the future, give you an insight into all GST provisions and compliance requirements, and also a practical training exposure, along with extensive knowledge of Advanced Excel required as a GST Accountant

GST Plus Course - GST Plus Training Online- Henry Harvin®

Course 1: GST Practitioner
- Gain basic knowledge about Tax, GST, Direct & Indirect Tax
- Get Acquainted with the types of GST and Models of GST
- Practice Destination Consumption and Origin-based GST
- Acquire Knowledge about concepts and basics of GST
- Get acquainted with GST concepts on supply, export & import, E-way bills
- Know all the provisions & Registration of GST
- Develop Skills for GST Invoicing, Returns, and Refunds
- Know the Laws regarding GST
Module 1: Introduction to GST
- What is Tax
- What is Direct and Indirect Tax
- What is GST
- GST History
- GST Challenges
- GST Benefits
- Drawbacks of GST
- Why GST
- Types of GST Models and GST Types
- Destination Consumption and Origin-based GST
- GST Deposit Chain or Flow
- Calculating GST
Module 2: GST Concepts and Basics
- Supply or Levy
- Place of Supply
- Value of Supply
- Export & Import
- E-Way Bills
Module 3: GST Registrations and Provisions
- Registrations
- Input Tax Credit & ITC04
- Transitional Provisions
- Job Work
Module 4: GST Invoicing and Returns
- Account & Records
- Invoice, Tax Payments
- Time of Supply
- Returns ( All )
- Refunds
Module 5: GST Litigation Management
- Appellate Levels of GST
- Audit & Assessments
- Offenses & Penalties
- Demand & Recovery
- Acts & Law
Course 2: Advanced Excel for GST Accountants
Learn to apply Advanced Formulas, Perform Data analysis & Data Visualization, and create Pivot tables & dashboards. This course will provide comprehensive knowledge of MS Excel and its function. The learner will be equipped with the knowledge about Power query and user-defined functions with skills in Advanced VBA

Module 1: Introduction to MS Excel
- Advantages of using MS Excel & Various purpose to use Excel
- Understanding of Workbook, Worksheet, columns, rows & Cells
- Ribbon & Tabs
- Quick access bar, Formula bar, Name bar, Status bar
- Keyboard Shortcuts & Navigation while using large data
- Different Use of Mouse
- Insert Comment
Module 2: Working with Tables
- Advantage of Converting data into tables
- Structured formula
- Use of Slicers
- Dynamic Range
Module 3: Understanding Cell References
- Absolute Reference
- Relative Reference
- Mixed Reference
- 3D Reference
Module 4: Basics Functions of Excel
- Text to Column
- Flash Fill
- Auto Fill
Module 5: Sorting Data
- In Ascending & Descending Order
- Sort with Text, Numbers & Date
- Sort with formatting (Cell, Color, Font Color)
- In Multiple Order
- In Custom Order
Module 6: Filtering Data
- Applying Filters by text, numbers, or date on the Data
- Advanced Filter: Setting up Criteria to Filter the data
- Applying Complex Criteria
- Clearing the existing criteria
- Use Wildcard characters in Filter Criteria
Module 7: Data Consolidation/Basics of Formula/Functions
- From multiple Sheets
- From multiple Files
- Understanding Syntax, Intellisense, Suggestion box & optional argument
- Basic Calculations & BODMAS Rule
- Calculate Square, cube & Raise Number to Power
Module 8: If Functions and text Functions
- 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 9: Working with Dates and CountIfs and SumIfs
- Date & Time Formula
- COUNTIF, COUNTIES, SUMIF, SUMIFS
Module 10: Lookup and Information Functions
- 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 11: Using Named Ranges
- Defining and Using Range Names
- Using Named Ranges in Functions
Module 12: Data Validation
- By Numbers, Text Length, Date, List (dropdown)
- Input Message and Error Message
- Dependent Data Validation
- Dynamic Dropdown range with Table
Module 13: Dynamic Array Formula
- Spilled Ranges & use of #
- Sort
- Sort by
- Unique
- Filter
- Sequence
- Ifs
Module 14: Using Conditional Formatting
- Applying Conditional Formatting
- Applying Multiple Rule Sets
- Creating Custom Rule Sets
- Viewing and Managing Rules
- Clearing Custom Rules
Module 15: Macros (Only Recording, Non-VBA)
- Displaying the Developer Tab
- Review and Purpose of Macros
- Where to Save Macros
- Absolute and relative record
- Running macros: Assigning to Quick Access Toolbar, shapes
- Pictures and keyboard shortcuts
- Macro recording with charts & sorting Data
- Alter the recorded code
- User-Defined Function (UDF)
- Use prebuild VBA code
Module 16: Summarizing Data with Pivot Tables
- Creating Pivot Tables
- Rearranging Pivot Table Data
- Modifying Pivot Table calculations
- Drill-Down
- Filtering the Pivot data
- Summarizing Values by Sum. Count. Average. Max. and Product
- Show Values As % of Grand Total, % of Column Total, % of Row Total
- Grouping Fields
- Creating Calculated Column(s) in Pivot
- Creating Calculated Item(s) in Pivot
- Showing and Hiding the Grand Totals
- Refreshing data in pivot table
- Changing the scope of data source
Module 17: Working with Slicers
- Inserting and Using a Slicer
- Renaming the Slicer
- Changing Slicer Settings
- Formatting a Slicer
- Clearing the Slicer
Module 18: Power Pivot / Power Query
- Enable PowerPivot
- Understand Import Data, Transform data, Data Model to create a report
- Use Load, Load to & Transform Data
- Use of Power query to record steps for all files from a folder
- Add column, Update Column with Text, Numbers, & date
Module 19: Charts
- Selecting data
- Formatting your Chart
- Understanding Different Types of Charts
- Combo Chart
- Creating Custom chart types
- Use of Secondary Axis
- Using Trend Line in Charts
Module 20: Other Topics
- Format Painter
- Freeze Pans
- Removing Duplicates
- Transposing Data
- Paste Special
- Print Settings
- Custom Formatting
Module 21: Excel Dashboard
- Objective to Create Dashboard
- Create Pivot Table & Charts
- Design Dashboard
- Use Macro to Automatically Refresh all when row data is changed or new data is added
Module 22: Protecting and Security
- Password Protect workbook (file) for open & modify
- Password Protect Sheet
- Password protect workbook structure (Review => protect Sheet)
- Allow Edit Range with password
Module 23: Mail Merge
- Understand Mail Merge
Complementary Module 1: Soft Skills Development
- Business Communication
- Preparation for the Interview
- Presentation Skills
Complimentary Module 2: Resume Writing

Resume Building Techniques

There's a reason that 95% of our alumni undertake 3+ courses as a minimum with Henry Harvin®

Mohan
★ ★ ★ ★ ★

See Proof

Radha
★ ★ ★ ★ ★

Shailesh
★ ★ ★ ★ ★

Sunaina
★ ★ ★ ★ ★

Akshay
★ ★ ★ ★ ★

Kaamna
★ ★ ★ ★ ★

Ratnesh
★ ★ ★ ★ ★