Working Hours:Monday to Sunday: 08 AM - 08 PM
Find us:225, Old Delhi Road, Opp Raj Cinema, Gurgaon
20th July, 2019 Weekdays & Weekends Classes
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
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 spend 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...
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 successfull training program. We also offer Microsoft certifications
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.
MIS Reporting includes Dashboards making, Creating Reports, Creating Graphs & Charts and Adding Meaningful Statistics to the reports
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.
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.
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 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.
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
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.
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.
