| Medium of instruction: | English |
Macros VBA
Introduction:
This course will help to write macros in Excel using programming language Visual Basic Application (VBA). Recorded macro can edited to customize it to fulfill our requirement and one can directly go for coding to accomplish the required tasks. One can write his own functions and procedures, design forms and working with add-ins.
Applications:
• Program is scheduled for Advanced Microsoft Excel users. VBA is a programming language, requires aptitude for programming.
Program Objectives
After completion of this program, the participants will be able to the following
1) Write macros to automate routine work
2) Create functions and procedures
3) Design and use forms for data entry
4) Create add-ins to deploy at client machines
5) Create simple reports
Course Contents
1) Understanding Security Levels
-
Why security
-
Security levels and its meaning
2) Functions
-
What is Function and Subroutine
-
Writing Functions using VBA Editor
-
Calling function in other workbook
3) Recording Macros
-
Recording and running macro
-
Storing macro in different books
-
Creating buttons and assigning macro to it
-
Creating My Menu
4) The Visual Basic Editor
-
Editing macros using VBA Editor
-
Understanding the project explorer
-
Exploring windows properties
-
Modifying code in code window
-
Debugging code
5) Programming Fundamentals
-
Variables, data types and constants
-
Arrays
-
Object Variables
-
Conditional structures (If …. Then, Select Case)
-
Logical Operators
-
Looping constructs (For loops, Do loops, while… Wend)
-
Built-in functions
-
Creating Subroutines
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
7) User Forms
-
Creating forms
-
Form events
-
Creating custom menus and toolbars
-
Creating Add-ins
| Online | ||||
| When | Duration | Where | Remarks | Price |
| Not Specified | (Total 30 Hrs) | Study Online (on your computer) | Not Specified |
INR 10,000 Per Course (Taxes As Applicable) |
| Price Notes: The cost for the course in Indian Rupees (INR) would change depending on the 'Current Rate' of US Dollar. Fees in (US $) 250. | ||||
Mumbai, Bandra West (Franchisee):- Aonline Training CO Peter Dias Road, Near Mehboob Studio,O'Priya Building1st Floor, Block No 6 Bandra West, Mumbai, Maharashtra, India
Mumbai, Andheri West (Franchisee):- Office No R- 26, 1st Floor, RNA Complex Lokhandwala rd Cross Lane, Next to High Point Restaurant Andheri West, Mumbai - 400 053, Maharashtra, India
Aonline Training
Aonlinetraining is a division of Compufield - The Pioneer Computer Institute which was established in 1985. The Institute is experienced in training students and professionals, in any field from India and Abroad. Aonlinetraining is the result-oriented solution to FAQ (Frequently Asked Questions) from the students and professionals from all parts of the World.
COMPUFIELD® Training Institute was started by Mr. M. E. Khairaz. It was the first one of its kind in Mumbai (Bombay) - INDIA and it specialized in INTERNET, DIGITAL ART, MULTIMEDIA and PROGRAMMING courses. Over the years Compufield has managed to maintain its standard for imparting quality training in all the latest software packages.
