Excel VBA for Beginners

One of the World’s Most Productive Software

Duration: 1 day (8 hours)
Workshop Date: 28 August 2020
Time: 9 am to 5 pm

Fees: $214 (inclusive of GST)
Venue: Informatics Academy

Visual Basic for Applications (VBA) is the programming language of Excel (and other Office programs), which specifically allow you to automate your repetitive tasks in Excel by writing so called macros.

VBA combined with Microsoft Excel is probably the most powerful tool available to you. VBA is sitting on the desktops of 500 million users of Microsoft Office, and most have never figured out how to harness the power of VBA in Excel.

Using VBA, you can speed the production of any task in Excel. If you regularly use Excel to produce a series of monthly charts, you can have VBA do the same task for you in a matter of seconds.

Learning Objective

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 since code runs much faster and save a huge amount of time for you.

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. You need not have previous knowledge of any programming language so it’s ideal if you’re a newcomer to Windows programming.

By the end of this workshop, you will:

• 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

Pre-Requisite: Basic knowledge of Microsoft Excel is required

Who Should Attend?

This workshop is ideal for learners who are seeking to expand, optimize, and increase the efficiency of their Excel spreadsheet skills using powerful programming, automation, and customization capabilities available with Visual Basic for Applications (VBA).This workshop is also suitable for people who use Microsoft Excel in their day-to-day work, and know the basics of Excel pretty well, and would like to extend their knowledge of the more advanced features & functions of Excel to become more productive and make the most of Microsoft Excel 2016.

Workshop Content

Session 1: Introduction to VBA Macros

  • Displaying the Developer Tab
  • About Macro Security
  • Saving Workbook that contain Macros

Session 2: Types of VBA Macros

  • Creating VBA Macros
  • Recording Macros

Session 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
  • Using Functions in a Worksheet
  • Function Procedures
  • Executing Functions Procedures
  • Working with Ranges
  • Selecting a Row or Columns
  • Moving a Range

Session 4: Working with Workbooks

  • In this section all the VBA knowledge will be
    applied to automate workbooks
  • Conclusion, sharing and reflection of learning.

Quick Enquiry