Please find the Course Details below

▪︎ Free 1st Day of classes & Free Demo

▪︎ 5 - Live Projects

▪︎ 100+ Live Examples

▪︎ End to End Codes will be given

About Trainer,

I am a direct Trainer working as an Automation Engineer in IT Firm, having 10+ years of experience in Automation can take End to End Training with your Project Support, Flexible Timings, can take concept till you understand, training will be taken as Friendly mode hence quick or slow learner's will be result oriented training. ATTEND A FREE DEMO THEN YOU CAN DECISION TO JOIN

Basics

• Introduction of VBA Macros

• Excel Shortcut. Keys

• Excel Formulas (Business Case)

• Recordings Macro

• Working with VBA Editor

• VBA Programming Concept

• VBA Syntax and Semantics

• Variable Type, Declaration and Array Concepts

• Decisions Making with Operators

• Repeating Actions with a Loops

• Procedures and Events

• Building Intuitive User Interface

• Objects and collections

• Functions

• User Forms and GUI

• Sort and Filter, Pivot Tables and Pivot charts with VBA Macros

Advance

• ODBC Connectivity to SQL Database and Query Handling

• Files and Folder Handling (FSO Method)

• Interacting with other MS - Office applications (word, PowerPoint and MSAcess)

• Interacting with Outlook Applications

• Running the SQL Queries within Excel Environment

• Interacting with Internet Explorer

• Interacting with Client Application

• Interacting with MAINFRAME by Excel

• Send keys

Automation's in Application's with

• Excel to Excel

• Excel to MS Office Applications (Excel, outlook, Access, word, notepad. Etc.)

• Excel to Database by using SQL

• Excel to Internet Explorer

• Excel to Mainframe

• Excel to Client Application (All kind of applications by identifying API)

Opportunities in Market

• Automation Engineer

• Vba Developer

• All BPO's and Back end process Automation

• MIS Executive (End to End Control)

Training Covers

• Training

• Training Material's

• Complete Code's for all Scenarios

• Project Assistance

• Interview Questions

• Placement Assistance

Gallery (3)

About the Trainer

4.9 Avg Rating

7 Reviews

31 Students

5 Courses

Gokul

B.Com

10 Years of Experience

I have close to 10 years of Experience in Excel & Excel Vba Macros (Basic & Advanced), RPA - Uipath.

Students also enrolled in these courses

Adv. VBA/Macros with Robotics using Excel VBA/Macro

LIVE

16 reviews

View this Course

Course offered by OfficeTechWorld

10 reviews

Excel VBA Class

LIVE

1 review

View this Course

Course offered by Nagarajan

1 review

Become a Excel Expert

LIVE

3 reviews

View this Course

Course offered by HB Certified Trainers

12 reviews

Microsoft Professional Excel Training LIVE Online

LIVE

59 reviews

10 Hours

₹ 4,000 Group Class (max 10)

View this Course

Course offered by Prabhas

45 reviews

Reviews (2)

5 out of 5 2 reviews

Gokul https://p.urbanpro.com/tv-prod/auth/photo/3325468-small.jpg Porur

5.0052

Gokul

S

Saroja

Reviewed on 30 Apr, 2018

Excel & Excel Macro

"Knowledge enhancing learning experience. The dedication in knowledge sharing from the tutor (Mr.Gokul) is fantablous. His unique and simple way of teaching is much appreciated. His patience and teaching until we are comfortable with the concepts is his trademark. "

Gokul

S

Swaminathan K R

Reviewed on 30 Apr, 2018

Excel & Excel Macro

"He is a good human being and purely professional, understands each and every one mind and gives training by teaching basics of excel and gives enough time to think logically and makes us think and applying macros based on our needs. Each and every penny valuable for his worthful training. "

View All

Have you attended any class with Prabhas Kumar?

Excel Vba Macros Training

About the Trainer

Reviews (2)

Prabhas Kumar Panda