Tag Archive Microsoft Excel 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

HUMAN RESOURCE APPLICATION USING MS EXCEL

image001image002

Please follow and like us:
ByKim Tan

MS Excel For Human Resource Application

nov-2016-excel-for-hr-page-1nov-2016-excel-for-hr-page-2

Please follow and like us:
ByKim Tan

FREE WORKSHOP -14TH MARCH 2016 – MS EXCEL FOR HR PERSONNEL

Courseware Description

In this free 3 hour workshop, the HR Personnel will learn the tips and techniques to save hours to resolve the difficulties in doing employee compensations, salary,leave, benefits etc.
They will also discover formatting techniques, manipulate charts and diagrams, using logical functions for HR Tasks

Prerequisites

It is recommended that students have a working knowledge of:

  • A Basic MS Excel knowledge is preferred.

Below are the session details:-

  • Lesson 1:
    • Learning formula fundamentals for HR applications
    • Creating formulas and their automatic application
    • Using references & named ranges for HR functions
  • Lesson 2:
    • Using pivot table and charts
    • Create a PivotTable Framework for HR Functions
  • Lesson 3:
    • Protecting your data forms from invalid data entry
    • Recording MACROS & automating Work
Course Outline : Download
Course Form : Download
Submit Form : Submit
Please follow and like us:
ByKim Tan

MS EXCEL FOR HR PERSONNEL

MS EXCEL FOR HR PERSONNEL

In this free 3 hour workshop, the HR Personnel will learn the tips and techniques to save hours to resolve the difficulties in doing employee compensations, salary,leave, benefits etc.

They will also discover formatting techniques, manipulate charts and diagrams, using logical functions for HR Tasks ..

Target Audience
HR Managers and HR Personnel who perform HR Functions on a regular basis

Course Pre-requisite:-
A Basic MS Excel knowledge is preferred.

Lesson 1

  • Learning formula fundamentals for HR applications
  • Creating formulas and their automatic application
  • Using references & named ranges for HR functions

Lesson 2

  • Using pivot table and charts
  • Create a PivotTable Framework for HR Functions

Lesson 3

  • Protecting your data forms from invalid data entry
  • Recording MACROS & automating Work

Venue:
UNIT 703, LEVEL 7, BLOCK A, KELANA CENTRE POINT, No 3 JALAN SS7/19, KELANA JAYA, PETALING JAYA

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:
ByKim Tan

(21st – 22nd October 2015) Human Resource Application Using Microsoft Excel

About The Course

The business world runs on the engine of human resources. Workers are one of the es-sential resources needed to produce timely goods and services with the right skills, attitude, knowledge and training, if required. Like any other function within an organization, this area needs to be managed well.

With this in mind, and knowing that HR professionals deal with many types of data, ranging from recruitment, employee benefit plans, career development programs, right up to retirement, they need to equip themselves with the right tools to perform the right analysis. This workshop aims at simplifying these tasks by introducing and utilizing various techniques of Microsoft Excel to track, manage and report HR data efficiently.

Specifically designed for the HR professional, this workshop allows one to have a quick-start on applying various functions, features, techniques, concepts and tricks available in Microsoft Excel to meet the needs of the HR Department. Being familiar with a useful library of Excel functions allows one to present data in a more meaningful and manageable way. Backed with relevant HR examples, participants can understand and apply them in their work almost immediately.

Course Outline

1. WHY EXCEL IS A HR PERSON’S BEST RESOURCE
2. INCORPORATING AND FORMATTING HR DATA IN EXCEL
3. WORKING WITH ORGANIZATION DATA
4. EXCEL FOR PERFORMANCE MANAGEMENT
5. EXCEL FOR COMPENSATION CHANGES
6. EXCEL FOR PERFORMANCE EVALUATION
7. EXCEL FOR MARKET ANALYSIS
8. CASE STUDY USING EXCEL

Course Date: 21-22 October 2015
Course Time: 9:00am – 5:00pm
Course Venue: Suite 37-8, The Boulevard, Mid Valley City, Lingkaran Syed Putra, 59200 Kuala Lumpur.

Course Fee : RM954 per person
Group Discount Fee : RM795 per person (for 3 pax and above)

Sign up now and get early bird fee of RM848 per person (until 14 OCTOBER 2015).
– Fees indicated are inclusive of 6% GST.
– Course fee inclusive of 2 daily tea break refresh-ment, lunch is not provided
– PC will be provided for each participant
This course is HRDF claimable.

For More Info

Please download the brochure HERE

Please follow and like us:
ByKim Tan

(9th November 2015) – Analysing, Interpreting and Summarising Business Data for Presentation using Pivot Table and Data Representation Using Excel Charts

Invitation
We take pleasure in inviting you to our

ANALYSING BUSINESS DATA USING PIVOT TABLE AND DATA REPRESENTATION USING EXCEL CHARTS

An exclusive half-day workshop for Senior Managers & Head of Depts on using Pivot Table & Excel Charts for Data Analysis & Presentation to Management Team

Divider
When
Monday, 9th Nov , 2015
2.00pm - 5.00pm
( tea breaks will provided )
Divider
Where
Unit 1009, Level 10, Menara PJ, Pusat Perdagangan AmCorp, 18, Persiaran Barat, 46050 Petaling Jaya, Selangor, Malaysia
Divider
Where
To reserve a seat, kindly contact Ms Kim Tan by 6th October 2015 at 0192569053
Divider
Schedule
1.30pm – 2.00pm - Morning Tea and Registration

2.00pm – 2.30pm - Lesson 1 - Introduction to PivotTables

2.30pm – 3.00pm - Lesson 2 - Creating PivotTables

3.00pm – 3.30pm - Tea Break

3.30pm – 4.00pm - Lesson 3 -Using PivotTables in Actual Work Examples

4.00pm-4.30pm- Lesson 4- Working with Pivot Charts

4.30pm- 5.00pm –Q&A

Divider
Map

Brief Description

Introduction
PivotTables are powerful data analysis tools, yet most MS Excel Excel users don’t use them to their fullest potential. This class shows you why PivotTables are so versatile for Business data analysis and how you can leverage PivotTables to rapidly spot trends and make fast business decisions on mountains of data.

Who Should Attend
This course is highly recommended for heavy users of Microsoft Excel especially Professionals who have made Microsoft Excel as an indispensable tool at work for the presentation of Data to the Board Members. Most reports at work will be simplified extensively with usage of the PivotTable and PivotChart tool.

Target Audience involved Business Owner, Business Heads, HR Director and Heads of Departments / Management Team

Course Pre-requisites
Participants enrolling in this course should have a working understanding on the basics of windows.
They are expected to have working experience with MS Excel basic calculations such as SUM .

Workshop Content

Module 1 – Introduction to PivotTables
Provides an overview of Excel PivotTable and the benefits of using PivotTable in Business World.

Module 2 – Creating PivotTables
This module will expose the participants to the various methods of creating PivotTable based on the various types of Business data that can be found in MS Excel or external data.

Module 3 – Using PivotTables in Actual Work Examples
This module will expose the participants to some real world cases where they get to do some data crunching using what have been taught from the previous modules

Module 4 - Working with Pivot Charts
This module will illustrate the applications of PivotChart and on how to manipulate it.

Event Schedule

Date of Training :
9th November, Monday, 2015
Time :
2.00pm - 5pm
Cost :
Free for Senior Managers and Head of Departments ( Tea Breaks and Course Notes will be provided )
Training Venue :
Unit 1009, Level 10, Menara PJ, Pusat Perdagangan AmCorp, Petaling Jaya

Free seats are very limited

Kindly contact Ms Kim Tan as soon as you can, at 019 2569053, or email kim@empowering1.com for reservation!

Please follow and like us: