+65 8133 0642 / +65 9138 9813 info@xaltius.tech

Excel VBA for Beginners

This is a beginners course which takes you through how Excel combined with VBA can prove to be a strong combination for automating repetitive tasks very easily.

What You’ll Learn

This beginner level training helps you learn the VBA language, and find practical ways to automate tasks and build a better workflow and automation in your work. It aims to help you automate routine tasks by recording, and writing/editing the Visual Basic For Applications (VBA Code) for Microsoft Excel. In this workshop you will learn the various programming nuances of VBA, work with Macros and how spreadsheets in Excel can be easily automated for various operations. This workshop will provide you with step-by-step instructions that illustrate each aspect of Visual Basic. 

Please click the event link in the timetable for the respective price.

Course Plan

MODULE 1: INTRODUCTION TO VBA MACROS
  • Displaying the Developer Tab
  • About Macro Security
  • Saving Workbook that contain Macros
MODULE 2: TYPES OF VBA MACROS
  • Creating VBA Macros
  • Recording Macros
MODULE 3: WRITING VBA CODE
  • Introduction to Variables
  • Controlling Execution
  • Flow of Control commands (IF, SELECT, FOR, DO, WHILE etc.)
  • Overview of VBA Functions / User-defined Function
  • Using Functions in a Worksheet
  • Function Procedures
  • Executing Function Procedures
  • Working with Ranges
  • Selecting a Row or Column
  • Moving a Range
MODULE 4: WORKING WITH WORKBOOKS
  • Automating Workbooks Utilizing VBA knowledge

Timetable

July 4th, 2020 – Click here to register

Prerequisites

Basic knowledge of Excel would be beneficial for this workshop.

About the Course

These are the key takeaways that participants will gain:

  • Gain a working understanding Excel VBA
  • Learn how to automate excel workbooks effectively for various operations
  • Record and Run Macros Easily
  • Gain knowledge on how to write macro programming in Excel
  • Code more efficiently in VBA

Relevant Courses

Data Literacy – Let the data journey begin!

Data Literacy Before embarking on the data journey, organizations need to be equipped with the right skills and be data literate. This course walks through that journey and empowers individuals with the skills required to get an organization ready. What You'll...

read more

Amazon Web Services and Introduction to DevOps

Cloud has become the go-to place today for storage, computation, security and many other services. The cloud is disrupting the analytics industry and taking over processes and applications by storm! This course helps you understand the fundamentals of AWS and DevOps Lifecycle.

read more

Microsoft Azure: Machine Learning

Cloud has become the go-to place today for storage, computation, security and many other services. The cloud is disrupting the analytics industry and taking over processes and applications by storm! This course helps you understand how you can perform analytics and machine learning using the cloud.

read more