Advance Excel Training in Gurgaon

Excel Bee Programme @ Webs Jyoti, Our Excel training is focused on data analysis and reporting. We focus on the most critical tasks that professionals and freshers require in order to analyze, manage and automate their MIS and excel sheet tasks.

Participants in our training go back to their desks and save time from implementing the tools and skills that were taught and implements during our Excel Training Programme.

Classes are conducted by renowned Author and Corporate Trainer Hirdesh Bhardwaj who have already involve in corporate training and development since 2009. Some of the training conducted by him @ Nestle India, National Skills Foundation of India, Studiokon Ventures pvt ltd, MBI Pvt ltd, FIA Global, Alpine India, Sap Lab and Dudhi Industries..

Topics Highlights

Learn how to create pivot table and charts

Filters and Advanced Filters

Using Analysis Tools: Goal Seek, Solver, and Data Tables

Magical Arrays Functions

Lookup Functions – (Simple Lookup, Lookup with Data Validation, Lookup with IfError Function, Approx Match, Reverse Lookup, nth Lookup, Indirect Lookup, Double Lookup , Lookup using Arrays and  Lookup with Index and Match )

Logical Functions – Learn how to use if, and or, iferror in your worksheet.

Amazing Charts like, Doughnut Charts, Gantt Chart, Pie Chart, Speedometer Chart etc.

Dashboard Designing

Data Validations – Basic and Custom Validations

Macro, How to record and edit Macros

Creating User Defined Functions (UDF) in VBA

Merging worksheets and workbooks

Handling Mailing activities VBA Outlook References



Course Name: MS Excel Basic, Advanced Level & VBA Macros

Course Duration: 36 Hours (2 hours class)

Timings: Weekend / Regular Classes

Course Fee: 7,000/

Demo Available: Yes

Batch Size: 3-4 Candidates

Additional Benefits:

100% Placement Assistance

Course Completion Certification

FREE Learning Material & Worksheets

FREE Life Time Membership

Address : Webs Jyoti, 225, Old Delhi Road

Opp Raj Cinema, Near Bus Stand Gurgaon  -122001

Contact: 8802000175

Enjoy the tutorial? Please spread the word :)

Follow by Email