Microsoft Visual Basic for Applications (VBA)


  • Microsoft Visual Basic for Applications (VBA), Singapore SKillsFuture elarning online course
  • Microsoft Visual Basic for Applications (VBA), Singapore SKillsFuture elarning online course
  • Microsoft Visual Basic for Applications (VBA), Singapore SKillsFuture elarning online course
  • Microsoft Visual Basic for Applications (VBA), Singapore SKillsFuture elarning online course
  • Microsoft Visual Basic for Applications (VBA), Singapore SKillsFuture elarning online course
  • Microsoft Visual Basic for Applications (VBA), Singapore SKillsFuture elarning online course

Course Description

The Microsoft Office suite of applications (Word, Excel, PowerPoint, and Access) allows users to customize views or output, but the processing performed by the applications cannot be changed. However, Microsoft provides an interface in which the user can create customized processing. The language used for this customized processing is based on a computer programming language called Visual Basic. The Microsoft programming environment, called Visual Basic for Applications, has a special format and syntax that must be followed in order for the computer to properly perform the work. This VTC course describes the reserved keywords, structures, and language aspects that a user would need to know in order to create customized processing for Microsoft Office applications. Work Files are included.

Find out more about Microsoft's productivity tools!

- Learn and understand the purpose of Microsoft's tools
- Know more about the functionality and features of each application
- Learn about functions that you never knew existed in Microsoft's tools
- Be fluent and an efficient user in Microsoft tools by the end of this course

This course is SkillsFuture Credit Eligible.


Course Objectives

1. Know and understand the basics of Microsoft Visual 
2. Know how to navigate the interface and tools pane 
3. Understand about Data Variables and Loops
4. Understand about Macros, VBA Expressions and Dialog boxes 
5. Knows about Conditional Processing 
7. Know how to test your work 


Related Courses

  • FileMaker Pro 13: Beginner

    FileMaker Pro 13: Beginner

    SGD $76.00

    Course Description

    FileMaker Pro is powerful enough to handle most database jobs, yet easy enough to create simple solutions in minutes. This practical ’how to’ course by FileMaker expert John Mark Osborne starts from beginner level and uses a single invoicing example to demonstrate all the features in FileMaker Pro 12 and 13. Feature that include: field creation, finding, sorting, layout mode, container fields, auto entry, validation, printing, scripts, calculations, importing, exporting, interface design as well as new FileMaker Pro 13 features: charting, snapshot links and the inspector. Examples of the invoice file are provided at every stage of the creation process so the user can easily review one section without starting from the beginning.Discover how data can be managed efficiently. - Find out how you can manage your database- Learn ways to fully utilize your data's potential - Know how queries can be implemented to run the data better - Understand an effective solution to optimize your database's productivity This course is SkillsFuture Credit Eligible.

    Read more...

  • Introduction to Cloud Computing

    Introduction to Cloud Computing

    SGD $45.00

    Course Description

    Technology is evolving and changing to embrace the cloud. Cloud computing allows you to utilize shared resources available through a service provider. Those resources can be storage space, use of software applications, or servers. You can buy more resources in the cloud if you need to and you can also give back resources that you no longer need. In this hands-on VTC course, you will access a variety of cloud services and work with different cloud providers such as Apple, Microsoft, Google, and Amazon. You will set up virtual servers, work with cloud file storage, learn about a variety of cloud collaboration options, and much more. This practical course will help you make the transition to working in the cloud from any device, anywhere, anytime! Cloud computing offers you unrestricted access to your resources. - Learn about the advantages of using cloud services- Learn about the various cloud services offered today- Know how to make full use of the cloud services for your resources - Understand how you can setup a cloud service for your own use This course is SkillsFuture Credit Eligible.

    Read more...

  • An Essential Online Course: Digital Collaboration with Office 365

    An Essential Online Course: Digital Collaboration with Office 365

    SGD $79.60

    Course Description

    Working with several separate software applications can be challenging. Microsoft Office 365 simplifies the process with an integrated collaboration and communication solution. Combining well known software applications with cloud features helps individuals and teams work together more productively. This course looks at the common features of Office 365 and how they can be used to support collaboration and communication. You and your staff will learn how to monitor and collaborate on projects and tasks, share knowledge and content with colleagues, and use social and communication tools efficiently. Discover the different products of Office 365 today! - Explore the different features in Office 365 - Know more about the functions of each individual product  - Learn about the purpose of the different products in Office 365 - Discover the usefulness of Office 365 for your job  This course is SkillsFuture Credit Eligible.

    Read more...


Content

Introduction

+

What VBA Is

What This Course Is About

VBA vs. Visual Basic

Using the VBA Editor

Data and Variables

+

Data Types

Storage and Data Sizes

Declaring Variables

Variable Names

Putting Values in Variables

Creating Constants

String Variables

Handy String Functions

What an Array Is

Creating Arrays

Resizing Arrays

2-Dimensional Arrays

Sample Variables

Using Macros

+

Macro Recording

Recording a Macro

Running a Macro

Editing a Macro

Help in VBA

Application Object

VBA Expressions

Preview Available

+

Simple Arithmetic Operators

Advanced Arithmetic Operators

Comparison Operators

Logical Operators

Order of Operations

Mathematical Expressions

Using Functions in Formulas

Mathematical Functions

Conversion Functions

String Functions

Finding Words in Strings

Replacing and Comparing Strings

Sample Expressions

Working with Dates

Date Functions

Dialog Boxes

+

User Interaction

Using Message Boxes

Format Options

Results of Message Boxes

Using Input Boxes

Functions and Procedures

+

Creating a Subroutine

Understanding Parameters

Parameter Passing

Function vs Procedure

Return Statement

Sample Function AVE

Arrays as Parameters

Conditional Processing

+

What Conditional Processing Is

IF Block

Complex Conditions

Nested IFs and Elseif

Using IF in Coin Toss

Sample Function MIN

Multiple Outcomes

SELECT Block

Multiple CASE Statements

Conditional Functions

Loops

+

Parts of a Loop

Infinite Loops

DO WHILE Loop

DO UNTIL Loop

FOR Loops

Running Arrays

Update AVE Function

Sample Array Sort

Sample Swap Routine

Tracing FOR Loops

Step Value in For Loops

EXIT Statement

Testing Your Work

+

The Debug Environment

Seeing Values

Stepping Through Code

Breakpoints

Finding and Fixing Errors

Conclusion

+
Resource Files

What We Learned

Planning for your VBA Code

Credits

+

About the Author

SkillsFuture Credit Eligible
SGD $45.00
(Price excludes GST)
GET ACCESS NOW
Convince your boss email
This site is best viewed using the latest versions of Google Chrome, Apple Safari, Mozilla FireFox, Microsoft Internet Explorer 11 and Edge which supports HTML5/Webkit technologies.