Call us:+91-8802000175

Find us:M-24, Old DLF Colony, Sector-14, Gurugram

excel

Enrollment Open : Advance Excel, VBA & SQL

View enrollment process

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 professionals. 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-4059041


Module : Excel, Advance Excel, VBA Macros & SQL
Duration: 120 Hrs (2-3 hrs session)
Timings: Weekdays & Weekends
Batch Size: Upto 8 participants
Additional Benifits : Free Training certificate & Placement assistance

Special Offer : Advanced Excel VBA + SQL Server Duration 3 Months - Online sessions conducted by Corporate Trainer & Author Hirdesh Bhardwaj Wikipedia

Advance Excel, VBA Macros & SQL Training Overview

  • Overview of Analytics - Whats is Data Analytics, Data Modeling and Data Mining
  • Overview of excel basics, worksheet optimization, and data cleaning in excel
  • How to make your report effective (Data visualization) using Custom and Conditional formatting
  • Aggregate functions (Sum, 3-D functions, average, count, countifs, sumifs etc)
  • Date and time functions( EOMonth, DateDiff, NetworkDays, Workdays, Weeknum, Today, Month, Year etc)
  • Summarize data using Pivot table and charts
  • Data cleaning and validations in Excel
  • Basic and Advanced Filters on various scenarios
  • Lookups - VLookup, Reverse Lookup, Index Match, Indirect and dependency list
  • Logical Functions - Super logical If, nested if, and, or functions, how to combine logical functions)
  • Various Text Functions - How to use find, substitute, len, trim,exact, left, right, mid, Upper and Lower functions
  • What if Analysis (Goal Seek, Data Tables, EMI Calculation, Solver Tool)
  • Dashboard Designing in Excel
  • Arrays Functions (CSE Functions in Excel)
  • Data Validations tools
  • Data forecasting tools
  • VBA Macros (How to record macros, UDF, Variable, control flow etc)
  • VBA Filters & Reporting
  • VBA How to automate mail functions in VBA
  • VBA Events
  • VBA How to create mergers, filters reports
  • SQL DML DDL DQL DCL TCL Queries
  • SQL Select, order by having clause
  • SQL indexes
  • SQL Different types of Joins
  • SQL Aggregate functions and Reporting
  • SQL Date/ Strin functions
  • SQL Pivot & Filters Queries
  • PL-SQL/TSQL Triggers & Procedures
  • PL-SQL/TSQL Variables, functions, ifs & loops
  • PL-SQL Transactions

To get detailed information about the course and demo session details, kindly fill your details below-



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...


       
1

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...

1

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.

1

Training Certification

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

1

Post Training Support

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

1

Flexible Timings

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

1

Placement Assistance

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

TRAINING MODULES

ENROLLMENT PROCESS

1
Interaction

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

2
Demo Session

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

3
Registration

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


Online Training Program for Advance Excel & VBA

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