Microsoft Excel Macro VBA Programming (Advanced)

by Ted Learning Claim Listing

This course covers aspects of developing macros for practical applications. New and advanced tools have been included in this course.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

Ted Learning Logo

img Duration

2 Days

Course Details

This course covers aspects of developing macros for practical applications. New and advanced tools have been included in this course.

 

Pre-requisites:

  • Completion of Microsoft Excel VBA (Fundamentals of Macro)

 

Course Outline for This Programme:

Module 1: Building User Interactive Applications:

  • Introduction

  • Message Box

  • Input Box

  • The Excel Inputbox Method

 

Module 2: More VBA Programming Fundamentals:

  • GoTo Statement

  • Select Case Statement

  • Using Arrays

  • Creating Multi-Dimensional Array

 

Module 2: More VBA Programming Fundamentals:

  • With… End Statement

  • GoTo Statement

  • Select Case Statement

  • Using Arrays

  • Creating Multi-Dimensional Array

 

Module 3: Creating Custom Functions:

  • Introduction

  • Function examples

  • Categorising & Adding Function Description

 

Module 4: Working with User Forms:

  • Introduction

  • Inserting a New Userform

  • Adding controls to a Userform

  • Setting A Control’s properties

  • Creating a Userform: An Example

  • Adding More Controls to the Toolbox

 

Module 5: Creating Custom Menus:

  • Userform “Menu”

  • Tool Bar “Menu”

  • Command Bar Menu

  • Creating A Short Cut Key

  • Adding & Deleting Menu Automatically

 

Module 6: B:

  • What Is An Add-In?

  • Creating An Add-In

 

Module 7: Exercises:

  • Loan Calculator Application

  • Data Entry Application

  • Kuala Lumpur Branch

    12-07, Binjai 8 Premium SOHO, Kuala Lumpur
  • Teacher's Name
  • Julian
  • Teacher's Experience
  • Academic Qualifications Diploma in Accountancy ACCA (Association of Chartered Certified Accountants), UK Professional Certifications Pembangunan Sumber Manusia Berhad (PSMB) Certified Trainer Microsoft Certified Trainer (MCT) Julian specialises in conducting MS Excel application courses & seminars for various companies, local & multinationals. He teaches practical on-the-job experience, which translates to real-life exercises for participants’ benefit. Julian conducts various IT courses using Word Processors, Spread sheet, Database, Multimedia & Programming applications
  • Gender
  • Male
  • Teacher's Nationality
  • N/A

Check out more MS Excel courses in Malaysia

G-Tec Computer Education Sdn. Bhd Logo

MS Excel

A successful database is efficient, quick, accurate, and easy to use. This course covers how to create such a database with MS Excel.

by G-Tec Computer Education Sdn. Bhd [Claim Listing ]
Malaysian Export Academy Sdn Bhd Logo

Microsoft Excel Intermediate

In this Microsoft Excel Intermediate training class, you will improve your skill set by learning to work with advanced formulas, lists, and illustrations. You will also work with charts and advanced formatting techniques, including styles.

by Malaysian Export Academy Sdn Bhd [Claim Listing ]
  • Price
  • Start Date
  • Duration
Ted Learning Logo

Microsoft Access 2016/2019 (Advanced)

In this course, students add to their Access education in order to provide themselves with marketable job skills. This course builds on the foundational skills obtained by attending the Access 2016 – Part 1 course.

by Ted Learning [Claim Listing ]
IC Training & Consultancy ICTC Logo

MS Excel (Level 1)

MS Excel course is offered by IC Training & Consultancy ICTC. Our experts have years of experience working with Microsoft Office and Google Suite, and we’re passionate about helping others make the most of their Microsoft Office and Google Suite software.

by IC Training & Consultancy ICTC [Claim Listing ]
NexTrain Logo

Microsoft PowerPoint (Intermediate Level)

Microsoft PowerPoint training is offered by NexTrain. NexTrain Consultancy Sdn. Bhd. was established with the prime objective to train and upgrade the technical and management skills of the Malaysian workforce in manufacturing industries and commercial sectors.

by NexTrain [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy