Excel VBA Macro Training

Creating Functions
- Writing a Simple Functions
- Calling Functions
- Creating Parameters
- Optional Parameters
- Rewriting Code to use Functions
COURSE DESCRIPTION
Visual Basic for Applications (VBA) is a scripting language developed by Microsoft which allows the development of user-defined functions and the automation of certain processes and calculations. VBA is built into most Microsoft Office applications to extend their functionality. It can be used to control many aspects of the host application, including manipulating user interface features, such as menus and toolbars, and working with custom user forms or dialog boxes.
COURSE DETAILS
Tutortek’s VBA Macro Course (online / classroom) training is designed to help you become a top VBA Macro’s Professional. During this course, our expert instructors will help you:
- Process Automation
- Report Generation Automation
- Eliminate Manual Process/Manual Interaction
- Organize & Managing data easily using the tool
- Excel Based Automation
- Automation of Import/Export utility
- Organizing data into Multiple workbooks/worksheets
- Interaction to Databases (MS-Access, SQL Server etc.)
- Interaction of Applications (eg: PowerPoint, Outlook, Word)
- Automate the Send e-mail (Download attachment, send file etc.)
- Eliminate Manual Process/Manual Interaction
- Automate complex analysis easily
EXCEL VBA MACRO COURSE CAN BE TAKEN UP BY:
Students & Freshers :As a fresher it would be little difficult to get the job.Learning VBA Macro will open new doors of oppurtunities for you.
Working Professionals :Who are not satisfied with their current profile & wants to boost their career with the latest technology.
Course Features
- Lectures 20
- Quizzes 0
- Duration 35 hours
- Students 26
- Assessments Self
-
- Excel VBA Introduction
- VBA Introduction Part-2
- Running VBA Code
- Message Boxes in VBA
- Input Boxes in VBA
- Selecting Cells and Ranges by using VBA:
- Working with Sheets
- Errors Handling and Debugging
- Working with Workbooks
- Variables in VBA
- Object variables in VBA
- With Statements
- If Statements
- Select Case Statement
- Looping in VBA
- For Next Loops
- For Each Loops
- Creating Functions
- File System Object
- User VBA Forms