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...
We prepare candidates on real time data sheets We also provide learning material i.e. practice worksheets, online tutorial and recorded videos.
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.
We provide flexible timings which is suitable for you. We provide morning classes 8:am and evening 7 pm and weekends classes.
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.
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.
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.