EXCEL-VBA (MACRO PROGRAMMING) COURSE IN JAIPUR

FREE DEMO CLASSES

MODULE 1: UNDERSTANDING SECURITY LEVELS

MODULE 2: FUNCTIONS

  • What is Function and Subroutine
  • Writing Functions using VBA Editor
  • Calling function in other workbook

MODULE 3: RECORDING MACROS

MODULE 4: THE VISUAL BASIC EDITOR

  • Editing macros using VBA Editor
  • Understanding the project explorer
  • Exploring windows properties
  • Modifying code in code window
  • Debugging code

MODULE 5: PROGRAMMING FUNDAMENTALS

  • Variables, data types and constants
  • Arrays
  • Object Variables
  • Conditional structures (If I. Then, Select Case)
  • Logical Operators
  • Looping constructs (For loops, Do loops, while Wend)
  • Built-in functions , Creating Subroutines

MODULE 6: EXCEL OBJECT MODEL

  • Working with objects properties, events and methods
  • Application objects
  • Workbook objects, Worksheet objects and Range objects
  • Charts objects
  • Pivot table objects

MODULE 7: USER FORMS

  • Creating forms , Form events
  • Creating custom menus and toolbars
  • Creating Add-ins

Module 8: Working with other applications

  • Working Word, PowerPoint and other applications.

COURSE DURATION 1 MONTH

C And C++ Training Institute in Jaipur

Placements of Thirdeye

Leave a Reply

Your email address will not be published. Required fields are marked *