Advanced Excel VBA Macros - APG Learning
nav-closed

Register for interview

advanced excel vba macros

Write to us for more information
Advance excel

Advanced Excel VBA Macros

You will learn to automate and extend the Excel environment to modify your Excel models, automate routine tasks, customize your user interface, and manage large quantities of data. You will obtain practical fluency in Visual Basic for Applications (VBA) specifically…

  • Please Login..review_star
  • student_enrolled Student's Enrolled
  • best_selling Best Selling
Write to us for more information

Course Detail

Format:

Full Time

Duration:

1 Year

Accreditation:

TISS SVE

Course Provider:

APG Learning

Start Date:

01 August 2019

Fees:

₹1,75,000/-

Duration

15 days

Modules

1

Hours

50 hours

Start Date

19 Jun 2021

Course Provider:

APG Learning

Rs.5,084.00

Address:Sakal Nagar,

Gate No. 1, Baner Road,

Aundh, Pune 411 007

Training 5 or more people?

Get your team access to APG Learning top 200+ courses anytime, anywhere.

Try APG Learning for Business

About Course

You will learn to automate and extend the Excel environment to modify your Excel models, automate routine tasks, customize your user interface, and manage large quantities of data.

You will obtain practical fluency in Visual Basic for Applications (VBA) specifically as it applies to Microsoft Excel.

Modules

Start VBA & Security

  • Introduction about VBA
  • Security Concepts involved in excel 2013/16/19
  • How to use Visual basic Editor VBE
  • The excel macro recorder

 

Excel objects

  • Introduction to object, properties & methods
  • Using Inputs box & message box
  • Sheets, ranges & offsets
  • Excel VBA variables

 

Condition and loops

  • Using if statement in VBA
  • SELECT case statement
  • Using Do while loop & FOR NEXT loop in Excel

 

Functions & Sub routine

  • Working with user defined Functions
  • Theory on variables, scoping etc
  • Working with dates

 

Controls

  • Filling User form Controls
  • Filling a List box and Combo box using Loops
  • User form Multipage Control

 

Validation

  • Validating user input into a user form
  • Textbox and spin buttons user form controls
  • Passing user form control values back to a spreadsheet
  • Passing range values to user form controls
  • Option buttons and check boxes user form controls Finding the active control on a user form Plus

 

Chart

  • Creating Chart in Excel using VBA
  • Customizing the chart

 

Pivot

  • Pivot Tables & VBA
  • Generating Multiple Pivot Table Reports using VBA

 

Database

  • Pivot Tables & VBA
  • Generating Multiple Pivot Table Reports using VB

 

 

Learning Outcomes

  • Learning the basics of the VBA language.
  • Using loops to perform repetitive tasks.
  • Interacting with users via user forms and message boxes.
  • Working with built-in VBA Functions.
  • Accessing directories and files.
  • Automating report generation and saving as PDF.
  • Creating your own Excel functions and Add-Ins

Fee Structure

Fees- 6000/-

Duration – 50 hours( sat & sun )

For more info call on 7350006102

SIMILAR COURSES

nav-closed

Download Brochure