Home > Courses > WSQ - Automating Excel with VBA Programming

WSQ - Automating Excel with VBA Programming

Name: WSQ - Automating Excel with VBA Programming
Price: 450 SGD
Rating: 4 (35 reviews)

Training Provider: AVANTUS TRAINING PRIVATE LIMITED

Course Reference: TGS-2023036548

S$450

Original: S$900

Save S$450

About This Course

At the end of the course, Learners will be able to:
• LO1. Identify relevant controls, elements and features that can be included in the customization of Excel to meet design objectives
• LO2. Scope and design customisations in Excel to meet the business and functional needs of the organisation
• LO3. Apply VBA design methods and tools to achieve planned customisations
• LO4. Evaluate and improve the functionality and interoperability of the customisations made
• LO5. Document customisations made in relation to user specifications and requirements

What You'll Learn

This 3-day course will equip learners with the knowledge and ability to automate most tasks in Excel using Visual Basic for Applications (VBA). Learners will learn how to record macros and script Excel to automate procedures and processes. Learners need not have programming background to pick up these skillsets as they will be guided to code from scratch using the intuitive language of VBA. A good knowledge of VBA can help save time, simplify and streamline work processes, and improve productivity at work.

Entry Requirements

The learner should possess:
- Ability to use the basic functions of Microsoft Excel
- Ability to read, listen, speak and write in English at a level equivalent to Workplace Literacy Level 5
- At least 3 GCE 'N' Level Passes
- At least 1 year of working experience in any field that uses computers at work

Learners who do not meet the education requirements but have at least 3 years of relevant work experience can be accepted on a case by case basis subject to approval by the Management Representative.