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

Fajar International College Logo

Microsoft Excel Basic Training

Microsoft Excel Basic course is offered by Fajar International College. Fajar International College (FIC) is in business to provide the highest standard of education in Occupational Safety and Health, Business Management, and Accounting Courses.

by Fajar International College [Claim Listing ]
Cad Training Centre Logo

Microsoft Excel (Basic)

This training programme teaches you how to get started with Ms Excel. We will cover essential functions and uses such as data entry, simple formula/functions, working with basic charts etc.

by Cad Training Centre [Claim Listing ]
TARUMT (Tunku Abdul Rahman University College) Logo

Manipulating Data Effectively With Microsoft Excel (Level 1 & 2)

Nowadays, any managerial or analyst role requires you to work with data. Excel remains one of the most effective and easy-to-use tools for crunching data.

by TARUMT (Tunku Abdul Rahman University College) [Claim Listing ]
Sabah Institute of Art Logo

Data Management With Microsoft Excel (SCMS0201)

Microsoft Excel is a powerful tool that can help you organize, calculate, analyze, revise, update, and present your data much easier and less time, than if you used traditional pen-and-paper methods or non-specialized software.

by Sabah Institute of Art [Claim Listing ]
FAME International College Logo

IT Training

This training programme is designed for those who are interested to strengthen IT functionality in Microsoft Excel, Microsoft Access and Microsoft Power Point for business functions, lead date analysis, productivity measurement and etc.

by FAME International College [Claim Listing ]

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