Excel VBA for Absolute Beginners

All versions available. Outline version below is Microsoft Excel 2019. If you need assistance just chat with us LIVE.

Course Objectives

Before attending this course, students must be able to demonstrate the following skills:

  • Ability to use a computer keyboard and a mouse.
  • Familiarity with the general operations of Microsoft Windows operating system.
  • Basic knowledge and skill in using Microsoft-Excel (Any version).

The course materials, lectures, and lab exercises are in English. To benefit fully from the instruction, students need an understanding of the English language and completion of the prerequisites.

Target Audience

Any Microsoft Excel users who wants to do extra ordinary thing from their Microsoft excel applications where but limited by the predefined features. This includes those who know nothing about computer programming.

Methodology

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

Course Modules

Module 1 – Introduction

Module 2 – Automation via Macros

Module 3 – Using instructions

Module 4 – Linking VBA with Excel

Module 5 –The instructions building block

Module 6 –Modules

Module 7 –When you make mistake…

Module 8 –The variables

Module 9 – Useful VBA native functions

Module 10 –Other useful basic VBA entities

Module 11 – The Parameter

Module 12 – Operators

Module 13 – Branching Constructs

Module 14 – Iteration Constructs

 

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

Trainer P.L

 4.5

She is an expert on Microsoft Applications, Publisher (Version 2000, XP, 2003 & 2007, VBA, Introduction To Internet, Multimedia Fundamentals, IT Skills For Non-PC Users, Basic IT skills and related programs. In her previous company, she was responsible for developing training courseware and customizing training curriculum.

Chat with us LIVE to get a

FREE QUOTATION!

COURSE DETAILS

COURSE INCLUDE

ALL IN FROM ONLY

RM0/DAY

*T&C Applies

PARTICIPANT REVIEWS FOR THIS COURSE

4.2

  • 35%
  • 52%
  • 13%
  • 0%
  • 0%
  • OC
    Ong Poh Chin
    Executive, Operations

    5

  • TY
    TAN CHAI YUAN
    Manager / Supervisor, HR / Learning and Development

    5

  • KZ
    Khoh Lee Zee
    Assistant Manager, Procurement / Purchasing

    5

  • TV
    Tee Yee Von
    Assistant Manager, Procurement / Purchasing

    5

  • FR
    FAZIATUL AISHAH BINTI RASHID
    Executive, Customer Service / Hospitality

    5

  • LY
    Low Weng Yan
    Senior Executive, Sales

    5

  • PQ
    Poo Zi Quan
    Executive, Procurement / Purchasing

    5

  • EY
    ENG MENG YEAN
    Assistant Manager, Operations

    5

    Good knowledge & experience for this training
  • CG
    Celina Gan
    Executive, Procurement / Purchasing

    4

  • CH
    CHONG YENG HSIEN
    Junior Executive, Warehousing / Logistics

    4

  • NQ
    Nicole Chan Zhi Qi
    Executive, Warehousing / Logistics

    4

  • SG
    SIA HIM GEK
    Executive, Procurement / Purchasing

    4

  • Ly
    Lim shu ying
    Assistant Manager, Warehousing / Logistics

    4

  • Wc
    Wong soo ching
    Senior Executive, HR / Learning and Development

    4

  • AN
    Amir Hafizuddin Bin Narzari
    Executive, Warehousing / Logistics

    4

  • CT
    Chen Wei Ting
    Senior Executive, HR / Learning and Development

    4

  • KL
    Kong Wai Lin
    Executive, Procurement / Purchasing

    4

  • YL
    Yuki Chang Yoke Lin
    Manager / Supervisor, Customer Service / Hospitality

    4

  • YX
    Yeow Cai Xing
    Senior Executive, HR / Learning and Development

    4

  • EF
    ENG Meng Fui
    Manager / Supervisor, Customer Service / Hospitality

    4

  • KY
    KONG HOEI YU
    Executive, Procurement / Purchasing

    3

  • CW
    Chia Xiu Wei
    Executive, Warehousing / Logistics

    3

  • LR
    Lee Huei Ru
    Executive, Warehousing / Logistics

    3

OF 3Next

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?