Working Hours:Monday to Sunday: 08 AM - 08 PM

Find us:225, Old Delhi Road, Opp Raj Cinema, Gurgaon

Enrollment now : Advance Excel, VBA & SQL

View enrollment process

Call us : +91-8802000175

Live sessions are available through Video Conferencing. for enrollment and training details kindly call us or WhatsApp +91-8802000175

Advance Excel, VBA Macro Training in Gurgaon

Webs Jyoti, established in 2009 - Training and development organization based in Gurgaon NCR. We provide corporate training as well as classroom training for the professional. We work with the businesses and individuals who need MIS, Excel Macro and Data Analytics classes at Flexible timings & affordable pricing. We have conducted 500+ Classrooms and 50+ Corporate Training Successfully. We run weekdays as well as weekend classes at our training institute.
For Training related enquiry Call us: +91-8802000175, 0124-4360863

Module :Excel, Advance Excel & VBA Macros : Duration: 70 Hrs (2-3 hrs session)   Timings: Regular & Weekends Both available
Batch Size: Small batch size - upto 6 participants   Free Training certificate & Placement assistance

About Trainer
Hirdesh Bhardwaj, a well-known author as well as Founder of Webs Jyoti, conducts corporate and classroom training on Excel, Advance Excel and VBA Macros. He has more than 13 years of experience with a well-reputed MNCs where he spends more than 8 hours in a day working with Excel sheet, VBA editor and always try to explore new challenges in excel to make it absolute for corporate use Read More...


Industry Expert Trainer

Hirdesh Bhardwaj, a well known author as well as Founder of Webs Jyoti, conducts corporate and classroom training on Advance Excel and VBA Macros...


Hands-On Sessions

We prepare candidates on real time data sheets We also provide learning material i.e. practice worksheets, online tutorial and recorded videos.


Training Certification

We award participants a course completion certificate after a successfull training program. We also offer Microsoft certifications


Post Training Support

We provide life time support for the trainees, candidates can join revision and doubt classes free of cost.


Flexible Timings

We provide flexible timings which is suitable for you. We provide morning classes 8:am and evening 7 pm and weekends classes.


Placement Assistance

We also provide placement support and interview preparations for the working as well as fresher candidates free of cost.




We prefer an interaction with the particpant to discuss their training requirements and the learning skills.

Demo Session

After interaction if candidate require a free trial or demo sesssion, we arrange the same on a scheduled time.


After interaction or a demo session, you can enroll for the respective module.

Training Highlights

Reporting and analytics

MIS Reporting includes Dashboards making, Creating Reports, Creating Graphs & Charts and Adding Meaningful Statistics to the reports

Pivot Table & Charts in Excel

Pivot Tables allow you to tabulate and report on data in your spreadsheets in ways that would take hours to achieve without using a Pivot Table.

Advanced filter, Array Functions in excel

When you use the Advanced Filter, you need to enter the criteria on the worksheet. Create a Criteria range (blue border below for illustration only) above your data set. Use the same column headers. Be sure there's at least one blank row between your Criteria range and data set.

Dashboard in Excel, Lookup Functions

Using Doughnut, Gantt, Pie and Bar Charts, You can get a quick, visual status update on your projects. Various Lookups VLookup, Index Match Indirect and Offset are popular functions in Excel


New Features in Excel 2016

15 Jul 2019 Hirdesh Bhardwaj

New Charts - Tree map, Waterfall, Sunbrust and Combo Charts, Slicer Tool for the Pivot table, Power view, We will also explore 3-D Maps, Field,Items and Set and timelines in Pivot Table. We also trained you on Quick Tool and smart lookup available in 2016.

Top 50 Functions in Excel

20 Jul 2019 Hirdesh Bhardwaj

During our sessions, we will explore top 50 functions i.e. text cleaning, date and times functions, logical and advance if and or functions, various types of lookup, top 10 mathematical, accounting and financial functions in Excel

Analysis Tools: Goal Seek, Solver, and Data Tables

10 Jul 2019 Manish Ray

We will explore how to analyze your data with excel, how to use goal seek, how to use solver, how to create Amortization Tables to Calculate Mortgage Payment and how to use the Analysis ToolPak Add-In.

VBA Macros Automation

15 Mar 2019 Pankaj Shakya

At our Training Institute, We have developed several VBA tools which help you to automate your excel tasks. Some major tools i.e. merge multiple excel files to a single Excel file, filter data on multiple criteria, Merge multiple CSV Files.

advance excel & mis training institute in gurgaon

advanced excel institute in gurgaon

advanced excel institute in gurgaon sec-14

advanced excel training institute in gurgaon

best excel training institute in gurgaon

vba macro classes in gurgaon