Basic Excel VBA Programming Course for Beginners

First, solve the problem Then, write the code.
Basic VBA Course

Course Title: Basic Excel VBA Programming for Beginners

Designed for non VBA practitioners to solve real business problems with VBA programming & Excel macros.

Training Course Duration (days)
03
Location:
Singapore
Venue:
Frasers Tower
Dates:
Ask for dates
Funding:
SkillsFuture subsidies not applicable yet

What is VBA?

Microsoft Excel is a powerful tool that you can use to manipulate, analyze, and present data. Built within Excel is a computer programming language called VBA (Visual Basic for Applications). The idea is by writing a VBA computer program, you can instruct Microsoft Excel to perform complex, repetitive and even mundane tasks on your behalf. Used properly on suitable problems, a VBA program working within Excel can have wide ranging automation benefits that can increase a department’s productivity. As machine automation begins to take over many human tasks, learning how to code has been said to be an attractive employability skill for the future.

Course Objective for Basic VBA Course

Designed for non VBA computer programmers. This is a short & easy-to-follow workshop to develop a practical knowledge of VBA (Visual Basic for Applications) with Microsoft Excel. The participant will learn how to build VBA programs from scratch that can automate Microsoft Excel to perform work. Throughout the course of the workshop, our facilitator incorporates VBA codes which address real life business problems.

What problems this course solves

Traditional Excel VBA courses overwhelms the non-practitioner with too many programming concepts. Consequently, the learner grasps the theory but not the practical experience to produce VBA codes for solving basic spreadsheet problems.

Gentle Learning Course Structure

Basic VBA Course

Basic VBA Course Outline

* Using the Visual Basic Editor
* The VBA programming workflow from code to execution
* Useful tips and tricks from real world situations
* VBA coding from scratch
* Developing with Excel Macros
* Processing massive records & Excel rows with VBA programming
* Create an automated report application with VBA
* Create an automated stock trading program with VBA

This workshop aims to train anyone with no programming experience to be proficient with the VBA programming language within Excel. By solving various challenging problems and doing guided projects, the participant will learn to perform a wide variety of automation tasks to improve Excel productivity and embark on interesting office automation projects.
Basic VBA Course
Create a full featured automated business reporting app in our workshop.
Basic VBA Course
Create a full interfaced VBA application in our workshop

Who Should Attend This Course

For Excel users who wish to expand their skill set to engage greater analyst roles. Participants are expected to have a good working knowledge of Excel as a pre-requisite.

Training Provider

VBA is a deep computer language. Like learning any language, instructor quality determines how much you get out of the classroom. Learn from real practitioners with over 15 years of development & consulting experience. Unlike other centers, we keep our classes small so that there are real discussions about real problems.

Course Trainer

Derek Leong is a fellow Consultant at Aeternus. He has a broad background in marketing, business analysis & software development. When he conducts Excel and other courses, he combines technical expertise and business experience with a creative bent.

Basic Excel VBA Course Lesson 1

Write your first piece of VBA code!

It may appear strange that to write VBA codes into an Excel workbook, we do not use Microsoft Excel!Instead, we use another application called the Visual Basic Editor (VBE) to write the code in text. This VBE application will save our VBA codes into the Excel workbook.Simply follow these steps:
  1. Start up Microsoft Excel.
  2. Press ALT+F11 key to start the Visual Basic Editor coding environment.
  3. A new windowed application will appear like below. This is where you will write your first VBA code.
basic excel vba singapore
Currently, the VBE window appears rather “empty”. You need to “Insert a Module” before you can start typing in some VBA code. This is always done in any Excel VBA project big or small.
Follow these steps:
  1. On Visual Basic Editor menu bar, click “Insert” then “Module“. You should see a new white surface to type your VBA code appearing on your right.
basic excel vba singapore
You can type these VBA codes into a module like writing in a NotePad. basic excel vba singapore

Make sure your typing cursor is stays inside the Excel VBA code you have just typed. Press “F5” on your keyboard and Microsoft Excel will run the VBA code!


basic excel vba singapore

Basic Excel VBA Learning Resources

Great Art Pixelated with Excel VBA

You can create beautiful pixelated artworks with this Excel VBA application! There are creative ways to use it. Create unique avatars for Zoom meetings or WhatsApp!

Fastest Search Excel VBA Codes

In this article I set myself a challenge to write the fastest VBA codes to locate a cell in a range of 5 column by 1048576 rows (5.2 millon cells) in a worksheet. They are written to be reusable in your own Excel VBA projects.

Corporate Clients

We have helped teams from various organisations.

We work with businesses and individuals

who need effective Microsoft Office training solutions.​

We organise bespoke corporate workshops​

to improve employee productivity using Microsoft Office Tools.

Trainers with decades of real-world consulting experience

so you can ask us anything.

About Aeternus Consulting

Best Excel courses in Singapore conducted by expert consultants

Aeternus Consulting is the premier training centre in Singapore for Excel CoursesBasic Excel, Advanced Excel and Excel VBA Macro courses. For more Microsoft Excel training courses, please visit our Excel training page.

Aeternus Consulting is now on Instagram! So take a look and follow us on Instagram.