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