Quality Dynamics Consultancy Sdn Bhd presents
Microsoft Excel - Pivot Table
(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 Answerwho 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 13/11/2019
Standard: RM720.00 Per Day / 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:
QUALITY DYNAMICS CONSULTANCY SDN BHD
No. 343, Block A, Kelana Centre Point, No.3 Jalan SS7/19,
Kelana Jaya, 47301 Petaling Jaya,
Selangor, Malaysia.
Tel : 03-78054587 / 03-78044196
Fax: 03-78054514
E-mail:
training@qdc.com.my
(
Wani/ Thang )
PSMB Reg: 620717-P
(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)