DISCOVERING THE SECRETS OF MACRO AND VBA IN MICROSOFT EXCEL

By LIVE ONLINE PROGRAM

Date:

16 & 17 Feb 2022 (Every session 9am - 5pm)

Wed & Thus

Venue:

LIVE ZOOM

MACRO AND VBA IN MICROSOFT EXCEL

Are you facing a repetitive clean up of fifty tables in Word? Do you want a particular document to prompt the user for input when it opens? Are you having difficulty figuring out how to get your contacts from Microsoft Outlook into a Microsoft Excel spreadsheet efficiently?

You can perform these tasks and accomplish a great deal more by using Visual Basic for Applications (VBA) for Office—a simple, but powerful programming language that you can use to extend Office applications.

INTRODUCTION

Generally, MACRO AND VBA IN MICROSOFT EXCEL, Microsoft Excel is a spreadsheet application used to create lists, perform calculations, and analyse numbers. While the default features of Excel should be enough in most scenarios, in some cases you will want more complex functionality to perform advanced operations. To make this possible, Excel is accompanied by Microsoft Visual Basic, a programming environment that allows you to use the Visual Basic Application (VBA) language to enhance the usefulness and functionality of a spreadsheet.

VBA allows you to write code that can automatically perform actions on a document and its content. Besides as an end user, now you are a ‘programmer’ to use Excel as a development tool to design an information system.

OBJECTIVES

This course is designed for working adults for the following objectives:

– To improve current spreadsheet (Microsoft Excel) solution skills.

– To use Visual Basic Application (VBA) language to automate daily tasks.

– To prepare students in designing an user-friendly interface in Excel

– To prepare students to train others.

LEARNING OUTCOMES:

At the end of the MACRO AND VBA IN MICROSOFT EXCEL course, students should be able to:

  1. Understand and apply VBA language commands in Excel
  2. Use VBA to control the internal calculation or formulas or data flow in the reports.
  3. Design custom user interfaces in Excel.
  4. Simplify and speed up the tasks using VBA/ Macro

ENQUIRY form

    ORGANIZATION DETAILS





    PERSON-IN-CHARGE DETAILS



    FOR FURTHER INFORMATION, PLEASE CONTACT US!