Call +65 6100 0613 Email: enquiry@tertiaryinfotech.com

Instructor-led Classroom Adult Training in Singapore - Modular Fast Track Skill-Based Trainings

Visual Basic Application (VBA) for Excel Training

ln this Visual Basic (VBA) for Excel Training, the trainer will introduces object-oriented programming and show how to automate routine tasks and provide custom functionality to enhance Excel performance and efficiency. This course introduces the Visual Basic for Applications programming language, covers creating subroutines and functions to hold code.

Topics include:

  • Working in the Visual Basic Editor
  • Adding code to a macro
  • Creating, exporting, and deleting code modules
  • Declaring and using variables
  • Managing variable scope
  • Defining arrays
  • Managing workbooks and worksheets with VBA
  • Repeating tasks with loops
  • Debugging VBA code
  • Cutting, copying, and pasting cell data
  • Running and triggering event procedures

After your registered for the course, you can apply SSG grants below

Click here to apply SkillsFuture Credit for Individual

Click here to apply WSG Absentee Payroll for Company
Course Code: CRS-N-0034981

Course Booking

$248.00 (GST-exclusive)

Course Date

Course Time

* Required Fields

Course Cancellation/Reschedule Policy

We reserve the right to cancel or re-schedule the course due to unforeseen circumstances. If the course is cancelled, we will refund 100% to participants.
Note the venue of the training is subject to changes due to class size and availability of the classroom.
Note the minimal class size to start a class is 3 Pax.


Training Grant and Subsidy

All Singaporeans aged 25 and above can use their $500 SkillsFuture Credit from the government to pay for a wide range of approved skills-related courses. Visit the SkillsFuture Credit website www.skillsfuture.sg/credit to choose from the courses available on the SkillsFuture Credit course directory

Course Details

Module 1 Introduce Visual Basic for Applications (VBA) 

  • Introducing object oriented programming
  • Examining Excel object model
  • Working in the Visual Basic Editor
  • Setting VBA project properties
  • Creating, exporting, and deleting code modules
  • Creating a subroutine or function
  • Controlling procedure scope and visibility
  • Adding comments to the code
  • Running a VBA routine
  • Adding code to a recorded macro

Module 2: Defining Variables, Constants. and Calculations

  • Introducing Excel VBA data types
  • Declaring variables and requiring declarating before use
  • Managing variable scope
  • Defining static variables and constants
  • Creating a calculation using mathematical operators
  • Defining arrays
  • Defining and using object variables
  • Streamlining code reference

Module 3: Adding Logic to VBA Code

  • Repeating a task using a For Next loop
  • Stepping through all items of a collection Using the For Each loop
  • Repeating a tasking using the Do loop
  • Performing a task when conditions are met using the If - Then
  • Selecting which item to take using the Case statement

Module 4 Debugging Your VBA Code

  • Managing errors using On Error statements
  • Stepping through a subroutine or function
  • Setting breakpoints in the code
  • Verifying output using the immediate window
  • Watching a value in a routine

Module 5 Managing Workbook Elements and Data in VBA

  • Writing a value to a cell
  • Cutting, copying and pasting cell elements
  • Finding values in cells
  • Referring to cells using the Offset function
  • Concatenating text strings
  • Returning part of a string
  • Managing worksheets with VBA
  • Managing workbooks with VBA

Module 6 Adding Advanced Elements to Your Workbook

  • Turning off screen updating within a macro
  • Using worksheet function in a macro
  • Acquiring values using an input box or message box
  • Calling a subroutine from another subroutine

Module 7 Using Excel Events in Your VBA Code

  • Running a procedure when you open, close or save a workbook
  • Running a procedure when a cell range changes
  • Triggering a procedure using a specific key sequence

Who Should Attend

  • Office workers that use VBA to automate Excel
  • Engineers that want to VBA to perform mathematical calculations
  • Finance workers that want to VBA to perform finance tasks

Prerequisite

Nil

Trainers

Excel VBA TrainerPeter Goh is the Technology Evangelist at Disruptive Digital, a full-service digital agency based in Singapore, offering innovative & effective web and native mobile application development. He specializes in bleeding edge software development and have more than 10 years' experience in developing customized applications for desktop, web and mobile platforms. He has extensive domain knowledge in .Net and Java programming, iOS development and has helped many to create e-commerce web sites on Amazon AWS and Microsoft Azure

Excel VBATrainerKhoo Yong graduated from NTU with a bachelor degree in Mechanical and Production Engineering. Currently, working as a principal engineer in one of the top 3 Semiconductor Manufacturing Pure-Play Foundry in the world, he is a statistician support Operations and Engineering, driving the Statistical Process Control Program in the Fab. He specializes in Statistics , basic Excel and advance Excel, including excel macro coding. He regularly conduct Statistical Process Control Courses in the company. He is a certified ACTA Trainer ( Advance Certificate in Training and Accessing) as well as a certified Black Belt.

VBA TrainerCarey is an undergraduate at the Singapore University of Technology and Design (SUTD). He has previously interned at DSO National Laboratories, where he co-wrote a research paper on differential cryptanalysis on block ciphers. As an avid game developer, he has clinched 1st runner-up twice consecutively at the Singapore Games Creation Competition.

Besides having a vested interest in machines, he tries in his capacity to make a difference in society. In 2014, he co-wrote a research paper pinpointing the location of various civil unrests in Singapore, and advocated for the importance of civil unrest commemorative markers at the Anatomy of a Riot conference organised by the Singapore Heritage Society. Thereafter, he was invited to intern at the Ministry of Home Affairs to finetune the research. If one pays attention when crossing the junction of Alexandra Road and Tanglin Road, one can spot a blue rectangular marker commemorating the 1955 Hock Lee Bus Riots. The commemorative marker was established by the National Heritage Board after consultations with his team and the Ministry of Home Affairs.

When he is not trying to meet the demands of being an undergraduate in Singapore, he might be taking solitary walks in parks, or working on his pet projects involving Arduino or Raspberry Pi microprocessors.

VBA Learn TrainerMarcus Lee has his degree in Computer Science and a background in Statistics from the University of Otago. Before returning to Singapore, he analysed vacation data provided by the New Zealand Board of Tourism to determine the favourite activities of Australian, Japanese, and German tourists in New Zealand. In addition to a vast number of other demographics statistics, he has been able to provide significant advice to the board on how to promote tourism in New Zealand. His core specialization skills are Java, R, Statistical Analysis, Machine Learning, NumPy, Scikit, and Network Management. He has also a fair amount of experience in C, C++, and Python.

Excel VBA TrainerRaaj has 14 years of experience in Designing , delivering and supporting, products, projects and programs in the area of enterprise SAP and Data Science . He is certified in SAP ABAP,HANA and ACTA certified as well .

He has also trained many consultants and developers on Data Science, R programming, Python, SAP HANA, BI and related products and worked extensively in Asia ( Singapore, Bhutan, Vietnam, India, Myanmar ). His core specialization skills are R programming, Python, Azure Machine Learning, SAP HANA.

Excel VBA TrainerEric Goh is a seasoned Data Science Researcher and Software Engineer with years of experience in multiple industries. Eric Goh’s varied career includes data and text mining, intelligent systems development, IT project management, engineering product design and researches. During his free time, Eric teaches as an Adjunct Instructor at the University of the People. He also started SVBook.com, and developed his own data science software at DSTK.Tech. He holds a Master of Technology degree, Executive MBA degree, and a Graduate Diploma.

VBA  TrainerSundari has more than 10 years of experience in Software Training and Development. She initiated her career as a Trainer and worked in various companies, developing and nurturing client relationships. She is passionate about training and to impart her knowledge to others and always eager to learn more.

Area of expertise:

  • Data Warehousing - SAP BI 7.0
  • Reporting Tools - BEx Query Designer, BEx Analyzer, Web Analyzer, Web Application Designer, BEx Report Designer and Dash Boards
  • Language - Visual C++ (6.0), C#(.Net), C, C++, Java and also in SAP ABAP/4, SD, FI
  • Operating Systems - Windows10, 7, 2000.NT, 98, XP, MS-DOS, Unix
  • Databases - Oracle 9i/8i, SQL Server and MS-Access
  • GUI - Visual Basic 6.0, Power Builder 5.0, Developer 2000 
  • Java-script, HTML5, CS6, Dreamweaver, MS-Office.

She is currently pursuing Masters in Business (ERP Systems) in Victoria University, Australia. She has completed her Bachelors in Computer Science in Bharathiar University, India and Professional Diploma in SAP Business Intelligence in Victoria University, Australia - Lithan Hall Academy, Singapore. She is certified in SAP BI 7.0 (TBW45_70) and Oracle 9i PL/SQL Developer from Oracle Corp U.S. Also certified in ACTA (Advanced Certificate in training and assessment) from WDA Singapore.

VBA TrainerDr. Cao Yongxin (Steve) has more than five years of solid industrial and research experiences in data analytics. He held PdD on operations research in National University of Singapore. After his Phd study, he worked as data analyst and scientist in manufacturing and commodity trading companies. He is specialized in analyzing, visualizing and mining complex time series data using Python tools sucha as Pandas, Numpy, Matplotlib, SK-Learn, Tensorflow etc. He did research on predictive analytics on various systems e.g., Forex and commodity trading, system performance prediction, machine maintenance, etc. Besides data analytics using Python, he also extended his expertise in Microsoft Excel VBA, Hadoop big data platforms such as AWS and Microsoft Azure. In addition, he is strong in mathematical modelling and has cross-disciplinary domain knowledge in operations research, currency and commodity trading and industrial automation.

VBA TrainerDr. Shailey Chawla is an experienced academician and researcher with over 10 years of experience in teaching and research. Her PhD research topic was on Web Requirements Engineering. She has published various research papers and book chapters in reputed international journals and conferences. Her recent research has been in Big Data Analytics at Hong Kong Polytechnic University where she worked on Urban Data Analytics and Educational Data Mining. She is proficient in R, Python, Java, Advanced Excel, Data Mining, C, Linux programming among various other core computing subjects.

VBA TrainerKen Hiong has over 20 years of work experience in the healthcare and pharmaceutical industry holding various functional and managerial roles in sales, marketing, business development, finance, business analysis and planning.

He graduated with a degree in Pharmacy and holds a Master of Business Administration from the National University of Singapore and a Master of Applied Finance from the University of Adelaide.

He is an expert Excel user and has a keen interest in scripting and web development with practical knowledge of HTML, Javascript, CSS, PHP, MySQL, WordPress, VBA, amongst others. Applying these tools at work, he had simplified many work methodologies, improved data analysis and business reporting processes, achieved higher productivity and enhanced quality outcomes. He is an advocate of lifelong learning.

Customer Reviews (7)

Will RecommendReview by Joan Lim
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
Very patient and clear explanation from trainer (Posted on 7/27/2018)
Will RecommendReview by Tan Jit Choon
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
The course material is comprehensive, but will be better if it contains examples of actual usage of the functions (Posted on 7/27/2018)
Will RecommendReview by Ryan
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
more practices (Posted on 7/8/2018)
Might RecommendReview by Henry Fung
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
Nil (Posted on 11/23/2017)
Will RecommendReview by Feng Rui
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
Nil (Posted on 9/22/2017)
Will RecommendReview by Hock Chai
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
Nil (Posted on 5/7/2017)
Might RecommendReview by Kenneth Choo Wei Jie
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
More practice and tasks on the spot which i find interesting (Posted on 3/19/2017)

Write Your Own Review

You're reviewing: Visual Basic Application (VBA) for Excel Training

How do you rate this product? *

  1 star 2 stars 3 stars 4 stars 5 stars
1. Do you find the course meet your expectation?
2. Do you find the trainer knowledgeable in this subject?
3. How do you find the training environment
  • Reload captcha

Tags

Use spaces to separate Subjects. Use single quotes (') for phrases.

You May Be Interested In These Courses

Advanced Excel Essential Training

Advanced Excel Essential Training

7 Review(s)
$228.00 (GST-exclusive)
Statistical Data Analysis Training with Excel

Statistical Data Analysis Training with Excel

14 Review(s)
$298.00 (GST-exclusive)