Advanced Excel Course for Accountants in Hindi —
VLOOKUP, Pivot, Macros
This advanced Excel course by CA Piyush Gupta teaches accountants to automate their work in Hindi: VLOOKUP, INDEX-MATCH, pivot tables, logical functions, conditional formatting for auditing, and macros that turn hours of work into one click. Open to any background, CA-signed certificate; sold in the MS Office Combo (₹2,500) and included in CPATP.
At a Glance
-
✓Course Name: Advanced Excel Course for Accountants in Hindi
-
✓Level: Beginner to Advanced
-
✓Language: Hindi (explanation) & English (notes/portal)
-
✓Eligibility / Prerequisite: any stream after Class 12
-
✓Format: Online (Recorded lectures + community support)
-
✓Certificate: Yes — CA-signed
-
✓Price: Included in CPATP Bundle (Not sold separately)
-
✓Bundle Status: Exclusive to the 25-in-1 CPATP bundle
Recommended For
What You Will Learn
Gain direct practical capabilities to perform compliance and operational finance work:
- ✓ build lookups and reconciliations
- ✓ summarise data with pivots
- ✓ flag anomalies
- ✓ automate repetitive reports.
Why This Course
must-know accounting formulas, VLOOKUP & INDEX-MATCH, pivot tables, logical functions, conditional formatting to catch errors, and macros to automate reports.
Practical Professional Use:
Learn double-entry bookkeeping, taxation portal filings, and ledger preparational formats using live setups. Best alternative to unstructured tutorials.
Certificate & Pricing
Standard credentials and clear standalone pricing options for independent learning:
Syllabus Details — Module by Module
Core subjects covered:
- Changing Default Save Locations
- File Management Insights
- Essential Shortcut Keys
- Formatting Data Techniques
- Theme Implementation
- Managing Sheet Names and Panes
- Special Paste Techniques
- Number Formatting and Assumptions
- Working with Percentages and Decimals
- Applying Font Colors via Paste Special
- Structuring and Grouping Sheets
- Copying and Opening Sheets
- Techniques for Data Analysis
- Tracing Dependents and Precedents
- Conditional Formatting Methods
Core subjects covered:
- Introduction to Microsoft
- Excel Basics
- Exploring Home Tab Functions
- Understanding Insert Tab Features
- Detailed Work on Home and Insert Tabs
- Overview of Page Layout Options
- Utilizing Formulas in Formula Tab
- Exploring Data Tab Functionalities
- Review Tab Features and Usage
- View Tab Functions and Uses
- Inserting and Customizing Charts
- Quick Access Tools and Functions
- Naming Sheets and Freezing Panes
- Diverse Saving Options
- Writing and Executing Macros
Core subjects covered:
- Macro Task Execution
- Referencing Cells in VBA Macros
- Formatting Techniques in VBA
- Implementing ‘End’
- Command in VBA
- Usage of ‘Offset’ Command
- Automating Data Entry Tasks
- Working with Objects and Variables
- Variable Usage and Examples
- Applying ‘IF’, ‘AND’, ‘OR’ in VBA
- Creating Functional Buttons
- Exploring Alternate Scenarios
- Understanding and Implementing Loops
- MS Excel Shortcuts
- Basic and Advanced Filtering
Core subjects covered:
- Introduction to IF Function
- VLOOKUP Function Applications
- Creating Custom Shortcuts
- Working with Pivot Tables
- Theoretical Understanding of Macros
- VBA User Interface Overview
- Macro Creation and Usage
- Personal Macro Workbook Creation
- Storing and Viewing
- Macro Workbook
- Using Relative References
- Recording and Storing Macros
- Adding Macro Buttons
- Saving Excel Macro Workbooks
Courses are continuously updated — new videos are added whenever tax laws or portals change, so students always learn the latest 2026 rules. The complete, current module list is maintained in the Smartious app.
Who can take this course?
This training is structured for anyone looking to build highly marketable compliance and operational finance skills:
- • any stream after Class 12
- • accountants
- • MIS/audit assistants.
What results do students get from this course?
“The practical training lessons on the Smartious App are excellent. I learned exactly the tools and automation skills needed for office accounting jobs.”
“If you want real earning-ready skills, Smartious is the only answer. We did actual corporate templates, data formats, and sheets. The certificates are highly respected.”
“I didn’t know how actual business templates and formatting work. The step-by-step videos in the Smartious App are so detailed. Truly innovative teaching!”
These are among 5,430+ verified ratings (4.9/5) of CA Piyush Gupta (Smartious) on Google Play and Google Maps.
Read More Reviews ➔Frequently Asked Questions
None. Anyone from any background can learn after Class 12; it’s a software skill taught in Hindi with accounting examples, from basic formulas to macros, so beginners can follow.
Excel speed is one of the most valued skills for accounts, MIS and audit roles — automating reports saves hours and makes you stand out. Strong Excel skills help move past the ₹12,000–₹15,000 junior range; actual earnings depend on your role. It pairs well with Tally and the other CPATP courses.
Excel is sold together with Word and PowerPoint in the MS Office Combo (₹2,500) and is also included in CPATP; it isn’t sold as a single course. It’s in Hindi with a CA-signed certificate. You enrol through the Smartious app.
No. Excel is open to everyone; the course is built for accountants but needs no prior degree — just a willingness to practise the formulas shown.
Download the app to enrol & see the latest syllabus
Gain full access to screen-by-screen video tutorials, live client computations, and the Smartious community support group.