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

  • Strategize with Service Oriented Architecture - Part 3

    Strategize with Service Oriented Architecture - Part 3

    SGD $45.00

    Course Description

    SOA: Service Orientated Architecture part 3 This training has been created to provide you with relevant and important information concerning SOA: Service Orientated Architecture. During this training we will be concentrating on the main points of applying design strategies to a service orientated architecture. You will also learn all there is to know about SOA, how to design and apply the best principles, tips and techniques with detailed practices and principles. We will also be covering various aspects of legacy systems and applications, providing information on security, and appropriate governance with clear details to help you achieve success with SOA, including the design and creation of services for implementation within your enterprise. By the end of this training you will have a high level overview of the benefits of SOA, how to design and implement SOA in your business today. Very little is discussed regarding APIs or code unless used to display the implications of certain technologies and standards. This is a technical training, which is focused on architects, designers, business analysts, IT managers and executives. Achieve success with Service Oriented Architecture.  - Know how to align your business strategy  - Identify what sort of strategy your business needs to strive  - Learn how strategies can help bring your business to greater heights - Know the benefits of Service Oriented Architecture 

    Read more...

  • Notes & Citations

    Notes & Citations

    SGD $99.00

    Course Description

    Microsoft OneNote® is a powerful notetaking and organization tool for teachers and students. Its robust features allow you to create organized pages enhanced with multimedia elements. Annotation and search features also make it an excellent study and active learning resource. Best of all, these tools can be shared by groups of users for collaboration and interaction. In this online course, we explore the powerful Microsoft® OneNote program in the context of teaching and learning.Improve your notetaking and organization skills with this course!- Learn how OneNote can improve the way you take notes- Improve your productivity one step at a time with OneNote- Discover the many different usage of OneNote- Understand how OneNote may just be the right tool for youThis course is SkillsFuture Credit Eligible.

    Read more...

  • Explore iOS 6

    Explore iOS 6

    SGD $40.00

    Course Description

    iOS 6 is the world's most advanced mobile operating system. Version 6 brings tighter integration with social media, new maps, refinements with Siri, and so much more. This VTC course explores the new features of iOS 6 along with the basics of operation. VTC author Sam McGuire demonstrates how to set-up your device and get the most from its day to day use. Topics include: app usage, interfacing with iCloud, social media, and a host of other practical applications. This course covers everything you need to get the most from your mobile devices.Keep yourself updated with the new changes in iOS. - Learn about the changes in the latest version of iOS - Undersatand about the operating system - Discover the newly-added features in each new version - Go through an in-depth view of the features of each iOS 

    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.