Excel Amazing Macros

0

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 Shalina

 4.5

Shalina has   20   years   of experience in IT related fields including 11 years in conducting public courses. She specializes  in  Corporate  IT  infrastructure  planning  (networking,  troubleshooting and  system  integration),  conducts  applications  training  programs  such  as Microsoft,  Adobe,  Lotus  and  COMPtia  products  as  well  as  organizes  and conducts exhibitions and seminars.

Chat with us LIVE to get a

FREE QUOTATION!

COURSE INCLUDES

COURSE BENEFITS

ALL IN FROM ONLY

RM1,335/DAY

RRP RM1,910/DAY   SAVE RM575

*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?