VBA

Why take VBA Training?

In Excel few tasks take more of effort and are time consuming, to overcome this we make use of VBA, mainly used for automating the manual tasks.

Brief about topic

In VBA course, you will be learning about how to automate the tasks by calling the related objects, altering their properties. Creating user defined functions, userforms and working with events.

Course Content

  • Introduction to VBA, Variable and Data types
  • VBA Logic & Loops
  • Case Study - Writing an excel macro to extract individual elements from a string
  • VBA Functions, Variables / Procedure Scope and Lifetime
  • Case Study - Using msgbox and functions in VBA to generate desired results
  • Worksheets & Arrays
  • Importing Data into Excel
  • Case Study - Writing SQL statements in VBA to manipulate data
  • GUIs and User Forms
  • Case Study - Creating user forms to make meaningful filtering of data
  • Form & Excel Controls
  • Case Study - Appending and creating new files before using form and ActiveX controls to call macros
  • Charts and Pivots
  • Case Study - Creating legends using checkboxes and pivot tables
  • Building Regression Tool

  • 24 hours of self-paced video

Instructor-led live online classes

OFFER ! Pay an 'Early Bird' deposit now and save 10% on the final price!

Early Bird Offer

  • 15

    Jun

    Mon - Fri ( 3 Weeks )

    5:00 PM-7:00 PM(IST)

    • 40% off

      25,000

    15,000
40% Off till 12-Jun
  • 13

    Jun

    Sat- Sun (3 Weeks)

    2:00 PM - 4:00 PM(IST)

    • 40% off

      25,000

    15,000
40% Off till 12-Jun

Live Classes

On-time scheduled virtual classes with limited trainer-student ratio.

Expert Trainers

Best industry experts with years of online training experience.

Tailored Course

Based on your expertise and goals we design course for you.

Flexible Schedule

Learn at your schedule , time zone and convenience.

Get Certified

Receive a certificate to confirm the level of your skills in a professional context.

×

Get A Quote

Please fill your details. Fields marked with mandatory are mandatory

(Allowed types : PDF, DOC, XLS, JPEG, GIF, PNG )

Privacy Policy : We hate SPAM and promise to keep your email address safe.