Location
-
Format
What’s this? Ways to train
Classroom
Live, instructor-led training in a standard, professional classroom environmentVirtual
Live, instructor-led training conducted over the internet, with hands-on labsOnline
An online, HTML5, self-paced learning experience available for all coursesOn-site
Private training for your entire team, delivered at your location, a training center, or onlineVideo classroom
Learn more about our training formats
High-definition video of our most popular courses, streamed to your laptop or personal device
-
1 Day with 08 hours per day
-
Mon 22 Mar 09:00 - Mon 22 Mar 17:00
-
HRDF SBL Claimable
-
Certificate of Attendance available
-
1 Days
-
All of our private classes are customized to your organization's needs.
-
Click on the button below to send us your details and you will be contacted shortly.
Already purchased this offering? Log in
Request more information
Inquiry for: Myself My Company
By providing your contact details, you agree to our Privacy Policy
Thank You
Our learning consultant will get back to you in 1 business day
50448: Maximizing Pivot Table
WHAT YOU WILL LEARN
Elements of this syllabus are subject to change. This one-day instructor- led course provides students with the knowledge and skills to examine and manipulate raw data through the use of Microsoft Office Excel PivotTables and PivotCharts
AUDIENCE
This course is intended for Information Workers
METHODOLOGY
This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise
COURSE OBJECTIVES
Upon completion of this program, participants should be able to :
- Understand the benefits of PivotTable Reports.
- Convert raw data in an Excel worksheet into meaningful PivotTables and PivotCharts.
- Manipulate the PivotTable layout.
- Use grouping.
- Create custom calculations.
- Use formulas and create formulas outside of a report.
- Create a PivotChart and publish it to a Web site
Modules
- Maximize the Power of PivotTable
- Ask the Questions
- Get the Answers
- Review
- Understand what needs to be done before creating a PivotTable.
- Understand the ways you can use PivotTables to get the type of data you need.
This module explains how to take raw data in an Excel worksheet and make it more meaningful with PivotTables.
Topics
- Determine What You Need to Know
- The Source is Important
- Ready, Set, Go
- The PivotTable Layout
- What Goes Where
- Result of Our PivotTable
- Viewing Our Data Differently
- Review
Practice
- Practice 2
After completing this module, students will be able to:
- Prepare an Excel worksheet before using the PivotTable wizard.
- Use the PivotTable and PivotChart wizard.
- Understand the PivotTable layout, and which fields need to be dragged to which area of the layout.
- Perform a simple PivotTable manipulation to change the way data is presented.
This module explains how to rearrange the PivotTable layout, work with fields, and refresh data.
Topics
- Rearrange the Layout
- What We Get
- Add a New Field
- Remove a Field
- Add or Remove a Field Using the Wizard
- Rename a Field
- Format Numbers
- Change the Sort Order and Top 10
AutoShow
- Refresh Data
- Review
Practice
- Practice 3
After completing this module, students will be able to:
- Manipulate fields of a PivotTable to view raw data in different ways.
- Change the format of data in a PivotTable.
- Use the Sort and Top 10 command.
- Update a PivotTable report when the source data changes.
This module explains how to use grouping to further summarize PivotTable information, how to work with subtotals and grand totals, and how to format the finished PivotTable.
Topics
- Create a Quarterly Group
- Group Data Manually
- Display Subtotals
- Hide/Display Grand Total
- Format a PivotTable Report
- • Review
Practice
- Practice 4
After completing this module, students will be able to:
- Group and ungroup data.
- Group data manually.
- Create a subtotal field.
- Hide and display grand totals.
- Format a finished PivotTable for readability.
This module explains how to create additional data fields and create and use custom calculations.
Topics
- Creating a Second Data Field
- Use Count to Summarize Data
- Display Numerical Data as a Percentage of the Total
- Create a Custom Calculation
- More Functions in Custom Calculation
- Review
Practice
- Practice 5
After completing this module, students will be able to:
- Add data fields.
- Use the Count function to get more detailed information about sum totals.
- Display numerical data as a percentage of the total.
- Create custom calculations.
This module explains how to create new fields and items using the Calculated Field and Calculated Item formulas, and how to create formulas outside of a report.
Topics
- Using Formulas
- Create a Calculated Field
- Create a Calculated Item
- Use PivotTable Data Outside the Report
- Use the GETPIVOTDATA Function
- Turn Off the GETPIVOTDATA Function
- Review
Practice
- Practice 6
After completing this module, students will be able to:
- Use formulas to create new fields and items.
- Create and use calculated fields.
- Create and use calculated items.
- Use PivotTable data outside the report.
- Use the GETPIVOTDATA function.
This module explains how to create a PivotChart report and publish it to a Web site, add fields to a PivotTable browser, use a PivotTable list, and use multiple ranges as source data.
Topics
- Create a PivotChart Report
- Publish PivotTable Reports to the Web
- Add Fields to a PivotTable Browser
- Use a PivotTable List
- Use Multiple Ranges as Source Data
- Review
Practice
- Practice 7
After completing this module, students will be able to:
- Use the PivotTable and PivotChart wizard to create a PivotChart.
- Enhance the look of a PivotChart by using the Vary Colors By Point option.
- Share a PivotChart with colleagues by publishing it to a Web site.
- Describe the difference between a PivotTable and a PivotTable List.
- Use data from different worksheets and ranges.
Answers to Review Questions
Topics
- Review 1
- Review 2
- Review 3
- Review 4
- Review 5
- Review 6
- Review 7
Using the Place Card
Topics
- At Work
- In Training

Anne Teoh Hui San
A rising and highly engaging trainer, Anne Teoh represents a new face for Microsoft Office training. She has been involved in training Microsoft Windows 8 and Windows Phone development and design Microsoft Student Partners (MSP) for a year. Within her first year venture into the training industry, she is now highly sought after by banking, investment firms and high-tech industries; to execute competent Microsoft Office training. She specializes in delivering Office Word, Office Excel and Office PowerPoint trainings, having most of the occasion delivering beyond client expectations of what defines a training.Focusing heavily on delivering hands-on experience to her participants, she instils a robust understanding of the fundamentals for Microsoft Office training; as she strongly views that traditional delivery of training should be phased out and delivered in a lively manner that reflects the everyday routine of a given professional.Besides training, she is also as a deeply involved the development of Windows Phone Applications, mostly handling the UI/UX portion.

Pauline Leong Pei Loo
Being in the information technology background for so many years, she is an expert on Microsoft Applications, Publisher (Version 2000, XP, 2003 & 2007, VBA, Introduction To Internet, Multimedia Fundamentals, IT Skills For Non-PC Users, Basic IT skills and related programs. In her previous company, she was responsible for developing training courseware and customizing training curriculum.Pauline is a reliable person, helpful, independent and friendly person with a pleasant personality. Her classes are lively as she enjoys interacting with people and delivering her knowledge to individuals. Read More

Patrick Cheah Liat Hin
Patrick has been involved in the IT industry since 2002 and has exposure in both technical and non-technical area which includes customer service, marketing, web and graphic design and technical support.In IT training, Patrick started off as a course facilitator guiding users in an online E-Learning portal. He proceeded to classroom training, where he trained visually impaired students in using Access Technology and Microsoft Office; then moved on to train professionals from various manufacturing sectors in Microsoft Office; covering from basic to advanced level courses.Apart from technical training, Patrick is also involved in soft skill training. A member of the Toastmasters International since 2006 and an Advanced Communicator, he conducts public speaking courses for students as well as working professionals.

Azrulnizam Bin Ahmad
Azrulnizam Ahmad has been working in the business industry since 2004 and has been exposed to all the common challenges faced by business personnel. With his years of experience working with business and management, IT services and end users, he understands the importance of business value, infrastructure efficiency and user productivity.He shares his training passion in Microsoft Office 2007 Application - Excel, PowerPoint, and Word; Microsoft Office 2010 Application - Excel, PowerPoint, and Word and also emphasizes on the criticality of this aspect in any implementation.He is an energetic, independent, goal-oriented individual that has a high work standard and is committed to his work. He is also a good planner, is creative and resourceful, has great leadership charisma and works well with others. Read More

Amelia Dillon
Having experienced many years in acquiring skills and knowledge in the related fields, the trainer is among a few of extraordinary trainers in the local training arena. The one thing that makes her a prominent trainer is her knowledge and exposure gathered over many years in IT industry. She is well known to have the ability to enlighten participants by not only leading them towards the subject matter but also by allowing them to relate to the subject matter and at the same time make the process of learning a lot more easier. Over the years, she has developed many training modules and had extended her service to various companies. Some of these modules include the PPSMI manual that was used by the Ministry of Education to train teachers nation-wide on how to use the PPSMI equipment. Read More

Jarina Muhamad Ismail
Since 2005, Jarina is involved in delivering learning programmes for Microsoft Excel, PowerPoint, Project, Outlook, Access, Word, Publisher and Visio. As a Microsoft Office Specialist (MOS) in all versions (2003-2013), she is using her expertise to provide timely solutions to the end-user which ranges from basic to advanced level including power users. She has experience in training and coaching various teams of professionals like executives, engineers, managers and directors to organize, analyze, create report and present business data more efficiently.
Read More

Izham Fariz Ahmad Jinan
Izham Fariz experience in IT includes creating systems using Visual Basic and Power Builder as front-end and MS-SQL 2000 and MS Access as database. Other programming languages are C++ and Cobol. He is also exposed to Rational Rose and Microsoft Transaction Server. Read More

Mazlita Binti Mat Hassan
Mazlita has
a vast experience in teaching and training in various Computer Applications
software and other subjects. Her relaxed but thorough teaching skills makes her
extremely popular with her participants and clients. She is passionate about
disseminating knowledge and always ensures that the learning environment and
resources provided support the participants' needs.
Apart from teaching,
she is also involved in database development projects. Her recently completed
database development project was with Corporate Services Division, Tenaga
Nasional Berhad, where she developed four database systems for their Training
Unit, Administration Unit, Human Resource Unit (Compensation & Benefits).
Previously,
Mazlita spent 11 years in London, studying and working at various companies,
mainly providing consultancy work regarding Web Data Mining. Her previous
clients include Gabriel Securities Limited, Yoga Therapy Centre, Beer &
Young Limited and The London Transport Museum.
Mazlita has
written several research papers that appeared in renowned international
journals and conferences, aside from providing teaching assistance and
designing course materials for undergraduate students whilst studying for her
PhD.

Siti Suriani Shih Othman
With more than 10 years of working experience to her belt, Siti Suriani is currently doing corporate trainings for various public and private sector, mainly on Microsoft Office Application. She was previously a lecturer with Cosmopoint College of Technology and University Technology MARA, supervised students' laboratory sessions, prepared lecture notes, modules and materials. Some of the courses taught by her included Multimedia Development Methods, Digital Media For Interactive Application, Computing Fundamentals, Object Oriented Programming II, PC Maintenance, Computer Architecture, Database Management, System Analysis and Design, Java Programming and many more.She has also attended instructors training workshop organized by UPM and was involved in Centralized Exam Paper Marking conducted by UPM. Other short courses that she has also attended are Train The Trainer and soft skills trainings. Read More

Shalina Hj Mohd Salleh
Shalina has 20 years of experience in IT related fields including 11 years in conducting public courses. She specializes in Corporate IT infrastructure planning (networking, troubleshooting and system integration), conducts applications training programs such as Microsoft Office, Adobe, Lotus and COMPtia products as well as organizes and conducts exhibitions and seminars.She has conducted training courses in Malaysia, Indonesia and Brunei using programs developed by her and others based on the “competency" approach which ensures successful learning through “drawing out " hidden ideas during the training session. Her training programs have consistently been rated as “excellent“ by her course participants and corporate clients. Read More
Ricky Chan Chee Ho
Ricky have extensive knowledge in software application, management skills, leading edge technology planning and implementation as well as superior strategic thinking & communication skills.His expertise are in Exchange Server, SQL Server 2000, 2005, 2008, 2012, Windows 2000, Microsoft Windows Server 2003, 2008, 2012, Window XP, Vista, 7, 8, Window NT server, Microsoft offices 2003, 2007, 2010, Microsoft Project 2013, 2007 and 2010.

Tern Zhi-Guang
Tern Zhi-Guang is a certified professional trainer for both creative and professional courses. He has 3 years' experience in the multimedia industry as a Web Designer cum Trainer and is well-verse in content management system for the web. As an Adobe Certified Expert, he lives up to his standard and has never failed to make his class an active and lively one. He is a highly motivated person and his involvement in martial arts has also helped him to be mentally strong as well as a highly disciplined. The organizations that have benefited from his training are UTM, POLIKU, Chung Hwa, Osram, CIDB Construct Service S/B, Holiday Tours & Travel S/B, I&P Group S/B, Sunway Education Group S/B Software, TBWA-ISC Malaysia Sdn Bhd, Net Business Solution, Public Mutual Berhad, Universiti Malaysia Pahang, University Malaya, University Malaysia Sabah, University Malaysia Sarawak, Polytechnic Arau, UITM Puncak Perdana, Sony Malaysia, Jabatan Landscape Malaysia, Polytechnic Dungun, Universiti Malaysia Pahang and Institute Latihan Perindustrain Selandarb(Malacca). Read More

Chin Chee Chong
Chin Chee
Chong has been in the Information Technology industry for the past 21 years
starting and is well-versed in
troubleshooting, assembling of
PCs, IT software
applications, IT training
and development for
Microsoft Office users.
He is one of
the pioneer certified Microsoft Word, Excel, PowerPoint, Access and Outlook trainers
in Malaysia having attained his Microsoft Office Specialist Master Instructor (MOS)
and Microsoft Certified Trainer (MCT) by Microsoft USA.
His
extensive tutelage experiences spanning over 12 years stem from conducting courses
for corporate companies such as 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.

Sylvia Sharon Anthony
She began
her career as a Corporate Trainer and her personal areas of expertise are wide;
encompassing Database and Graphic applications. In addition to that; she also
specializes in corporate coaching for government, multi-national companies to
local SMEs.
Sylvia has
acquired immense knowledge and skill in the training field. Since becoming a
trainer, her work has involved design, delivery and developing training
programmers. In her 16 years of experience in the training arena she has
delivered and customized training programmers specifically to tailor for
organization's unique training needs and to maximize the participant's learning
outcomes.
As a
trainer, Sylvia constantly strives to improve herself and learn new methods and
skills. She is passionate about building new programs that meet the upcoming
challenges of the IT industry. She is currently developing a customized Excel
programme which will emphasize on the advanced features of Microsoft Excel i.e.
Mastering Charts, Functions and Pivot Tables.

Kua Su-Ann
Su-Ann has been in the IT training industry for the 20 years and has trained thousands of people on the use of Microsoft Office. As Microsoft Office application is her area of specialization, she is an expert in all versions of the software and is capable of teaching at the basic, intermediate and advanced level. She has provided training to a variety of people: bankers, IT Personnel, young and old office workers, managers, senior managers, directors and corporate C-level executives. Su-Ann is the trainer of choice for many of our Blue Chip clients. Besides training, she has also been deeply involved in courseware development. In addition to developing generic courseware on Microsoft Office Applications, she has developed customized courseware to meet the unique requirements of the clients.

M. Angeline ap P. Morgis
Angeline Morgis has been training corporate clients from various industries, namely manufacturing, financial institutions and advertising companies on customized and end-user computer training programmes. She has developed manuals for Microsoft Word (Beginner to Advanced), Microsoft Excel (Beginner to Intermediate), Microsoft Outlook, Windows, FrontPage, Paintshop Pro, Windows NT Supporting, Microsoft Access, Microsoft Powerpoint (Beginners to Advanced), Visio and Photoshop.She was the Project Manager for the development of trainer's manual for HP's Large Format Printers which were used for training for the whole of Asian Region. She also developed a Learner's Guide for Selangor Human Resource which was a government project; coordinated and oversee SAP projects implementation for Shell Malaysia. The project involved the documentation of the SAP Financial and Procurement modules and she personally conducted training for them using SAP for their Financial and Procurement Process. Read More

Habibah Binti Shaari
As
a leader and trainer, Habibah brings with her more than 20 years of corporate
experience from diverse industries. She is an experienced, versatile, dynamic
and passionate trainer.
Her work with Mesiniaga Sdn. Bhd. and Institute
Tadbiran Awam (INTAN) has given her invaluable experience in handling all
aspects of ITC training including planning, developing, delivering and managing
training programs. Her work experience
as a System Analyst and Analyst Programmer adds to her credentials as an IT
specialist. She is instrumental to the growth of the company and her long list
of satisfied clients bears testimony to her leadership qualities.
Her
diverse background, sound analytical skills and IT qualification accelerates
her role as an in-house consultant and her overall training effectiveness. Her
commitment to her work, passion in people development and a strong track record adds value in
building human capital with the various organisations she works with. Organisations she has worked for include Kementerian
Pendidikan Malaysia, Kementerian Sumber Manusia, PROTON, National Panasonic,
Usahanita to name a few.
Course Reviews

Kevin Boey
Top notch course, delivered by top notch trainer. Training center and its facilities are wonderful.
4.8
17 Ratings