Quality Dynamics Consultancy Sdn Bhd presents

Jan 18, 2018 (9am - 5pm) at Holiday Inn Kuala Lumpur Glenmarie

Microsoft Excel - Intermediate

(by Mr. Chin Chee Chong )

objectives

At the end of this course, participants are expected to:

1.  Understand the Excel Tools to assist in building formulas
2.  Create basic formulas and functions
3.  Able to create and format charts
4.  Work effectively with multiple sheets in workbooks
5.  Use tools, copy and paste data in the format you want
6.  Analyze and work with Excel list/database features

program content

Topic 1:  Managing Worksheets and Workbooks

1.    Adjusting Zoom
2.    Using Multiple Windows
3.    To open multiple windows of several workbooks
4.    Using Freeze Panes
5.    Using Split Windows
6.    Custom Views
7.    Hiding and Un-hiding worksheets and workbooks
8.    Working with Multiple Worksheets
9.    Changing Worksheet Tab Colours
10.   Inserting Worksheets
11.   Moving Worksheets
12.   Copying Worksheets
13.   Deleting Worksheets
14.   Grouping and Ungrouping Sheets

Topic 2:  Functions & Formulas

1.    Cell References: Relative, Absolute and Mixed
2.    Inserting Static & Dynamic Dates and Times
3.    Mathematical Functions with Maths Operators
4.    SUM, AVERAGE, MAX, MIN, COUNT, COUNTA functions
5.    SUMIF and COUNTIF Functions

Topic 3:  Conditional Formatting

1.    Applying Cell Highlighting
2.    Applying Top & Bottom and Average Rules
3.    Applying Data Bars, Colour Scales, and Icon Sets
4.    Creating a Customised Rule with Formula Conditions
5.    Editing Rules
6.    Prioritizing Rules
7.    Deleting Rules

Topic 4:  Creating a Charts

1.    What is a Chart?
2.    Inserting a Chart
3.    Elements of a Chart
4.    Activating a Chart
5.    Formatting a Chart
6.    3-D Charts
7.    Adjust Chart Data
8.    Saving a Chart Template
9.    Working with Charts

methodology

Lecture, discussion, individual/group exercise, Question and Answer

who must attend

Existing Excel users with a good understanding of Excel basics who need to be more effective with Excel and automate reporting with functions and formulas etc.


(KINDLY TAKE NOTE:  PARTICIPANTS ARE REQUESTED TO BRING THEIR LAPTOP AND EQUIPPED WITH MICROSOFT EXCEL 2010 AND ABOVE VERSION)

RENTAL OF LAPTOP IS AVAILABLE UPON REQUEST.

investment fee / early bird by 05/01/2018

Standard: RM720.00 Nett PerDay / Not Available per participant

Group discount: Not Available / Not Available per participant for a minimum of 2 participants from the same company

(Fee inclusive of Refreshment, Buffet Lunch, Training Bag, Handouts,  & Certificate of Completion)

registration & payment


PROGRAMS ARE CLAIMABLE UNDER SBL SCHEME

Please register online through www.qdc.com.my or call 03-78054587 / 03-78044196. Our phone line operation hours are from 8:30am to 6:00pm from Monday to Friday.

All registration MUST be accompanied with PAYMENT.

Completed registration form with CHEQUES should be made in favor of "Quality Dynamics Consultancy Sdn Bhd" and sent to:

(FEE PAID IS NOT REFUNDABLE but replacement may be made at no additional cost. Quality Dynamics Consultancy Sdn Bhd reserves the right to cancel or reschedule the above course and shall inform participants of the changes)

COURSE FACILITATOR - MR. CHIN CHEE CHONG

Mr. Chin Chee Chong has been in the Information Technology industry for the past 19 years starting with PC hardware where he is well-versed in troubleshooting and assembling of PCs. Thereafter, he ventured into IT software applications specializing in IT training and development for Microsoft Office users.

He is one of the certified training pioneers in Malaysia having attained his Microsoft Office Specialist Master Instructor (MOS) as well as a list of certifications stating that he has sound knowledge in Microsoft Word, Excel, PowerPoint, Access and Outlook. He also carries the title Microsoft Certified Trainer (MCT) by Microsoft USA. Having spent the last 9 years in this training field, his vast experience has equipped him with substantial knowledge to excel in the training field.

His extensive tutelage experiences are from conducting training courses for a number of corporate companies. Among his software training clients are American Insurance Group Berhad (AIG), Allianz General Insurance Malaysia Berhad, Citibank Berhad, Favelle Favco Berhad, EC-Council Academy, HSBC Bank Malaysia Berhad, Institute of Bankers Malaysia (IBBM), Jerneh Insurance Berhad, OCBC Bank Berhad, Proton Holding Berhad, Shell Information Technology International, Sime Darby Plantation Sdn Bhd, SP Setia Berhad, Wong Engineering Electronics Berhad and many more.

Besides the corporate sector, Mr Chin also trains the government sector such as Jabatan Pengangkutan Jalan (JPJ Academy Malacca), Keretapi Tanah Melayu Berhad (KTMB), Ministry of Health (MOH), Multimedia Development Corporation Sdn Bhd (MDec), Tentera Laut DiRaja Malaysia (TLDM) as well as local universities like UITM Shah Alam, University Tenaga Nasional (UNITEN) and Multimedia University (Cyberjaya & Melaka Campus).