Microsoft Excel 2013 - Level 5 (Introduction to Excel VBA)

MDIS


Course introduction

Most people express a modicum of surprise when told that Excel alike Access it can be enhanced with Visual Basic (VB). But it should really be no surprise at all since both programs share a similar structure. Increasingly, Visual Basic (VB) is being used to enhance Excel's basic functionality and create intelligent spreadsheets and financial models.



Course Benefits


Upon completion of this workshop, participants will be able to;

  • This course aims to introduce Visual Basic Application (VBA) in as non-threatening a manner as possible
  • Beginning with wizards and macros, participants are led through the methods and syntax of simple programming in Visual Basic (VB), culminating in writing custom code, customising Excel elements and debugging



Target Audience


This course would benefit anyone who wishes to harness the power that Excel can demonstrate when combined with programming in Visual Basic (VB).



Course Outline


Recording Macros

  • Macro Recorder Overview
  • Recording Macros
  • Macro Storage
  • Assigning Shortcuts
  • Recording Formatting Macros
  • Recording Calculation Macros
  • Testing Macros
  • Relative Recording
  • Assigning Macros to Toolbars
  • Viewing Macro Code
  • Modifying Recorded Macro
Introduction to Visual Basic Application (VBA)
  • Overview of Visual Basic Application (VBA)
  • Visual Basic Editor Interface
  • Project Explorer
  • Properties Window
  • Code Windows
  • Setting General Options
  • Modifying Existing Code
  • Creating Reference to Object
  • Setting Object Properties
  • Using With… End with Structure
  • Commenting Statements
Variables, Data Types and Constants
  • Variable Naming Rules
  • Declaring Variables
  • Defining Data Type
  • Scoping Variables
  • Working with Constants
Procedures
  • Overview of Procedures
  • Creating Command Procedures
Using Excel Objects
  • Excel Object Model
  • Using Workbook Objects
  • Using Worksheet Objects
  • Using Range Objects
  • Objects In Procedures
Programming Techniques
  • Communicating with the User
  • Prompting for User Input
  • Creating Conditional Statements
  • Testing for Multiple Conditions
  • Looping / Repeating Statements
User-Defined Functions
  • Creating Custom Functions
  • Passing Arguments
  • Creating Add-Ins
Creating Custom Forms
  • Userform Overview
  • Creating Custom Form
  • Modifying Form Properties
  • Adding Controls to Form
  • Control Properties
  • Running a Form
Methodologies

Participants must be familiar with Excel when attending this course. This course is not suitable for beginners.
A combination of lectures, explicit teaching, practical demonstrations and peer teaching is applied for this course.

Key Information
 
Duration 2 days
Time 9 am to 5 pm
Date 14 - 15 Jan 2019
25 - 26 Apr 2019
26 - 27 Aug 2019
09 - 10 Dec 2019
Trainer Microsoft Certified Trainer

Course Fee
 
Member $363.80
Non-Member $428.00
 
  • Members enjoy a 15% discount before GST
  • Group Discount (5 or more participants) - 10%
  • All fees are inclusive of 7% GST
Funding Available

1) COMPANY SPONSORED PARTICIPANT
  • SDF GRANT REIMBURSEMENT (Non-WSQ)
  • SDF Grant Amount: S$28.00
  • SDF Course Code: CRS-N-0030704
2) INDIVIDUAL PARTICIPANT
SkillsFuture Credit
(Individual Singaporean aged 25 and above)
Pre-approved SkillsFuture funding of S$500.00



Available Course Sessions


Please click here to stay updated on upcoming sessions.



Trainer Profile


Microsoft Certified Trainer

All of our Associate Trainers offer our high level of service therefore are subject to regular peer assessments and interview prior to joining our Institute. They must all be qualified and have relevant experience to an agreed level and are subjected to continual audit and evaluation. Strict internal assessment is implemented as an integral part of our quality control mechanism.



 

Top