Skip To Content
Automate Routine Tasks using Microsoft Excel Macros is a Program

Automate Routine Tasks using Microsoft Excel Macros

Self-paced

Sorry! The enrollment period is currently closed. Please check back soon.

Full program description

Automate Routine Tasks using Microsoft Excel Macros

Who Should Attend

  • Participants who would like to know what is Recording Macros and how it can help in their daily work with minimum programming skills
  • Participants who would like to know what is Visual Basic Application in Microsoft Excel

Course Duration

1 Day / 7 Hours

Course Outline

Working with macros

  • What is a macro?
  • Limitations/drawbacks
  • Using macros
  • Where a macro is stored
  • Recording a macro
  • Running a macro
  • Assigning a macro to a toolbar button
  • Assigning a macro to a keyboard combination
  • Assigning a macro to a menu
  • Assigning the macro before the macro is recorded
  • Assigning a worksheet button to your macro

Opening the visual basic editor window

  • The code window
  • The project explorer
  • The properties window
  • Inserting a new module
  • Statements
  • Sub, end sub statements
  • Data types
  • Variables and constants
  • Declaring variables
  • Assigning variables
  • User interaction

Using Excel Objects

  • The Application Object
  • The Workbook Objects
  • Program Testing with the Editor
  • Using Workbook Objects
  • The Worksheets Object
  • Using the Worksheets Object
  • The Range Object
  • Using Range Objects
  • Using Objects in a Procedure

Functions in VBA

  • Understanding Functions
  • Creating User-Defined Functions
  • Using a User-Defined Function in a Worksheet
  • Setting Function Data Types
  • Using Multiple Arguments
  • Modifying a User-Defined Function
  • Creating a Function Library
  • Referencing a Function Library
  • Importing a VBA Module
  • Using a Function in VBA Code

Course Objectives

Upon course completion, participants will be able to:

  • Tell what is Macro and the limitation of Macro
  • Record various types of Macros
  • Know what is VBA in Microsoft Excel
  • Add user interaction with Macro using Message Box

Pre-requisites

  • Simple typing using the keyboard
  • Navigating using the mouse
  • Managing files and creating folders
  • Working knowledge of Microsoft Excel 2013 or 2016

Price

 Original course fee $299.60 (with GST)
 After funding for NTUC Union Member $20 (with GST)


Terms and conditions apply. NTUC LearningHub reserve the right to make changes or improvements to any of the products described in this document without prior notice.

Prices are subject to other LHUB miscellaneous fees

UDSIT12