Welcome to OMEGA COMPUTER EDUCATION AND SPOKEN ENGLISH
WELCOME TO OMEGA COMPUTER EDUCATION AND SPOKEN ENGLISH
MACROS IN ADVANCE EXCEL ( S-MADC )

BASIC INFORMATION

  • Course Fees : 16500.00 20000.00/-
  • Course Duration : 3 MONTH
  • Minimum Amount To Pay : Rs.500.00
  1. Module 1:
    • Basic
    • Create Functions & Procedures
    • Design & Create Reports
    • Underst&ing Security Levels
    • Security levels & its meaning
  2. Module 2:
    • Functions
    • What is Function & Subroutine
    • Writing Functions using VBA Editor
    • Calling Functions other workbook
    • Relative & Absolute Macros
  3. Module 3:
    • Recording Macros
    • Recording & running macro
    • Storing macro in different books
    • Creating buttons & assigning macros
    • Creating My Menu
  4. Module 4:
    • The Visual Basic Editior
    • Editing macros using VBA Editor
    • Underst&ing the project explorer
    • Exploring windows properties
    • Modifying code & Debugging code
  5. Module 5 :
    • Programming Fundamentals
    • Variables, Data types & Constants
    • Arrays, Object Variables
    • Conditional structures (If Then, Select Case)
    • Logical Operators / Looping constructs (For loops, Do loops, While)
    • Buit-in functions, Creating Subroutines
  6. Module 6:
    • User Forms
    • Creating forms, Form events
    • Creating custom menus & toolbars
    • Creating Add-ins

10th