Quality Dynamics Consultancy Sdn Bhd presents

Mar 29, 2018 (9am - 5pm) at Bayview Hotel, Georgetown, Penang

Microsoft Excel - Pivot Table (Penang)

(by Mr. Chin Chee Chong )

objectives

At the end of the course participants are expected to:

1.  Become familiar with the Power Pivot application and import data.
2.  Manipulate data in a Power Pivot worksheet.
3.  Create reports using Power Pivot data.
4.  Perform a variety of analytical tasks using Power Pivot
5.  Construct and operate Pivot table using some of the more advanced techniques

program content

Chapter 1
   •  Pivot table data structure
   •  Data table structure
   •  Understanding how pivot tables work
   •  Creating a pivot table report
   •  Filtering your pivot report
   •  Hiding and displaying pivot items
   •  Changing the pivot table report
   •  Using report filters
   •  Show report filter pages slicers
   •  An alternative to filers
   •  Drilling down data

Chapter 2
   •  Using pivot table tools
   •  Options tab
   •  Customising pivot table objects
   •  Sorting the pivot table selecting
   •  Items in a pivot table
   •  Refreshing data
   •  Creating a dynamic range
   •  Design tab
   •  Pivot table styles
   •  Changing the report layout
   •  Hiding grand totals
   •  Hiding sub totals

Chapter 3
   •  Pivot field settings
   •  Summarising more than one value
   •  Changing the value caption changing
   •  How data is summarised changing
   •  The number format changing how
   •  Values are displayed calculations in
   •  Pivot tables calculated field
   •  Calculated items

Chapter 4
   •  Creating pivot charts
   •  Analyse tab
   •  Design tab
   •  Layout tab
   •  Format tab

Chapter 5
   •  Grouping Data
   •  Grouping Dates
   •  Grouping Values

Chapter 6
   •  Using disparate data sources
   •  Customising the quick access toolbar
   •  Working with multiple ranges of data
   •  External data sources

Chapter 7
   •  Preparing your data dealing
   •  With blank cells filling up
   •  Repeated items correcting
   •  Date separators rectifying
   •  Date issues
   •  Configuring windows

methodology

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

who must attend

Executives and non-executives who have an interest in Pivot Table should attend this program.



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

LAPTOP IS AVAILABLE FOR RENTAL UPON REQUEST.


investment fee / early bird by 15/03/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).