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

Non-NTUC member: $270

NTUC member: $20

UDSIT06