Have you ever felt frustrated using Microsoft Excel to perform
mundane and often repetitive tasks? Have you ever felt that there has to
be an easier and faster way to perform to do something? Well, using
Microsoft Visual Basic for Application (VBA) programming language allows
you to automate manual tasks within Excel and allows you to be more
effective and efficient with your time. Not only does it provide you
access to a rich library of additional tools and capabilities, over and
above what a standard user may have access to, it can also be used to
integrate with some of the Microsoft other Office applications such as
Outlook, Word and MS Access.
- So, who should take this course?
- Anyone who wants to learn how to be a proficient VBA programming
Anyone who wants to learn how to effectively utilize the tool to solve and automated manual tasks
In this course you will learn some of the fundamental concepts of
the VBA programming language. Not only does this course include a review
of the basic concepts and key functionality available within this rich
programming language such as the IF, Select Case and Loop Statements,
you will also learn how to design and develop your own custom objects
using the concepts of object orientated programming through the use of
class modules.
This course starts off with a brief refresher on the basic concepts
of the VBA programming language and a review of the VBA Editor, the
development environment that we will use during this course.
This program also includes a number of practical examples, to help
demonstrate how to effectively utilize the concepts that you have
covered during this course. This course includes the key concepts and
practical examples of the following VBA statements and functionality:
- IF Statements
- Loop Statements (For Next, Do While, Do Until)
- Exit Statements
- Goto Statements
- Select Case Statements
- Enumeration Data Types
- The DoEvents Statement
- Macros
- Arrays (declaring, re-initializing, auto populating and deleting arrays)
- Error Handling
- Standard Excel Objects
- Functions and Procedures
- Passing Values To Functions By Value
- Passing Variables to Functions By Reference
- Advance String Manipulation using the Trim, LTrim, RTrim, Left, Right, Instr and InstrRev Statements
- User forms
- Classes / Custom Objects
- Variable Declaration And Scope
We finish the training course by reviewing additional practical
examples of how to apply the key concepts that we have reviewed during
this course. In total, this course provides approximately
9 hours of course videos, including practical files and examples to help you become a proficient and effective programming.
Comments
Post a Comment