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
★ ★ ★ ★ ★