Course Objectives

  • Open a workbook containing macros
  • Run a macro
  • Use a shortcut key
  • Use the Microsoft Visual Basic toolbar
  • Open the Visual Basic Editor window
  • Use the Visual Basic Editor window
  • Record a macro
  • Assign a shortcut key
  • Use relative references
  • Assign a macro to a menu
  • Delete a macro from a menu
  • Delete a macro
  • Use custom toolbars and buttons
  • Create a custom toolbar
  • Add a button to a toolbar
  • Add a custom button
  • Assign a macro to a button
  • Change a button image
  • Display button text and images
  • Attach a custom toolbar
  • Delete a custom toolbar
  • Create a macro button
  • Use a macro button
  • Create a macro button
  • Copy a macro button

Target Audience

This course is intended for information workers who need to learn more in-depth techniques for creating time saving Excel macros

Methodology

This program will be conducted with interactive lectures, PowerPoint presentation, discussions and
practical exercise

Course Modules

Module 1 – Using Macros
Module 2 – Recording Macros
Module 3 – Editing Macros
Module 4 – Custom Button In Quick Access Toolbar
Module 5 – Adding Custom Controls to a Worksheet

Get To Know The Trainer

 
 

Trainer Jarina

 4.5

Managing and maintaining a Microsoft Windows Server 2003 Environment - educate the IT professionals who implement, manage, and troubleshoot existing network and system environments based on the Windows Server 2003 platform. Implementation responsibilities include installing and configuring parts of systems. Management responsibilities include administering and supporting systems

Chat with us LIVE to get a

FREE QUOTATION!

COURSE INCLUDES

COURSE BENEFITS

ALL IN FROM ONLY

RM0/DAY

*T&C Applies

PARTICIPANT REVIEWS FOR THIS COURSE

No review yet.

Courses you may like

MEMBERS ONLY FEATURE

Kindly sign-up or log-in to get access.

LOGIN

Login with your social account

or

Don’t have an account with us?

FREE FOR LIFE

Sign Up to Bookmark your Favourite Course
or Request for a Quotation instantly

Sign in with your social account

or

By signing up, you agree to our Terms of Use and Privacy Policy

Have an account with us already?