Please login to use this feature. You can use this feature to add the product to your favourite list.
Close
You have added this product to your favorite list. Check My Favourite
Close
You have removed this product from your favourite list.
Close
Please login to use this feature. You can use this feature to add the company to your favourites list.
Close
This company has been added successfully. Check My Favourite
Close
This company has been removed from your favourite list.
Close
Please login to use this feature. You can use this feature to add the company to your inquiry cart.
Close
This company has been added to your inquiry cart.
Close
This company has been removed from your inquiry cart.
Close
This product has been added to your inquiry cart.
Close
This product has been removed from your inquiry cart.
Close
Maximum number of Product/Company has been reached in inquiry cart.
Close
Growthvue Management & Consultancy (M) Sdn Bhd
Growthvue Management & Consultancy (M) Sdn Bhd 1362519-T

14-Feb-2022

Objective:

At the end of the training, participants are able to: 
  • Record and run macros easily
  • Write VBA code manually using Excel
  • Perform Loops, Controls and Error Handling in Excel Macro
  • Create and apply VBA functions in Excel
  • Use Events to trigger specific VBA code
  • Write useful VBA application that automate routine tasks

Outline:
  • Introduction to VBA
    • Recognizing the power of Excel VBA Macro
    • Identify workbooks that support macros
    • Showing the Developer Tab
    • Understanding Macro Security
    • Recording and running a macro
 
  • Understanding the Basics
    • Exploring the VBA Editor
    • Examining Recorded Macro codes Introducing the Selection Object
    • Understand Properties, Methods and Parameters
    • Using the Line Continuation Character
    • Using the With…End With statement
    • Writing Comments
 
  • Working with Variables and Constants
    • Understanding the Scope of Variables
    • Identifying the different Data Types
    • Working with Variables
    • Exploring Object Variables
    • Declaring and using Constants
 
  • User Interaction techniques
    • Using VBA InputBox function
    • Using Excel inputBox method
    • Using VBA MsgBox function
    • Using UserForm
 
  • Overview of Objects
    • Introducing the Application Object
    • Exploring Workbooks and Workbook Object
    • Exploring Worksheets and Worksheet Object
 
  • Referring to Ranges
    • Introducing the Range Object
    • Referencing a range using the UsedRange Property
    • Accessing a range using the UsedRange Property
    • Finding the First Cell with data
    • Referencing the Last Row and Column in the data range
    • Using the Cells Property
    • Utilizing the Offset Property while working with Range
 
  • Loop Structures
    • Using For Each..Next Loops 
    • Using For…Next Loops
    • Using Do…While Loops
    • Using Do..Until Loops
    • Exiting a Loop Early
    • Nesting Loops
 
  • Selection Structures
    • Using simple if statement
    • Using If..Then..Else statement
    • Using multiple If..Then..Else statement
    • Using Select Case statement
    • Using nested if statement
 
  • User-defined Functions
    • Exploring commonly used VBA Functions
    • Create user-defined functions
    • Executing user-defined functions
 
  • Event Programming
    • Understand Event Parameters
    • Working with Worksheet Events
    • Working with Workbook Events
 
  • Error Handling
    • Identifying the different types of errors
    • Debugging tools: Stepping through Code
    • Debugging tools: Breakpoint
    • Debugging tools: Immediate Window
    • Debugging tools: Watch Window
    • Handling Errors by choosing to ignore them
    • Employing basic error handling with the On Error GoTo Syntax
 
  • Hands-on VBA Macro Project
    • Build Database from Report
    • Define the Monthly Project
 
  • Useful VBA Macros
    • Combining Workbooks
    • Separating data into different worksheets
    • Separating data into different workbook

Duration:
2 days (14 hours)

Target Audience:
This course is aimed at experienced Excel users who wish to automate repetitive tasks or simplify more complex tasks using Excel macros and Visual Basic for Applications (VBA) programming language

Methodology:
Demonstration, practical learning, case discussion and exercises

Prerequisite(s) or equivalent knowledge:
Participants must have good Microsoft Excel skills and understand key concepts of spreadsheets. It is not necessary to have prior programming knowledge.
Hantar mesej anda ke Growthvue Management & Consultancy (M) Sdn Bhd
Terima kasih untuk pertanyaan anda!
Perkhidmatan pelanggan kami akan menghubungi anda tidak lama lagi.
Nama Anda *
Nama Syarikat Anda
Emel Anda *
Nombor Telefon Anda *
Tajuk *
Mesej *
Captcha *
Pejabat Utama

Growthvue Management & Consultancy (M) Sdn Bhd 1362519-T
170A, Jalan Pahlawan 2, Taman Tun Aminah, 81300 Skudai, Johor, Malaysia.

Tel:

Emel:
Laman Web: https://www.growthvuemnc.com
Laman Web: https://growthvuemnc.newpages.com.my/
Laman Web: https://growthvuemnc.n.my/

Pejabat Lain

Growthvue Sourcing Joy (Hangzhou) Technology Co., Ltd.
RM 1032 3F No. 230, Tianmushan West, Road Xianlin, Street Yuhang, District Hangzhou, Zhejiang, China.

H/p:
Emel:

Growthvue Sourcing Joy Limited
Room1002, 10/F, Easey Comm BLDG Nos 253-261, Hennessy Road, Wanchai, Hongkong.

H/p:
Emel:

Melayari Melalui : Laman Utama - Klasifikasi - Syarikat - Tempat - Tag - Produk - Berita Baru dan Promosi - Jawatan Kosong - Laman Web Mudah Alih - Google - Keputusan SEO

NEWPAGES

  • US 15859
  • GB 12566
  • CA 10107
  • AU 9924
  • IE 5325
  • BR 4887
  • NZ 2174
  • CN 1433
Orang dalam talian
Seni Jaya Logo
Brochure
Download
Our PackageContact Us