Microsoft Certified and Highly experienced Trainer Short batches with 3-4 candidates Fully Practical oriented sessions Assignments on each Topic Affordable Fees Near to Metro Station

Topics Covered

Introduction to VBA Writing your First VBA Code Errors and Debugging Buttons, Toolbars and Keyboard Shortcuts Selecting Cells(Range, Cells, Activecell,End, Offset) Playing with Worksheets, Charts and Sheets Handling Workbooks Explanation on Variables and Object Variables Message Boxes Input Boxes (as Method and Function both) With Statements If Statments Select Case Statements Looping (Do, Do While, Do Until, For Loop, For Each Loop) Creating Customized and your own functions to be used in MS Excel Error Handling (On Error, Resume, Goto) Event Procedures User Forms Handling Files and Folders File Dialogs How to Work with Constants in VBA Creating Word Documents using Excel VBA Creating PowerPoint Presentations Sending Outlook Emails using Excel Database Connectivity Creating Addins and Use anywhere

Who should attend

Working professionals like Engineer, Call center employees, actuarials, people looking for job etc. Students

Pre-requisites

Basic Computer knowledge

What you need to bring

Notepad and pen

Key Takeaways

Assignments on each topic Industry level analysis knowledge Good networking Access to online videos to learn more tricks and tips

About the Trainer

4.9 Avg Rating

25 Reviews

24 Students

6 Courses

Anant Jain

Certified by Microsoft as MS Office Specialist

8 Years of Experience

Anant Jain, is a Microsoft certified
as Microsoft Office Specialist
Having work experience of more
than 6 years in many International
companies.
Sound knowledge of working in MS
excel and MS Access (Basic to
advanced level)
More than 3 years of experience of
training in MS Excel and MS
Access to many working professionals and even to foreign clients
Conducted training sessions of MS Excel and MS
access in many international companies
Worked on different projects given by MNCs to
automate their tasks in Excel and Access.

Reviews (13)

5 out of 5 13 reviews

Anant Jain https://p.urbanpro.com/tv-prod/member/photo/271102-small.jpg Krishna Nagar

5.00513

Anant Jain

Naresh Kumar

Reviewed on 27 Nov, 2018

Basic and Advanced MS Excel training

"Great learning experience by anant sir. After complete training from anant sir i have been getting more job option in industry. "

Anant Jain

Tapish Goel

Reviewed on 08 Sep, 2016

Basic and Advanced MS Excel training

"Amazing teacher. Builds up your concepts from the ground up. Helpful diligent sharp. These are the words which come to my mind when i think of anant. Keep it up! "

Anant Jain

Rishu

Reviewed on 07 Sep, 2016

Basic and Advanced MS Excel training

"I had taken classes for Basic & Advanced Excel and VBA from Mr. Anant. His classes are not like the boring PPTs delivered in one of those traditional institutes but one really enjoys his classes. He has his own teaching style and one can get video tutorials too if not able to attend the class (which is the best part). Also his YouTube tutorials are a great way to recollect things long after you are done with the course (as it is not feasible to remember everything). Thank you sir. "

Anant Jain

Gaurav Yadav

Reviewed on 11 Jul, 2016

Microsoft Excel Training

"My experience was awesome with Anant Jain. He is a very good teacher. He has very good knowledge of Excel and VBA. "

View All

Have you attended any class with Lokesh?