Advanced Excel Training Gurgaon

Start with the scratch, building a solid foundation that will give you further knowledge as you progress into advanced level of Excel and VBA

Get Started

Advance Excel and VBA Macros Training in Gurgaon

The Training is conducted by the Advanced Excel corporate trainer, having 13+ years of experience. We have conducted 500+ Classrooms and 50+ Corporate Training Successfully. Classroom Training for the participants who want to learn VBA via either weekday's sessions or weekend's sessions. Online Classes for the students who are willing to take online sessions and also for the students who want to attend back-up or missed lessons.
For Training related enquiry Call us: +91-8802000175, 0124-4360863

  • 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

Training Modules

Our Modules have been designed for all those people who work in the corporates or a student wanting to get hands-on training of MIS and Data Analytics. We will help all those people who use MS-Excel regularly to analyze complex data and train you to get the Excel skills on your finger-tips.

Advance Excel VBA

Excel from Basic to Advanced and VBA Macros

VBA Macros

VBA Macros from Basics to Advanced Level.

SQL Training

Transform your data into RDBMS. SQL server from basics to Advanced level

Tableau

Tableau desktop for data visualization and reporting

Photo Gallery

Advance Excel Training

© Webs Jyoti

Advance Excel Training

© Webs Jyoti

Advance Excel Training

© Webs Jyoti

Hirdesh Bhardwaj

Advance Excel Training

© Webs Jyoti

Advance Excel Training

© Webs Jyoti

VBA Macros Training

© Webs Jyoti

SQL Training

© Webs Jyoti

VBA Macros Training

© Webs Jyoti

SQL Training

© Webs Jyoti

Our Online Training Program

Our online training platform allows you to sit the module from home with a live trainer. You will be able to interact with the trainer and other delegates.

Testimonials

Feedback are always welcome from the learners, it help us to improve our training methodology as well as training quality

Trainer Profile

Hirdesh Bhardwaj, a well-known author as well as Founder of Webs Jyoti organization in Gurgaon, India. He has 13+ years of experience and conducts corporate and classroom training on Excel in corporates covering basic to advanced Excel and VBA Macros.

Hirdesh Bhardwaj

Founder, Trainer

Akanksha Sachan

SQL Trainer

Serigne Ndiaye

Placement Consultant

Clients

Webs Jyoti has been providing Corporate Training held in Delhi NCR held at various destinations to its promising client companies for last few years. Here are our some of the valuable clients listed below

Frequently Asked Questions

  • What are the topics covered in basic and intermediate Excel

    Overview of basics, print and formatting, worksheet optimization challenges,How to make your report effectiveness using Custom and Conditional formatting, Excel Aggregate functions (Sum, 3-D Sum, avg, count, countifs, sumifs etc), Date and Function functions ( EOMonth, DateDiff, NetworkDays, Workdays Weeknum, etc), Sorting and Filtering, Summarize data using Pivot table and charts,Data Cleaning Techniques and VLookup function.

  • Advanced VLOOKUP with index, match, reverse lookup and indirect function, Advanced Filters, Logical Functions (Super logical Ifs, and or nested functions, how to combine functions), Text Functions - Left, Right, Mid, Upper/Lower, Find, Substitute and Len functions, What if Analysis (Goal Seek, Data Table, Loan / EMI Calculation functions), Arrays Functions (CSE Functions in Excel), Data forecasting tools, VBA Macros (How to record macros, UDF, Variable, control flow etc), How to automate mail functions in VBA, How to create mergers, filters reports.

  • Our training program is based on real time scanarios and the tasks people are using in day to day activities. we have prepared 100+ sample worksheets loaded with real time data, we provide topic related after each session and ensure the solution by the next session. We also provide interview sample worksheets for the practice.

  • Duration of Advanced Excel module is 70 Hrs (2 Months), VBA basic to advanced is 60 Hrs and SQL module is 50 hrs duration. We provide classes on weekdays and weekend both. For fee and other details you can call to us +91-8802000175

  • After completion of the module you will award with our training certificate. We also help in placement services free of cost. We also provide post support and life time membership for the revision classes.

  • Excel is a tool including features of automate reporting and some functions, while VBA allow you to write code for user defined functions and the tasks which is repeated in excel. So for the excel there is no prerequesties while for VBA excel is mandatory.

Contact Us

Location:

225 Old delhi road, Gurgaon Haryana 122001

Call:

+91 8802 000 175

Loading
Your message has been sent. Thank you!