Tag Archive Excel Visual Basic Training

ByKim Tan

Automate Your Tasks with Microsoft Excel Macro / VBA

Automate Your Tasks with Microsoft Excel Macro / VBA  

Introduces users the fundamentals of VBA concepts that are applicable in the finance environment. The VBA tools allow integrating existing data and systems, enabling a person to use the standard functions and yet at the same time, customize it to meet his specific needs. In this non-intimidating approach to VBA and Excel Macro, this course uncovers the features that allow users to customize the Microsoft Excel that can easily be put to use in real-world scenarios.

Course Form : Download
Submit Form : Submit

Kindly contact Ms Kim Tan, at 019 2569053, or email kim@empowering1.com for reservation and details.
Thank you.

Please follow and like us:
ByKim Tan

Daily Application with Microsoft Excel Functions and Formulas

Daily Application with Microsoft Excel Functions and Formulas

The focus of this course is on the important of functions and their applications in our daily routines. This course will touch on most of he Excel built in functions and how useful it can be in automating our daily calculations.

Note

  • Course fee is claimable from PSMB (HRDC).
  • Registration must be received by the 11th Jan 2016.
  • Registration is valid for dates indicated above. No postponement is allowed.
  • Training Venue: Unit 703, Level 7, Kelana Centre Point, Jalan SS7 / 19, Kelana Jaya , PJ  Time: 9:00 am – 5:00 pm
Course Form : Download
Submit Form : Submit

Kindly contact Ms Kim Tan, at 019 2569053, or email kim@empowering1.com for reservation and details.
Thank you.

Please follow and like us:
ByKim Tan

Daily Application with Microsoft Excel Functions and Formulas

Daily Application with Microsoft Excel Functions and Formulas

The focus of this course is on the important of functions and their applications in our daily routines. This course will touch on most of he Excel built in functions and how useful it can be in automating our daily calculations.

Note

  • Course fee is claimable from PSMB (HRDC).
  • Registration must be received by the 11th Jan 2016.
  • Registration is valid for dates indicated above. No postponement is allowed.
  • Training Venue: Unit 703, Level 7, Kelana Centre Point, Jalan SS7 / 19, Kelana Jaya , PJ  Time: 9:00 am – 5:00 pm
Course Form : Download
Submit Form : Submit

Kindly contact Ms Kim Tan, at 019 2569053, or email kim@empowering1.com for reservation and details.
Thank you.

Please follow and like us:
ByKim Tan

Summarizing and Analyzing Business Data using Pivot Table and Data Representation thru Excel Charts

Summarizing and Analyzing Business Data using Pivot Table and Data Representation thru Excel Charts

Pivot Tables are powerful data analysis tools, yet most Excel users don’t use them to their fullestpotential. This class shows you why PivotTables are so versatile for Business data analysis andhow you can leverage PivotTables to rapidly spot trends and make fast business decisions onmountains of data.

Note

  • Course fee is claimable from PSMB (HRDC).
  • Registration must be received by the 11th Jan 2016.
  • Registration is valid for dates indicated above. No postponement is allowed.
  • Training Venue: Unit 703, Level 7, Kelana Centre Point, Jalan SS7 / 19, Kelana Jaya , PJ  Time: 9:00 am – 5:00 pm
Course Form : Download
Submit Form : Submit

Kindly contact Ms Kim Tan, at 019 2569053, or email kim@empowering1.com for reservation and details.
Thank you.

Please follow and like us:
ByKim Tan

(21st – 22nd September 2015) EXCEL VBA (MACRO PROGRAMMING)

Microsoft Excel VBA Macro Programming 

Introduction
This course is designed for users new to Excel macros, with little or no programming experience. In this training, you will learn how to apply three basic constructs: sequence, selection and iteration, into your problems; and create VBA programs to interact with multiple worksheets and workbooks. Microsoft Excel VBA (Macro) is a programming language attached with Excel. It help you create automated spreadsheets for your repetitive tasks such as:

  • generating dynamic reports based on your changing statistics;
  • customizating tools and integrating them into the spreadsheet;
  • simplifying complex tasks that needs to be performed regularly.

Course pre-requisites
Participants enrolling in this course should have basics knowledge on Excel.

Venue : Level 1, Menara PJ@AMCORP Petaling Jaya
Date : 21st – 2nd September 2015
Time : 9.00AM – 5.00PM

For more information regarding the course module please check the brochure below:
21-22 SEPT 2015-EXCEL VBA ( MACRO PROGRAMMING ) – v1
21-22 SEPT 2015-EXCEL VBA ( MACRO PROGRAMMING ) – v2

Please follow and like us: