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
Advanced Excel training in Gurgaon and Delhi NCR helps the participants to understand the complex reports and database easily.We also train you all major tricks and formulas, frequently used in corporate.
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.
Photo Gallery
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
Hirdesh conducted a number of advanced xl training for FIA. He would explain the concept very simply and also give us quick tools which we could use in our daily activities. He customised the training program for our requirement which made it easy for us to grasp the concept. He was very patient in answering our numerous queries and would give us multiple scenarios till we had grasped the concept.
Seema Prem
Co-Founder -FIA Technology
Very passionate and enthsuiast trainer. Love the way of his teaching style and dedication towards learners. His contribution of several books in the IT world is unforgettable.
Roni Jeffy Salomo Sidabutar
Business Development enthusiast
The whole sessions were excellent by expertise delivery. The best part of training is practice worksheets on which we worked during excel classes.
Vijay Agarawal
Data Analyst
It's a great opportunity to share my view about you and institute sir. It was my best experience with you. i wanna heartily thankful to you for guide me the best. thanks a lot, sir and surely recommend to all.
Pooja Sharma
QA
I highly recommend Mr Bhardwaj. He was my mentor and teacher in New Delhi at his institute. I got a chance to work closely with him on several projects. He possess key skills of Excel which will be beneficial for all Organization who want to success in this domain.
Serigne Ndiaye
Sr Business Solutions Consultant
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 ConsultantClients
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.
-
What are the topics covered in Advanced Excel
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.
-
Why our Training program is different from others
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.
-
What is the duration and training charges
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
-
What benifits you will get after the course
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.
-
How VBA is different from Excel
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
Email:
info@websjyoti.com
Call:
+91 8802 000 175